Professional Web Applications Themes

Int field type and error messages.. - Microsoft SQL / MS SQL Server

Hi all, I'm sure someone can answer this one with the greatest of ease... Typically I've known an 'int' type to have an upper value of 32 thousand something, and the same as a negative value... With SQL Server it seems higher...thing is I've been testing stuff and exceeded it, so I'd like to know what the highest number is... This :...

Sponsored Links
  1. #1

    Default Int field type and error messages..

    Hi all,

    I'm sure someone can answer this one with the greatest of ease...

    Typically I've known an 'int' type to have an upper value of 32 thousand
    something, and the same as a negative value...

    With SQL Server it seems higher...thing is I've been testing stuff and
    exceeded it, so I'd like to know what the highest number is...

    This :


    Sponsored Links
    Robb Guest

  2. #2

    Default Re: Int field type and error messages..

    Damn that control-B combo!!!!

    As I was saying...

    This :

    pageid=9999999999

    for example produces this error message

    Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
    [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of the varchar
    value '9999999999' overflowed an int column. Maximum integer value exceeded.

    Stick another 9 on the end (pageid=99999999999), and

    Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
    [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
    be truncated.

    is produced

    This however is ok...

    pageid=999999999

    clearly exceeding the 32 thousand thing...

    can anyone tell me what the highest number is please?

    Cheers

    Robb


    Robb Guest

  3. #3

    Default Sorted it - soz to bother...

    Books online is a wonderous thing!


    Robb Guest

Similar Threads

  1. Form field error messages
    By Shabam in forum ASP.NET Web Services
    Replies: 3
    Last Post: September 6th, 06:29 AM
  2. Replies: 6
    Last Post: June 30th, 11:56 PM
  3. Problem with character palette and Tracking field: can't type zero after type is modified
    By Tim_Murray@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 0
    Last Post: May 11th, 04:21 PM
  4. Replies: 6
    Last Post: July 22nd, 01:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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