I even tried switching it up to the following, with no difference:
[code]
[1] => Array
(
["T39_3"::integer >=] => 22
["T39_3"::integer <=] => 36
)
[/code]
The value '36' still comes out in the query as '36.000000'.
On Dec 7, 12:25 pm, Ozzy OG Kush <[email protected]> wrote:
> 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
