Results 1 to 3 of 3

Thread: handling null values[RESOLVED]

Threaded View

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    May 2003
    Location
    Sydney
    Posts
    1,123

    handling null values[RESOLVED]

    a follow up from the last problem i posted here.(btw) the last problem was solved. thanx to randem)

    the database returns a null value and there is an error. i have a code to handle the null value as :
    VB Code:
    1. If c_rs.Fields(fName).Value = Null Then
    2.             c_allData(c_dCount) = ""
    3.         Else
    4.             c_allData(c_dCount) = c_rs.Fields(fName).Value
    5.         End If
    Last edited by mebhas; Feb 3rd, 2004 at 11:46 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width