Hi, all, I have some extra information.
The target database is MSSQL. I found that if I run the update statment in a query analyser and then go back to my application to try again, the update statement will be fired. It seems strange to me. Is it an expected behaviour? Regard, Anthony -----Original Message----- From: Anthony Kong [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 4:49 PM To: '[EMAIL PROTECTED]' Subject: QueryBySQL and update statement Hi, all, I am using 0.9.8. I try to use QueryBySQL to apply an "update" clause on a few thousand records. I did not apply pb.getCollectionByQuery() on this sql object because it will fire "no resultset returned" error. Fair enough. So I did a pb.getCount(query_by_sql) instead. As far as I can see from the sql trace, a "select count(*) from object" table is fired instead of my update statement. I would like to know more about how to use QueryBySQL with an "update" sql statement. Regards, Anthony --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
