www.webdeveloper.com
Results 1 to 3 of 3

Thread: sql error

Hybrid View

  1. #1
    Join Date
    Jun 2011
    Location
    California
    Posts
    383

    Lightbulb sql error

    If i'm selecting * from a table and i get an error like so:


    (9 row(s) affected)
    Msg 7342, Level 16, State 1, Line 5
    An unexpected NULL value was returned for column "[MSDASQL].lastupdatedate" from OLE DB provider "MSDASQL" for linked server "AP_TRAINER". This column cannot be NULL.


    is there a way to ignore those rows and still pull the data i want? This would be very helpful if so... any help would be greatly appreciated. Thank you.

  2. #2
    Join Date
    Jul 2009
    Posts
    184
    Sounds like you want to make use of "IS NOT NULL".

    Something like this should work:
    Code:
    SELECT *
    FROM yourTableName
    WHERE yourColumnName IS NOT NULL
    EDIT: just noticed your using msdasql, not sure that syntax is going to work for you.
    Last edited by WestWeb; 12-13-2012 at 08:38 PM.

  3. #3
    Join Date
    Jun 2011
    Location
    California
    Posts
    383
    thanks for chiming in though.. i'll see what i can figure out by morning time.. but if you happen to have any more ideas.. please share a good work around this

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles