Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Set a number
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

snaayk
Senior Member

USA
1061 Posts

Posted - 10 April 2002 :  14:49:28  Show Profile  Visit snaayk's Homepage  Send snaayk an AOL message  Send snaayk an ICQ Message  Send snaayk a Yahoo! Message
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??


Nikkol
Forum Moderator

USA
6907 Posts

Posted - 10 April 2002 :  15:44:56  Show Profile

<%
if rsrev.eof or rsrev.bof then
revisit = ".05"
else
set revisit = rsrev("revisit")
end if
%>

Take out the part in red and correct the part in green.

Nikkol
Go to Top of Page

snaayk
Senior Member

USA
1061 Posts

Posted - 10 April 2002 :  16:17:59  Show Profile  Visit snaayk's Homepage  Send snaayk an AOL message  Send snaayk an ICQ Message  Send snaayk a Yahoo! Message
Must have been the part in RED that screwed up everything because I tried the GREEN one already...Working after removing the RED

Working Now thx.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07