Can anyone see whats wrong with this?
SQL
INSERT INTO items (itemcode, name, price, desc) VALUES ('TRO9732', 'Funky
Trousers', '10.99', 'Some damn funky trewsers!')
Original code:
<cfquery name="EnterInfo" datasource="CFXML">
INSERT INTO items
(itemcode, name, price, desc)
VALUES
('#arItemCode#', '#arItems#', '#arPrice#', '#desc#')
</cfquery>
DATASOURCE CFXML
VENDORERRORCODE -3502
SQLSTATE 42000
Running CFMX with Access2000 db on Win2000. All db fields are Text except
'desc' which is a memo field.
Cheers,
Douglas McKenzie
----------------------------------------
Internet Developer / Designer
[EMAIL PROTECTED]
07984 462 516
----------------------------------------
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
