-
Data type/syntax problem (mostly ignorance)
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)="F" AND ((OCCURENC.CLASS_STAT)="A" AND ((ENROLL.PAYMETHOD)="GU")<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 '(((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
-
Data type/syntax problem (mostly ignorance) (reply)
Hi Frank,
Try simplifying your query by getting it down to a simple "SELECT * FROM X".
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)="F" AND ((OCCURENC.CLASS_STAT)="A" AND ((ENROLL.PAYMETHOD)="GU")<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 '(((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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|