Solved

How to test for null values using the dreamweaver datasets

Posted on 2004-10-01
2
530 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
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 Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now