Boolean variable True/false

[Georgina]

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

[campkev]

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

[Georgina]

Thanks it worked!!!
Georgina

[Drew]

Clean it up and do it the right way :)

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