At 11:05 12/07/00 -0400 Douglas Jordon said....
Could be the ; at the end of '#TIMEx#')
Gordon
>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/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t
alk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.