Assuming that you dont want to write back to the file (i.e. read only) you could use a custom tag to read the file into a query, then manipulate the query with CF's Query of a Query technique. We do something similar to this to allow users to import CSV files into the main site's database.
Alternitavely you could look into setting the CSV file up as an ODBC text database, or I beleive in Access theres a way of specifying the filename in the From syntax of the query which may be of help. HTH On Mon, 14 Mar 2005 16:12:53 -0500, Wackers, Michiel <[EMAIL PROTECTED]> wrote: > I'm am looking to be able to use a CSV file in place of an access database. > I am looking to be able to allow people to perform a search and be able to > return information from this CSV file. Is this possible in Coldfusion? > > Michiel Wackers > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:752 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
