Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unhappy Unanswered: Show Region problem in ASP

    Ok, here we go. I have a table that displays dynamic data. I chose to use the " Show Region if Recodset Not Empty" behavior. The problem that I have is that it is finding values for an empty recordet and thus not finding the table when it needs to. I have traced the problem down to the fact that the database table is not exactly empty, it is blank but as I understand, being blank IS a value, so its seeing the blank values and not hiding the table. One solution I found was to do an "and columname IS NOT NULL in the where statement, but that would requie me to change all the blanks back to <NULL> values and even then, the next I update that column, the <NULL> will be overwritten with blanks again. Any one have any ideas?



  2. #2
    Join Date
    Mar 2003
    Atlanta, GA
    From your description, I'm assume you're using Dreamweaver.... which I have very little knowledge of. Have you tried testing for ISEMPTY('fieldname') instead of NULL in the WHERE condition?


Posting Permissions

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