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
