Re: Loop Loop Loop

Rick's the man. Worked like a charm. What database are you using, Bret? I use MySQL 5 and I import MLS data from two different MLS's every day, but I use SQL to do it in a cfquery, rather than CFML only. Very, very fast this way. For example, after downloading all the data from one of the MLS

Re: Loop Loop Loop

Glad it helped, Bret! [?] Rick On Thu, Apr 23, 2009 at 2:41 PM, Bret McDermitt bretmcderm...@gmail.comwrote: Rick's the man. Worked like a charm. What database are you using, Bret? I use MySQL 5 and I import MLS data from two different MLS's every day, but I use SQL to do it in a

Loop Loop Loop

Hey all, struggling with a large Real Estate data load. I have 6 text files with a couple hundred rows and a couple hundred columns which need to make their way into a database. I loop over the rows to get the actual data from the files, and I'm having to loop over each column to determine

Re: Loop Loop Loop

What database are you using, Bret? I use MySQL 5 and I import MLS data from two different MLS's every day, but I use SQL to do it in a cfquery, rather than CFML only. Very, very fast this way. For example, after downloading all the data from one of the MLS sites, I first run a cfdirectory

Re: Loop Loop Loop

SQL Server 2005 Express... I just looked up the SQL Server equivalent and I could run a BULK INSERT temp FROM 'D:\somedata.txt' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR='\n' ) to load the data initially, then just update my columns as needed... I'll have to try this out tonight. Thanks