i've spent the past 4hours trying to coerce some sql into Rose, and
its not working. perhaps someone here can point me in the right
direction.
My SQL is such:
SELECT
account.* ,
wants_item.*,
item.*
FROM
account2item_has has_item
LEFT JOIN
account2item_wants wants_item ON has_item.item_id =
wants_item.item_id
LEFT JOIN
account accountWanting ON wants_item.account_id =
accountWanting.id
LEFT JOIN
item ON wants_item.item_id = item.id
WHERE
accountWanting.id = ?
i have rose objects / managers created for all of the associated tables
account
item
has_item
wants_item
i can't seem to figure out how to load this via ROSE though. i'm not
sure on which class I should start the search on. none seem to make
sense. is something like this even reasonable in Rose ( i'm sure its
possible. everything seems possible. it just seems like it could be
a bit awkward )
-------------------------------------------------------------------------
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
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
