Emile, >From your description I don't know exactly what part you're struggling with. There are a number of ways to create searchqueries in MMBase, and these are usually straightforward and should definitely be easier to develop than writing your own DB-code.
The trouble you're reporting seems to indicate either a bug or a lack of documentation. In both this is usefull information to report. So explain in a little more detail what you tried to do - even if you have resorted to another aproach afterwards. Rob van Maris Technical Consultant Quantiq xmedia & communication solutions Koninginneweg 11-13 1217 KP Hilversum T +31 (0)356257211 M +31 (0)651444006 E [EMAIL PROTECTED] W http://www.quantiq.com > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Emile > > > Hi All > > does anyone have any experience with SearchQuery in mmbase - > in particular multiple relation steps? Is there an easier > way? It seems to be generating incorrect SQL, if one adds > more than one relation step, it adds insrel again into the SQL. > > A part of me wants to throw in the towel, take the SQL, fix > it and run it as is against the DB - is there a generic db > object in mmbase or do we have to set up another db pool > mechanism to query the database in a custom servlet?
