Re: Find() returns different formatted array when using Postgresql vs Mysql ( any way to resolve this? )

2013-01-11 Thread andrew gardner
I recognize this is an old thread, so I'm posting this answer here because I had the same issue today, and couldn't find a solution anywhere. I'll note I'm a relative novice to PHP. I ran into this issue converting a Cakephp 1.2 app from Mysql to Postgres. There are several instances of the "quer

Re: Find() returns different formatted array when using Postgresql vs Mysql ( any way to resolve this? )

2010-04-15 Thread altermod
Well I'm still using Cake version 1.1 so I can't used findfirst(). I'm just using find(). On Thu, Apr 15, 2010 at 8:46 AM, John Andersen wrote: > How do your find code look like? Are you using All or First? > Enjoy, >John > > On Apr 15, 7:30 am, Adam wrote: > > When I do a find and get 1

Re: Find() returns different formatted array when using Postgresql vs Mysql ( any way to resolve this? )

2010-04-15 Thread John Andersen
How do your find code look like? Are you using All or First? Enjoy, John On Apr 15, 7:30 am, Adam wrote: > When I do a find and get 1 row back in Postgres it has to be > referenced like $data[0][email] whereas in Mysql you can do > $data[Account][email]. > > I just migrated from Mysql to Postg

Find() returns different formatted array when using Postgresql vs Mysql ( any way to resolve this? )

2010-04-14 Thread Adam
When I do a find and get 1 row back in Postgres it has to be referenced like $data[0][email] whereas in Mysql you can do $data[Account][email]. I just migrated from Mysql to Postgres so I just have to go thru and change all single result queries that formerly worked in Mysql as $data[Account][emai