Selecting random record from database
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.
- Visit Site:
- Selecting random record from database
- Filed in:
-
ASP / Tutorials & Tips / Database-related
- Platforms:
-
- Databases:
-
- Date Added:
- Jul 12, 2007
- Last Updated:
- May 18, 2009
License and Pricing Information
Freeware
Price: $0.00 USD
| Publisher site visits: | 947 |
|---|---|
| Average rating: | 0.00 |
| Total ratings: | 0 |
Publisher Info
- Author:
- Dotnetindex.com
Other listings by this publisher
- Gportal Web Directory & News Portal (SEO PACK + 2009 RELEASE)
- GNEWS.NET Publisher
- Easy Download Manager
- Active News Manager Private label
- Professional Download Assistant
- How to use GetDirectories
- Counting Records In ASP.NET
- Using CultureInfo to modify output
- Creating Dropdown list control from Datasource
- Professional Contact Form
- Ikon Ad Manager
- Custom Paging in ASP
- Error Loging in ASP.NET
- Paging Records in JSP
- Counting Records in MySQL by JSP
-
JSP Hit Counter
- Java / JSP & Servlets / Counters / Text Based
- Executing Transact-SQL INSERT statement
- Executing Transact-SQL UPDATE statement
- Executing Transact-SQL DELETE statement
- Counting Records In A Database Table
- Database-Driven Login Script
- Registration Form
- Copying Files (using File System Object)
- Copying Folders (using File System Object)
- Checking Files Exists
- Compacting an Access database from ASP code
- Finding links using Regular Expression Syntax
- Regular Expression Syntax
- Using GetDate Function in an SQL Statement
- Returning Month of Date in an SQL Table
- Formating Date and Time
- Listing All Files in A Folder
- LTrim; RTrim; and Trim Functions
- Gnews Publisher Advanced
- Meta Name Parser
- Using SUM Function in An SQL Statement
- Glist Mailing List & Newsletter Manager
- Easy File Uploading
- Using GetRows To Get All Records From Table
- Delete Files Online
- Delete Folders Online
- VBScript Examples : DatePart Function
- Qmailing List Manager
- JScript Examples : setDate Method
- Displaying Sub Folders
- GLink Index Manager
- GLink Business Directory Edition
- Gazatem Technologies & Software
- Form to Mail Using CDO
- Giga RSS Reader
- Replacing single quotes in SQL scripts
- Fight Against SQL Injection Attacks
- Counting Records in SQL Script
- Comparing Dates in ASP
- Gnew Portal - Open Source Code
- ASP.NET Error Fix for : HTTP 401.3 Unauthorized Due to ACL on Resource
- Handling Unhandled Exceptions
- Starting to work with JSP Sessions
- Sending Emails in JSP
- Exporting Data From mySQL to Excel
- Writing Form Data to Text Files
- How to set cookies in JSP
- http://www.dotnetindex.com/articles/2176-Filling-Data-into-Select-List.asp
- Displaying Records From An Excel Database
- Database Search Engine
- Display Date and Time ih PHP
- How to Refresh a web page or redirect
- Working with Array : Remove An Item
- Disable Error On ASP Codes
- Paging Results in PHP
- VBScript Functions : The Len() Function
- Encoding URL strings
- Working with Arrays in PHP
- PHP Functions : array_fill
- Working with sessions in PHP
- MD5 Encryption in PHP
- How to use SCOPE_IDENTITY() in ASP.NET
- ASP Chat Box
- VBScript Functions : DatePart()
- Error Messages in ASP
- Using Object in ASP
- Displaying XML to DataGrid
- A Simple Contact Form
- How to Encrypt String Using MD5
- Writing binary files using BinaryWriter
- Creating Word Files Online
- Creating Excel Files Online
- Converting all applicable characters to HTML entities
- PHP Functions : urlencode()
- Response.Redirect Usage
- Creating Text files on server
- Date Validation in ASP.NET
- Generating XML files from SQL Database
- Generating Random Number Using RND Function And Randomize Statement
- Counting records in PHP/mySQL
- Contact Form in ASP.NET
- Simple XML/RSS Parser
- Gnews Publisher Open Source Code
- Media News Portal v 1.4 (2009 RELEASE + SEO PACK)
- Gnews Publisher v10
- Piranha News Manager .net release
- Gnews Publisher .NET (Aug'09 Released)
- Handle Error simple way in ASP.NET
- Handle Error simple way in ASP.NET
- Writing binary files using BinaryWriter
- How to Count all elements in an array
