Re: [PHP] Postgres query problem
Yeah, I found the problem, It was adding a "order by lower(title)" in another class which I forgot about when I was trying to test the query. so it works fine now. So yep, using, joines, case, order bys, lowers,inheritance in php/postgres all work fine. 1LT John W. Holmes wrote: >Double check that you have a.title, and not just title by itself. Two >tables must have a title column, so make sure you specify which one you >mean. > >---John Holmes... > >- Original Message - >From: "Aaron" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, June 12, 2002 12:40 AM >Subject: [PHP] Postgres query problem > > > > >>I have a sql quer like this : " select a.title AS bugga, b.id AS asdf >>FROM tableone AS a FULL JOIN tabletwo AS b ON(a.title=b.filething)" >> >>anyway, thats a test query which is slightly smaller then the one I >>want. BUT when i use it from the command console in postgres, it works >>no problem >> >>but in php it complains about ambiguos column "title".. so I dont >>know what I can do about it. >> >> >>-- >>PHP General Mailing List (http://www.php.net/) >>To unsubscribe, visit: http://www.php.net/unsub.php >> >> >> > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Postgres query problem
Double check that you have a.title, and not just title by itself. Two tables must have a title column, so make sure you specify which one you mean. ---John Holmes... - Original Message - From: "Aaron" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 12:40 AM Subject: [PHP] Postgres query problem > I have a sql quer like this : " select a.title AS bugga, b.id AS asdf > FROM tableone AS a FULL JOIN tabletwo AS b ON(a.title=b.filething)" > > anyway, thats a test query which is slightly smaller then the one I > want. BUT when i use it from the command console in postgres, it works > no problem > > but in php it complains about ambiguos column "title".. so I dont > know what I can do about it. > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Postgres query problem
I have a sql quer like this : " select a.title AS bugga, b.id AS asdf FROM tableone AS a FULL JOIN tabletwo AS b ON(a.title=b.filething)" anyway, thats a test query which is slightly smaller then the one I want. BUT when i use it from the command console in postgres, it works no problem but in php it complains about ambiguos column "title".. so I dont know what I can do about it. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php