Glad it helped, Bret! [?]
Rick
On Thu, Apr 23, 2009 at 2:41 PM, Bret McDermitt wrote:
>
> 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 t
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 t
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 Ri
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 funct
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 ho
5 matches
Mail list logo