i don't know a better way to phrase this, so let me illustrate in  
pseudocode

stored_information      # base table for stored info
        id
        useraccount_id
        stuff

stored_information__name        # extends stored info for name specific  
stuff.  essentially an 'inherits'
        stored_information_id
        name_specific_stuff

using rose, i need to get a list of stored_information__name for a  
useraccount_id

i don't need / don't want the stored_information row

i'm hoping there's a way to either:

a)      make a manager sub on stored_information, that will pull the  
related info from stored_information__name and ignore the class info  
for stored_information
b)      make a manager sub on stored_information__name that uses a join  
against stored_information, but does not retrieve the info in it

does that make sense at all?  my db is normalized like this for some  
performance reasons.  i'd love to just not pull the data if at all  
possible.  though i think i'm going to be stuck with pulling an  
entire row of [stored_information, stored_information__name]

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to