Dreamweaver - site check please

Author

site check please

Zachariah Crow

2004-02-20, 12:28 pm

I've got a page that is giving someone an error but I can't create it and no
one else has had any problems. The page in question is
http://www.studyinbc.com/studyinbc/...s/eslSearch.asp

Leave everything as it is and click on the "Search for Programs" button. The
person having the problem is getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query
expression '(Institution.INST_ID = esl_PROGRAM.inst_id AND
esl_PROGRAM.program_id = esl_INTAKE.program_id AND Institution.INSTITUTION
LIKE 'abc' AND esl_PROGRAM.program_length < 99 AND (esl_INTAKE.start_date
BETWEEN #//# AND #//#)) OR Institution.INST_ID = esl_PROGRAM'.

/studyinbc/ProgramsSchools/eslSearch.asp, line 74

Anyone else getting errors?

Dan Vendel *GOF*

2004-02-20, 12:28 pm

Zachariah Crow wrote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query
> expression '(Institution.INST_ID = esl_PROGRAM.inst_id AND
> esl_PROGRAM.program_id = esl_INTAKE.program_id AND Institution.INSTITUTION
> LIKE 'abc' AND esl_PROGRAM.program_length < 99 AND (esl_INTAKE.start_date
> BETWEEN #//# AND #//#)) OR Institution.INST_ID = esl_PROGRAM'.
>
> /studyinbc/ProgramsSchools/eslSearch.asp, line 74

Mac/FireFox:

Same error message

--
Dan Vendel - *GOF*
Contact me directly at http://contact.vendel.info
Formmail tutorial at http://www.vendel.info/tut/formmail.html
Nested table demonstration at http://www.vendel.info/tabletut/
Search Engine Optimization & Rank Control Utility at http://awr.vendel.info
Search Dreamweaver newsgroup at http://www.vendel.info/google.html

Joe {RoastHorse}

2004-02-20, 12:28 pm

i get the same error on the page you linked. the error says there's a
syntax error in your db query on line 74 - i would start by looking there.

joe

Zachariah Crow wrote:

> I've got a page that is giving someone an error but I can't create it and no
> one else has had any problems. The page in question is
> http://www.studyinbc.com/studyinbc/...s/eslSearch.asp
>
> Leave everything as it is and click on the "Search for Programs" button. The
> person having the problem is getting this error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query
> expression '(Institution.INST_ID = esl_PROGRAM.inst_id AND
> esl_PROGRAM.program_id = esl_INTAKE.program_id AND Institution.INSTITUTION
> LIKE 'abc' AND esl_PROGRAM.program_length < 99 AND (esl_INTAKE.start_date
> BETWEEN #//# AND #//#)) OR Institution.INST_ID = esl_PROGRAM'.
>
> /studyinbc/ProgramsSchools/eslSearch.asp, line 74
>
> Anyone else getting errors?
>
>

Zachariah Crow

2004-02-20, 2:28 pm

Thanks for the check. It seems that you can't link to this page directly
without getting this error. If you get to it via the menuing system, no
problems.

Thanks.

"Zachariah Crow" <zcrow@bccie.bc.ca> wrote in message
news:c15b3e$4d3$1@forums.macromedia.com...
> I've got a page that is giving someone an error but I can't create it and
no
> one else has had any problems. The page in question is
> http://www.studyinbc.com/studyinbc/...s/eslSearch.asp
>
> Leave everything as it is and click on the "Search for Programs" button.
The
> person having the problem is getting this error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query
> expression '(Institution.INST_ID = esl_PROGRAM.inst_id AND
> esl_PROGRAM.program_id = esl_INTAKE.program_id AND Institution.INSTITUTION
> LIKE 'abc' AND esl_PROGRAM.program_length < 99 AND (esl_INTAKE.start_date
> BETWEEN #//# AND #//#)) OR Institution.INST_ID = esl_PROGRAM'.
>
> /studyinbc/ProgramsSchools/eslSearch.asp, line 74
>
> Anyone else getting errors?
>
>