Not sure about the attribute, but why not just use $DBI::errstr along with
the return value. If an error is return you can display the $DBI::errstr if
not, but no rows are returned/updated you can display the "No rows found"
message yourself.
Ilya
-----Original Message-----
From: Curt Russell Crandall
To: [EMAIL PROTECTED]
Sent: 07/03/2001 10:14 AM
Subject: getting return messages from non-selects in Informix
I have a FCGI script that lets you enter an sql statement in a textbox
and
on submit the statement is submitted to the database. If it is a select
statement, a table with the results is displayed. If it is not a select
statement, the program simply prints an error that fetch* didn't work.
I'd like to make this program more intelligent by displaying the message
returned by the database by successful update, delete, insert,
etc. statements. I'm using Informix and I'm unable to find an attribute
or function that allows me to do this. I believe in Sybase you can just
do a fetch and grab a particular piece of the result set that would
contain this data (don't have the perldoc for DBD::Sybase in front of
me,
so I don't know offhand what the syntax would be to do this). Is
there's
something equivalent I can use under Informix to get this information?
Example
update informix.vp_ppreq
set ts = '2001-07-04 12:00:00'
where prt_date = '2001-03-01'
No rows found. -----> this is what I want to get!!!
Thank you,
Curt Crandall
