> How are you escaping it now? I am not, cake is doing it automatically.
I have an array of input params that I use to build an array: $temp[] = "FIND_IN_SET('".(int)$v."',Respcount.responsibilities)"; $v is the value that comes from the form. Then I join everything that is in temp with implode and call find all: $this->Docket->findAll(implode(' AND ',$temp)); When I look at the query the comma in FIND_IN_SET('".(int) $v."',Respcount.responsibilities) is stripped so the query dies. I have not looked through the cake code yet, I just assumed it is an automatic safety measure to avoid sql injections. But in this case I need the comma. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---