r 25, 2002 9:37 AM
To: CF-Talk
Subject: Mass Database update
We have a client that wants to drop a database table and replace it with
a new one every once and a while.
Is there any dummy proof ways of doing this?
Have them upload a CSV, use CFFILE to loop over the information and
import it?
The
<[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 25, 2002 10:36 AM
Subject: Mass Database update
> We have a client that wants to drop a database table and replace it with
> a new one every once and a while.
>
> Is there any dum
TECTED]]
> Sent: Wednesday, September 25, 2002 9:37 AM
> To: CF-Talk
> Subject: Mass Database update
>
>
> We have a client that wants to drop a database table and
> replace it with
> a new one every once and a while.
>
> Is there any dummy proof ways of doing this?
BCP?
> -Original Message-
> From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 25, 2002 9:38 AM
> To: CF-Talk
> Subject: RE: Mass Database update
>
> run it all in a dts package truncate the table and then use bcp to
import
> the csv
run it all in a dts package truncate the table and then use bcp to import
the csv file.
-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 10:37 AM
To: CF-Talk
Subject: Mass Database update
We have a client that wants to drop a database table
We have a client that wants to drop a database table and replace it with
a new one every once and a while.
Is there any dummy proof ways of doing this?
Have them upload a CSV, use CFFILE to loop over the information and
import it?
The data will start as an Excel table.
___
well,
because it is a list too. So you have two options I guess.
HTH,
Tyler M. Fitch
Certified Advanced ColdFusion 5 Developer
ISITE Design, Inc.
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:57 PM
To: CF-Talk
Subject: Re: mass da
ps :)
phillip
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 4:57 PM
To: CF-Talk
Subject: Re: mass database update
Count is a quantity amount for an item, and ID is the ID primary key of the
item being updated. This is fed from a form that allo
ROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 3:57 PM
Subject: Re: mass database update
> Count is a quantity amount for an item, and ID is the ID primary key of
the
> item being updated. This is fed from a form that allows the user to
update
ified Advanced ColdFusion 5 Developer
ISITE Design, Inc.
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:57 PM
To: CF-Talk
Subject: Re: mass database update
Count is a quantity amount for an item, and ID is the ID primary key of
the item
Original Message -
From: "Bruce Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 3:54 AM
Subject: mass database update
> I am doing a mass update of a table. The query looks like this:
>
>
> Update Inv1
&g
At 05:54 AM 01/15/2002 -0600, you wrote:
> I am doing a mass update of a table. The query looks like this:
>
>
>Update Inv1
>Set Count = #Count#
>Where ID = #ListGetAt(ID, thisItem)#
>
>
>
>What I am getting is this:
>Update Inv1
>Set Count = 9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9
>Where ID = 20
use the value of "thisItem".
phillip
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=c
use the value of "thisItem".
phillip
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 6:55 AM
To: CF-Talk
Subject: mass database update
I am doing a mass update of a table. The query looks like this:
Update Inv1
Set Coun
. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
- Original Message -
From: "Bruce Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 3:54 AM
Subject: mass database update
I am doing a mass update of a table. The query looks like this:
Update Inv1
Set Count = #Count#
Where ID = #ListGetAt(ID, thisItem)#
What I am getting is this:
Update Inv1
Set Count = 9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9
Where ID = 2077
I know that I have to associate a quantity (count
16 matches
Mail list logo
