Data type/syntax problem (mostly ignorance)

[Frank Pulliza]

Can anyone look at this and tell me what I am doing wrong?


SELECT OCCURENC.CLASSDATE, CLIENTS.LASTNAME, CLIENTS.FIRSTNAME, COMPANY.COMPNAME, OCCURENC.CLASSNOTE, CLASSDAT.SCHEDSHOW, OCCURENC.CLASSTYPE, ENROLL.ENROLLSTAT, OCCURENC.CLASS_STAT, ENROLL.PAYMETHOD
FROM (CLASSDAT INNER JOIN OCCURENC ON CLASSDAT.CLASSCODE = OCCURENC.CLASSCODE) INNER JOIN (COMPANY INNER JOIN (CLIENTS INNER JOIN ENROLL ON CLIENTS.CLIENTCODE = ENROLL.CLIENTCODE) ON COMPANY.COMPCODE = CLIENTS.COMPCODE) ON OCCURENC.CLASSNUM = ENROLL.CLASSNUM
WHERE (((OCCURENC.CLASSDATE)>=[StartDate:] And (OCCURENC.CLASSDATE)<=[EndDate:]) AND ((ENROLL.ENROLLSTAT)=&#34;F&#34 AND ((OCCURENC.CLASS_STAT)=&#34;A&#34 AND ((ENROLL.PAYMETHOD)=&#34;GU&#34)<br>ORDER BY OCCURENC.CLASSDATE, OCCURENC.CLASSNOTE DESC , CLASSDAT.SCHEDSHOW;

I want to be able to search by a range of dates. This is the SQL query directly from access, I am trying to use it through an ASP page, andI get the message below:

Database Error: [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression &#39;(((OCCURENC.CLASSDATE)>=[StartDate:] And (OCCURENC.CLASSDATE)<=[EndDate:]) AND ((ENROLL.ENROLLSTAT)=`F`) AND ((OCCURENC.CLASS_STAT)=`A`) AND ((ENROLL.PAYMETHOD)=`GU`))

Any ideas, feel free to e-mail. Thanks.

Frank
Santa Cruz, CA

Hi Frank,

Try simplifying your query by getting it down to a simple &#34;SELECT * FROM X&#34;.
Make sure that works. Then put in more and more of your criteria until it
fails.

John

------------
Frank Pulliza at 1/11/00 6:39:09 PM

Can anyone look at this and tell me what I am doing wrong?


SELECT OCCURENC.CLASSDATE, CLIENTS.LASTNAME, CLIENTS.FIRSTNAME, COMPANY.COMPNAME, OCCURENC.CLASSNOTE, CLASSDAT.SCHEDSHOW, OCCURENC.CLASSTYPE, ENROLL.ENROLLSTAT, OCCURENC.CLASS_STAT, ENROLL.PAYMETHOD
FROM (CLASSDAT INNER JOIN OCCURENC ON CLASSDAT.CLASSCODE = OCCURENC.CLASSCODE) INNER JOIN (COMPANY INNER JOIN (CLIENTS INNER JOIN ENROLL ON CLIENTS.CLIENTCODE = ENROLL.CLIENTCODE) ON COMPANY.COMPCODE = CLIENTS.COMPCODE) ON OCCURENC.CLASSNUM = ENROLL.CLASSNUM
WHERE (((OCCURENC.CLASSDATE)>=[StartDate:] And (OCCURENC.CLASSDATE)<=[EndDate:]) AND ((ENROLL.ENROLLSTAT)=&#34;F&#34 AND ((OCCURENC.CLASS_STAT)=&#34;A&#34 AND ((ENROLL.PAYMETHOD)=&#34;GU&#34)<br>ORDER BY OCCURENC.CLASSDATE, OCCURENC.CLASSNOTE DESC , CLASSDAT.SCHEDSHOW;

I want to be able to search by a range of dates. This is the SQL query directly from access, I am trying to use it through an ASP page, andI get the message below:

Database Error: [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression &#39;(((OCCURENC.CLASSDATE)>=[StartDate:] And (OCCURENC.CLASSDATE)<=[EndDate:]) AND ((ENROLL.ENROLLSTAT)=`F`) AND ((OCCURENC.CLASS_STAT)=`A`) AND ((ENROLL.PAYMETHOD)=`GU`))

Any ideas, feel free to e-mail. Thanks.

Frank
Santa Cruz, CA