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/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.
------------------------------------------------------------------------------
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.