Don't put ' marks around CFQUERYPARAM ... it already handles that for you.
Also, you were missing pound signs around several of the params.
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#,
<cfqueryparam value="#FORM.compname#" cfsqltype="cf_sql_varchar"
maxlength="25">,
<cfqueryparam value="#form.address#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#form.zip#" cfsqltype="CF_SQL_VARCHAR">,
'#form.area#-#form.prefix#-#form.suffix#',
'#form.farea#-#form.fprefix#-#form.fsuffix#',
<cfqueryparam value="#form.email#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#form.website#" cfsqltype="CF_SQL_VARCHAR">,
2,
'#today#',
'No'
)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:325056
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
