Selection Statements for MS Access

gmoney060 · July 17th, 2004, 11:02 PM

I am trying to make a Selection statement for my Access Database the "checks" 2 values. For example I only want the recordsets that have:
testing("SiteID") = SiteID <--Variable
testing("IPAd") = Request.ServerVariables("REMOTE_ADDR")

This is what I have, but it is not working:

Code:

IPCheck.Open "SELECT * From ClicksIN Where SiteID=" & SiteID & " " & "AND IP_Address=" & Request.ServerVariables("REMOTE_ADDR");"",ObjConn,1,2

happygv · July 17th, 2004, 11:15 PM

Hi there,

What are the datatypes of SiteId and IP_Address?

Try this

Code:

IPCheck.Open "SELECT * From ClicksIN Where SiteID='" & SiteID & "' AND IP_Address='" & Request.ServerVariables("REMOTE_ADDR") & "'",ObjConn,1,2

This should work.
Cheers!

_________________________
- Vijay G
Strive for Perfection

gmoney060 · July 18th, 2004, 07:24 PM

The datatypes:
"SiteId" is a number type field
"IP_Address" is a text type field

Using code that was givin to me by happygv i get the following error now:

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/test/HitIN.asp, line 32

rajanikrishna · July 18th, 2004, 08:27 PM

Hi,

as per the siteid(its numeric), the query is like...

IPCheck.Open "SELECT * From ClicksIN Where SiteID=" & SiteID & " AND IP_Address='" & Request.ServerVariables("REMOTE_ADDR") & "'",ObjConn,1,2

happygv · July 18th, 2004, 10:46 PM

gmoney060,

Yep, rajanikrishna's query should work for you.

It is always better to post the column datatypes too along with the query, as one wouldn't be aware of what datatype it is at your end, and that way you would be helped better and faster.

Cheers!

_________________________
- Vijay G
Strive for Perfection