Query works in Access and Dreamweaver - only partially works with webpage!
Posted on 2004-08-18
I have spent most of today trying to work out why my webpage is not correctly working!
I have an internal (intranet) website driven by an Access Database, with multiple pages with various queries displaying the information in a multitude of ways. All of my queries have worked so far (around 50) however I wrote a query to randomize the records returned from a simple query displaying the contents of a table yet in a random order each time the query runs. (Using Expr1: RND([ID])
One field of the query contains a simple randomize statement of the ID's within the table and I have selected order by Ascending results of the field with the randomizsing expression. The query works perfectly in Access and also in Dreamweaver once a recordset is set up and 'test' is selected. Even when I write SELECT TOP 1 People FROM QryRndm, the query works perfectly returning one row with a different persons name each time (which is actually what I want)
However, when I set the webpage up with various dynamic text components produced from the recordset, I get the same record each time, rather than a random record returned!
What is even more bizarre, the record returned is not the first one, it is indeed 'random' - the 7th I think in the table. However, no matter how many times I refresh (thinking maybe a cache problem), I always get the same record returned rather than a random one each time!
I don't understand how the query can work in Access, via the test function in the recordset of Dreamweaver, yet not when the actual webpage is displayed!
Is it an IIS problem? Why would all my other 50+ queries work, any not this one?
Any known issues using the RND() command directly in an SQL statement?