yes, mysql 5.1... On Wed, Jun 10, 2009 at 12:37 AM, Gabriel <[email protected]> wrote:
> > Rick, > > Is it a mysql db? If so, see Barney's reply. > > Cheers, > Gabriel > > -----Original Message----- > From: Rick Faircloth [mailto:[email protected]] > Sent: Wednesday, 10 June 2009 2:34 PM > To: cf-talk > Subject: Re: How can I make this work with expandPath? > > > Thanks, Gabriel...I'll see if I can make that work. > > To your question about why the \'s are being deleted...below the entire > query. > It's always run fine since I was using the hardcoded path. I have no idea > why the path would end up like "dinetpubwebroot > > eal_estate_datasmlcdaily_downloadstext_files2006_0609MF20060609_07114_ACR_1. > txt" > > Never seen that happen before... > > > <cfquery name="load_data" datasource="#application.dsn2#"> > > load data infile > > 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#today# > /#name#' > > <cfif #name# contains "ACR"> > > *into* *table* smlc_acr_temp > > <cfelseif #name# contains "COM"> > > *into* *table* smlc_com_temp > > <cfelseif #name# contains "LOT"> > > *into* *table* smlc_lots_temp > > <cfelseif #name# contains "MUL"> > > *into* *table* smlc_mul_temp > > <cfelseif #name# contains "OFF"> > > *into* *table* smlc_off_temp > > <cfelseif #name# contains "REN"> > > *into* *table* smlc_ren_temp > > <cfelseif #name# contains "RES"> > > *into* *table* smlc_res_temp > > </cfif> > > fields terminated *by* '|' > > lines terminated *by* '\r\n' > > </cfquery> > > > On Wed, Jun 10, 2009 at 12:21 AM, Gabriel <[email protected]> > wrote: > > > > > Rick, > > > > #replace(stringVar, '\', '/', 'all')# > > > > should give you the string as you need it, though I'd be more worried > > about why the \'s are being deleted during whatever operation you're > > trying to perform. > > > > - Gabriel > > > > -----Original Message----- > > From: Rick Faircloth [mailto:[email protected]] > > Sent: Wednesday, 10 June 2009 1:45 PM > > To: cf-talk > > Subject: How can I make this work with expandPath? > > > > > > Hi, all... > > > > I'm running a query that uses > > > > load data infile > > > > 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/# > > today# > > /#name#' > > > > The "/" have to be backwards to work in this case. If they are turned > > around as "\" in the path, they get deleted in the > > translation...haven't figured that one out... > > > > Anyway, I wanted to use: > > > > load data infile > > > > "#expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today > > #/#nam > > e#')#" > > > > That works except for the fact that all the "/" get translated into > > "\" by expandPath and then are deleted from the resulting path, > > leaving it invalid. > > > > How can I code this to make it work with expandPath? > > > > Nothing I've tried causes a correct path to be translated by CF. > > > > Thanks for any feedback... > > > > Rick > > > > > > ---------------------------------------------------------------------- > > ------ > > ------------------------------------------------------------ > > *"Ninety percent of the politicians give the other ten percent a bad > > reputation."* Henry Kissinger > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323321 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
