I have read that the when I want to create a string, I must enclose the date in hashes so my next attempt looked like this:
Setting the variable like the wizzard is doing for the for other variables
(e.g. the ID when I filter by URL):
WADWC__ParamStartDate = "-1"
If (Request.QueryString("StartDate") <> "") Then
WADWC__ParamStartDate = Request.QueryString("StartDate")
and then the query:
Set WADWC_cmd = Server.CreateObject ("ADODB.Command")
WADWC_cmd.ActiveConnection = MM_Calendar6_STRING
WADWC_cmd.CommandText = "SELECT Date AS XLABEL, Minutes AS YVALUE FROM Stats WHERE Site_ID = ? AND Date = #" & WADWC__ParamStartDate & "#"
WADWC_cmd.Prepared = true
WADWC_cmd.Parameters.Append WADWC_cmd.CreateParameter("param1", 5, 1, -1, WADWC__ParamSite_ID)
Sadly this doesn't work? WHy? Where am I doing the mistake?
Thanks for the help