Estou com o seguinte erro >
[Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression 'autorpost=#cartaz#'.
o codigo é este ai embaixo. Alguem poderia me ajudar? sou iniciante em ASP.
<%
SQL = "Select * From posts WHERE autorpost=#"&request("arquivo")&"#"
Set RS = ConnDB.Execute(SQL)
Function to_html(s_string)
to_html = Replace(s_string, vbcrlf, "<br>")
to_html = Replace(to_html, " ", "")
to_html = Replace(to_html, Chr(9)," ")
to_html = Replace(to_html, ":)", "<img src=""img/smiley1.gif"" width=""17"" height=""17"">")
to_html = Replace(to_html, ";)", "<img src=""img/smiley2.gif"" width=""17"" height=""17"">")
to_html = Replace(to_html, ":o", "<img src=""img/smiley3.gif"" width=""17"" height=""17"">")
to_html = Replace(to_html, ":D", "<img src=""img/smiley4.gif"" width=""17"" height=""17"">")
to_html = Replace(to_html, ":errr:", "<img src=""img/smiley5.gif"" width=""17"" height=""17"">")
to_html = Replace(to_html, ":(", "<img src=""img/smiley6.gif"" width=""17"" height=""17"">")
to_html = Replace(to_html, "X(", "<img src=""img/smiley7.gif"" width=""17"" height=""17"">")
'to_html = Replace(to_html, "expressao", "susbtituida por")
to_html = Replace(to_html, "marvel", "<a href=""http://www.marvel.com"" target=""_blank"">Marvel</a>")
to_html = Replace(to_html, "dccomics", "<a href=""http://www.dccomics.com"" target=""_blank"">DC Comics</a>")
End Function
nome = ""
While not RS.EOF
if nome <> rs("autorpost") then
response.write "<div class=""date""><br>:: "&formatDateTime(RS("datapost"),1)&"<br><br></div>"
response.write "<div class=""tit"">"&RS("titpost")&"</div>"
response.write "<div class=""posts"">"&to_html(RS("post"))&"</div>"
response.write "<img src=""img/dot.gif"" width=""1"" height=""5"" border=""0"">"
response.write "<div class=""byline"">Cadastrado em "&RS("autorpost")&" | "&left(RS("horapost"),5)&"</div><br>"
nome = rs("autorpost")
else
response.write "<div class=""tit"">"&RS("titpost")&"</div>"
response.write "<div class=""posts"">"&to_html(RS("post"))&"</div>"
response.write "<img src=""img/dot.gif"" width=""1"" height=""5"" border=""0"">"
response.write "<div class=""byline"">cadastrado em "&RS("autorpost")&" | "&left(RS("horapost"),5)&"</div><br>"
end if
RS.MoveNext
Wend
%>