J
|
Jane 7/19/2006 |
Julie,
select InstructorID,
|
J
|
JAT author 7/19/2006 |
Thanks! |
![]() |
Alexey admin 7/20/2006 |
Hi, select [InstructorID], [InstructorName], [InstructorBio], 'InstructorTBL_fulltext.asp?picfield=InstructorBio&where=InstructorID=''' & [InstructorID] & '''' as [Name_and_Bio] from [InstructorTBL] |
J
|
JAT author 7/20/2006 |
Hi, since your InstructorID field is of character type you need to add quotes to it. So here is the correct query:
|
J
|
JAT author 12/20/2006 |
Greetings! |
J
|
Jane 12/21/2006 |
Julie, select [InstructorID], [InstructorName], [InstructorBio], 'InstructorTBL_fulltext.asp?field=InstructorBio&key1=''' & [InstructorID] & '''' as [Name_and_Bio] from [InstructorTBL] |
J
|
JAT author 12/21/2006 |
Thanks! |
J
|
JAT author 12/27/2006 |
Help! |
![]() |
Sergey Kornilov admin 12/27/2006 |
Julie,
|
J
|
JAT author 12/27/2006 |
PERFECT!! Thank you so much!! |