paging problem

[Savas Ates]

Current Recordset does not support updating. This may be a limitation of the
provider, or of the selected locktype.

my connection string

Set baglantim=Serve r.Createobject( "ADODB.Connecti on")
Outpost="PROVID ER=SQLOledb;Ini tial Catalog=friends ;User Id=sa
;password=;Data Source=localhos t" (it is oledb)

im using stored procedure to make a user search in asp what is my fault?
error line absolute page...
xx="exec st_usersearch
@email='',@firs tname='',@surna me='',@citytr=' ',@usergender=' ',@onlinestatus =
''"

Sayfalanacak_Ka yit=5

If Request.QuerySt ring("Sayfa") = "" Then
Gosterilen_Sayf a = 1
Else
Gosterilen_Sayf a = CInt(Request.Qu eryString("Sayf a"))
End If

set rs=server.Creat eObject("adodb. recordset")

rs.pagesize=Say falanacak_Kayit

rs.open xx,baglantim,1, 3
If Gosterilen_Sayf a > Toplam_Sayfa Then Gosterilen_Sayf a = Toplam_Sayfa
If Gosterilen_Sayf a < 1 Then Gosterilen_Sayf a = 1

rs.AbsolutePage = Gosterilen_Sayf a

[Bob Barrows [MVP]]

Savas Ates wrote:

Current Recordset does not support updating. This may be a limitation
of the provider, or of the selected locktype.

my connection string

Set baglantim=Serve r.Createobject( "ADODB.Connecti on")
Outpost="PROVID ER=SQLOledb;Ini tial Catalog=friends ;User Id=sa

It is EXTREMELY bad and insecure programming practice to use the sa account
in your applications. The sa account can do anything in your system (not
just in the database). It should be used ONLY for administration by the
database administrator. Create a new login with only the permissions needed
to perform the tasks required by your application and use that account
instead of the sa account.

Also, from the looks of it, your sa account may have a blank password*. This
is also a bad idea: several internet worms have targeted sql servers with
password-less sa accounts. If your sa account has no password, and you value
your network's security, you should drop whatever you are doing and assign
the account a secure password.

* unless you just left it out, which would be a good idea. There is nothing
worse than broadcasting your sa password to the internet. A better way to
obscure the password without giving the empression it was blank would have
been to use xxxx
;password=;Data Source=localhos t" (it is oledb)

im using stored procedure to make a user search in asp what is my
fault? error line absolute page...
xx="exec st_usersearch
@email='',@firs tname='',@surna me='',@citytr=' ',@usergender=' ',@onlinestatus =
''"

Sayfalanacak_Ka yit=5

If Request.QuerySt ring("Sayfa") = "" Then
Gosterilen_Sayf a = 1
Else
Gosterilen_Sayf a = CInt(Request.Qu eryString("Sayf a"))
End If

set rs=server.Creat eObject("adodb. recordset")
Add this line:
rs.CursorLocati on = 3 'adUseClient
If Gosterilen_Sayf a > Toplam_Sayfa Then Gosterilen_Sayf a =
Toplam_Sayfa
If Gosterilen_Sayf a < 1 Then Gosterilen_Sayf a = 1

rs.AbsolutePage = Gosterilen_Sayf a

The AbsolutePage property needed to be set BEFORE the recordset was opened.
The recordset can be opened using the following simple statement (no need
for the dynamic sql statement shown above):

baglantim.st_us ersearch '','','','','', '', rs
Here are some links to alternative paging techniques:
http://www.aspfaq.com/show.asp?id=2120
http://www.aspfaq.com/show.asp?id=2352
http://www.adopenstatic.com/experime...dsetpaging.asp

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"