Solved

How to test for null values using the dreamweaver datasets

Posted on 2004-10-01
2
532 Views
Last Modified: 2012-05-05
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
Comment
Question by:reapesuk
2 Comments
 
LVL 19

Accepted Solution

by:
webwoman earned 190 total points
ID: 12203053
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
 

Author Comment

by:reapesuk
ID: 12203206
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

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question