If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > Show Region problem in ASP

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-29-04, 22:12
GTPBoy GTPBoy is offline
Registered User
 
Join Date: Apr 2004
Posts: 2
Unhappy 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
Reply With Quote
  #2 (permalink)  
Old 05-05-04, 18:21
MrWizard MrWizard is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On