Popular Articles | Latest Articles | Categories | RSS Feeds

Login  |  Register

Filtering results from database

Published on 11/16/2008 by Dotnetindex
 Vote this tutorial:

More articles in ASP

Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.

Let's see what's going on a fresh example :

<%

Const adFilterNone = 0
Const adFilterPendingRecords = 1
Const adFilterAffectedRecords = 2
Const adFilterFetchedRecords = 3
Const adFilterConflictingRecords = 5


Set rs = server.CreateObject("adodb.recordset")
cn = "Provider=SQLOLEDB;Data Source=virtualShop.gazatem.com;database=VirtualShop;uid=SA;pwd=;"
sql = "select * from virtualShop_Products order by productID desc;"

rs.open sql, cn, 3, 3

rs.FILTER = "stock < 2"
response.write "Low stock stock :
"

do while not rs.eof
response.write rs("productTitle") & ":" & rs("stock") & "
"

rs.movenext
loop

rs.Filter = adFilterNone
rs.FILTER = "stock > 5"
response.write "High stock report :
"

do while not rs.eof
response.write rs("productTitle") & ":" & rs("stock") & "
"

rs.movenext
loop

%>


Happy Coding !


 

Comments:
no comments submitted


Only members can write comments.Please, login / register to write comment.

Latest Posts

Active News Manager - news management system



ASP.NET Resources, Reviews

ASP Resources, Reviews

PHP, ASP, .NET, JSP Resources, Reviews




Who's online

  • There 62 online users.

ASP.NET Resources, Reviews

ASP Resources, Reviews

PHP, ASP, .NET, JSP Resources, Reviews

Hotscripts.com Free Photoshop, Flash and 3DS MAX tutorials