Bill, lo hice exacto:
gsSQL = gsSQL & "SELECT * FROM Auctions WHERE CategoryID='15' AND ItemOwner=10 AND Province='San Jose'"
y me da este error
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/ASP/RealState3/ViewSearchSales.asp, line 104
Y en esta linea lo que tengo es:
objPagingRS.Open gsSQL, GobjConnect, adOpenStatic, adLockReadOnly, adCmdText
Alguna Idea? :( :(
