Hello there, I've asked a question in stackoverflow about the following issue:
http://stackoverflow.com/questions/4120165/how-to-translate-this-to-sqlobject-select-distinct-columnname-where/ So far not many results, I'm hoping to get more info here. I'll update the stackoverflow quesiton in that case. In short, a recap from the above page: """ I have a specific SQL query that I need: select distinct author from blogtable where keyword = "dust"; Multiple authors can post about multiple keywords. The query works on the MySQL database if I use the raw sql query. But I can't seem to understand what I must do to get this correctly working in SQLObject. I see heaps of references to sqlbuilder, but the manual page on that is not very extensive. The examples provided in the google groups also talk as if SQLbuilder is the answer, but again, no specific example (for my problem) that I can understand. Could someone well versed in SQLObject explain to me how I implement the above SQL in SQLObject ? If not possible, can I pass the raw sql in any way via SQLObject to the underlying db ? """ I've been in and out of this group the last few weeks reading and searching. I've found several references to possible solutions to this using SQLBuilder, including a few commands, but I just can't seem to *understand* what is meant by those commands, nor what exactly sqlbuilder is and how to use it. It's becoming very frustrating... IS there a way to do this ? If so, how does SQLBuilder work ? An example would be really nice and much appreciated ! Regards, Alex ------------------------------------------------------------------------------ The Next 800 Companies to Lead America's Growth: New Video Whitepaper David G. Thomson, author of the best-selling book "Blueprint to a Billion" shares his insights and actions to help propel your business during the next growth cycle. Listen Now! http://p.sf.net/sfu/SAP-dev2dev _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
