skaterdav85 12 Posted August 19, 2010 Report Share Posted August 19, 2010 I have a few hidden input fields that contain integers and I am going to insert these values into a sql server db into fields of type int. I tried using the CAST() function in my query, but it keeps throwing an error saying:[Macromedia] [sqlServer JDBC Driver][sqlServer]Incorrect syntax near the keyword 'AS'.Is there anything wrong with my query? <cfquery datasource="db1">INSERT INTO testSetup (id1, id2, id3, position, testStartDate)VALUES( <cfqueryparam cfsqltype="cf_sql_varchar" value="form.id1">, CAST(#form.id2# AS INTEGER), CAST(#form.id3# AS INTEGER), 1, <cfqueryparam cfsqltype="cf_sql_varchar" value="form.startDate">)</cfquery> 1 Quote Link to post Share on other sites
jardrake 2 Posted December 28, 2012 Report Share Posted December 28, 2012 Whoa, what's up with using your # everywhere instead of their real values like ( and ). Anyways, what type of database are you using, are you sure it supports integer and not int? Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.