Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 543
  • Last Modified:

How to test for null values using the dreamweaver datasets

Hi,

I am using a dreamweaver dataset that has a query for totalling values in a database in a VB ASP.NET page. The code to display my total is (as placed by DWMX when you drag the field) :

<%# QryBasketTotal.FieldValue("TOTALAMOUNT", Container) %>

This displays the totals fine, but not formatted to 2 decimal places so I tried the following:

<%# formatCurrency(QryBasketTotal.FieldValue("TOTALAMOUNT", Container),2) %>

Which also works UNTIL the value of "TOTALAMOUNT" is empty or null, then it falls over in a big heap.

So, my question is, how can you test for a null value in ASP.NET on a dataset?

I have tried making my own functions to do a simple if <blah> is NULL then... but it would appear NULL is not supported, so I tried dbNull.Value (as found on the web):

function DisplayTotal() as String

      Dim Container
      if QryBasketItems.FieldValue("TOTALAMOUNT", Container) is dbNull.Value  then
            DisplayTotal="0.00"
      Else
            DisplayTotal =formatCurrency(QryBasketTotal.FieldValue("TOTALAMOUNT", Container),2)
      End If
End function

But THIS fails with "System.FormatException: Input string was not in a correct format."

PLEASE PLEASE PLEASE, does anyone know what I am doing wrong?

Thanks

Jimbo
0
reapesuk
Asked:
reapesuk
1 Solution
 
webwomanCommented:
There's an isNull command in classic ASP that returns true/false. I suspect it still exists.
if isNull(QryBasketItems.FieldValue("TOTALAMOUNT", Container))  then

You can see what that does. At least you're only debugging one thing, so it's easy to know if it's working or not. ;-)
0
 
reapesukAuthor Commented:
Thanks Webwoman but this function doesn't exist in ASP.NET VB.

I have "solved" it another way by converting the value (or not as the case may be) to a string and then testing for an empty string:

MyValue=QryBasketTotal.FieldValue("TOTALAMOUNT", Container).ToString

Probably not the best solution but it works.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now