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("ASPdb.Pro"'Create the ASP-db object
MyDb.dbQuickProps="2071;StudentDatabase1;;both ;4,both" 'Set its std properties
MyDb.dbSQL = "SELECT * from Userdb WHERE ID=" & Request ("ID"& " AND UserID='" & Request ("UserID"
& "' AND Password = '" & Request ("Password"
& "'"
MyDb.dbNavigationItem="filter, Next, Prev"
MyDb.dbNavigation="Both"
MyDb.dbUnit = 8
MyDb.dbgridDisplayFlds= "0,1,2,3,4"
MyDb.dbStatusBar=True
MyDb.dbRecordCount=5000
MyDb.dbGridInc=50
MyDb.ASPdbPro 'Call ASPdb to do its magic!
%>
Your help is greatly appreciated.