Yes, but if it calls the database and doesn't wait for anything back, just goes ahead and calls it again... wouldn't it happen the same as when I call the queries - and the loop is faster than the database?
-----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 12:46 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: What is this SQL Error? > The DBA wants me to call a stored procedure, "wait" until the > stored procedure is done, then continue with the loop to call > it again... Is there a way to make sure the store procedure > is "done" before the code continues? I'm pretty sure that CF will handle this for you; CF won't call the next iteration of the loop until the first one has completed. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
