Hi all,

HELP!! - I'd like to select a record by not using a field name to filter. For example, here's what I'd usually do:

SELECT * FROM tblTest WHERE tblTest.ID = " & lngID & "

BUT I'd prefer to do it a bit like this:

SELECT TOP " & intRandom & " * FROM tblTest

As you can see here, this will sonly select 2 records, I want to select one only. Basically what I'm trying to is select a random record in the table. But I don't have a clue how to it, please help

NOTE: I'm using ASP/Vb-Script to code me pages

Thanks for reading

you could try this

bring in all records (without using TOP ....)

then use the following

'Max record value
rndMax = CInt(connection.RecordCount)
connection.MoveFirst

Dim rndNumber
Randomize Timer
rndNumber = Int(RND * rndMax)
connection.Move rndNumber

that will select a random record from the selected