I keep getting "Data type mismatch in criteria

Hi..

I did my search but just couldnt fix my problem.

If my rs looks like that

strSQL = "SELECT * FROM OGLASI WHERE Approve=true ;"

it works fine.

But coz this si detail page i needed to select the ID's.

So when i write it like that

Dim IntOID
IntOID = Request.QueryString("OID")

strSQL = "SELECT * FROM OGLASI WHERE 'OID = " & IntOID & " AND Approve=true ;"

Then i get this errror:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query expression ''OID = '' AND Approve=true ;'.
/mysite/_INC_test.asp, line 37

following code is on line 37:
oglasRS.Open strSQL, adoCon


Thanks in advance..


Edited by urko - 20 September 2006 at 8:11pm

You also seem to have a quote before OID=, that should not be there and to make sure oid is a number use CInt(Request.QueryString("OID"))

Thanks for answers...

I fixed it.

Problem was that instead of OID i had to write CID....
OID is a autonumber for ads and CID is for catID.

I wanted to go to detail page of categories where subcats are shown for each main category....

I didnt see it until yesterday when I was checking my code again...
and quote before OID was the problem too.

Oh....i feel so stupid....