I'm thinking maybe:
set handle = '" + newH + "' || SUBSTRING(handle from POSITION('/' in handle))
from handle
I've seen more than a few people on the newsgroups (and we're in the same boat)
who have changed the handle suffix so that it doesn't necessarily correspond to
the handle_id anymore. I think this would be a very good refinement.
B--
From: Bill Tantzen [mailto:wile...@gmail.com]
Sent: Tuesday, December 10, 2013 1:08 PM
To: dspace-tech
Subject: [Dspace-tech] update-handle-prefix broken?
Or am I misunderstanding something? In UpdateHandlePrefix.java:
sql = "update handle set handle = '" + newH + "' || '/' || handle_id " +
"where handle like '" + oldH + "/%'";
shouldn't this be
set handle = '" + newH + "' || '/' || handle
What do you think?
Bill
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette