At 19:22 01/03/2002 +0530, Chetan Lavti wrote: >Nope, >Sorry, but nowhere I was thinking about the boolean value. >I was only talking about the return value of mysql_affected_rows(Mysql >*)and it's return type is (unsigned int), which depends upon the no of >rows affected by the last query. >I have just ask you based upon a very rough table( flag_test).. >So, there is no question of returning boolean value..I think you >interpreted it wrongly. isn't it ??
You are correct. I just skipped through your question quickly >By the way, thanks for your suggestion. > >Thanks and regards, >Chetan Lavti > > > > > >-----Original Message----- >From: John Dean [mailto:[EMAIL PROTECTED]] >Sent: Friday, March 01, 2002 5:25 PM >To: DL Neil; Chetan Lavti; [EMAIL PROTECTED] >Subject: Re: Row affected from Mysql Command line and api's > > >Hi >I think you need to read a book on C since C has no notion of a boolean >value > >At 11:40 01/03/2002 +0000, DL Neil wrote: > >Hi Chetan, > > > >Suppose I have a table : > > > >mysql> select * from flag_test; > >+--------+------+ > >| name | flag | > >+--------+------+ > >| Chetan | Y | > >+--------+------+ > >1 row in set (0.00 sec) > > > >I am setting/unsetting the flag field from the api's ; > > > >Now if the flag is already set and I executes the Query from the Mysql > >Command prompt it shows : > >MySQL> update flag_test set flag='Y' where name='chetan'; > >Query OK, 0 rows affected (0.00 sec) > >Rows matched: 1 Changed: 0 Warnings: 0 > > > >but if the same Query I run from the C program and if I check the >return > >value of mysql_affected_rows(Mysql *) it returns 0 , > >Actually I am doing something based on it's return value but Instead of > >Rows matched: 1 > > > > > >=The function only returns the number of rows "affected"/updated, not > >the number of rows "matched" (in the WHERE clause). In this case, if >the > >flat was already "Y" (your interaction from the MySQL client), then the > >C program will not have had a change to make - and not counted it as > >"affected". > > > >=Change the flag to non-Y, and then re-run the C prog. > > > >=Regards, > >=dn > > > > > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail ><[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >Regards >John, >Former MySQL Developer > >----- >[EMAIL PROTECTED] >http://www.rygannon.com Regards John, Former MySQL Developer ----- [EMAIL PROTECTED] http://www.rygannon.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php