pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Strange browser behavior when querying PostgreSql database
9+ messages / 6 participants
[nested] [flat]

* Strange browser behavior when querying PostgreSql database
@ 2003-09-02 14:50 gras.christophe@libertysurf.fr
  2003-09-02 21:35 ` Re: Strange browser behavior when querying PostgreSql database CoL <col@mportal.hu>
  2003-09-05 08:43 ` Re: Strange browser behavior when querying PostgreSql database Gerd Terlutter <Gerd.Terlutter@MplusB.de>
  2003-09-05 12:31 ` Re: Strange browser behavior when querying PostgreSql database Bruno Wolff III <bruno@wolff.to>
  2003-09-05 12:31 ` Re: Strange browser behavior when querying PostgreSql database Bruno Wolff III <bruno@wolff.to>
  2003-09-05 12:43 ` Re: Strange browser behavior when querying PostgreSql database Luis H <pgsql-php@geekhouse.no-ip.com>
  2003-09-05 12:43 ` Re: Strange browser behavior when querying PostgreSql database Luis H <pgsql-php@geekhouse.no-ip.com>
  0 siblings, 6 replies; 9+ messages in thread

From: gras.christophe@libertysurf.fr @ 2003-09-02 14:50 UTC (permalink / raw)
  To: pgsql-php

Hi,

I have a problem in a php script :

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 ....

The problem comes from a request I peform in this PHP script :

when I do the following request I have the problems quoted above :

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?


Thanks in advance,


Christophe Gras



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Strange browser behavior when querying PostgreSql database
  2003-09-02 14:50 Strange browser behavior when querying PostgreSql database gras.christophe@libertysurf.fr
@ 2003-09-02 21:35 ` CoL <col@mportal.hu>
  5 siblings, 0 replies; 9+ messages in thread

From: CoL @ 2003-09-02 21:35 UTC (permalink / raw)
  To: pgsql-php

Hi,

Chris FR wrote, On 9/2/2003 4:50 PM:

> Is it due to PHP ? or PostgreSQL?
You know :) Debug it.

C.




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Strange browser behavior when querying PostgreSql database
  2003-09-02 14:50 Strange browser behavior when querying PostgreSql database gras.christophe@libertysurf.fr
@ 2003-09-05 08:43 ` Gerd Terlutter <Gerd.Terlutter@MplusB.de>
  5 siblings, 0 replies; 9+ messages in thread

From: Gerd Terlutter @ 2003-09-05 08:43 UTC (permalink / raw)
  To: Chris FR <gras.christophe@libertysurf.fr>; +Cc: 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@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        #
--------------------------------------------------------





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Strange browser behavior when querying PostgreSql database
  2003-09-02 14:50 Strange browser behavior when querying PostgreSql database gras.christophe@libertysurf.fr
@ 2003-09-05 12:31 ` Bruno Wolff III <bruno@wolff.to>
  5 siblings, 0 replies; 9+ messages in thread

From: Bruno Wolff III @ 2003-09-05 12:31 UTC (permalink / raw)
  To: Chris FR <gras.christophe@libertysurf.fr>; +Cc: pgsql-php

On Tue, Sep 02, 2003 at 07:50:15 -0700,
  Chris  FR <gras.christophe@libertysurf.fr> wrote:
> 
> SELECT a.* FROM a WHERE a.idf = b.id

You shouldn't use the above syntax as it is non standard and is more
commonly used by mistake than intentionally. People looking at your code
later will wonder what you were really trying to do.

> I solved the problem by modifying the request :
> 
> SELECT a.* FROM a, b WHERE a.idf = b.id
> 
> Now the script works.

I am not sure why there is a difference in these two cases. Possibly you
didn't give us the real queries and there is something else going on.



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Strange browser behavior when querying PostgreSql database
  2003-09-02 14:50 Strange browser behavior when querying PostgreSql database gras.christophe@libertysurf.fr
@ 2003-09-05 12:31 ` Bruno Wolff III <bruno@wolff.to>
  5 siblings, 0 replies; 9+ messages in thread

From: Bruno Wolff III @ 2003-09-05 12:31 UTC (permalink / raw)
  To: Chris FR <gras.christophe@libertysurf.fr>; +Cc: pgsql-php

On Tue, Sep 02, 2003 at 07:50:15 -0700,
  Chris  FR <gras.christophe@libertysurf.fr> wrote:
> 
> SELECT a.* FROM a WHERE a.idf = b.id

You shouldn't use the above syntax as it is non standard and is more
commonly used by mistake than intentionally. People looking at your code
later will wonder what you were really trying to do.

> I solved the problem by modifying the request :
> 
> SELECT a.* FROM a, b WHERE a.idf = b.id
> 
> Now the script works.

I am not sure why there is a difference in these two cases. Possibly you
didn't give us the real queries and there is something else going on.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)






