evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From: Srimanta [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 8:47 PM
To: CF-Talk
Subject: Time Required for Updating DB
Hi
I am having trouble updating
Teitelbaum [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 7:28 PM
Subject: RE: Time Required for Updating DB
Like (I think) Isaac said, there's probably something wrong with the code,
but it's kind of hard to tell for sure without looking at the code.
I apologize
Thanks Mosh
Yup. 8^)
I am trying to update price field in Table named Product with values from
field newprice in Table named New. The primary key in both the tables is
dealerpart no (Text) which is unique.
Note: All the records need to be updated
CFQUERY name=UpdatePrice Datasource=XYZ
Many Thanks Mosh,
Thanks for the time taken to look into my problem and for the codes.
Will try .
Srimanta
- Original Message -
From: Mosh Teitelbaum [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 8:03 PM
Subject: RE: Time Required for Updating DB
, 2002 8:03 PM
Subject: RE: Time Required for Updating DB
Thanks Mosh
Yup. 8^)
I am trying to update price field in Table named Product with values
from
field newprice in Table named New. The primary key in both the tables is
dealerpart no (Text) which is unique.
Note: All the records
:[EMAIL PROTECTED]]
Sent: Tuesday, 8 October 2002 5:40 PM
To: CF-Talk
Subject: Re: Time Required for Updating DB
Mosh,
Tried the codes. Still no luck.
The query runs for about 8 to 10 minutes and then the
screen shows hundreds of lines of the SQL and no data is updated.
Srimanta
Its OK
No attitude problems with me.
Srimanta
- Original Message -
From: Ryan Sabir [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 8:41 PM
Subject: RE: Time Required for Updating DB
The code is missing CFQUERY etc... tags around the SQL code...
Maybe
PROTECTED]]
Sent: Tuesday, October 08, 2002 3:40 AM
To: CF-Talk
Subject: Re: Time Required for Updating DB
Mosh,
Tried the codes. Still no luck.
The query runs for about 8 to 10 minutes and then the
screen shows hundreds of lines of the SQL and no data is updated.
Srimanta
cc:
Subject: RE: Time Required for
Updating DB
10/08/2002 08:12
Hi
I am having trouble updating a fairly small size database with approx 2
records.
Size in MB is approx 18 MB. Type Access 2000.
I am updating one particular column, in all the rows with CF Query and Loop
tags.
First the program generates : Bad Allocation Error complaining of Virtual
memory
.. I'd be really suspect that there's something wrong, but I'd have to see
the code to make any really intelligent comments about it... On cf5 you
might want to build yourself a rudimentary progress bar that outputs a
little bit of the data from the current record being updated, so you can see
11 matches
Mail list logo