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:309557 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4