> Can you do multiple insert statements in one CFQUERY statement? > ie > <cfquery ...> > Insert into ....
> Insert Into ... > Insert Into ... > </cfquery> > If yes, is there something special that needs to be added? It probably depends on your drivers, although I've not been able to in the past with the default MS SQL Server drivers provided with CF 5 and prior... You can use a select statement to insert data from a query into another table, although I'm guessing that this is for your "enterprise manager" app you were talking about earlier today, so I'd say your best bet is probably multiple cfqeuries... S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
