I have the following code:
<%
strsql = "SELECT revisit " & _
"FROM revisits " & _
"WHERE techid = '"&techid&"' AND month = '"&smm&"'"
set rsrev = con.Execute (strsql)
if rsrev.eof or rsrev.bof then
revisit = '".05"'
else
set revisit = rsrev("revisit")
end if
%>
If rsrev.eof I want to make revist = a number. However, I keep getting errors when I try to do the above.
Error: Microsoft VBScript compilation error '800a03ea'
Syntax error
/upload/template.asp, line 162
revisit = "".05""
Anybody know the correct syntax to do this??