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:307067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

