[PHP-WIN] Re: Excel OLE Automation : accessing the Excel constants

2009-05-26 Thread Geoff Lane
On Wednesday, May 27, 2009, 5:55:51 AM, Samuel wrote: > ExcelSheet.Range("C65536").End(xlUp) > This fails because the constant xlUp is undefined... > There is some user contributed notes about that problem in the > documentation (http://jp2.php.net/manual/en/book.com.php) but it doesn't > say if

[PHP-WIN] Excel OLE Automation : accessing the Excel constants

2009-05-26 Thread Faubry, Samuel
Hi, I'm confronted to a new problem with Excel Automation: I don't manage to access the constants. For example, I want to find the last cell in a column: ExcelSheet.Range("C65536").End(xlUp) This fails because the constant xlUp is undefined... There is some user contributed notes about that pr

Re: [PHP-WIN] Counting returned MySQL rows, and possibly storing returned recordset in a session variable

2009-05-26 Thread Jacob Kruger
Will look at the mysql_num_rows function. Suppose I could try something like assigning the whole returned recordset to an array that I then saved in a session variable, but depending on the size of the returned data rows it might not be worth it in terms of load on the server. Am currently just l

[PHP-WIN] Counting returned MySQL rows, and possibly storing returned recordset in a session variable

2009-05-26 Thread Jacob Kruger
As far as I know/thought, you could include something like COUNT(*) in a list of fields to be returned from MySQL to get told how many rows were returned by mysql_query, but it doesn't seem to want to work on this instance of MySQL I have here installed inside WAMP. Also, if I try assigning the