I'm using CakePHP 1.3.6, DB is postgresql 8. I tried your suggestion but it did not work.
On Dec 7, 12:16 pm, Geoff Douglas <[email protected]> wrote: > What Cake version are you using here? > What database server are you using? > > it appears that the values are still coming across as strings. (They are > both enclosed in single quotes) > You may want to edit your between clause and expicitly convert the values > that you are passing in to integers. > > In MySQL this is done by wrapping the value in a CONVERT() or CAST() > function. > So your array would look like > > [1] => Array > ( > ["T39_3"::integer BETWEEN CAST(? as INT) AND CAST(? as > INT)] => Array > ( > [0] => 22 > [1] => 36 > ) > > ) > Let me know if that works. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
