DB's Nulls (access) giving me a hard time

Ask a Question related to ASP.NET General, Design and Development.

  1. #1

    Default Re: DB's Nulls (access) giving me a hard time



    Nevermind, I got this too. I guess I should search first, and ask later. Thanks for reading.

    --
    BethF, Anchorage, AK

    It's YOUR God.
    They are YOUR rules.
    YOU burn in hell.
    Child Guest

  2. Similar Questions and Discussions

    1. DW application giving SQL server driver time out
      Hi.. When I click at my Recordset in DW application, it giving me an error Microsft ODBC SQL server driver, timeout expired.. what is happen?
    2. Giving Access to files in a directory
      I have this script that checks user permissions in a database table and gives users access to files in a directory on the server. At the moment it...
    3. Giving users access to certain files in a directory
      Ok here is my problem. We have a directory of excel files and users can only look at files they have been assigned permissions for, all the files...
    4. I have a hard time accesssing document Nib file from Main Nib.
      I've looked at the SimpleMultiWindow sample. I look at it and seems like you just define the function in the Main Nib file, then you called the . ...
    5. giving access to specific folders
      hi, i am the administrator of my computer and i want to give my users limited access to certain folders when logged in as administrator. can i...
  3. #2

    Default Re: DB's Nulls (access) giving me a hard time

    Child,

    You were very close.

    If IsDBNull([Expression As Object]) Then

    End If

    Sincerely,
    --
    S. Justin Gengo, MCP
    Web Developer

    Free code library at:
    [url]www.aboutfortunate.com[/url]

    "Out of chaos comes order."
    Nietzche


    "Child" <beth@NOT-SO-bad-dawgs-in-ak.com> wrote in message
    news:Xns93D16198F6A7CbethNOTSObaddawgsina@216.168. 3.44...
    > I get errors when doing attempting to insert a null value from a db into a
    label. the code
    > works fine when there is a value in the db field.
    >
    > Example:
    >
    > lblorgname.text=DsPageData.Tables("OrganizationDat a").Rows(0).item("name")
    >
    >
    >
    > I figure i need to test for null, but can't figure out how to do it.
    IsNull(), =null, isnull all don't
    > work
    >
    > My server tells me "'null' is not declared. 'Null' constant is no longer
    supported; use
    > 'System.DBNull' instead"
    >
    > How do I use system.dbnull in this instance?
    >
    > --
    > BethF, Anchorage, AK
    >
    > It's YOUR God.
    > They are YOUR rules.
    > YOU burn in hell.

    S. Justin Gengo Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139