>From the docs @ cfquery
---------
The cfquery tag also returns the following result variables in a structure. You
can access these variables with a prefix of the name you specified in the
result attribute."[...]
result_name.GENERATED_KEY
MySQL only. The ID of an inserted row. MySQL 3 does not support this feature.
---------
So I try this in MySQL client version: 5.0.45:
<cfquery name="qInsertAuthors" datasource="cms" username="www"
password="gHe6i2Gyi">
INSERT INTO authors(
firstname,
lastname,
title,
gender,
pseudonym,
notes)
VALUES(
'',
'',
'',
'',
'',
'');
</cfquery>
<cfdump var="#qInsertAuthors#">
I get
"Variable QINSERTAUTHORS is undefined."
Also after I add AlwaysReportTriggerResults=true to the connection string of
the dsn (mentioned in the comments section of the page).
As far as I can see this feature works not as advertised.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304654
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
