2005/9/7, Xavier CAMIER <[EMAIL PROTECTED]>: > Good morning, > > Curiosity is a bad habit but here are the explanations ;-) > > - The app users can create new records. > - The records are made of a Code, a Description, a Price and a Group. > - The Code is mask free but if the user wants to adopt a convention (eg > : a code starts with 2 digits of the group) and if he lacks of memory > (or just want to see how the other users did) the app must provide a way > to show a sample list of existing records for that group (a kind of > Coding convention reminder made of examples).
But do you actually need a *random* sample? Why not just the first / last 10 records? Another possible solution might be to take current milliseconds and use that to determine the starting record with ROWNUM. Kind regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
