access 2000 odbc in asp

  • Thread starter Thread starter David
  • Start date Start date
D

David

this is going to drive me to drink...again, could someone put thier evil eye
on this query and let me know what is wrong.

trackingnumber = char
inventoryid=number

"select * from inventory where trackingnumber = ' " & trackingnumber & " ' "
& " and inventoryid <> " & inventoryid


Thanks in advance...
David
 
Your query looks OK, why do you think there is something wrong with it?

Ragnar
 
Check you actual query carefully, you have a comma between the <> and the
12.

Ragnar
 
I am getting this error when I try to do a update,

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 'trackingnumber = '001ABCN060204' and inventoryid <> , 12'.

/pages/update_inventory.asp, line 117
 
Can't get rid of it, and don't know what causes it to show up. It is not in
the query, any thoughts?
 
Computers do only what you tell them, so it must be there somehow. Have you
checked the inventoryid
variable?
If the query string you post is copied from your asp code, then that would
be the only way I can think of.that comma getting there.

Ragnar
..
 
Back
Top