NEWID() in Access Database
I am working on this project and I want to display a random recordset, but it does not seem towork with Access at all.
I have it workin in SQL 2000 database but access is more complicated.
Can anyone help?
Set rsSpecials = Server.CreateObject("ADODB.Recordset")
rsSpecials.ActiveConnection = MM_conn_STRING
rsSpecials.Source = "SELECT P_Name, P_OnSpecial, P_OnSpecialPrice, P_SmallPicture, P_ID, NEWID() AS P_ID1 FROM Products WHERE P_OnSpecial=yes ORDER BY P_ID1"
rsSpecials.CursorType = 0
rsSpecials.CursorLocation = 2
rsSpecials.LockType = 1
rsSpecials_numRows = 0
The NEWID() part is the problem.
I tried RAND() but.......