and still get the error.
<CFQUERY name="additem" datasource="purchaseorders">
INSERT INTO itemsordered
(cnumber,
line,
qty,
item,
priceeach,
totalprice
)
VALUES (#cnumber#,
'#line#',
'#qty#',
<cfqueryparam value="#Trim(item)#" cfsqltype="CF_SQL_VARCHAR">,
'#trim(item)#',
'#trim(totalprice)#'
)
Where cnumber = #cnumber#
</cfquery>
Robert O.
HWW
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
