Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/dev/traderfeedback/view.asp, line 55
line 55 is either
rsV.open "SELECT * FROM SITE_COMP WHERE U_ID = '" & intTopID & "'", my_conn
OR
rsV.open strsql,my_conn
I get the same error on both?
my code is:
<%
set rsV = Server.CreateObject("ADODB.RECORDSET")
rsV.open "SELECT * FROM SITE_COMP WHERE U_ID = '" & intTopID & "'", my_conn
'rsV.open strsql,my_conn
Response.Write("<h3 class=""style2""> Information Display for ID " & intTopID & "</h3>")
%>
</td>
</tr>
<tr>
<td>
<%
Response.Write "<center><p>This information was posted on " & rsV("DATE") & "" & VbNewLine & _
"Topic Status: " & VbNewLine
If rsV("UA_LOCKED") = 0 then
Response.Write "UnLocked" & VbNewLine
else
Response.Write "Locked for Content" & VbNewLine
end if
Response.Write "Aliases:<Br>" & rsV("U_ALIS") & "" & VbNewLine & _
"<br>User Contact:<br>" & rsV("U_CONTACT") & "" & VbNewLine & _
"<br>Details of Events:<br>" & rsV("U_INFO") & "" & VbNewLine
If rsV("U_PROOF1") <> "" then
Response.Write "<br>Link 1: <a href=""" & rsV("U_PROOF1") & """>" & rsV("U_PROOF1") & "</a>" & VbNewLine
end if
If rsV("U_PROOF2") <> "" then
Response.Write "<br>Link 2: <a href=""" & rsV("U_PROOF2") & """>" & rsV("U_PROOF2") & "</a>" & VbNewLine
end if
If rsV("U_PROOF3") <> "" then
Response.Write "<br>Link 3: <a href=""" & rsV("U_PROOF3") & """>" & rsV("U_PROOF3") & "</a>" & VbNewLine
end if
Response.Write "<br><br><a href=""./reply.asp?ID=" & intTopID & """>Add to Content</a>" & VbNewLine
rsV.close
set rsV = nothing
%>
Can't quite figure out whats wrong? Any Ideas?
Topic Locked
Posted - 05 January 2005 : 17:14:25
