I tried that also and I get crazy things like " {08A95C45-4CEE-4A86-9B18-13DA30C013C9}" inserted as the subdir_id if I have the fieldsize set as "Replication ID", or " -2138072423" if I have it set for "Long Integer".
-----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:27 PM To: CF-Talk Subject: RE: Access Question > I'm having a tough time with an access query. I'm sure > it's something simple, but I had shoulder surgery > yesterday so I have a ball pumping goodies into the > shoulder at it's own discretion. :-) > > INSERT INTO subdir > VALUES ('#good#') > > And the table is: > subdir_id (autonumber) > subdir (text) > > The error says: > ODBC Error Code = 21S01 (Insert value list does not > match column list) > > [Microsoft][ODBC Microsoft Access Driver] Number of > query values and destination fields are not the same. > > SQL = "INSERT INTO subdir VALUES ('AAAA')" Add the field name to the query: INSERT INTO subdir (subdir) VALUES ('#good#') Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ::::::::::::: dream :: design :: develop ::::::::::::: MXDC 02 :: Join us at this all day conference for designers & developers to learn tips, tricks, best practices and more for the entire Macromedia MX suite. September 28, 2002 :: http://www.mxdc02.com/ (Register today, seats are limited!) :::::::::::::::::::::::::::::::::::::::::::::::::::::: ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists