On 4/14/07 1:16 AM, Jonathan Vanasco wrote: > is there a way to get Rose to search based on functions? > > ie: > bad > SELECT * FROM useraccount WHERE email = ? > good > SELECT * FROM useraccount WHERE lower(email) = lower(?)
See this thread for some earlier discussion on this topic: http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/msg01616.ht ml -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