Title: Message Title
|
|
For "find the affected items," Oracle 10g doesn't like the above, but this is accepted: SELECT handle, text_value, 'http://hdl.handle.net/'||handle AS fixed FROM metadatavalue, metadatafieldregistry, handle WHERE to_char(text_value) = 'http://hdl.handle.net/123456789' AND metadatafieldregistry.metadata_field_id = metadatavalue.metadata_field_id AND metadatafieldregistry.element = 'identifier' AND metadatafieldregistry.qualifier = 'uri' AND handle.resource_type_id = 2 AND handle.resource_id = metadatavalue.item_id; (The reasons: text_value is a CLOB and must be converted to CHAR for use in WHERE; text_value is a CLOB and apparently cannot be aliased. Fortunately the alias was not used.)
|
|
|
|
|
|
|
------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience. Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel