Mantis Bugtracker

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0003796 [Quercus] major always 12-02-09 01:52 12-02-09 01:52
Reporter Heiko View Status public  
Assigned To
Priority normal Resolution open  
Status new   Product Version 4.0.2
Summary 0003796: pg_query_params doesn't return true value on non-select statements
Description When using update/insert/delete statements with pg_query_params, quercus returns a false value, even if the query was successful. It is therefore not possible to test the correctness of the query and the following code fails:

$sqlsentence =
          'UPDATE Sessions SET sessionstate = $1, accesstime = $2 ' .
          'WHERE sessionid = $3';
$result = pg_query_params($mmDbConnection, $sqlsentence, array($s1, $AccessTime, $mmSessionId));
if (!$result) {
   ...handle error...
Additional Information [^]

Return Values

A query result resource on success or FALSE on failure.

/com/caucho/quercus/lib/db/ #executeInternal:
      if (pstmt.getStatementType().equals("SELECT")) {
        PostgresResult result = new PostgresResult(env, null, pstmt.getResultSet(), null);
        return result;
      } else {
        // XXX: ??? return type?
        return null;
        // return pstmt;
Attached Files

- Relationships

There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
12-02-09 01:52 Heiko New Issue

Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
26 total queries executed.
24 unique queries executed.
Powered by Mantis Bugtracker