Nah, using Access the field 'desc' is reserved - 'descending' innit! D'Oh -----Original Message----- From: Russ Michaels [mailto:snake@;snakepit.net] Sent: 08 November 2002 20:18 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL error
Are u trying to insert larger amount of text than the length of the text field? > -----Original Message----- > From: Douglas McKenzie [mailto:doug@;clevermonkeys.co.uk] > Sent: 08 November 2002 17:31 > To: CF-Dev > Subject: [ cf-dev ] SQL error > > > 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] > > -- ** 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] -- ** 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]
