Hi,
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):
<%
Dim WADWC__ParamStartDate
WADWC__ParamStartDate = "-1"
If (Request.QueryString("StartDate") <> "") Then
WADWC__ParamStartDate = Request.QueryString("StartDate")
End If
%>
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