On 6/24/07 5:53 PM, James Masters wrote: >>> Does Rose facilitate such "display-only" fields in some way? >> write a function in the rose class.... > > Thanks. I've got this working but have hit 2 probs. The first is that my > classes are automatically generated and adding the functions to the Extra.pm > doesn't work.
Why not? > The second is that I also need to sort on one of these fields. This doesn't > seem to happen I think because Rose delegates sorting to SQL and, of course, > SQL doesn't know about the field, which is a PERL-only entity (a perl > function). > > As it happens, in this case the field can also be formulated in SQL. And > it's standard SQL to define a field and then use it to output and to "ORDER > BY" within an SQL statement. > > Can Rose work with a field defined like this? There's some experimental support for stuff like that, but it will require you to define a new column class: http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/msg00710.ht ml But I agree that a better solution is needed... -John ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
