Confused again! Okay revdb_execute return the number of rows modified. This would make a 0 (zero) return value a indeterminate state. Since one cannot tell if 0 (zero) rows where modified or if a error occured preventing the statement from executing. How does one tell the difference?
K -==-=-=-=-=-=-==-=-=-=-=-=-=-=-==-=-=-=-=-=- Disclaimer: Any resemblance between the above views and those of my employer, my terminal, or the view out my window are purely coincidental. Any resemblance between the above and my own views is non-deterministic. The question of the existence of views in the absence of anyone to hold them is left as an exercise for the reader. The question of the existence of the reader is left as an exercise for the second god coefficient. (A discussion of non-orthogonal, non-integral polytheism is beyond the scope of this article.) --- On Tue 06/01, K < [EMAIL PROTECTED] > wrote: From: K [mailto: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Tue, 1 Jun 2004 10:35:35 -0400 (EDT) Subject: SQL UPDATE statements <br><br><br>According to my understanding of the database API revExecuteSQL is to be used for statements like INSERT and UPDATE. This statements error infromation is returned in "the result". I cannot seem to find a way to get the number of rows modified in a reExecute query that uses UPDATE. Any ideas? Is this simply a oversite? Is there a API I am unaware of? <br><br>K<br><br><br><br><br>-==-=-=-=-=-=-==-=-=-=-=-=-=-=-==-=-=-=-=-=-<br>Disclaimer:<br><br>Any resemblance between the above views and those of my<br>employer, my terminal, or the view out my window are purely<br>coincidental. <br>Any resemblance between the above and my own views is non-deterministic.<br><br> The question of the existence of views in the absence of anyone to hold<br>them<br>is left as an exercise for the reader. The question of the existence of<br>the reader<br> is left as an exercise for the second god coefficient. <br>(A discussion of non-orthogonal, non-integral polytheism is beyond the<br >scope of this >article.)<br><br><br><br>_______________________________________________<br>Join >Excite! - http://www.excite.com<br>The most personalized portal on the >Web!<br>_______________________________________________<br>use-revolution mailing >list<br>[EMAIL >PROTECTED]<br>http://lists.runrev.com/mailman/listinfo/use-revolution<br> _______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web! _______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
