Checking if DB field is empty

instead of checking for nothing, check for something.

if len(rsProposals.Fields.Item("Proposal").Value) > 1 then ...
else....
end if

But, no text means no color at all, why change color when there is no text?

Sorry, i didn't see the other field "Proposal".

What is it exactly that you want to do?
- Print "Proposal" whenever "Rationale" is not null or empty?

For now, I want to print out the value of proposal in a different color if the value of rationale is empty/null - or not. I eventually want to have the value of proposal displayed in form of a link which when clicked on would open a new window containing the value of rationale - i.e. if there's something in rationale, there's a link, - if there's nothing, no link...

did my sample work?

You could also do something like this:


<%
strRaionale = Trim(rsProposals("Rationale"))
strProposal = Trim(rsProposals("Proposal"))

if  not isNull(strRaionale ) and  strRaionale <> "" then
   strFontColor = "#009A76"
else
   strFontColor = "#FF0000"
end if
%>
<td>
     <font size="-1" face="Arial, Helvetica, sans-serif">
            <font color="<%=strFontColor%>"><%=strProposal %></font>
     </font>
</td>




=:o))

Bill_Harding:

I tried your approach as
 
       if len(rsProposals.Fields.Item("Rationale").Value) > 1 then
       Response.Write "<font color=""#009A76""> "& (rsProposals.Fields.Item("Proposal").Value) &" </font>"
       else
       Response.Write "<font color=""#FF0000""> "& (rsProposals.Fields.Item("Proposal").Value) &" </font>"
       end if

This changes the color of the value of proposal according to whether the Rationale field contains something,as desired, but the value for Rationale doesn't show up!...

When I take out the [if len(rsProposals.Fields.Item("Rationale").Value) > 1 then]  logic  and leave just:

Response.Write "<font color=""#009A76""> "& (rsProposals.Fields.Item("Proposal").Value) &" </font>"

The value of Rationale shows up now. Here's what Rationale's ASP code looks like:

<td><div align="center"><font size="-1" face="Arial, Helvetica, sans-serif">
      <%
      Response.Write (rsProposals.Fields.Item("Rationale").Value) %></font></div></td>




Dxpert:

I tried your example, as outlined below:

              <%
      dim strRationale
      strRationale = Trim(rsProposals("Rationale"))
       if  not isNull(strRationale ) and  strRationale <> "" then
       Response.Write "<font color=""#009A76""> "& (rsProposals.Fields.Item("Proposal").Value) &" </font>"
      else
       Response.Write "<font color=""#FF0000""> "& (rsProposals.Fields.Item("Proposal").Value) &" </font>"
       end if
      %>

'strRationale = Trim((rsProposals.Fields.Item("Rationale").Value)) also seems to work.

Result: - the value/txt of proposal shows up in different colors depending on whether the value for Rationale is empty/null - GOOD, but then again the value of Rationale REFUSES to show up! Here's the code for Rationale's display:

<td><div align="center"><font size="-1" face="Arial, Helvetica, sans-serif">
      <% Response.Write (rsProposals.Fields.Item("Rationale").Value)%>
</font></div></td>

Do you guys know why the value for Rationale doesn't show up when we include logic to check whether or not it's empty - it seems to be doing this across the board regardless of whether we use Len, ISNULL or ISEMPTY!

I tried:                
                <%
      dim strRationale
      strRationale = Trim(rsProposals("Rationale"))
       Response.Write "<font color=""#FF0000""> "& (rsProposals.Fields.Item("Proposal").Value) &" </font>"
      %>

and the value of Rationale still wouldn't show up - it is only when I commented out 'strRationale = Trim(rsProposals("Rationale")) that the value for Rationale DID show up...

I'm not sure what's going on here, and why the value for Rationale is absent with the inclusion of something as benign as
strRationale = Trim(rsProposals("Rationale"))!

Ok can you just post you whole code and point where you are getting the error? It's getting very hard to understand these pieces...

