PHP DataGrid and ODBC

Talk about working with different database types

Moderator: alexandrleonenko

legionar
Newbie
Newbie
Posts: 3
Joined: Jul 16th, '10, 06:33

PHP DataGrid and ODBC

Postby legionar » Jul 16th, '10, 06:54

As a newbie in DataGrid, I have a problem with DataDirect ODBC 4.1 32-Bit Progress SQL92 v9.1D driver.
I can connect, but I always get only first record, in spite of the fact, that I can see number of records at the bottom of the page.
Moreover, in a simple standalone PHP page I can get all records.
So, it is hidden somewhere in DataGrid.
Can you help me ?

P.S. I discovered, that in function DrawTabular() the variable row_upper is NOT DEFINED ! Why ? :shock:

administrator
Site Admin
Site Admin
Posts: 6003
Joined: Jan 7th, '09, 23:18
Contact:

Re: PHP DataGrid and ODBC

Postby administrator » Jul 18th, '10, 11:12

What version you work with?

legionar
Newbie
Newbie
Posts: 3
Joined: Jul 16th, '10, 06:33

Re: PHP DataGrid and ODBC

Postby legionar » Jul 19th, '10, 07:06

administrator wrote:What version you work with?

Progress 9.1D04
PHP DataGrid version 4.2.8 (01.10.2008)

I made a weird attempt, and changed the value of $this->row_upper by hand (datagrid.class.php, row 2803) - and I saw immediately all my records on the screen.
So, physically, everything is OK, except the fact, that in case of this driver, DataGrid does not define $this->row_upper.
And I don't know why ... :(

administrator
Site Admin
Site Admin
Posts: 6003
Joined: Jan 7th, '09, 23:18
Contact:

Re: PHP DataGrid and ODBC

Postby administrator » Jul 19th, '10, 07:33

We recommend you move to DataGrid Pro - there were many mssql and odbc issues already fixed.


Return to “Databases: different types implementation”