Need help on SQL-string

Results 1 to 2 of 2

Thread: Need help on SQL-string

  1. #1
    Join Date
    Dec 1969

    Default Need help on SQL-string

    Could someone help me with a statement that gets 5 random records from a db ?<BR><BR>Thanx!<BR><BR><BR>Espen

  2. #2
    Join Date
    Dec 1969

    Default RE: Need help on SQL-string

    (let&#039s say you want to randomly pick 5 products from your database) Add a field to you main product table with an integer datatype and check the Identify box (assuming SQL 7.0) or using the autonumber datatype in Access. once you have a seperate integer for each product you can then write the ASP code.<BR><BR>Check out this site for how to use the ASP Randomizer:<BR><BR><BR><BR>good luck,<BR>bart

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts