SQL ERROR

[alexfusion]

Hi Everyone,
I have a table with information about some kinds of services that a company does.I have an input form that enters data into the table.Every time that a new order is required one fills the fields and inserted data into the table.That is working fine.
The problem is when one check the order status entering the order number.I am using the Id fiel as an autonumeric field to automatically generate the order numbers but when one enters the order number in the form field I get an SQL error
because Id is numeric and the value entered in the form is a string.I tried LSParseNumber to convert to numeric,but I still get the error.
Can anyone give me an idea about how to solve this problem or another way to generate automatically the order numbers than using an autonumeric field in the table?
I hope I was clear.

Thank you very much.

alexfusion

mixale@hotmail.com

 

[tlhawkins]

This usually is not a problem.

I would check if you are putting quotes around the value in your Query, it should look like this:

Where ID = #Form.ID#

Not:


Where ID = '#Form.ID#'

IF there is still a problem please post the code and we'll get right on it.

Hope it all works out.