Rick, Is it a mysql db? If so, see Barney's reply.
Cheers, Gabriel -----Original Message----- From: Rick Faircloth [mailto:r...@whitestonemedia.com] 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 <coldfus...@evolution7.com> 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:r...@whitestonemedia.com] > 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/#today > #/#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:323319 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4