THis is quick and dirty, cfloop over your query and use cfinsert. 3 lines of code.
Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Jun 8, 2008, at 4:19 PM, Richard White wrote: > Hi, > > i have built up a ColdFusion query with the use of querynew, > queryaddrow etc... > > the columns i have in this query are identical to a query i have in > my mysql database(including the column types) > > is there a way for me to quickly transfer all the data from the > coldfusion query to the mysql database without the need of a loop > > im sure coldfusion must have a quick way of doing this (a one liner > maybe!!!) > > thanks very much > > richard > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
