Nevermind... I figured it out. The value 36 was actually a php float type and thats why it was being converted like that by dbosource. explicitly converting that value using intval() fixed the problem.
On Dec 7, 1:07 pm, Ozzy OG Kush <[email protected]> wrote: > 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
