The net's largest PHP, CGI, Perl, JavaScript and ASP script collection and resource web portal
  New Listings
New Listings
Most Popular
Most Popular
Top Rated
Top Rated
Discussion
Discussion
Link to Us!
Link To Us
Search For:         
   
 
Categories

Ajax
ASP
ASP.NET
C and C++
CFML
CGI and Perl
Flash
Java
JavaScript
PHP
Python
Remotely Hosted
Ruby on Rails
Tools and Utilities
Web Hosting
XML

Sponsor Links



Home :: ASP :: Tips and Tutorials :: Database-related Notes 

Selecting random record from database Hits: 588


Description:
This ASP source code describes a short way to select a record from database. First we need to calculate how many records we have in our table. Using randomize function, we generate a random number between 0 to count of records in database. Last part of code to select our record using our random number. We must move dynamic cursor in database table and move it to row number. There a few ways to move cursor to row, but personally we can do it similiar as paging records. We select all records from table dividing one record per page. Complete reference code is included.


 Resource Specification
Platform(s): windows
Date Added: Jul 12, 2007
Last Updated: Jul 12, 2007
Author: Dotnetindex.com


 Share


 License Information
License # 1:
  License Type: Freeware Price: Free


Average Visitor Rating:     5.00 (out of 5)
Number of Ratings: 1 Votes

  Visitor ratings breakdown by period
  Last 7 Days 0 0 0 0 0 0.00
  Last Month 0 0 0 0 0 0.00
  Last Year 0 0 0 0 1 5.00
  Overall 0 0 0 0 1 5.00
  1 2 3 4 5 AVG
  Visitor Rating Totals
1 2 3 4 5


  Visitor Voting Booth

Average Member Rating: Not yet reviewed by any member....

You can be the FIRST one to write a review for Selecting random record from database.

 Other Links by This Member






 

Register | FAQ/Support | Contact Us | About Us | Getting Rated | Link to Us | Bookmark Us | Advertising Info | Terms of Use | Privacy Policy
Copyright © 2008 iNET Interactive. All rights reserved.
Other iNET Interactive Sites:
Web Hosting Talk | dBForums | Mac Forums | Hosting Catalog