I have a recordset within dreamweaver as follows:
WHERE pPrice <= MMColParam and pPrice >= MMColParam1 and (GETDATE() - pDateEntered) < MMColParam2
However when trying to display the page I receive the following error message:
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type datetime.
/propertyresults_quick.asp, line 37
Can anyone advise me how to amend the necessery within the recordset SQL query to eliminate this.