What are you really trying to do? Are you importing data from a flat file?
How many rows of data are we talking about? Is this a one time or reoccurring import? 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 6:29 PM, Richard White wrote: > Hi will > > thanks for the reply > > the problem i am having is that it is taking ages to loop through > and insert > > at the moment i am using a function from cflib to get the contents > of a each row in the cf query. is there a quicker way to get this as > well > > thanks > > > > thanks > >> 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: >> >>> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:307069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
