Fistering results from database
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 !
Read More
Custom Search
- Simple XML RSS Parser
- Generating Random Number Using RND Function And Randomize Statement
- How to Refresh a web page or redirect to another page
- Custom Paging in ASP Fast And Easy
- Converting all applicable characters to HTML entities
- Professional Contact Form
- Creating Access Database Connection String
- Using DateDiff function in SQL Statement
- VBScript Examples DatePart Function
- Executing Transact SQL UPDATE statement using SQLCommand
- Custom Paging results in ASPNET using A Better Way
- Using GetDate Function in an SQL Statement
- Copying Folders using File System Object
- Form to Mail Using CDO
- Sending Emails in JSP
- Easy Download Manager Free Version
- ASP Chat Box
- Writing Form Data to Text Files
- Paging Records in JSP
- What is Ecommerce and the Importance of Ecommerce
- Beginning-Ajax-and-ASPNET-35
- How to upload images to mySQL within PHP
- Simple XML RSS Parser
- Counting records in PHP mySQL
- ActiveNews Manager Freeware News Exchange Software
- How to write and use a JavaBean My frst java bean
- Paging Results in PHP
- Free User Registration Form
- A-timesaver-control-GridView
- ASPNET Web Counter Free Open Source Code
- Easy Download Manager Free Version
- ASP Chat Box
- Writing Form Data to Text Files
- Paging Records in JSP
- Beginning-Ajax-and-ASPNET-35
- How to upload images to mySQL within PHP
- Simple XML RSS Parser
- ActiveNews Manager Freeware News Exchange Software
- Counting records in PHP mySQL
- How to write and use a JavaBean My frst java bean
- Paging Results in PHP
- Free User Registration Form
- A-timesaver-control-GridView
- ASPNET Web Counter Free Open Source Code
- Comparing Dates
