Re: "BETWEEN ? AND ?" turning some values into floats

2011-12-07 Thread Ozzy OG Kush
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 wrote: > I even tried switching it up to the following, w

Re: "BETWEEN ? AND ?" turning some values into floats

2011-12-07 Thread Ozzy OG Kush
7; still comes out in the query as '36.00'. On Dec 7, 12:25 pm, Ozzy OG Kush 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 wrote: > > > > > > > >

Re: "BETWEEN ? AND ?" turning some values into floats

2011-12-07 Thread Ozzy OG Kush
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 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 encl

"BETWEEN ? AND ?" turning some values into floats

2011-12-07 Thread Ozzy OG Kush
I have a situation where I have to add a "BETWEEN ? AND ?" condition to a set of queries. The strangest thing happens though - certain values get turned into floats. Here's an example of the conditions that CakePHP sends to model- >find(): [code] Array ( [SurveyData.SS_COMPLETE] => 1 [AND]

Re: data source not properly quoting casted fields in conditions array

2011-10-05 Thread Ozzy OG Kush
Unfortunately our DB engineer does not want to add any kind of implicit casting to the DB because it may break other things. I'm trying to avoid duplicating the work that DboSource->read() does in case future versions of Cake modify the way they do things, because that solution had not escaped me.

data source not properly quoting casted fields in conditions array

2011-10-05 Thread Ozzy OG Kush
I believe I have found a bug in CakePHP. I have a complex array of conditions being passed into a model->find() call. The field in the database is always a 'text' datatype (postgresql), but sometimes acts as a number and therefore I have to cast it, and its NOT possible to switch these datatypes be

Re: Need help getting site to work

2008-10-26 Thread Ozzy OG Kush
connection errors (showing file paths and such), which I don't want to happen. Thoughts/suggestions? On Oct 25, 6:35 pm, Ozzy OG Kush <[EMAIL PROTECTED]> wrote: > I'm using CakePHP 1.1, and Apache 2.2. > > On Oct 24, 4:45 pm, Ozzy OG Kush <[EMAIL PROTECTED]> wrote:

Re: Need help getting site to work

2008-10-25 Thread Ozzy OG Kush
I'm using CakePHP 1.1, and Apache 2.2. On Oct 24, 4:45 pm, Ozzy OG Kush <[EMAIL PROTECTED]> wrote: > Here's my situation. I have my site (http://www.phillynorml.org/) set > up in a production environment (index.php, .htaccess, img, css, js, > etc in ../DocumentRoot, e

Need help getting site to work

2008-10-24 Thread Ozzy OG Kush
Here's my situation. I have my site (http://www.phillynorml.org/) set up in a production environment (index.php, .htaccess, img, css, js, etc in ../DocumentRoot, everything else in ../cake, and it's working great for the most part. The problem is that in DocumentRoot I have another folder with a

Re: I can not solve "Session - losing value after redirect" problem after I read all previous posts.

2008-05-22 Thread Ozzy OG Kush
I'm having the same problem!!! It simply won't save sessions for me. On Apr 14, 1:49 pm, columbus <[EMAIL PROTECTED]> wrote: > Hi, > > I am a beginner in both php andcakePHP. I have met the same problem > as many previous posts. However, I have tried most of the solutions > and it is still not wo

Re: Session problem

2008-05-21 Thread Ozzy OG Kush
Hey, I am having this same exact problem! I'm using CakePHP 1.1.19.6305 . This is very frustrating! Any help would be very appreciated. On Apr 23, 11:45 am, creationsings <[EMAIL PROTECTED]> wrote: > Did you ever find a solution to this?  I think I am experiencing a > similar problem.  I can wr