and what if you define an alias to your column? select users.id, users.name, my_custom_function(users.id, 'ABC') AS custom, users.phone from users where users.id > 500;
or better : "AS users.custom" and another question, do you need to specify "users.id" instead of just "id" ? In your example, it will work On 29 mai, 20:53, weckmann <[EMAIL PROTECTED]> wrote: > That is a small workaround... because then i can get the value > returned by the function by calling $result[0] > ['my_custom_function(users'][id] ... and I also have all other values > before. > > But that workaround does not work if you need to call more than one > function. It only works if you call just "normal" columns and in the > end one single speciality. > > And also, if you have a function with more than 2 parameters, things > are getting much worse because then there is another "," in the string > and Cake get really crazy about this ;-) > > So, I guess, I have to avoid using functions... or only use on in the > end of the string? Or does anyone have a rabbit hidden in his had for > me? > > On 29 Mai, 17:53, "b logica" <[EMAIL PROTECTED]> wrote: > > > What happens if you put the function call last in your query? > > > On Thu, May 29, 2008 at 9:47 AM, weckmann <[EMAIL PROTECTED]> wrote: > > > > 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 -~----------~----~----~----~------~----~------~--~---
