Ven algo mal en est SQL?
CountSQL = CountSQL & " SELECT COUNT(*) AS total FROM Auctions WHERE Ended = 0 And CategoryID = " & SQLVal(ID) & " and AvailDate <= " & SQLDate(NOW)
al imprimir la consulta me da:
SELECT COUNT(*) AS total FROM Auctions WHERE Ended = 0 And CategoryID = 1 and AvailDate <= #2/27/2003 11:27#
Y Me manda este error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax near '' at line 1
/real-estate/default.asp, line 83
Ahh, si quito la fecha, no me manda error!:
CountSQL = CountSQL & " SELECT COUNT(*) AS total FROM Auctions WHERE Ended = 0 And CategoryID = " & SQLVal(ID)
Pero ocupo la fecha!
Gracias