> 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">
You haven't specified a RESULT attribute for your CFQUERY tag, as described in the documentation: <cfquery ... result="myResultStructOfJustice"> Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304655 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
