getting the number of affected rows
Hans Bulfone <[email protected]> Wed, 18 Oct 2006 15:41:43 +0200
| Newsgroups | gmane.lisp.clsql.devel |
|---|---|
| Message-ID | <[email protected]> |
hi, i need a way to get the number of affected rows of an sql update or delete expression, but it seems this is not supported by the current clsql version. this could be easily implemented, at least for postgresql and mysql, by changing database-execute-command to return the number of affected rows (got via PQcmdTuples or mysql_affected_rows) and execute-command to return the result of database-execute-command. what do you think of this? i can write a patch with the proposed changes for postgresql and mysql, (and perhaps sqlite2/3). bye, hans.