CommandText Compile Error

[bazzer747]

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?

[Newsgroup_User · Accepted solution]

Try

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')" %>


--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[bazzer747]

That's cracked it - why didn't I figure that one! Many thanks