> I just want to show a random picture form all those in my database. I used > to just get the number of pics in my DB, then geta RND # and then call that > ID, but, because I Autonumber them, when a pic got deleted, I would > sometimes get an error. > > So, how can I get a rnd Pic ID from a database that has say 20 pics, but 10 > are set to NOT be shown....ideas?
Use Getrows() and select a random index of the array. -- Lon Kraemer ----------------------------------------- --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
