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:323322
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
