> I'm not sure that you have duplicates - you have > > - "collection Aigle-21" and "Collection Aigle21" for collTitle > - "teuchos collection Aigle-21" and "Teuchos Collection Aigle-21" for > collDesc > > ie, different capitalisation.
thanks, never noticed that -- seems i somehow managed to confuse fedora while testing my collection objects (the collection object in question existed _twice_ below $FEDORA_HOME/data/objects, no idea how this could happen). > If you make both these the same, you should end up with four rows -- but > multiplying by 2x2 for these variants gives you the 16 rows you returned. > > You might be expecting only two results rows - but you seem to have two > different subjects for each member also, so you'll get a separate row for > each subject. yes, and it might become even more if someone adds translations. > By the way, it's easier to spot this sort of thing if you sort, ie add an > order by clause, eg > > order by $collTitle $collDesc $memberID $member $memberTitle > $memberSubject; > > that will make it a lot more obvious. yes, i was looking for some documentation how to formulate queries -- frinst how to merge the different subjects into one field and to do ordering. any links available? ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Fedora-commons-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
