|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
January 16th, 2005, 06:06 AM
|
|||
|
|||
asp and sql error
hi all this is my 1st post i hope you can help what i am tryin to do is an sql
query rthat searches a data base i am using the folowing code successfully but i wanna change it a tiny bit strSQL = "SELECT location.* FROM location WHERE (cardid='1')" i need to change cardid to check against an asp var.. so somethin like strSQL = "SELECT location.* FROM location WHERE (cardid=my_var)" any ideas help would be appricated thanks john
|
|
#2
January 16th, 2005, 08:54 AM
|
||||
|
||||
|
This is the first of two other crossposts.
Just because you post a question in different sections of the forum, it's not going to get any attention. Crossposting is NOT encouraged at this forum. Too bad I posted an answer to your other crosspost.
|
|
#3
January 16th, 2005, 11:22 PM
|
|||
|
|||
|
Hi John
Try this. "SELECT location.* FROM location WHERE (cardid=" & my_var & ")" See if you enclose your asp variable within double quotes it becomes a string rather than an include variable. So you need to close the double quote before the variable and then concatinate the string with the variable. regards Ragesh Quote:
|
|
| Viewing: ASP Free Forums > Programming > Code Bank > asp and sql error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
