Thread: SELECT DISTINCT

i have an application intended to allow someone to look at an image file,
and enter data about the subject of the image. the application puts up a
copy of the image, and them provides fields for the user to fill in. the
combo boxes are preloaded with the data that has been seen before (like
model numbers). i am generating a web page, and using C for the
application, running on PGSQL 7.2 on a Lunix 7.2 (RH) system.

so far, the application seems to work fine, when it works. occasionally, it
seems to fail after a call to the database of SELECT DISTINCT, which i use
to preload the combo boxes. usually it fails during the same call each time
thru (looking for the same column), but occasionally it fails somewhere
else. reloading the page sometimes cures the problem, but sometimes not.

the application is not leaving me any pearls of wisdom in the syslog file,
and the process is not hung up.

i am sure it is something stupid i am doing.

this is the string i am using to query the database:

#define DBGSTRING "SELECT DISTINCT %s FROM %s ;\n"

any help would be appreciated, i have been hitting this wall for about
three weeks, and working around it, but i need to get things settled down
soon, so i need to deal with it.

thanx


stev knowles

On Thu, 2002-05-23 at 06:01, stev knowles wrote:
>
> the application is not leaving me any pearls of wisdom in the syslog file,
> and the process is not hung up.
>
> i am sure it is something stupid i am doing.
>
> this is the string i am using to query the database:
>
> #define DBGSTRING "SELECT DISTINCT %s FROM %s ;\n"

In this sort of situation I will wrap the query call:

  $query = sprintf( DBGSTRING, $fieldname, $tablename );
  $result = pg_Exec( $myconn, $query );
  error_log( "QF: $query", 0);

Then I can look at syslog after it happened.

Of course you have to enable logging to syslog from within PHP, and if
you do that you might also suddenly discover what is happening through a
more useful error message.

Regards,
                    Andrew.
--
--------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/        PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201    MOB: +64(21)635-694    OFFICE: +64(4)499-2267
       Are you enrolled at http://schoolreunions.co.nz/ yet?