How can I change the dataobject sql query below to use the "lower()"
function in oracle
getEmailId.addDynamicCriterion("emailid",
CSpCriteriaSQLObject.EQUAL_TO_STR_OPERATOR,
new CSpString(emailID));
getEmailId.execute();
I want the query to look like this...
SELECT emplid from tablename
WHERE lower(emailId) = 'john.doe'
--
John Lapham
Global One
begin:vcard
n:Lapham;John
tel;work:703.471.2431
x-mozilla-html:FALSE
org:Global One;Information Services / Corporate Services Systems
version:2.1
email;internet:[EMAIL PROTECTED]
title:Software Engineer
adr;quoted-printable:;;13775 McLearen Road=0D=0A;Oak Hill;Virginia ;20171 ;
fn:John Lapham
end:vcard
_________________________________________________________________________
To unsubscribe from this mailing list please send an email to:
[EMAIL PROTECTED]
Please remember to use the same email address you subscribed with.
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
