Scriptsmount a free web scripts directory provides website scripts, webmaster scripts, web directory scripts, directory scripts, php scripts, perl scripts, cgi scripts, html scripts, database scripts, asp.net scripts, form scripts, guestbook scripts for webmasters
Web Scripts :: ASP :: ASP Tips and Tutorials :: Database-related
74.
Multiple Form Selection (Where In)
|
|
Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammerin?Hank Greenberg. The years he played are available to select from in a dropdown menu. When multiple years are selected they are passed comma delimited. Utilizing the where in statement in our sql the comma delimited selections are appended to our sql statement to display only those years selected
Hits: 17 Rating: 0.00 Votes: 0
[Detail]
[Send URL]
Category: ASP :: ASP Tips and Tutorials :: Database-related
|
76.
Paging Records With GetRows
|
|
You all must have seen and done stuff with the RecordSet object, infact everything is done with the RecordSet object. Now, this acticle explains how to use GetRows to page through the records that you recieve from the SELECT. It's much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection. Plus GetRows let's you count the records correctly!
Hits: 14 Rating: 0.00 Votes: 0
[Detail]
[Send URL]
Category: ASP :: ASP Tips and Tutorials :: Database-related
|
77.
Limit query results with the Recordset object
|
|
Have this short program around so that you can quickly see what columns and what data are in your database. Here you will see some of the common methods and properties used to limit the results from your SQL query. Using a simple form that takes a table name and a submit button, and you can easily display increments of the table data. Full source code available.
Hits: 20 Rating: 0.00 Votes: 0
[Detail]
[Send URL]
Category: ASP :: ASP Tips and Tutorials :: Database-related
|
|
|
|
|