----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> --snip-- > And besides, I would still implement it without depending on TSQL: > > <cfquery datasource="test"> > <cfloop from="1" to="3" index="i"> > INSERT INTO test (testID) > VALUEs (<cfqueryparam cfsqltype="cf_sql_integer" value="#i#">); > </cfloop> > </cfquery> > > One database connection, not database dependent. Best of both worlds :) --snip-- ---------------------------
Isn't it impossible to do this when you're using Access? I know you shouldn't be using Access, etc., but I've never been able to get multiple SQL statements to work in Access. Is there a trick I'm missing, or is this just something else to live with and remind me I shouldn't be using Access? ;-) Gyrus [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net PGP key available ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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