Re^5: Increment DB using Perl

You need a static ID. If you want to go based on the ordering of the select statement, try (not sure how many DB's support this):

SELECT ROWID, ID
FROM  REQUEST
[download]

and then update based upon that rowid (if possible)... but it's tricky when there's no key to go off of. I'm not even 100% sure that'll work.

--------------
It's sad that a family can be torn apart by such a such a simple thing as a pack of wild dogs

Comment on Re^5: Increment DB using Perl Download Code