Unfortunately, I'm not getting a random image each time, I get the same one every time, Record 30..
sSQL="SELECT TOP 1 a.* FROM Pictures a WHERE a.PIC_ID <= (SELECT MIN(b.PIC_ID) + CLng(ROUND(RND() * (MAX(b.PIC_ID) - MIN(b.PIC_ID)), 0))" sSQL= sSQL & " FROM Pictures b) ORDER BY a.PIC_ID DESC" Help? --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
