LaughingLynx 0 Newbie Poster

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.