2 svar · 217 visningar · startad av Eclipse
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.