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.