Invalid column name 'StartDate'.
Jeg får følgende fejlmeddelelse:Invalid column name 'StartDate'.
/indkøbsregnskab/index.asp, line 221
Min kode ser sådan her ud:
Linje 221 er sidste linje!
If Request.Form("WhatWasChosen") = "MonthlyConsumptionChosen" Then
Dim MonthName, intMonth, Year, StartDate, EndDate, intEndDate
Dim CostFood, CostDrinks, CostCleaning, EndSum1, EndSum2
MonthName = Request.Form("Month")
intMonth = ChangeMonthNameToInteger(MonthName)
Year = Request.Form("Year")
StartDate = Year & "-" & intMonth & "-01"
StartDate = CDate(StartDate)
intEndDate = CalculateEndDate(MonthName, Year)
EndDate = Year & "-" & intMonth & "-" & intEndDate
EndDate = CDate(EndDate)
Set objConn = Server.Createobject("ADODB.Connection")
strConnString = "Provider=SQLOLEDB;" & _
"Persist Security Info=FALSE;" & _
"User ID=sa;" & _
"Password=pb16950;" & _
"Initial Catalog=Indkøbsregnskab;" & _
"Initial File Name = C:\Programmer\Microsoft SQL Server\MSSQL\" & _
"DATA\Indkøbsregnskab_Data.mdf;"
objConn.Open strConnString
strSQL = "SELECT * FROM Consumption_T WHERE Date_DT > StartDate AND " & _
"Date_DT < EndDate ORDER BY Date_DT"
Set objRS = Server.Createobject("ADODB.Recordset")
objRS.Open strSQL, objConn, adOpenStatic, adLockReadOnly, AdCmdText
Hvad er der galt?
