By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,910 Members | 1,085 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,910 IT Pros & Developers. It's quick & easy.

paging problem

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

my connection string

Set baglantim=Server.Createobject("ADODB.Connection")
Outpost="PROVIDER=SQLOledb;Initial Catalog=friends;User Id=sa
;password=;Data Source=localhost" (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='',@firstname='',@surname='',@citytr='',@us ergender='',@onlinestatus=
''"

Sayfalanacak_Kayit=5

If Request.QueryString("Sayfa") = "" Then
Gosterilen_Sayfa = 1
Else
Gosterilen_Sayfa = CInt(Request.QueryString("Sayfa"))
End If

set rs=server.CreateObject("adodb.recordset")

rs.pagesize=Sayfalanacak_Kayit

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

rs.AbsolutePage = Gosterilen_Sayfa
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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=Server.Createobject("ADODB.Connection")
Outpost="PROVIDER=SQLOledb;Initial 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=localhost" (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='',@firstname='',@surname='',@citytr='',@us ergender='',@onlinestatus=
''"

Sayfalanacak_Kayit=5

If Request.QueryString("Sayfa") = "" Then
Gosterilen_Sayfa = 1
Else
Gosterilen_Sayfa = CInt(Request.QueryString("Sayfa"))
End If

set rs=server.CreateObject("adodb.recordset")
Add this line:
rs.CursorLocation = 3 'adUseClient
If Gosterilen_Sayfa > Toplam_Sayfa Then Gosterilen_Sayfa =
Toplam_Sayfa
If Gosterilen_Sayfa < 1 Then Gosterilen_Sayfa = 1

rs.AbsolutePage = Gosterilen_Sayfa


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_usersearch '','','','','','', 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"
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.