That's exactly what I'm doing, Justin. And I'm trying to integrate data from two different data providers with very different db schemas and will probably have to add a third provider who yet another different db schema to the mix.
Trying to get all this data in every day, parse it, then get it into my local database, then uploaded to my production server is a big pain. I'm able to almost completely automate the process with one vendor, but the other one is the one that's causing all the problems and has me searching for wildcard methods, etc. You're right about the cfftp function. I do use that with one and I'm trying to get the other one to give me direct access via ftp instead of having to click links on their site to get to the data folders. If I can get direct access via ftp I can use the listdir feature of cfftp to create that list of filenames and bypass having to use wildcards at all. Thanks for the tip! Rick > -----Original Message----- > From: Justin D. Scott [mailto:[EMAIL PROTECTED] > Sent: Saturday, August 30, 2008 2:04 PM > To: CF-Talk > Subject: RE: Wildcard characters in filepath? > > > The files would follow this format: > > II20080830_033219_ACR.log > > If you're downloading via FTP then you can get a list of the remote files, > then loop through the resulting query object to look for the files you want. > > From the filenames it looks like you're downloading images from MLXchange. > I'm in the midst of updating all our MLS code here as well so I can feel > your pain. > > > -Justin Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
