Passing a drop down menu option into an SQL statement

[outonalimb]

I am trying to pass a value from a drop down menu into a SQL statement. The drop down menu contains only numbers.

I have this sussed for drop down menus containing text, but when I pass the number through, I get a data mismatch error.

I want the user to select a number from the menu and then perform a search based on this number.

What am I doing wrong?

Regards,

 

[andybeh]

Hi,

Post your code so we can have a look at it. Most likely you are you have "" around a value that doesn't need it.

Cheers

ab

 

[outonalimb]

I thought it might be a conversion problem. How do I convert a string to an integer? I am fairly new to ASP.

Regards,

 

[bhoge]

hi outonalimb
u can try with this code
SQL="Select * from tablename where field=" & Cint(Request("comboname&quot)
I think it is problem of data type conversion
Enjoy Programming!!!!!!!!!!