By default PostgreSQL does case sensitive filtering. E.g.When I do
(1) "SELECT info_type FROM infos WHERE info_type LIKE '%TP%'"
then I can't get 'tp', 'Tp', 'tP'.
To do a case insensitive search I do
(2) "SELECT info_type FROM infos WHERE info_type ~*'TP'"
To do a case insensitive filter using dbforms I tried using
filterString = "info_type~*%TP%"
but this is not giving me the desired result. It appears that dbforms is
using (1) format to send the query to the database (in which case postgres
will do a case sensitive filter) and not (2).
How can I do a case insensitive filter in dbforms (based on PostgreSQL)?
-------------------------------------------------------
This SF.net email is sponsored by: Get the new Palm Tungsten T
handheld. Power & Color in a compact size!
http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
