[Rdfapi-php-interest] Mysql commands out of sync

[Geraint E. <rd...@co...>]

I am new to RAP (I'm looking at it to develop a Firefox/RDF based 
application and am looking for a good way to keep my server datasources 
in sync)- it looks neat so far :-)  but I've come across a couple of 
problems.

1. Running through the Test:Manipulate DbModel I figured out that I had 
to call getNewModel if the model didn't exist.  A note to this effect or 
adding ti to the source code would be handy.

2. I encountered adodb errors in 2 places where the mysql commands were 
out of sync (I'm using MySQL 4.1.14 and PHP 5.1.2).  I upgraded the 
adodb drivers to the latest versions but that was no help.  To fix the 
problem I had to modify two functions in DbStore and DbModel by adding a 
$res->close() statement.

My modified code is :

function modelExists($modelURI) {

   $res =& $this->dbConn->execute("SELECT COUNT(*) FROM models
                                   WHERE modelURI = '" .$modelURI ."'");
   if (!$res)
      echo $this->dbConn->errorMsg();
   else {
         $res->close();
      if (!$res->fields[0])
         return FALSE;
      return TRUE;
   }
 }

    function contains(&$statement) {

        $sql = 'SELECT modelID FROM statements
           WHERE modelID = ' .$this->modelID;
        $sql .= $this->_createDynSqlPart_SPO($statement->subj, 
$statement->pred, $statement->obj);

        $res =& $this->dbConn->getOne($sql);
        if (!$res)
        return FALSE;
        $res->close();
        return TRUE;
    }

I don't have any other Databases to test this on.  Is this a specific 
bug to the mysqli driver?

Geraint