Thanks. I did have it right, but I was trying different things to get it to
work to the query got messed up. I did end up figuring it out though.
-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com]
Sent: July-28-09 5:09 PM
To: cf-talk
Subject: re: Invalid parameter binding
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,
Tel
Hey all,
I found the problem. Seems just posting the question fixed it, lol!
Rick Sanders
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
A
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!
INSERT INTO dbo.Businesses INSERT INTO dbo.Businesses
(CountyID,CityID,CategoryID,SubCatID,SubCat2ID,BusinessName,Add
4 matches
Mail list logo