CFMeta

This setting in CF Admin will give you grief if you are inserting a second command inside a CFQUERY tag to retrieve the last inserted record key.

1. login to CF Admin
2. select the DSN to edit
3. display advanced settings
4. in the Connection String edit field enter ‘allowMultiQueries=true’
5. save the settings

You should be able to execute multiple SQL statements within a single <CFQUERY> block now.

Originally posted on Ben Nadel’s site – Turning On Multiple Statements In ColdFusion 8 MySQL 4/5 Datasource.  Thanks Ben!

This entry was posted on February 17, 2010 at 11:38 am and is filed under CF Admin, CF Tips & Traps, Database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.