On Oct 31, 2005, at 8:10 AM, Pier Fumagalli wrote:
INSERT INTO longdescs (bug_id,who,bug_when,thetext) SELECT bug_id, 1,SYSDATE(),'Issue migrated to Jira: http://issues.apache.org/jira/ bugzillasearch.jsp?id=' || bug_id from bugs where product_id =8;Should work, unless I messed up some minor bit of syntax.
Thanks Scott.
Ok, but I don't have permissions to try this out... The only thing I got is "readbugs" access! :-)
I need to set up a long running test here, then I can take a stab at it. On a backup, at first. (:
S. -- [EMAIL PROTECTED] http://www.temme.net/sander/ PGP FP: 51B4 8727 466A 0BC3 69F4 B7B8 B2BE BC40 1529 24AF
smime.p7s
Description: S/MIME cryptographic signature