Re: Problem loading data from text file...

2008-09-18 Thread Azadi Saryev
ch row is delimited by chr(10)&chr(13). > > I can't figure out how to use both delimiters to parse the rows and the row > elements. > > Suggestions? > > Thanks, > > Rick > > > >> -----Original Message- >> From: Eric Roberts [mailto:[EMA

RE: Problem loading data from text file...

2008-09-18 Thread Rick Faircloth
nt: Thursday, September 18, 2008 2:26 AM > To: CF-Talk > Subject: RE: Problem loading data from text file... > > Why not use cffile and then load it into the db...then you could easily > process the data to be however you want it? > > Eric > > /*-Original Messa

RE: Problem loading data from text file...

2008-09-17 Thread Eric Roberts
Why not use cffile and then load it into the db...then you could easily process the data to be however you want it? Eric /*-Original Message- /*From: Rick Faircloth [mailto:[EMAIL PROTECTED] /*Sent: Wednesday, September 17, 2008 7:40 PM /*To: CF-Talk /*Subject: Problem loading data from

Problem loading data from text file...

2008-09-17 Thread Rick Faircloth
I'm using this query to load data into a table from a text file: load data infile 'e:/inetpub/webroot/real_estate_data/hmls/data/#today#_idx_custom/active_photos.txt' into table hmls_active_photos_temp lines terminated by '\r\n' ignore 1 lines It runs f