Why partial data would be saved to the table is beyond me though. Maybe you weren't
running things in a transaction and there was no rollback? Another query doing an
insert?
Gregory Harris
Los Angeles ITA Dept.
[EMAIL PROTECTED]
>>> [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/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?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.