Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP error displaying "True/False" db field as yes/no

Status
Not open for further replies.
credo

credo

Programmer
Jul 26, 2001
50
0
0
GB
Hello,

I'm trying to simply display Yes/No instead of True/Fasle from an Access db yes/no field in a table cell - having trouble with the ASP formatting with the following statement :

<td width=&quot;122&quot; valign=&quot;top&quot; class=&quot;gen2&quot;>
<%= If (rs_av.Fields.Item(&quot;w1_Avail&quot;).Value = True)

' set the yes/no true/false access field to more friendly yes/no

Response.Write &quot;Yes&quot;
Elseif (rs_av.Fields.Item(&quot;w1_Avail&quot;).Value = False) Then
Response.Write &quot;No&quot;
End If
%></td>

this is throwing up the error :
Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement
/bigbluetravel/vd.asp, line 299
= If (rs_av.Fields.Item(&quot;w1_Avail&quot;).Value = True)

I've tried various changes ,but am getting same error..

Thanks in advance for any tips...


 
Sort by date Sort by votes
It should read:

<%= If (rs_av.Fields.Item(&quot;w1_Avail&quot;).Value = True) Then

Only because I've done it before myself... :)


-----------------------------------------------------------------------------------------------------
&quot;If you can't explain something to a six-year-old, you really don't understand it yourself.&quot;
-- Albert Einstein
 
Upvote 0 Downvote
Hi,
Thanks for your quick response Chopstick - but I had'nt left out the first &quot;Then&quot;, it was a code pasting error ... so my code is :

<td width=&quot;122&quot; valign=&quot;top&quot; class=&quot;gen2&quot;>
<%= If (rs_av.Fields.Item(&quot;w1_Avail&quot;).Value = True) Then
' set the yes/no true/false access field to more friendly yes/no
Response.Write &quot;Yes&quot;
Elseif (rs_av.Fields.Item(&quot;w1_Avail&quot;).Value = False) Then
Response.Write &quot;No&quot;
End If
%></td>

so still getting the same error ...

Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement
/bigbluetravel/vd.asp, line 303
= If (rs_av.Fields.Item(&quot;w1_Avail&quot;).Value = True) Then

 
Upvote 0 Downvote
I typically don't use the ElseIf statement, but if I remember correctly, it reads essentially as a second If statement, so it must therefore have a corresponding End If. In this case, try adding another End If to the bottom of your original If statement:

<td width=&quot;122&quot; valign=&quot;top&quot; class=&quot;gen2&quot;>
<%= If (rs_av.Fields.Item(&quot;w1_Avail&quot;).Value = True) Then
' set the yes/no true/false access field to more friendly yes/no
Response.Write &quot;Yes&quot;
Elseif (rs_av.Fields.Item(&quot;w1_Avail&quot;).Value = False) Then
Response.Write &quot;No&quot;
End If
End If
%></td>

-----------------------------------------------------------------------------------------------------
&quot;If you can't explain something to a six-year-old, you really don't understand it yourself.&quot;
-- Albert Einstein
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
write HTML code within ASP line
Replies
1
Views
86
xwb
xwb
leifoet
  • Locked
  • Question
How to send HTML emails with ASP classic?
Replies
0
Views
70
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
Return to current location on page after asp processes.
Replies
2
Views
73
penguinspeaks
penguinspeaks
penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
59
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
First execute an input command and only then proceed with displaying the next record of the table
Replies
0
Views
51
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top