So, the long version would be:
#replace(expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today#/#name#'),
"\", "all")#
Right?
Gabriel's var version:
<cfset filePath =
"expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today#/#name#')">
#replace(filePath, "\", "all")#
Correct?
Rick
On Wed, Jun 10, 2009 at 12:24 AM, Barney Boisvert <[email protected]>wrote:
>
> MySQL uses the backslash as an escape character. So after you use
> expandPath, use replace to double them up. That should take care of it.
>
> Cheers,
> Barneyb
>
> ---
> Barney Boisvert
> [email protected]
> http://www.barneyb.com
>
> On Jun 9, 2009, at 8:45 PM, Rick Faircloth <[email protected]>
> wrote:
>
> >
> > 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#/#name#')#"
> >
> > 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:323320
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
