can anyone answer this

Discussion in 'ASP .Net' started by Mike, Jun 21, 2004.

  1. Mike

    Mike Guest

    Ok heres the issue. I have a copy of the production database localy on my
    machine for developing, the DB has null values in some rows, now when i run
    my code against the row of data that has NULL values in the columns, i get
    no errors, Now here is the issue, when I go against the same database on our
    test server and the asp.net code is on the web server I'm getting errors
    when the value is NULL,

    Why will NULLS work on my local copy of the db, and the vb.net/asp.net code
    is the same on my local box as it is on the web server?

    Confused
     
    Mike, Jun 21, 2004
    #1
    1. Advertising

  2. Mike wrote:
    > Ok heres the issue. I have a copy of the production database localy on my
    > machine for developing, the DB has null values in some rows, now when i run
    > my code against the row of data that has NULL values in the columns, i get
    > no errors, Now here is the issue, when I go against the same database on our
    > test server and the asp.net code is on the web server I'm getting errors
    > when the value is NULL,
    >
    > Why will NULLS work on my local copy of the db, and the vb.net/asp.net code
    > is the same on my local box as it is on the web server?
    >
    > Confused
    >
    >


    Are you sure that you didn't accidentally have the NULLs transformed
    into empty values (empty strings, etc.) by DTS or however you 'copied'
    the database locally? Confirm that there are actually NULLs in your
    local DB either thru Ent. Manager or debug the code and verify the
    values are NULL. Might be overkill, but there's no reason I can think
    of for the code to act differently....

    BTW, I'm assuming SQLServer...

    --
    Craig Deelsnyder
    Microsoft MVP - ASP/ASP.NET
     
    Craig Deelsnyder, Jun 22, 2004
    #2
    1. Advertising

  3. It sometimes happen in release-mode build and not in debug-mode build, of
    course
    you can not debug your application that is compiled in release mode.

    Solution: handle all fields for nulls.

    --
    Hope this helps,
    Zeeshan Mustafa, MCSD


    "Mike" <> wrote in message
    news:Ol3h3I%...
    > Ok heres the issue. I have a copy of the production database localy on my
    > machine for developing, the DB has null values in some rows, now when i

    run
    > my code against the row of data that has NULL values in the columns, i get
    > no errors, Now here is the issue, when I go against the same database on

    our
    > test server and the asp.net code is on the web server I'm getting errors
    > when the value is NULL,
    >
    > Why will NULLS work on my local copy of the db, and the vb.net/asp.net

    code
    > is the same on my local box as it is on the web server?
    >
    > Confused
    >
    >
     
    M. Zeeshan Mustafa, Jun 22, 2004
    #3
  4. Can U give more information on this.
    OS + SP
    Framework Version
    Database
    SQL Provide or OleDBProvider

    Regards,

    Trevor Benedict R
    MCSD

    *** Sent via Devdex http://www.devdex.com ***
    Don't just participate in USENET...get rewarded for it!
     
    Trevor Benedict R, Jun 22, 2004
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. PJ
    Replies:
    2
    Views:
    576
    KathyB
    Jul 19, 2003
  2. =?Utf-8?B?RGlmZmlkZW50?=

    can anyone answer this tuff question?

    =?Utf-8?B?RGlmZmlkZW50?=, Jan 6, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    384
    Marina
    Jan 6, 2005
  3. Guest
    Replies:
    0
    Views:
    138
    Guest
    Dec 23, 2003
  4. James Radke
    Replies:
    1
    Views:
    150
  5. Joe Van Meer

    can anyone answer this for me?

    Joe Van Meer, May 7, 2004, in forum: ASP .Net Web Controls
    Replies:
    1
    Views:
    127
    David Jessee
    May 8, 2004
Loading...

Share This Page