[SQLObject] SQLBuilder

[Lutz S. <l.s...@4c...>]

Hello,

I need a litle bit of advice how to use SQLBuilder.
First question: has anybody examples or documentation about
SQLBuilder ?

At the moment I'm using this way to get the data:
 
res=conn.queryAll("select fa.name as fa_name, fa.id as
fa_id, fa.catalog_name as fa_catalog_name, \
 ca.name, ca.id, ca.catalog_name \
from cm_catalog as fa, cm_catalog as ca, \
cm_catalog2catalog as ca2ca, cm_user2catalog as us2ca \
where fa.id = us2ca.cm_catalog_id \
and us2ca.cm_user_id=60 \
and fa.id = ca2ca.catalog \ 
and ca.id = ca2ca.children \
and fa.active='t' \
and ca.active='t' \
order by ca.name, fa.name")

Not very elegant but its working.

My question is now if somebody can transfer this query to a
valid SQLBuilder expression so I have a working example.

After my enlightenment I'll be share my knowledge in the wiki.

Many thanks in advance !!

Kindly regards

Lutz Steinborn