Professional Web Applications Themes

selecting records on empty int field - MySQL

Hi, I want to select records having an empty int field. I probably should change that field to not-empty by default, so I have to at least give the value 0 to it. Until then I don't know how to select it: select lidnr from hvw where naam != " " and kenmerk2006 != ' ' where naam = char and kenmerk2006 = int doesn't work. Thanks for helping out. Huub...

Sponsored Links
  1. #1

    Default selecting records on empty int field

    Hi,

    I want to select records having an empty int field. I probably should
    change that field to not-empty by default, so I have to at least give
    the value 0 to it. Until then I don't know how to select it:

    select lidnr from hvw where naam != " " and kenmerk2006 != ' '

    where naam = char and kenmerk2006 = int doesn't work.

    Thanks for helping out.

    Huub
    Sponsored Links
    Huub Guest

  2. #2

    Default Re: selecting records on empty int field

    On 26.04.2007 11:41, Huub wrote: 

    Try

    WHERE your_field IS NULL

    robert
    Robert Guest

  3. #3

    Default Re: selecting records on empty int field

    > Try 

    Working. Thank you.
    Huub Guest

Similar Threads

  1. Selecting records using URL.recordID Problems!!
    By EnergyFed in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: August 4th, 12:02 AM
  2. Selecting Records based on DB column with list
    By craigkaminsky in forum Coldfusion Database Access
    Replies: 1
    Last Post: May 4th, 07:41 PM
  3. selecting every Nth records set
    By chriskeeler2 in forum Macromedia ColdFusion
    Replies: 1
    Last Post: March 10th, 10:20 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