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

    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?

    Thanks.

    Brendon

  2. #2
    Join Date
    Mar 2003
    Location
    Atlanta, GA
    Posts
    191
    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?

    Tim
    Tim

Posting Permissions

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