From: | Gerd Terlutter <Gerd(dot)Terlutter(at)MplusB(dot)de> |
---|---|
To: | Chris FR <gras(dot)christophe(at)libertysurf(dot)fr> |
Cc: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: Strange browser behavior when querying PostgreSql database |
Date: | 2003-09-05 08:43:13 |
Message-ID: | 3F584CA1.6070205@MplusB.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
Chris FR wrote:
> when I execute it via Internet Explorer , sometimes the source is
> complete (no problem), sometimes the source is incomplete (the html
> page is cutted), and sometimes the browser doesn't display anything
> and wait and wait and wait ....
It looks like a typical M$ problem ;-)
most developers use Linux
> SELECT a.* FROM a WHERE a.idf = b.id
>
> I solved the problem by modifying the request :
>
> SELECT a.* FROM a, b WHERE a.idf = b.id
>
> Now the script works.
>
> But I don't understand why the first request causes those problems ?
>
> Is the first request has a correct syntax ? ( when submitted to
> Postgres, there is no error message , and the results are displayed)
> Is it due to PHP ? or PostgreSQL?
>
have you set
error_reporting = E_ALL & ~E_NOTICE
in your php.ini ? and no error-output in a bad sql-statement?then i
don't know, but i think it's better to make joint-select with ...from
'all joint tables' where ...
bye, Gerd
--
--------------------------------------------------------
# Gerd Terlutter | Mueller+Blanck Software GmbH #
# gerd(at)MplusB(dot)de | Gutenbergring 38 #
# gerd(dot)terlutter(at)web(dot)de | D-22848 Noderstedt #
# tel:0171/6992579 | tel:+49 40 500 171-1 #
# Buero:040/500171-17 | fax:+49 40 500 171-71 #
--------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-09-05 12:31:50 | Re: Strange browser behavior when querying PostgreSql database |
Previous Message | Grant Henderson | 2003-09-05 08:28:07 | Re: Strange browser behavior when querying PostgreSql database |