Those figures don't surprise me, because the cfquery is run once not 1000 times and is a valid query if separated with a ';'
-----Original Message----- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Friday, 8 February 2002 12:01 AM To: CF-Talk Subject: RE: looping inside cfquery - brain on vacation Just tested it, 1000 INSERTS, SQL Server 7.0, both ways ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists