URGENT help needed please!!

Originally posted by : Atlas (butch@atlascomputercenters.com)Hi, thx for the help in advance. This is my line of code:strSQL= "SELECT * from qryEvaluations WHERE SchoolID =" &Request.Form("SchoolID") AND ClassShift =" &Request.Form("ClassShift")I get an error message that says expected end of statement and points to the C in ClassShift after the quote at the end of the line. What is wrong with it?ThxAtlas

Originally posted by : Diabloro (diabloro@hotmail.com)Hi i have check your form and here what i see:1-Capital Letters aren't a good idea for computers to read.2- You have too many comma or missing commas."".ex.:ClassShift =("=open comma)Where is the closing comma???) &Request.Form("ClassShift")It should be:ClassShift =" &request.form("classshift")"Another thing, the star in this sentence stands for what?? It is a confusing sign for the computer:strSQL= "SELECT (*) from qryEvaluations WHERE Try to fix these minor errors, if you have other error message it might be that the form is incomplete...------------Atlas at 8/3/2001 3:28:47 PMHi, thx for the help in advance. This is my line of code:strSQL= "SELECT * from qryEvaluations WHERE SchoolID =" &Request.Form("SchoolID") AND ClassShift =" &Request.Form("ClassShift")I get an error message that says expected end of statement and points to the C in ClassShift after the quote at the end of the line. What is wrong with it?ThxAtlas