Updated: 07/12/2007

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.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Database-related
• Tags
  • asp code,
  • asp code source,
  • asp count record,
  • asp cursor,
  • asp database code,
  • asp number random,
  • asp paging,
  • asp paging code,
  • asp paging records,
  • asp random,
  • asp random number between,
  • asp randomize,
  • asp reference,
  • asp select,
  • asp select count,
  • asp select from,
  • asp select from database,
  • asp source,
  • asp source code,
  • asp to database,
  • count asp,
  • count in asp,
  • count records in asp,
  • database to asp,
  • is number asp,
  • paging asp,
  • paging code in asp,
  • paging in asp,
  • paging records,
  • paging using asp,
  • random asp,
  • random number in asp,
  • select count asp,
  • select count in asp
  • ...
• Platforms
  • Windows
• Licenses
  • Freeware
• Author
  • Dotnetindex.com