Insert SQL string problem

[pewilson]

Hello, I am inserting two values from my form into one value in the database. I am allowing users to select the time from a Option list name="cboDepartureTime" and select AM/PM from another Option list name="cboTime so I end up with a value of 3:00 PM. My browser will error out on this line stating "Data type mismatch in criteria expression."

This is the line of code that is giving me trouble.

strSQL = strSQL & request.form("cboDepartureTime & & cboTime&quot & "')"

The data type in the database is set to "text".

Im not sure how to go about fixing it.

Thank you in advance.
Paul
paul_wilson74@hotmail.com

 

[SashiRaveendran]

strSQL = strSQL & request.form("cboDepartureTime&quot & request.form(cboTime&quot & "')"

 

[pewilson]

Thanks for help sjravee!!! One more question, what is the best way to insert a space between the two variables?

Thanks again Paul
paul_wilson74@hotmail.com

 

[SashiRaveendran]

var1 & " " & var2