How can I Randomize database results using FrontPage

[Guest]

I am trying to randomise a recordset in FrontPage but I am getting nowhere
fast.

I have tried all the search engines and the suggestions I have used either
don;t work or have no effect.

I don't want to get into using script if I can help it.

I am using MS Access, DSN connection and .ASP pages to retrive the information

If anyone can help I would be grateful.

I can send the page I am trying to use, but it is confidential.

Simon Jefferson

 

[Guest]

I'm not sure what you mean by randomise a recordset but my experience with
FrontPage is that it is good for submitting data to a database and displaying
data in a database using the "Database Results" wizard. But if you try to do
much beyond that you are going to have to delve into the script a bit.

-Michael

 

[Thomas A. Rowe]

Requires custom written ASP/VBScript to accomplish, not something that can be accomplished from
within the FP database components.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Clark]

Just curious -- what do you mean by randomize the recordset? Do you
mean that you want to bring up the records resulting from some query
and have tnem ordered differently every time the query is run?

Or could it mean that each record has a randomly generated (but doesnt
change once it is entered) number in one of the fields, and the
results are ordered by that "random" number? In which case the same
query will always bring up the results in the same order, but it would
be "random" in terms of the order in which the records were created?
In which case you could just put a random number in one of the fields
as a (somewhat hokey) solution.

In any case, (I'm no asp maven) that has to be really easy to do with
a little asp code --

 

[Clark]

actually, if the scenario described in the second paragraph works for
you, it is easy to accomplsh using a randomly generated autonumber
field and sorting by that number. Even though the records would come
up in the same (random-looking) order when queried, any new record
added to the database would get inserted at a random location relative
to prior records (and it would stay in that position in subsequnet
queries)