<font face='Verdana'>Using DMX. I am trying to return a random image and text to a page. The DB is Access. I have a image table with ID, imgurl, textfield. I have written my SQL statement
SELECT *
FROM imagetable
ORDER BY RND(id)
When I use the TEST button i get a random recordset back each time. However, when I run the page i get the last record of the table each time.
I am stumped
Thanks

Brad</font id='Verdana'>

Brad Dunzer

Dear Brad,
Is your ID field an autonumber primary key?

Regards,
Brent

Brent,

Yes the ID field is an autonumber primary key.

Any ideas?

Brad

Brad Dunzer

Update.

This might be an IIS thing. On my test server which is Windows 2000 i get the last record result when i run the page. But i transfered the file to my Windows 2000 Server box and i get the first record.

Very interesting

Brad Dunzer