PLEASE help me! Very simple issue w/ ASP/database/SQL

[wctins]

I can't figure it out and I know is a simple issue, please help me!

The message error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tbl_state.stateID='.

/fiq2/Admin/admin_update.asp, line 11

The code:
<%@LANGUAGE="VBSCRIPT"%>
<%
'Create connection object
Dim dbConn
Dim rs_state
Dim rs_details

Set dbConn = server.CreateObject("adodb.connection")
'connect to database via DSN
dbConn.open("fitquest100")
Set rs_details = dbConn.Execute ("SELECT * FROM tbl_gym INNER JOIN tbl_state ON tbl_state.stateID=tbl_gym.state WHERE tbl_state.stateID=" & Request.QueryString("stateID"))
%>


Thanks guys,
Will

[heiho]

perhaps try this:

Set rs_details = dbConn.Execute ("SELECT * FROM tbl_gym INNER JOIN tbl_state ON tbl_state.stateID=tbl_gym.state WHERE tbl_state.stateID=" & Cint(Request.QueryString("stateID")))

hei