Possible Bug in SQL Monitor of Community.

After executing an UPDATE statement, it says, "Your query returned 0 rows." when infact, it updated 4573 records.



Mike

----------
Michael J. Challis - CRUZN8R - PT Cruiser Club - http://www.ptcruiserclub.org

http://www.ptcruiserclub.org/forum

SQL Monitor just executes your query.
You get the result text directly from the database software.

I'm not quite sure, but an update query in MySQL will only result row numbers, if data was really changed. If you do update more times with same data, will be returned 0 rows.

Best regards,
Webmaster33

---

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

How do you know it updated over 4000 rows if it said 0? =)

MySQLMan ;)

I guess you don't have to believe me, what do I care. Try it yourself.

Mike

----------
Michael J. Challis - CRUZN8R - PT Cruiser Club - http://www.ptcruiserclub.org

http://www.ptcruiserclub.org/forum

I use mysqlman all the time...it works fine.

This information was for the programmer of this beta software. Are you the programmer?

I can duplicate this everytime.

Mike

----------
Michael J. Challis - CRUZN8R - PT Cruiser Club - http://www.ptcruiserclub.org

http://www.ptcruiserclub.org/forum

Are you referring to mysqlman or something different - I'm confused?

Ok I see you are using the SQL monitor.

I just took a look at the code and inside the while loop that fetches the query results then it increments a counter using:

$count++

..which is then passed into a language variable, so I can't see why it would return 0.