I am trying to query ID (Number Field), UserID (Text Field), Password (Text Field) and I continue to receive a syntax error.
Is there something that I am doing wrong?

My code:

<body>
<%
Set MyDb=Server.CreateObject(&#34;ASPdb.Pro&#34 &#39;Create the ASP-db object
MyDb.dbQuickProps=&#34;2071;StudentDatabase1;;both ;4,both&#34; &#39;Set its std properties
MyDb.dbSQL = &#34;SELECT * from Userdb WHERE ID=&#34; & Request (&#34;ID&#34 & &#34; AND UserID=&#39;&#34; & Request (&#34;UserID&#34 & &#34;&#39; AND Password = &#39;&#34; & Request (&#34;Password&#34 & &#34;&#39;&#34;
MyDb.dbNavigationItem=&#34;filter, Next, Prev&#34;
MyDb.dbNavigation=&#34;Both&#34;
MyDb.dbUnit = 8
MyDb.dbgridDisplayFlds= &#34;0,1,2,3,4&#34;
MyDb.dbStatusBar=True
MyDb.dbRecordCount=5000
MyDb.dbGridInc=50
MyDb.ASPdbPro &#39;Call ASPdb to do its magic!

%>

Your help is greatly appreciated.