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
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
