syntax error in query expression

[aonefun]

What may be the cause of the error message: syntax error in query expression 'ManufacturerPartNumber="'?

This is recordset query:
SELECT Products.ManufacturerPartNumber, Products.ProductFamily FROM Products WHERE ManufacturerPartNumbe ='" & Request.Form("VendorPartNumber") &"'

 

[vacunita]

You seem to have quoting problems.

Try it like this:

ManufacturerPartNumbe ='" & Request.Form([red]'[/red]VendorPartNumber[red]'[/red]) &"'

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[aonefun]

thanks for your response.

I'm still getting the same error message

 

[vacunita]

How about like this:

ManufacturerPartNumbe =' & Request.Form([red]"[/red]VendorPartNumber[red]"[/red]) &'

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[ChrisHirst]

response.write the sql command string before performing the query so you can actually SEE what is wrong with it.



Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[Cheech]

http://www.tek-tips.com/faqs.cfm?fid=3957

[Peace][Pipe]