That's interesting, because I had narrowed the fields down to one: the
body field which of course contains commas(the data is email). How do I
get around this? It's an Access database memo field.
DJ
"Dempsey, Timothy F." wrote:
>
> Doug,
>
> Could one of you values have a comma in it? That might make the database
> think it has more values than you intend.
>
> -- Tim Dempsey
>
> -----Original Message-----
> From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 12, 2000 11:06 AM
> To: Cold Fusion List
> Subject: why is this happening?
>
> 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=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=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
