Re: adodb - absolutepage

From: Bjørn Ivar Katla <katla(at)bitmaker(dot)no>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: adodb - absolutepage
Date: 2010-10-28 13:42:07
Message-ID: 6901022C-19CC-4D93-82D2-98401C9A932C@bitmaker.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

You are absolutely right - the declarations of the file containing adUseClient was missing in my code and vbscript is very tolerant of declarations anywhere in the code...

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ørn Ivar Katla

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

> (2010/10/28 21:20), Bjørn Ivar Katla wrote:
>> Here are the results. Pagecount are correct ( pagesize set to 20, records: 28)
>>
>> rs.absolutepage : -1
>> rs.pagecount: 2
>> rs.cursortype: 3
>> rs.locktype: 3
>> rs.cusorlocation: 2
>
> Doesn't rs.CursorLocation=2 mean adUseServer?
>
> regards,
> Hiroshi Inoue
>
>> regards
>> Bjørn Ivar Katla
>>
>>>
>>> (2010/10/28 4:58), Bjørn 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 against 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 .absolutepage 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 = adUseClient
>>>> rs.PageSize = 20
>>>> rs.Open sql, sconn,1,3
>>>
>>> I see .absolutePage=1 here.
>>>
>>> Could you display .CursorType, .LockType or .CursorLocation after
>>> opening the recordset?
>>>
>>> regards,
>>> Hiroshi Inoue

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message r.melizzi@tin.it 2010-10-30 20:49:28 psqlodbc_09_00_0200 - Information
Previous Message Hiroshi Inoue 2010-10-28 13:02:12 Re: adodb - absolutepage