Re: Cake 1.2, multiple sql function in query

2007-06-08 Thread francky06l
Thanks AD, did not think of trying this one in this way. cheers On Jun 8, 2:18 pm, AD7six <[EMAIL PROTECTED]> wrote: > On Jun 7, 5:11 pm, francky06l <[EMAIL PROTECTED]> wrote: > > > > > Hi All, > > > I am starting to use cake 1.2 for a project. I want to do things in > > the "cake" way and on the

Re: Cake 1.2, multiple sql function in query

2007-06-08 Thread AD7six
On Jun 7, 5:11 pm, francky06l <[EMAIL PROTECTED]> wrote: > Hi All, > > I am starting to use cake 1.2 for a project. I want to do things in > the "cake" way and on the simple tests db I wanted to retrieve the > street name by soundex as well as checking the soundex of the reverse > string. > > My

Cake 1.2, multiple sql function in query

2007-06-07 Thread francky06l
Hi All, I am starting to use cake 1.2 for a project. I want to do things in the "cake" way and on the simple tests db I wanted to retrieve the street name by soundex as well as checking the soundex of the reverse string. My query look like this : // this is needed to reverse the utf-8 strin