Issue using MAX() function
Hey, the following code works if I don't use the MAX() function and replace it with *
All I want to do is get the largest value in the img_set column for the specific date.
Getting the following error
'How many image sets is there
query_set = "SELECT MAX(img_set) FROM images WHERE DATEVALUE(upload_date_time) = "&ISODate(getdate)
rs.Open query_set, conn
response.Write "<"&rs("img_set") & "><br />"
loop while not rs.EOF
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/nightclub_photography/pages/rotate.asp, line 35