NULL feilds and ERROR messages from libpq++

Started by Tabor Kellyalmost 25 years ago3 messagesgeneral
Jump to latest
#1Tabor Kelly
pdxmax@dsl-only.net

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

#2Tabor Kelly
pdxmax@dsl-only.net
In reply to: Tabor Kelly (#1)

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

#3Peter Eisentraut
peter_e@gmx.net
In reply to: Tabor Kelly (#2)
Re: NULL feilds and ERROR messages from libpq++

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