lfernand
Posts: 19
|
| Posted: 02/17/2009, 1:06 PM |
|
Hello,
Is there a way to change(or to add) the custom condition LIKE to ILIKE on Visual Query Builder? I use Postgres and it will be a far easier to do the searchs with this change.
|
 |
 |
lfernand
Posts: 19
|
| Posted: 02/17/2009, 1:07 PM |
|
I forgot to tell. I'm using CCS4.1.
|
|
|
|
rbaldwin
Posts: 172
|
| Posted: 02/18/2009, 10:33 AM |
|
use qb to build the query, then switch from Table to SQL and edit like to ilike.
|
|
|
|
lfernand
Posts: 19
|
| Posted: 02/20/2009, 8:44 AM |
|
Thanks rbaldwin, but is there a way to change this at any Code Charge's configuration file?
|
|
|
|
lfernand
Posts: 19
|
| Posted: 03/03/2009, 11:41 AM |
|
up
Anyone does know a better solution? Cause the way rbaldwin suggested, i would lost the visual query builder feature.
|
|
|
|
damian
Posts: 838
|
| Posted: 03/03/2009, 2:12 PM |
|
suggest you talk to support regarding this query...
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
lfernand
Posts: 19
|
| Posted: 03/10/2009, 1:59 PM |
|
Last chance before posting on the support.  Anyone does know?
|
|
|
|
Oper
Posts: 1195
|
| Posted: 03/10/2009, 6:44 PM |
|
what does ILIKE do compared with LIKE?
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
datadoit
|
| Posted: 03/10/2009, 7:34 PM |
|
Oper wrote:
> what does ILIKE do compared with LIKE?
>
ILIKE = case insensitive.
MySQL is case insensitive by default, thus there's no ILIKE in MySQL.
|
|
|
|
Oper
Posts: 1195
|
| Posted: 03/10/2009, 9:41 PM |
|
Thank Datadoit
lfernand in that case you could do this:
on the event BeforeBuildSelect
sender.where = "MusicTitle ILIKE '%" & ccgetparam("s_MusicDescripcion","") & "%'"
or somethign like this is PHP
$Container->where->SetValue("MusicTitle ILIKE '%" . CCGetFromGet("DESc", "") . "%'")
you know PHP so you i think you will undertand what i tryed to do
(i know nothing about PHP)
this way you dont have to change the Query also you may
need to the "AND" in case more parameters in the VQB.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
lfernand
Posts: 19
|
| Posted: 03/11/2009, 9:37 AM |
|
Oper
Thx for the help, but I know how to do this via code. What I want to know is if i can modify the condition like to Ilike on the visual query builder, so for each search i would not need to add before build select codes.
|
|
|
|
lfernand
Posts: 19
|
| Posted: 03/17/2009, 1:37 PM |
|
For who have interest in this, i was able to do this by modifying the class clssqlparameters on Classes.php. This solution was provided by the administrators of the brazilian codecharge forum. www.codecharge.com.br
Its a code generated by ccs, so changing this will make CCS to not control this method anymore.
|
|
|
|
