var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Get Random Record.......
I have two fields in database, ID and Name and 25 record in database..
I wanna get random 10 record from database....
So how can i achive...?
I m using MS Access....
thanx in advance
A "quick and dirty" way is to add a field called "sort", open the table into a recordset, randomize, and set a "random" number into each field. Then, sort the data by the new field.
Each time you run the routine, the records are "reordered". There's a chance you'll get 2 records witht he same random number, but hey, they're still in a different order than when you started.
The things you'll have to look up are:
Do ... Loop
thanx for reply,,
but can i get random record at Database level.. without any additional field in table ???
I'd rather be riding on the Tiger 800 or the Norton