Ad:

ASP Discussion Thread
Unsolved
Views: 17246

Jan 20th, 2006

Boolean variable True/false

Expand Post »

Hi there,
Using DMX4 & MsAccess (ASP VBScript)

i'm trying to show my True/false results as Yes/No. I am trying this at the mo:
<%If(RsNewProds.Fields.Item("Org").Value)=1 Then
Response.Write("Yes") else Response.Write("No")end if%>

but it comes up with error 0x800A0412 at the 'else' bit of the script

Any thoughts??
Thanks

Similar Threads

how to pass class variable to another class in Java
Boolean Algebra in C++
boolean array in Java
What is the size of a boolean variable in Java
Convert first character from lowercase to uppercase? in C++

Georgina

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jan 2006

Permalink

Jan 23rd, 2006

Re: Boolean variable True/false

asp can appear tempermental with if statements. Try this.
<%
If(RsNewProds.Fields.Item("Org").Value)=1 Then
Response.Write("Yes")
else
Response.Write("No")
end if
%>

campkev

Reputation Points: 14

Solved Threads: 19

Posting Pro in Training

Offline

484 posts
since Jul 2005

Permalink

Jan 23rd, 2006

Re: Boolean variable True/false

Thanks it worked!!!
Georgina

Georgina

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jan 2006

Permalink

Jan 25th, 2006

Re: Boolean variable True/false

Clean it up and do it the right way

ASP Syntax (Toggle Plain Text)
 <%
If CBool(RsNewProd("Org")) Then
	Response.Write("Yes")
Else
	Response.Write("No")
End If
%>
 <%
If CBool(RsNewProd("Org")) Then
	Response.Write("Yes")
Else
	Response.Write("No")
End If
%>

The cleaner you code the easier it is to go back and edit things.

Drew

Reputation Points: 25

Solved Threads: 7

Junior Poster

Offline

166 posts
since Apr 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: Designing an Intranet using ASP

Next Thread in ASP Forum Timeline: shopping cart

DaniWeb Message

Cancel Changes

User Name
Password