Re: [SQL] Updating selected record

2005-02-08 Thread John DeSoi
On Feb 8, 2005, at 9:05 AM, Levente Lajko wrote:   I have problem with a table from where I select specific field data SELECT filed1, field2 FROM tbl WHERE progress = 1 LIMIT 1  through a perl script or multiple instances of that script. The script sets the progress value of the progressed recor

[SQL] Updating selected record

2005-02-08 Thread Levente Lajko
Hi,   I have problem with a table from where I select specific field data SELECT filed1, field2 FROM tbl WHERE progress = 1 LIMIT 1  through a perl script or multiple instances of that script. The script sets the progress value of the progressed record to 0, so that other processes not