access 2000 odbc in asp

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
 
R

Ragnar Midtskogen

Your query looks OK, why do you think there is something wrong with it?

Ragnar
 
R

Ragnar Midtskogen

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

Ragnar
 
D

David

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
 
D

David

Can't get rid of it, and don't know what causes it to show up. It is not in
the query, any thoughts?
 
R

Ragnar Midtskogen

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
..
 
Top