Thanx, for some reason I have some problems posting to this listserv last week, it seems fine now.
Tim Cadieux (613) 947-4895 Technical Applications Analyst / Analyste des applications techniques Client Services Section / Section de services � la client�le Administrative Services Division / Division des services administratifs Corporate Services Branch / Direction des services minist�riels Facsimile / T�l�copieur : (613) 947-8799 -----Original Message----- From: David L. Penton [mailto:[EMAIL PROTECTED]] Sent: September 30, 2002 9:02 AM To: ActiveServerPages Subject: RE: Random picture from a Database Maybe my reply to this post slipped through the cracks: SELECT TOP 1 a.* FROM MyTable a WHERE a.id <= ( SELECT MIN(b.id) + CONVERT(int, ROUND(RAND() * MAX(b.id), 0)) FROM MyTable b ) ORDER BY a.ID DESC will work in MSA...with a table/column name changes to suit. David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Damn, I need to run some thing like this on Access 2000 Tim Cadieux (613) 947-4895 Technical Applications Analyst / Analyste des applications techniques Client Services Section / Section de services � la client�le Administrative Services Division / Division des services administratifs Corporate Services Branch / Direction des services minist�riels Facsimile / T�l�copieur : (613) 947-8799 -----Original Message----- From: Anders Borum [mailto:[EMAIL PROTECTED]] The NEWID() function is probably SQL Server only. With regards Anders Borum. --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
