DaniWeb Forum Index > Web Development > ASP

Boolean variable True/false

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jan 2006

Posts: 2

Reputation: Georgina is an unknown quantity at this point

Solved Threads: 0

Georgina

Offline

Newbie Poster

Boolean variable True/false

Jan 20th, 2006

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

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: Boolean variable True/false

Jan 23rd, 2006

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
%>

•

Join Date: Jan 2006

Posts: 2

Reputation: Georgina is an unknown quantity at this point

Solved Threads: 0

Georgina

Offline

Newbie Poster

Re: Boolean variable True/false

Jan 23rd, 2006

Thanks it worked!!!
Georgina

•

Join Date: Apr 2004

Posts: 167

Reputation: Drew is an unknown quantity at this point

Solved Threads: 7

Drew

Offline

Junior Poster

Re: Boolean variable True/false

Jan 25th, 2006

Clean it up and do it the right way

 Help with Code Tags 
 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
%>