Usually when I get a message like that in sql it usually means I forgot something simple like a comma. Are you inserting several things?
-----Original Message----- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 1:06 PM To: CF-Talk Subject: RE: Access Question 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!) :::::::::::::::::::::::::::::::::::::::::::::::::::::: ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
