Thanks for the clarification, Garbriel. Tomorrow I'll have a go at getting this working.
I actually tried a variation of the escape character, as I thought that might be what was happening, but I wasn't using replace at the time. Hopefully, this will work...I'll post back about it. Thanks, again... Rick On Wed, Jun 10, 2009 at 12:49 AM, Gabriel <[email protected]> wrote: > > Rick, > > As Barney says that mysql uses '\' as an escape char, you'd need to replace > '\' with '\\'. > > Check the docs on the replace function, the syntax would be: > > > #replace(expandPath('\real_estate_data\smlc\daily_downloads\text_files\#toda > y#\#name#'), > "\", "\\", "all")# > > Replace(originalString, substringToReplace, stringReplacement, [scope]) > > - Gabriel > > -----Original Message----- > From: Rick Faircloth [mailto:[email protected]] > Sent: Wednesday, 10 June 2009 2:41 PM > To: cf-talk > Subject: Re: How can I make this work with expandPath? > > > 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/#tod > > > ay > > > #/#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:323324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
