As long as the param exists no there is not a problem. What kind of "binding error" are you getting?
Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Toni Steinhauer [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 9:14 PM To: CF-Talk Subject: Using attributes within cfqueryparam in Fusebox application Is there a problem using 'attributes' instead of FORM or URL within cfqueryparam? I am getting invalid binding errors on this insert: INSERT INTO OrderHeader (Orderno, ItemTotal, Shipping, OrderTotal, PurchaseDate, BuyerEmail, BuyerName, Ship2Name, Ship2Addr1, Ship2Addr2,Ship2City, Ship2State, Ship2Zip, Ship2Country, PaymentType, Card, Exp, Bill2Name, Bill2Address, Bill2City, Bill2State, Bill2Zip, Bill2Country, DayPhone, Fax, SiteID, Comments, OrderType, Discount, EntryDate) VALUES( <cfqueryparam value="#attributes.ordernumber#" cfsqltype="cf_sql_integer">, #itemtotal#, #shipping#, #total#, #CreateODBCDate(Now())#, <cfqueryparam value="#attributes.EMAIL#" cfsqltype="cf_sql_varchar" maxlength="50">, '#bname#', '#shipfname# #shiplname#', '#shipaddress#', '#shipaddress2#', '#shipcity#', '#shipstate#', '#shipzip#', '#shipcountry#', <cfqueryparam value="#attributes.PAYMETHOD#" cfsqltype="cf_sql_varchar" maxlength="20">, '#ccr#', '#expdate#', '#bname# , <cfqueryparam value="#attributes.ADDRESS#" cfsqltype="cf_sql_varchar" maxlength="50">, <cfqueryparam value="#attributes.CITY#" cfsqltype="cf_sql_varchar" maxlength="50">, '#bill2state#', <cfqueryparam value="#attributes.ZIP#" cfsqltype="cf_sql_varchar" maxlength="20">, <cfqueryparam value="#attributes.COUNTRY#" cfsqltype="cf_sql_varchar" maxlength="50">, <cfqueryparam value="#attributes.PHONE#" cfsqltype="cf_sql_varchar" maxlength="20">, <cfqueryparam value="#attributes.FAX#" cfsqltype="cf_sql_varchar" maxlength="20">, #siteid#, <cfqueryparam value="#attributes.COMMENTS#" cfsqltype="cf_sql_longvarchar">, 0, #discount#, #CreateODBCDate(Now())#) I have been able to do similar inserts in scripts that are not under Fusebox using FORM and URL with no errors being thrown. I was just wondering if the 'attributes' is the problem. This is an older Fusebox 3 application. THANKS! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
