| Author |
 Topic Search  Topic Options
|
Greaser 
Newbie
Joined: 30 October 2002
Location: United States
Status: Offline
Points: 26
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Exception occurred -
Posted: 14 August 2003 at 9:56am |
I think what I am trying to do is pretty simple. <% if rsPass("seconds") <> " " then response.write "Sorry. There is no test pass with this is. Please contact <a href=mailto:mail@somesome>" end if %> If rsPass is null then I want to display the message. Am I even close in my coding? I get when using it. Error Type: (0x80020009) Exception occurred. /lab/ sql/pass. asp, line 192
|
 |
MorningZ
Senior Member
Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 August 2003 at 10:32am |
|
what code is at line 192?
|
|
Contribute to the working anarchy we fondly call the Internet
|
|
Greaser
Newbie
Joined: 30 October 2002
Location: United States
Status: Offline
Points: 26
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 August 2003 at 10:44am |
|
if rsPass("seconds") <> " " then
|
|
pmormr
Senior Member
Joined: 06 January 2003
Location: United States
Status: Offline
Points: 1479
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 August 2003 at 4:04pm |
try replacing
if rsPass("seconds") <> " " then
with
if rsPass("seconds") = "" then
|
|
|
|
3BEPb
Groupie
Joined: 07 August 2003
Location: United States
Status: Offline
Points: 81
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 August 2003 at 9:37pm |
|
pmormr, rsPass("seconds")<>"" doesn't mean Null AFAIK. That means just blank record, which is NOT NULL anyway.
Edited by 3BEPb
|
|
pmormr
Senior Member
Joined: 06 January 2003
Location: United States
Status: Offline
Points: 1479
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 August 2003 at 3:43pm |
i said try, and btw, that line should work. He used the wrong word to describe his situation, from what i picked up in that code, if there's nothing in seconds then he wants to display the message. Look at the blue text a little bit closer, notice that it sayes '=' not '<>'!
P.S. I know a good anger therapist!
|
|
|
|
3BEPb
Groupie
Joined: 07 August 2003
Location: United States
Status: Offline
Points: 81
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 August 2003 at 9:51pm |
pmormr, lol :)
I prefer build, not destroy, so I never angry. If you think abt caps in "NOT NULL", sorry, but that's the way how I highlite values in code :))))
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 August 2003 at 10:26pm |
|
The best way to detect null is the IsNull function, so try:
<%
if IsNull(rsPass("seconds")) then
response.write "Your Message"
end if
%>
|
|
|
|
