Hey all,
I've tried adding params on all fields, then only some. I've changed the type from clob to varchar to char...... I still get the same error. Help please, thanks! <cfquery name="bus" datasource="ConnectNS"> INSERT INTO dbo.Businesses INSERT INTO dbo.Businesses (CountyID,CityID,CategoryID,SubCatID,SubCat2ID,BusinessName,Address,Zip,Tele phone,Fax,Email,Website,TypeID,DateListed,Paid) VALUES (#county.countyid#,#form.city#,#form.combo0#,#form.combo1#,#form.combo2#,'<c fqueryparam value="#FORM.compname#" cfsqltype="cf_sql_clob" maxlength="25">','<cfqueryparam value="form.address" cfsqltype="CF_SQL_VARCHAR">','<cfqueryparam value="form.zip" cfsqltype="CF_SQL_VARCHAR">','#form.area#-#form.prefix#-#form.suffix#','#for m.farea#-#form.fprefix#-#form.fsuffix#','<cfqueryparam value="form.email" cfsqltype="CF_SQL_VARCHAR">','<cfqueryparam value="form.website" cfsqltype="CF_SQL_VARCHAR">',2,'#today#','No') </cfquery> Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4