On Sat, Apr 14, 2007 at 01:16:10AM -0400, 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(?)
How about:
$users = UserAccount->get_objects_from_sql(
args => [ $email ],
sql => 'SELECT * FROM useraccount WHERE lower(email) = lower(?)',
);
--
Bill Moseley
[EMAIL PROTECTED]
-------------------------------------------------------------------------
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
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/rose-db-object
