Hello, I attempt to get some list using SQLObject and MySQL and count number of results using SQL_CALC FOUND_ROWS and FOUND_ROWS() like this:
select_statement = "SELECT SQL_CALC_FOUND_ROWS * FROM table1" count_statement = "SELECT FOUND_ROWS()" conn = connectionForURI( config.get( 'sqlobject.dburi' ) ) results = conn.queryAll( select_statement ) results2 = conn.queryAll( count_statement ) num_of_results = results2[0][0] However, when this method is called frequently, the num_of_results value will be wrong. (often '1' ) I checked connections of the two queries by using CONNECTION_ID() function and found that connection IDs are different when the num_of_results value is wrong. How can I get correct value? -- Yasuo Shirai --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
