> Gregory Harris:
> Quite simple, count the amount of Fields, and the amount of values, and
they aren't consistent you have 11 fields and 12 values, re-tool and try
again!
Nope 12 and 12.
You should try looking at the full sql that gets passed, check it for quotes
etc.... What DB are you using???
~Justin
> >>> [EMAIL PROTECTED] 07/12 8:05 AM >>>
> Why would this query:
>
> <cfquery datasource="datasourcename">
> insert into emails(
SUBJECT, FROMX, TO, DATEX,
> BODY, ATTACHMENTS, CC, MESSAGENUMBER,
> ATTACHMENTFILES, REPLYTO, HEADER, TIMEx)
> values
(
'#query.SUBJECT#', '#FROMX#', '#query.TO#', #DATEy#,
'#query.BODY#', '#ATTACHMENTSX#', '#query.CC#', '#query.MESSAGENUMBER#',
'#ATTACHMENTFILESX#', '#query.REPLYTO#', '#query.HEADER#', '#TIMEx#'
);
>
> </cfquery>
>
> return this error?:
>
> ODBC Error Code = 21S01 (Insert value list does not
> match column list)
>
> [Microsoft][ODBC Microsoft Access 97 Driver] Number
> of query values and destination fields aren't the
> same.
>
> What's also odd is that the data is being saved to the table.
>
> TIA,
>
> Doug Jordon
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
>
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
