Cameron, That's pretty cool. I like that it will allow for fewer cfquery tags when you are always executing a series of SQL statements together. Is the concern about SQL injection attacks serious enough to avoid doing this? I was thinking that creating a seperate datasource in CF Administrator with the allowMultiQueries=true added just for those situations where I use mutiple statements and then not using any user inputs in those queries would help protect against this.
I'm still stuck on how to create a database using a cfquery and then create tables in that database without going into CF Administrator to manually specify a datasource for the new databases (using CF MX 7). Any advice on how this can be done would be really appreciated. Thanks, Kevin Hall ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2423 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
