GetRows, not working anymore after record 99 :'( - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

GetRows, not working anymore after record 99 :'(

My ASP application was working fine till now. My GetRows statement
returns 99 rows. Actually there are 100 rows since yesterday. Normally
it always went right, till someone added the row 100. Should I set a
pagesize or something, is there a limitation to 99 or 100?

I am using the following code:
~~~~~~~~~~~~~~~~~~~~~~~~
'connection string
strConnection = "provider=microsoft.jet.oledb.4.0; data source=" &
server.Mappath(strDatabase) &_
";jet oledb:database password=" &
strPassword

'en nog wat variabelen
dim mySql, conn, rs

mySql="select * from " & strTable

set conn=server.createobject("adodb.connection")
conn.open strConnection
set rs=conn.execute(mySQL)

If rs.eof then
response.write "No records matched
"
response.write mySQL & "
So cannot make table..."
Call CloseAll
response.end
End if


showblank=" "
shownull="empty"

'verkrijg alle gegevens uit de tabel en sluit de verbinding.
'!!!!!!!!!! alldata doesn't contain row 100 !!!!!!!!
alldata = rs.getrows()
rs.close
set rs=nothing
conn.close
set conn=nothing

'print de inhoud van de cellen in de tabel
numcols=ubound(alldata,1) 'verkrijg aantal elementen in 1e
argument van het array
numrows=ubound(alldata,2) '...
~~~~~~~~~~~~~~~~~~~~

I hope someone does have a solution or an idea that can bring me
toward a solution. All help is welcome. In the meanwhile my internet
application will be out of order. :'(

Much thanks in advance,

Roderik


[hr]
[red]The 100[/red] best Dutch [blue]websites (free participation):[/blue]
:-) http://www.top100nederland.tk/

Comments

Sign In or Register to comment.