Hi all,
its very urgent,
how to do the sorting in Ms-access db,
i am using the following code,but it shows error as
"current provider does not support sorting or filtering"
code is
DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtest=dsntest &"DBQ=" &Server.MapPath("/access_db/paybill.mdb")
Cn.Open DSNtest
rs.open"select * from bidorder",cn,1,2
rs.Sort = "[bidprice]"
If lngSortField > 0 Then
strSortField="[" & rs.Fields(Cint(lngSortField)).Name & "]"
strStortField=strSortfield
rs.sort=strSortField
End if
whats the problem in this?
anyone help in this?
thanks
jegatha
---------------------------------
Free antispam, antivirus and 1GB to save all your messages
Only in Yahoo! Mail: http://in.mail.yahoo.com
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
