pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gerd Terlutter <Gerd.Terlutter@MplusB.de>
To: Chris FR <gras.christophe@libertysurf.fr>
Cc: pgsql-php@postgresql.org
Subject: Re: Strange browser behavior when querying PostgreSql database
Date: Fri, 05 Sep 2003 10:43:13 +0200
Message-ID: <3F584CA1.6070205@MplusB.de> (raw)
References: <2a584f81.0309020650.6457780e@posting.google.com>

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@MplusB.de        | Gutenbergring 38             #
# gerd.terlutter@web.de | D-22848 Noderstedt           #
# tel:0171/6992579      | tel:+49 40 500 171-1         #
# Buero:040/500171-17   | fax:+49 40 500 171-71        #
--------------------------------------------------------





view thread (9+ messages)  latest in thread

Message-ID: <3F584CA1.6070205@MplusB.de>
Permalink:  ../3F584CA1.6070205@MplusB.de/
Also on:    postgresql.org/message-id/3F584CA1.6070205@MplusB.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: Gerd.Terlutter@MplusB.de, gras.christophe@libertysurf.fr
  Subject: Re: Strange browser behavior when querying PostgreSql database
  In-Reply-To: <3F584CA1.6070205@MplusB.de>
  References: <2a584f81.0309020650.6457780e@posting.google.com> <3F584CA1.6070205@MplusB.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox