quick question

Results 1 to 3 of 3

Thread: quick question

  1. #1
    Join Date
    Dec 1969

    Default quick question

    I&#039m displaying the contents of an Access db to a page using <BR>&#060;%=Field1%&#062;.<BR><BR>My question is that in some cases there is no data in a field and I would like to display the field only if it has data. It would really clean up the page from some blank spots if I could.<BR><BR>So my question is how do you write the statement if field1 has something in it then display it, if not don&#039t.<BR><BR>I tried If "field1 &#062; "" then response.write &#060;%=Field1%&#062;<BR>but it didn&#039t work.<BR><BR>What am I missing?

  2. #2
    oh...my body and soul Guest

    Default quick answer

    &#060;%<BR>If not isnull(field1) then<BR>......<BR>end if<BR>%&#062;<BR><BR>field1 will ahve to have a value right. I assume you are assigning the recordset value to that variable

  3. #3
    Join Date
    Dec 1969

    Default I am and thanks

    I am assigning the rs that value.<BR><BR>Thanks for the syntax help. I learned something new!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts