Kolla datum i SQL

SQL = "SELECT s.intID, s.intMenuID, s.strName, s.strRollOver," _
& " s.dteCreated, s.dteViewFrom, s.dteViewTo, s.bolView, s.intSortfield, " _
& " m.intID, m.strName, m.strRollOver, " _
[b]& " (SELECT IF(s.dteCreated <= date(), " _
& " true, false) as bolPublish FROM [" & mySubMenu & "] s, [" & myMenu & "] m  " _
& " WHERE s.intMenuID = m.intID AND s.intMenuID = " & request("menuID") & " ) " _ [/b]
& " FROM [" & mySubMenu & "] s, [" & myMenu & "] m   " _
& " WHERE s.intMenuID = m.intID AND s.intMenuID = " & request("menuID") _
& " ORDER BY s.intSortfield;"

Markerad kod fungerar ej.
index.asp?row=0&menuID=1

If ? Skalär subselect? Access?

SQL = "SELECT s.intID, s.intMenuID, s.strName, s.strRollOver," _
& " s.dteCreated, s.dteViewFrom, s.dteViewTo, s.bolView, s.intSortfield, " _
& " m.intID, m.strName, m.strRollOver, " _
& " IIF(s.dteCreated <= date(), " _
& " true, false) as bolPublish " _
& " FROM [" & mySubMenu & "] s, [" & myMenu & "] m   " _
& " WHERE s.intMenuID = m.intID AND s.intMenuID = " & request("menuID") _
& " ORDER BY s.intSortfield"

Rätta raden

& " IIF(s.dteCreated <= date(), 'True', 'False') " _

Jag trodde att IIF var en kvalificerad felstavning...

Det var en luring! :-)

Nu fungerar det i alla fall.