UD4/W2K/ASP/VB

Hello,

with the server behavior of 'Random Record' I can let a record spent by chance from the DB.

I would like to let 4 records now spent by chance from the DB. then I used 'repeatarea' for it. The problem of this combination, that a record will show doubly records.

How can this be solved better and right? Is there possibly also an extensions for it?

Ciao Frank

I am not 100% this will work but try using SELECT DISTINCT in the query containing 'Random Record'.

An example of how it is used is below.

SELECT DISTINCT make
FROM Cars

Cars is the table, make is a column heading.

Good luck and update this thread with the results please.

Best regards
Davrus

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I am not 100% this will work but try using SELECT DISTINCT in the query containing 'Random Record'.

An example of how it is used is below.

SELECT DISTINCT make
FROM Cars

Cars is the table, make is a column heading.

Good luck and update this thread with the results please.

Best regards
Davrus
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I tried that. have you got any more advice?
I want to show the banners randomly, but distinct banners. Not duplicates.
biasi.xhosting.se/rklm_list_rand_dist.asp

Thanks in advance

// L

Lb