> > I'm pretty sure you don't need to use all that concatention. Try: > > <cfset sqlQuery = "insert into testTable(testID,data1,data2) values > (#testIDValue#,'#data1Value#','#data2Value#');"> > > Warren Koch
Also, is there a very good reason why you don't build the query string inside your cfquery tags? i.e. <cfquery name="runInsertQuery" datasource="dbName" username="#dbUsername#" password="#dbPassword#"> insert into testTable(testID,data1,data2) values (#testIDValue#,'#data1Value#','#data2Value#') </cfquery> Also, alot of people will advise you to use cfqueryparam (me included), so the code would look like: <cfquery name="runInsertQuery" datasource="dbName" username="#dbUsername#" password="#dbPassword#"> insert into testTable(testID,data1,data2) values ( <cfqueryparam cfsqltype="cf_sql_integer" value="#testIDValue#">, <cfqueryparam cfsqltype="cf_sql_varchar" value="#data1Value#">, <cfqueryparam cfsqltype="cf_sql_varchar" value="#data2Value#">) </cfquery> -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296971 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
