I take that back, I was probably remembering using Access about 5 years ago .. which is probably the last time I tried it. In MS SQL Server you're probably good if you use the semi-colon on the end of each insert statement.
S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 >> 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 > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
