> 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!)
::::::::::::::::::::::::::::::::::::::::::::::::::::::
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
