Hello,
I'm a newbie to SQLObject and I have a simple problem. I have a
postgres database in which I store a search key in which I need to do a
select using a regular expression.
The resulting sql needs to look like this:
SELECT *
FROM indices
WHERE search_key ~ '^x2x[0-9]{1,2}z'
ORDER BY id;
Using SQLObject how can I change the default "=" operator to "~" to get
the proper sequal? I don't mind over riding something (the Select I
assume) for this one db specific select, and then having the system
dependent on the db used.
Is there a clean way to do this?
TIA
Sherman
--
Sherman Lambert
[EMAIL PROTECTED]
Colorado State Public Defenders Office
--That justice escape none!
-------------------------------------------------------
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
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
