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.stat eID='.

/fiq2/Admin/admin_update.as p, line 11

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

Set dbConn = server.CreateOb ject("adodb.con nection")
'connect to database via DSN
dbConn.open("fi tquest100")
Set rs_details = dbConn.Execute ("SELECT * FROM tbl_gym INNER JOIN tbl_state ON tbl_state.state ID=tbl_gym.stat e WHERE tbl_state.state ID=" & Request.QuerySt ring("stateID") )
%>


Thanks guys,
Will

[heiho]

perhaps try this:

Set rs_details = dbConn.Execute ("SELECT * FROM tbl_gym INNER JOIN tbl_state ON tbl_state.state ID=tbl_gym.stat e WHERE tbl_state.state ID=" & Cint(Request.Qu eryString("stat eID")))

hei