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