Missing Operator error

Hello,

I am creating a page that displays sections of a database based on ClassTypeID, and using the following as my SQL statement:

"SELECT * FROM Classes WHERE ClassTypeID=" & request("ClassTypeID") & ""

The user will select a category from the following menu:

<p><a href="class.asp?ClassTypeID=1">Care Management</a>
		</p>
		<p><a href="class.asp?ClassTypeID=2">Claims/Customer Service</a>
		</p>
		<p><a href="class.asp?ClassTypeID=3">Provider Network </a>	
		</p>
		<p><a href="class.asp?ClassTypeID=4">Pharmacy Benefit Management</a>	
		</p>

I am getting the error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ClassTypeID='.

This code works without a hitch on another site; I am clueless as to what operator it thinks needs to be there. I've tried a closing semicolon in various places but I still get an error. Please help! Thank you.

LaughingLynx

Newbie Poster

1 post since Jul 2010

Reputation Points: 10

Solved Threads: 0

This article has been dead for over three months