Why not just store them somewhere under your web root, and then use cfhttp to read them in as query objects.
> -----Original Message----- > From: James Smith [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 16, 2006 8:10 AM > To: CF-Talk > Subject: Query Tab Delimited Files > > I am having a problem with tab delimited reports downloaded from Amazon. > > I have them saved in a directory, and that directory contains a schema.ini > file with the following lines. > > [schema.ini] > ColNameHeader=True > Format=TabDelimited > MaxScanRows=25 > CharacterSet=OEM > > I then have an ODBC datasource set up for this folder and an ODBC socket > set > up for CF. > > Unfortunately CF queries these files as comma delimited, which they are > not, > and it screwes up the result set. > > It works fine if I add > [395056231.txt] > ColNameHeader=True > Format=TabDelimited > MaxScanRows=25 > CharacterSet=OEM > > To the schema.ini file but this directory will get a new file every 15 > minutes and I don't want to have to modify the schema.ini file 96 times a > day when the default first group should work. > > Any ideas how I get CF to read them as the TabDelimited files they are > using > a default setting? > > -- > Jay > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
