Odd I am using a DSN to connect to an Access DB using:
strSQL = "SELECT TOP 1 * FROM Comments ORDER BY NEWID()"
I am getting
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'NEWID'
in expression.
Andy
> -----Original Message-----
> From: Andrew Zetterman [mailto:[EMAIL PROTECTED]]
> Sent: 25 September 2002 23:35
> To: ActiveServerPages
> Subject: RE: Random picture from a Database
>
>
> SQL Books Online
> -----------------------------
>
> NEWID
> Creates a unique value of type uniqueidentifier.
>
> Syntax
> NEWID ( )
>
> Return Types
> uniqueidentifier
> -----------------------------
>
> So if you put it into your order by it will generate a unique
> id for each record and then it will sort by that column.
> Each time you query the unique id will be different so the
> order of your records will change. So the top 1 record will
> randomly change.
>
> Andrew
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 25, 2002 2:36 PM
> To: ActiveServerPages
> Subject: RE: Random picture from a Database
>
>
>
> How exactly does the below code work?, I haven't seen that before.
>
> -----Original Message-----
> From: Andrew Zetterman [mailto:[EMAIL PROTECTED]]
> Sent: September 25, 2002 9:42 AM
> To: ActiveServerPages
> Subject: RE: Random picture from a Database
>
> David Penton posted a query a few weeks ago that could select
> a random record.
>
> SELECT TOP 1 col FROM tbl ORDER BY NEWID()
>
> HTH,
>
> Andrew
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 25, 2002 8:29 AM
> To: ActiveServerPages
> Subject: RE: Random picture from a Database
>
>
> But how do I get a random pic from the remaining pics?
>
> -----Original Message-----
> From: Matthew Small [mailto:[EMAIL PROTECTED]]
> Sent: September 25, 2002 9:19 AM
> To: ActiveServerPages
> Subject: RE: Random picture from a Database
>
> Put a binary field in your table. If the field is set, don't
> use that picture.
>
> Matthew Small
> IT Supervisor
> Showstopper National Dance Competitions
> 3660 Old Kings Hwy
> Murrells Inlet, SC 29576
> 843-357-1847
> http://www.showstopperonline.com
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 25, 2002 9:14 AM
> To: ActiveServerPages
> Subject: Random picture from a Database
>
> 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?
>
> Tim
>
>
> ---
> 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.unsub%%
>
> ---
> 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.unsub%%
>
> ---
> 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.unsub%%
>
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
