I've been using the basic SQLObject APIs very happily for the last year. Thanks for all the hard work.
I have a question as to what is the best approach to the following - I want to do a join across multiple tables potentially returning lots of rows. I do this with MyClass.select which gives me the attributes for MyClass. If I want to report the cols of the other tables I have to follow the joins I've set up in my classes, while this works fine it's not very efficient because as far as I can see another query happens every time I use one of these pre-set up joins. I know I can use a raw query in these instances but I would then miss out on my customised columns and object oriented approach. Is there some sort of way of having a composite object which contains all the classes I wanted in the join? Is there some other approach I've missed entirely? I noticed something relevant in the SQLBuilder & Views thread from Johan Dahlin a few weeks ago is that what I should be looking at? On another vaguely related question - is there a proper way to execute a (sub)query built with sqlobject.sqbuilder.Select standalone. I can sometimes get a str representation and pass that to queryAll but not always... Cheers. ------------------------------------------------------------------------- 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 _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
