pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
NULL feilds and ERROR messages from libpq++
3+ messages / 2 participants
[nested] [flat]

* NULL feilds and ERROR messages from libpq++
@ 2001-06-15 19:00 Tabor Kelly <pdxmax@dsl-only.net>
  2001-06-15 22:57 ` NULL feilds and ERROR messages from libpq++ Tabor Kelly <pdxmax@dsl-only.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Tabor Kelly @ 2001-06-15 19:00 UTC (permalink / raw)
  To: pgsql-interfaces

Okay, I need to generate e-mails based on a table that may or may not
have certain fields that are null. Why is it that every time I do a
PgDatabase::GetValue on a field that has a null value, I get an error
message printed to my console ("PQgetvalue: ERROR! tuple number 0 is
out of range 0..-1")? Is there a way to turn this off? If
not, what is a good work-around?

Thank You,

Tabor Kelly





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

* NULL feilds and ERROR messages from libpq++
  2001-06-15 19:00 NULL feilds and ERROR messages from libpq++ Tabor Kelly <pdxmax@dsl-only.net>
@ 2001-06-15 22:57 ` Tabor Kelly <pdxmax@dsl-only.net>
  2001-06-16 12:49   ` Re: NULL feilds and ERROR messages from libpq++ Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Tabor Kelly @ 2001-06-15 22:57 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

I am using the libpq++ interface to interact with a table that has
some NULL fields in it. Why is it that every time I do a
PgDatabase::GetValue on a field that has a NULL value, I get an error
message printed to my console ("PQgetvalue: ERROR! tuple number 0 is
out of range 0..-1")? Is this the normal behavior? It seems very odd
that it would be, since it is common to interact with tables that
contain NULL fields.

Thank You,

Tabor Kelly





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

* Re: NULL feilds and ERROR messages from libpq++
  2001-06-15 19:00 NULL feilds and ERROR messages from libpq++ Tabor Kelly <pdxmax@dsl-only.net>
  2001-06-15 22:57 ` NULL feilds and ERROR messages from libpq++ Tabor Kelly <pdxmax@dsl-only.net>
@ 2001-06-16 12:49   ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Peter Eisentraut @ 2001-06-16 12:49 UTC (permalink / raw)
  To: Tabor Kelly <pdxmax@dsl-only.net>; +Cc: pgsql-general@postgresql.org

Tabor Kelly writes:

> I am using the libpq++ interface to interact with a table that has
> some NULL fields in it. Why is it that every time I do a
> PgDatabase::GetValue on a field that has a NULL value, I get an error
> message printed to my console ("PQgetvalue: ERROR! tuple number 0 is
> out of range 0..-1")? Is this the normal behavior? It seems very odd
> that it would be, since it is common to interact with tables that
> contain NULL fields.

I think you're operating on a query result that returned zero rows.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter




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


end of thread, other threads:[~2001-06-16 12:49 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-15 19:00 NULL feilds and ERROR messages from libpq++ Tabor Kelly <pdxmax@dsl-only.net>
2001-06-15 22:57 ` Tabor Kelly <pdxmax@dsl-only.net>
2001-06-16 12:49   ` Peter Eisentraut <peter_e@gmx.net>

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