Skip to main content
Participant
April 24, 2007
Answered

CommandText Compile Error

  • April 24, 2007
  • 2 replies
  • 424 views
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?
This topic has been closed for replies.
Correct answer Newsgroup_User
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





2 replies

bazzer747Author
Participant
April 24, 2007
That's cracked it - why didn't I figure that one! Many thanks
Newsgroup_UserCorrect answer
Inspiring
April 24, 2007
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