Hello John,
thanks for the new release. Two annoying bugs in my application are gone.
The following important question is still open:
But is there a way to do the following in RDBO:
SELECT DISTINCT products.*
FROM products LEFT JOIN prices ON (products.id = prices.product_id)
WHERE prices.region = 'DE'
LIMIT 1, 1
RDBO has no problems with the FROM and WHERE line, but I don't know how
to achieve the SELECT and LIMIT.
(The limit bug is fixed.)
I think other ERM call this "auto-join" (CDBI::Sweet?). Maybe you can
call it "search_objects", because it does a selection (WHERE) but no
projection (SELECT *) on these tables.
Do you understand my concern? Do you think you can make this into RDBO?
Thanks,
bye Uwe
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
