adodb - absolutepage

adodb - absolutepage

am 27.10.2010 21:58:58 von katla

Hi,

I am implementing PostgreSQL as a replacement for a ms sql server web appl=
ication and are using pgsqlodbc (8.4.2) on my windows IIS/.ASP against my 8=
..4 postgreSQL database on an ubuntu server.=20

Part of this applications is to enable users to search data and only have 2=
0 records displayed on each page. This is done by use of the .absolutepage=
property of ADODB.Recordset object. I set pagesize and when I open the r=
ecordset - the rs.absolutepage is -1

Here is the parameters I set when opening the recordset.

rs.CursorLocation =3D adUseClient
rs.PageSize =3D 20
rs.Open sql, sconn,1,3

I am using the OCBD driver right out of the box without any special options=
..

Are there options to make this work or is this not implemented in the drive=
r?=20

And since I am uncertain about this: Should I use the 9.x driver when the d=
atabase is 8.4?

Brgds

Bj=F8rn Ivar Katla
Bitmaker as
Fabrikkgaten 3=20
5059 Bergen - Norway

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: adodb - absolutepage

am 28.10.2010 05:57:23 von Hiroshi Inoue

(2010/10/28 4:58), Bj=F8rn Ivar Katla wrote:
> Hi,
>
> I am implementing PostgreSQL as a replacement for a ms sql server web =
application and are using pgsqlodbc (8.4.2) on my windows IIS/.ASP agains=
t my 8.4 postgreSQL database on an ubuntu server.
>
> Part of this applications is to enable users to search data and only ha=
ve 20 records displayed on each page. This is done by use of the .absolu=
tepage property of ADODB.Recordset object. I set pagesize and when I op=
en the recordset - the rs.absolutepage is -1
>
> Here is the parameters I set when opening the recordset.
>
> rs.CursorLocation =3D adUseClient
> rs.PageSize =3D 20
> rs.Open sql, sconn,1,3

I see .absolutePage=3D1 here.

Could you display .CursorType, .LockType or .CursorLocation after
opening the recordset?

regards,
Hiroshi Inoue


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: adodb - absolutepage

am 28.10.2010 14:20:18 von katla

Here are the results. Pagecount are correct ( pagesize set to 20, records:=
28)

rs.absolutepage : -1=20
rs.pagecount: 2=20
rs.cursortype: 3=20
rs.locktype: 3=20
rs.cusorlocation: 2

regards
Bj=F8rn Ivar Katla

>=20
> (2010/10/28 4:58), Bj=F8rn Ivar Katla wrote:
>> Hi,
>>=20
>> I am implementing PostgreSQL as a replacement for a ms sql server web a=
pplication and are using pgsqlodbc (8.4.2) on my windows IIS/.ASP against m=
y 8.4 postgreSQL database on an ubuntu server.
>>=20
>> Part of this applications is to enable users to search data and only hav=
e 20 records displayed on each page. This is done by use of the .absolutep=
age property of ADODB.Recordset object. I set pagesize and when I open th=
e recordset - the rs.absolutepage is -1
>>=20
>> Here is the parameters I set when opening the recordset.
>>=20
>> rs.CursorLocation =3D adUseClient
>> rs.PageSize =3D 20
>> rs.Open sql, sconn,1,3
>=20
> I see .absolutePage=3D1 here.
>=20
> Could you display .CursorType, .LockType or .CursorLocation after
> opening the recordset?
>=20
> regards,
> Hiroshi Inoue
>=20


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: adodb - absolutepage

am 28.10.2010 15:02:12 von Hiroshi Inoue

(2010/10/28 21:20), Bj=F8rn Ivar Katla wrote:
> Here are the results. Pagecount are correct ( pagesize set to 20, reco=
rds: 28)
>
> rs.absolutepage : -1
> rs.pagecount: 2
> rs.cursortype: 3
> rs.locktype: 3
> rs.cusorlocation: 2

Doesn't rs.CursorLocation=3D2 mean adUseServer?

regards,
Hiroshi Inoue

> regards
> Bj=F8rn Ivar Katla
>
>>
>> (2010/10/28 4:58), Bj=F8rn Ivar Katla wrote:
>>> Hi,
>>>
>>> I am implementing PostgreSQL as a replacement for a ms sql server we=
b application and are using pgsqlodbc (8.4.2) on my windows IIS/.ASP agai=
nst my 8.4 postgreSQL database on an ubuntu server.
>>>
>>> Part of this applications is to enable users to search data and only =
have 20 records displayed on each page. This is done by use of the .abso=
lutepage property of ADODB.Recordset object. I set pagesize and when I =
open the recordset - the rs.absolutepage is -1
>>>
>>> Here is the parameters I set when opening the recordset.
>>>
>>> rs.CursorLocation =3D adUseClient
>>> rs.PageSize =3D 20
>>> rs.Open sql, sconn,1,3
>>
>> I see .absolutePage=3D1 here.
>>
>> Could you display .CursorType, .LockType or .CursorLocation after
>> opening the recordset?
>>
>> regards,
>> Hiroshi Inoue

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: adodb - absolutepage

am 28.10.2010 15:42:07 von katla

You are absolutely right - the declarations of the file containing adUs=
eClient was missing in my code and vbscript is very tolerant of declaration=
s anywhere in the code...=20

I have tried with a 3 now (adUseClient) and it works as it should. Great=
- that means that I can continue with my move form MS SQL server to Linux/=
PostgreSQL.

regards and sorry for wasting your time with my own shortcomings...

Bj=F8rn Ivar Katla


Den 28. okt. 2010 kl. 15.02 skrev Hiroshi Inoue:

> (2010/10/28 21:20), Bj=F8rn Ivar Katla wrote:
>> Here are the results. Pagecount are correct ( pagesize set to 20, recor=
ds: 28)
>>=20
>> rs.absolutepage : -1
>> rs.pagecount: 2
>> rs.cursortype: 3
>> rs.locktype: 3
>> rs.cusorlocation: 2
>=20
> Doesn't rs.CursorLocation=3D2 mean adUseServer?
>=20
> regards,
> Hiroshi Inoue
>=20
>> regards
>> Bj=F8rn Ivar Katla
>>=20
>>>=20
>>> (2010/10/28 4:58), Bj=F8rn Ivar Katla wrote:
>>>> Hi,
>>>>=20
>>>> I am implementing PostgreSQL as a replacement for a ms sql server web=
application and are using pgsqlodbc (8.4.2) on my windows IIS/.ASP against=
my 8.4 postgreSQL database on an ubuntu server.
>>>>=20
>>>> Part of this applications is to enable users to search data and only h=
ave 20 records displayed on each page. This is done by use of the .absolut=
epage property of ADODB.Recordset object. I set pagesize and when I open =
the recordset - the rs.absolutepage is -1
>>>>=20
>>>> Here is the parameters I set when opening the recordset.
>>>>=20
>>>> rs.CursorLocation =3D adUseClient
>>>> rs.PageSize =3D 20
>>>> rs.Open sql, sconn,1,3
>>>=20
>>> I see .absolutePage=3D1 here.
>>>=20
>>> Could you display .CursorType, .LockType or .CursorLocation after
>>> opening the recordset?
>>>=20
>>> regards,
>>> Hiroshi Inoue


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc