Thanks for the info, Barney.
I can't understand why it works like this:
load data infile
"d:/inetpub/webroot/real_estate_data/text_files/#today#/#name#"
Seems like MySQL would turn that into:
d:inetpubwebrootreal_estate_datatext_files2006_06092006060901_acr_1.txt
But for some reason, with the normal "\" turned around as "/", it works find
in the query.
Seems like I would have to write:
d:/\inetpub/\webroot/\real_estate_data/\text_files/\#today#/\#name#"
???
Rick
On Wed, Jun 10, 2009 at 12:52 AM, Barney Boisvert <bboisv...@gmail.com>wrote:
>
> On my phone so excuse the brevity:
>
> P = expandPath("...");
> P = replace(P, "/", "\", "all");
> P = replace(P, "\", "\\", "all");
>
> Load data infile '#P#'
>
> Cheers,
> Barneyb
>
> ---
> Barney Boisvert
> bboisv...@gmail.com
> http://www.barneyb.com
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:323325
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
