Sure, that's easy: SELECT bitstream.name, bitstream.sequence_id FROM bitstream,bundle2bitstream,bundle WHERE bundle.name = 'THUMBNAIL' AND bundle2bitstream.bitstream_id = bitstream.bitstream_id AND bundle2bitstream.bundle_id = bundle.bundle_id;
or change the first line to SELECT bitstream.name || '?sequence=' || bitstream.sequence_id depending on what format you want. Regards, ~~helix84 ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech