RE: Time Required for Updating DB

2002-10-08 Thread Mosh Teitelbaum
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

Re: Time Required for Updating DB

2002-10-08 Thread Srimanta
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

RE: Time Required for Updating DB

2002-10-08 Thread Mosh Teitelbaum
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

Re: Time Required for Updating DB

2002-10-08 Thread Srimanta
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

Re: Time Required for Updating DB

2002-10-08 Thread Srimanta
, 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

RE: Time Required for Updating DB

2002-10-08 Thread Ryan Sabir
:[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

Re: Time Required for Updating DB

2002-10-08 Thread 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

RE: Time Required for Updating DB

2002-10-08 Thread Mosh Teitelbaum
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

RE: Time Required for Updating DB

2002-10-08 Thread kpeterson
cc: Subject: RE: Time Required for Updating DB 10/08/2002 08:12

Time Required for Updating DB

2002-10-07 Thread Srimanta
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

Re: Time Required for Updating DB

2002-10-07 Thread S . Isaac Dealey
.. 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