^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Strange browser behavior when querying PostgreSql database
  2003-09-02 14:50 Strange browser behavior when querying PostgreSql database gras.christophe@libertysurf.fr
@ 2003-09-05 12:43 ` Luis H <pgsql-php@geekhouse.no-ip.com>
  5 siblings, 0 replies; 9+ messages in thread

From: Luis H @ 2003-09-05 12:43 UTC (permalink / raw)
  To: Chris FR <gras.christophe@libertysurf.fr>; pgsql-php

Are you sure it freezes on the query? Could it be php code that uses the
results from the query that hang the system?

-L
----- Original Message ----- 
From: "Chris FR" <gras.christophe@libertysurf.fr>
To: <pgsql-php@postgresql.org>
Sent: Tuesday, September 02, 2003 10:50 AM
Subject: [PHP] Strange browser behavior when querying PostgreSql database


> Hi,
>
> I have a problem in a php script :
>
> 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 ....
>
> The problem comes from a request I peform in this PHP script :
>
> when I do the following request I have the problems quoted above :
>
> 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?
>
>
> Thanks in advance,
>
>
> Christophe Gras
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Strange browser behavior when querying PostgreSql database
  2003-09-02 14:50 Strange browser behavior when querying PostgreSql database gras.christophe@libertysurf.fr
@ 2003-09-05 12:43 ` Luis H <pgsql-php@geekhouse.no-ip.com>
  5 siblings, 0 replies; 9+ messages in thread

From: Luis H @ 2003-09-05 12:43 UTC (permalink / raw)
  To: Chris FR <gras.christophe@libertysurf.fr>; pgsql-php

Are you sure it freezes on the query? Could it be php code that uses the
results from the query that hang the system?

-L
----- Original Message ----- 
From: "Chris FR" <gras.christophe@libertysurf.fr>
To: <pgsql-php@postgresql.org>
Sent: Tuesday, September 02, 2003 10:50 AM
Subject: [PHP] Strange browser behavior when querying PostgreSql database


> Hi,
>
> I have a problem in a php script :
>
> 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 ....
>
> The problem comes from a request I peform in this PHP script :
>
> when I do the following request I have the problems quoted above :
>
> 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?
>
>
> Thanks in advance,
>
>
> Christophe Gras
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster






^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Strange browser behavior when querying PostgreSql database
@ 2003-09-05 08:28 Grant Henderson <granth@fusion-advertising.co.uk>
  0 siblings, 0 replies; 9+ messages in thread

From: Grant Henderson @ 2003-09-05 08:28 UTC (permalink / raw)
  To: pgsql-php


Perhaps you are referencing a table (b) that has not been included?
-----Original Message-----
From: Chris FR [mailto:gras.christophe@libertysurf.fr] 
Sent: 02 September 2003 15:50
To: pgsql-php@postgresql.org
Subject: [PHP] Strange browser behavior when querying PostgreSql
database


Hi,

I have a problem in a php script :

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 ....

The problem comes from a request I peform in this PHP script :

when I do the following request I have the problems quoted above :

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?


Thanks in advance,


Christophe Gras

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)






^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Strange browser behavior when querying PostgreSql database
@ 2003-09-05 08:28 Grant Henderson <granth@fusion-advertising.co.uk>
  0 siblings, 0 replies; 9+ messages in thread

From: Grant Henderson @ 2003-09-05 08:28 UTC (permalink / raw)
  To: pgsql-php


Perhaps you are referencing a table (b) that has not been included?
-----Original Message-----
From: Chris FR [mailto:gras.christophe@libertysurf.fr] 
Sent: 02 September 2003 15:50
To: pgsql-php@postgresql.org
Subject: [PHP] Strange browser behavior when querying PostgreSql
database


Hi,

I have a problem in a php script :

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 ....

The problem comes from a request I peform in this PHP script :

when I do the following request I have the problems quoted above :

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?


Thanks in advance,


Christophe Gras

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster




^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2003-09-05 12:43 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-09-02 14:50 Strange browser behavior when querying PostgreSql database gras.christophe@libertysurf.fr
2003-09-02 21:35 ` CoL <col@mportal.hu>
2003-09-05 08:43 ` Gerd Terlutter <Gerd.Terlutter@MplusB.de>
2003-09-05 12:31 ` Bruno Wolff III <bruno@wolff.to>
2003-09-05 12:31 ` Bruno Wolff III <bruno@wolff.to>
2003-09-05 12:43 ` Luis H <pgsql-php@geekhouse.no-ip.com>
2003-09-05 12:43 ` Luis H <pgsql-php@geekhouse.no-ip.com>
2003-09-05 08:28 Re: Strange browser behavior when querying PostgreSql database Grant Henderson <granth@fusion-advertising.co.uk>
2003-09-05 08:28 Re: Strange browser behavior when querying PostgreSql database Grant Henderson <granth@fusion-advertising.co.uk>

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