this don't work

[exodus300]

Microsoft OLE DB Provider for ODBC Drivers error '80040e10' 

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. 

/cokeandrumisyum/menu.asp, line 59

this is line59:

59   rs2.Open "SELECT UserName, RegisteredDate FROM Users WHERE RegisteredDate = " & _
60    "(SELECT MAX(RegisteredDate) FROM Users)", conn

[Thanks in advance|Hope I helped you]
Exodus300

 

[Tarwn]

Rather than do an embedded query, you could Do something like: SELECT Top 1 UserName, RegisteredDate From Users ORDER BY RegisteredDate DESC

Somewhat the same, but less work (I think)
-T

[sub]01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111[/sub]
The never-completed website:

http://www.tiernok.com/