Just an idea: I think you can use MS ODBC to deal with delimited text file as a "database" or You can do this: 1. Convert the text file as a "recordset". This can be done by converting your delimited text file (CSV) to CF Query (recordset) 2. Use QoQ for select operation against the recordset. 3. For insert operation, you can use queryaddrow - querysetcell 4. For update operation, you can use querysetcell 5. For delete operation, you can put a marker - an extra field to denote whether that record should be removed or not
When you are finished, you can then rewrite the recordset back into CSV. (Don't forget to exclude records marked for deletion above) HTH, Rizal www.masrizal.com ColdFusion Custom Tags And More At 11:12 PM 1/26/2009, you wrote: > >You never did clarify if by "flat file" you mean "text file"? > >Yes, you are correct about that, sorry. I mean a delimited text file. > >Specifically, I am precluded from installing any database, including >using access database files. > >bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
