Web Scripts - php scripts, perl scripts, cgi scripts, asp scripts, directory scripts, programming scripts

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


  Home  |   Add Resource  |   Modify Resource    


Web Scripts :: ASP :: ASP Tips and Tutorials :: Database-related


41. Randomizing a Recordset

This article describes several ways to use a SQL calculated field and the ORDER BY clause to arrange a recordset in random order. It provides a simple tool for verifying that the results are uniformly random. Also shows a technique for bubbling records with certain attributes to the top of an otherwise randomized list.

Hits: 28 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

42. Using Multiple Recordsets

This article explains a solution on how to increase the performance of your ASP pages that rely on gathering data through several different Recordsets. Specially, using a nifty feature of the ADO Recordset object, Multiple Recordsets, you can store multiple SQL query results in one Recordset object, requiring fewer communications with the database.

Hits: 16 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

43. ASP Access Database Tutorials

This is a group of 3 tutorials that guide you through the process of using an MS Access Database in ASP. The tutorials teach you how to connect to a database, add data to the database, update the database, and delete from the database. The 3 tutorials togather allow you to build a simple Guestbook for your web site.

Hits: 21 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

44. Printing Headers on every page of a report (from a database)

The author writes "Recently I was asked to develop a web based report that would collect data from a database, format it in an HTML page and then print a certain number of rows on each page with a column header on each page. This solution solves the problem." Source code available for download.

Hits: 15 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

45. Interrogating a Stored Procedure with ADO

This article describes how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. It shows how to create the code in an automated fashion for use in VBScript connecting to MS SQL Server 7.

Hits: 33 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

46. SQLServerTools Object

This example shows how to get a list of all current tables in the database, get a list of dependent stored procedures for each table and do it all in a stored procedure.

Hits: 22 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

47. AddCriteria Simplifies SQL Queries

AddCriteria is a small function that simplifies the code needed to produce a SQL query from a set of optional criteria posted by a user. This article explains how to use this function.

Hits: 20 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

48. Fastest way of Database Access : Caching Records in Memory

A step by step tutorial on caching data in memory. This tutorial goes one step further from simply caching data in memory to allow you to set a time limit in seconds after which it refreshes the data in memory. Extremely useful technique. Online demo available.

Hits: 28 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

49. Using Disconnected Recordsets

This article covers rarely discussed feature of ADO Recordsets, disconnected Recordsets. It examines what disconnected Recordsets are, how to use them, and what advantages they offer over connected Recordsets. Also examines how to create custom, disconnected Recordsets.

Hits: 24 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

50. Database Editing Sample

This is a quick sample code which combines a number of database functions into one script. Includes functions to add, delete, and edit records in a database table. It illustrates a number of useful techniques for database manipulation.

Hits: 42 Rating: 0.00 Votes: 0    [Detail] [Send URL]


Category:  ASP :: ASP Tips and Tutorials :: Database-related

Pages:      5       



Web Scripts  |  Add Resource  |   Modify Resource


©2006 All rights reserved. Web Scripts