My count shows 12 and 12.
Here it is again, illustrated:
<cfquery datasource="datasourcename">
insert into emails(
1 SUBJECT,
2 FROMX,
3 TO,
4 DATEX,
5 BODY,
6 ATTACHMENTS,
7 CC,
8 MESSAGENUMBER,
9 ATTACHMENTFILES,
10 REPLYTO,
11 HEADER,
12 TIMEx)
values (
1 '#query.SUBJECT#',
2 '#FROMX#',
3 '#query.TO#',
4 #DATEy#,
5 '#query.BODY#',
6 '#ATTACHMENTSX#',
7 '#query.CC#',
8 '#query.MESSAGENUMBER#',
9 '#ATTACHMENTFILESX#',
10 '#query.REPLYTO#',
11 '#query.HEADER#',
12 '#TIMEx#');
Brandon Whitaker wrote:
>
> 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!
>
> What was throwing me is that the data he had *right* was still being saved.
> I've been fortunate(?) to work with native drivers instead of ODBC, and this
> (or any other failure) would simply have discarded the whole query and
> inserted nothing - is this 'partial insert' a common behavior of ODBC
> drivers?
>
> Brandon Whitaker
> [EMAIL PROTECTED]
> -------
> "It'll get used by the same people using Opera. People dressed in black
> wearing berets."
> - Dave Watts, on Mozilla
>
> "It makes you feel so welcome to have a greeter like Papa Dave at the door.
> Kind of like what Wal-Mart wishes it could do."
> - John Allred, on Dave Watts
>
> "The net interprets censorship as damage and routes around it."
> - John Gilmore
>
> ------------------------------------------------------------------------------
> 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.
