> It sounds to me like you are asking the wrong question - what sql is > getting executed. > > AD
Since I am using the query function of a model the executed SQL is correct, its just the string that i supply. That is not the problem. I already used the debug mode to see what gets executed. The problem is that cake tries to split the answer of the database into its known multi-dimensional array structure... So, to stick to the original example, I would use a code like this: $sqlstring = "select users.id, users.name, my_custom_function(users.id, 'ABC'), users.phone from users where users.id > 500;"; $result = $this->User->query($sqlstring); Then $result will hold the array which I showed in my last posting... which is quiet useless because users.phone is missing (or anything that comes after the function call). --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