=:o))

Ok, I'll try this again... Like I said I have an access DB whole values I'm pulling up and displaying on main.asp. Two of the columns in the DB are the Proposals and Rationale columns. For now I'm trying to change the color of the value of PROPOSAL for each row in the repeat region, depending in whether the value of RATIONALE is null/empty - or not.

The way this info is being displayed on main.asp is on an HTML table with columns corresponding to the columns in the access DB. The code I've been providing, above, is that of the Proposal and Rationale columns. That said, I'm having problems with the value of the Rationale column not showing up when I try to use some logic to determine whether the value of Rationale is empty.

The code b4 using the logic looks like:

For Proposal column:
<td><font size="-1" face="Arial, Helvetica, sans-serif">
               <%
      dim strRationale
       Response.Write "<font color=""#FF0000""> "& (rsProposals.Fields.Item("Proposal").Value) &" </font>"
      %>
</font></td>

For Rationale column:
 <td><div align="center"><font size="-1" face="Arial, Helvetica, sans-serif">
      <%
      Response.Write (rsProposals.Fields.Item("Rationale").Value)
      %>
</font></div></td>

In this setup, the value of the Rationale column shows up in main.asp


The code using the logic to check whether the Rationale column is empty/null looks like:

For Proposal column:
<td><font size="-1" face="Arial, Helvetica, sans-serif">
      dim strRationale
      strRationale = Trim(rsProposals("Rationale"))
      'strRationale = Trim((rsProposals.Fields.Item("Rationale").Value))
      if  not isNull(strRationale ) and  strRationale <> "" then
         Response.Write "<font color=""#009A76""> "& (rsProposals.Fields.Item("Proposal").Value) &" </font>"
      else
         Response.Write "<font color=""#FF0000""> "& (rsProposals.Fields.Item("Proposal").Value) &" </font>"
       end if
      %>
 </font></td>


For Rationale column:
 <td><div align="center"><font size="-1" face="Arial, Helvetica, sans-serif">
      <%
      Response.Write (rsProposals.Fields.Item("Rationale").Value)
      %>
</font></div></td>

With the logic in, the value for the Rationale column fails to get displayed - is blank, which is where I'm stuck/don't understand...

Have I explained myself better/Does it make sense now?  Thanks again for your suggestions

Have u tried this way may be it will work

strRaionale = Trim(rsProposals("Rationale"))


if (Isempty(strRaionale)) then
---------------------
else
---------------------
end if

What datatype is rational
If it is a text fielde then try

if rsProposals("Rationale")="" then

'this means it is blank

if it is a true false then
if rsProposals("Rationale")=false then

if it is a number
then
if rsProposals("Rationale")=0 then

Ok, I've changed my approach a bit - made things simpler. What I'm doing now is I'm trying to display the value of Rationale for a given row result in form of a link that's independent of whether or not the Rationale field is empty. I'm using the value of the company field as the link text. Here's the code:

main.asp
<td><div align="center"><font size="-1" face="Arial, Helvetica, sans-serif">
    <%
    dim str_rationale
               str_rationale = rsProposals("Rationale")      
     response.write "<A href = 'rationales2.asp?str_text=" & str_rationale & " ' target = '_blank'>"
     Response.Write (rsProposals.Fields.Item("Company").Value)
     Response.Write "</A>"
     %>
</font></div></td>


rationales2.asp

dim passed_text
passed_text = request.querystring("str_text")

if len(str_text) = 0 then
response.write " dang it, it still didn't work.."
else
response.write "The value passed from the previous link = " & str_text & "<BR>"
end if

What happens now is that the value of Rationale can be seen (on the browser status bar) when I hover over the link to it, but when I click on the link itself to view the full Rationale text in the new window (as per the code) there's nothing in "str_text" - I get "dang it, it still didn't work.." It's quite baffling! - see anything I'm doing wrong in passing/retrieving the variables? Thanks guys.

ANYONE?