Hide areas

jroxit · January 21st, 2009, 03:00 PM

I have a form on a classic .asp page. The fields on the form vary from user to user.

For example:

Jane Doe signs in...she sees
Customer Name __________
Customer ID __________
Phone # __________
NA __________

John Public signs in...he sees

Customer Name: ________
Account Number: ________
Phone # ________
Email Address ________

The underlines represent text boxes in my form. The labels are generated through .asp and a SQL database from customer to customer. Is there any way where there is a "NA" as a label that I can hide both the "NA" and the associated textbox?

I know you can hide or show an area is a database is/isn't empty. Can I use the same type of programming if the field label is equal to "NA"?

Thanks in advance!

Old Pedant · January 21st, 2009, 04:24 PM

Maybe you need to show some of your existing code.

This doesn't even "feel" like an ASP question to me, since obviously you could simply do

Code:

<input type=hidden name="NA" value="<%=RS("NA")%>" >

in HTML code.

Are you auto-generating the form, using the DB field names??? If so, you could simply do

Code:

Set RS = conn.Execute("SELECT * FROM table WHERE someid = " & someid )
For fnum = 0 To RS.Fields.Count-1
    Set fld = RS.Fields(fnum)
    If UCase(fld.Name) = "NA" Then
%>
        <input type=hidden name="NA" value="<%=fld.Value%>" >
<%
    Else
%>
    <%=fld.Name%>: <input name="<%=fld.Name%>" value="<%=fld.Value%>" >
<%
    End If
Next
%>

But, really, maybe you need to show code????