On 5/3/06 7:41 PM, Guillermo Roditi wrote: > SQL definitions are at the bottom if i am not clear enough.... > > yeah, i am basically trying to do a view, but myISAM doesnt support it [...] > > I baiscally want the different types of property vlues to be as transparent > to the interface as possible so i can load() a ::User with=> > 'prop_values' and it automatically gets both binary type vvalues and > character type values.
A prop_values view is the cleanest solution. Any chance you can upgrade to Postgres? :) Failing that, you could probably make a new relationship type for this "pull values from many different tables depending on a column value in another table" relationship, but I'm not sure how general-purpose it'd be. And in the end, your custom relationship would be running exactly the same database queries that you'll run if you do it "manually" using Manager queries and/or multiple standard relationships under the covers. If you want the load(with => ...) magic to work too, just override load(), rummage through the with => ... arguments, and do whatever you need to to before passing control on to the base class load(). -John ------------------------------------------------------- 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