Answered
CommandText Compile Error
In Dreamweaver I've set up a database filter with following
command:
CommandText='<%# "SELECT PGCCalenderALLYears.EventDate, PGCCalenderALLYears.Event, PGCCalenderALLYears.EventTime, PGCCalenderALLYears.Day, PGCCalenderALLYears.Venue FROM PGCCalenderALLYears WHERE (((PGCCalenderALLYears.EventDate) > DateValue( NOW() ))) AND ((PGCCalenderALLYears.EventDate) < DateValue( NOW()+2 )) AND (PGCCalenderALLYears.VENUE = "HOME")" %>'
And the test button in Dreamweaver works fine. However, when I try this in a browser I get a compile error:
Compiler Error Message: BC32017: Comma, ')', or a valid expression continuation expected.
so it looks like it doesn't like the quotation marks surrounding the VENUE, which I can understand. Odd that Dreamweaver is OK with this but it fails in real life!
Anyway - is there a way to specify a fixed value in the CommandText?
CommandText='<%# "SELECT PGCCalenderALLYears.EventDate, PGCCalenderALLYears.Event, PGCCalenderALLYears.EventTime, PGCCalenderALLYears.Day, PGCCalenderALLYears.Venue FROM PGCCalenderALLYears WHERE (((PGCCalenderALLYears.EventDate) > DateValue( NOW() ))) AND ((PGCCalenderALLYears.EventDate) < DateValue( NOW()+2 )) AND (PGCCalenderALLYears.VENUE = "HOME")" %>'
And the test button in Dreamweaver works fine. However, when I try this in a browser I get a compile error:
Compiler Error Message: BC32017: Comma, ')', or a valid expression continuation expected.
so it looks like it doesn't like the quotation marks surrounding the VENUE, which I can understand. Odd that Dreamweaver is OK with this but it fails in real life!
Anyway - is there a way to specify a fixed value in the CommandText?
