Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default boolean cfsqltype

    Can someone please advise what cfsqltype should I used for boolean (true/false)?
    I've tried cf_sql_bit, but my results were inconsistent.
    i.e. correct sometimes, but at other times the return values were not correct.

    Thanks

    doramon Guest

  2. Similar Questions and Discussions

    1. CFQUERYPARAM CFSQLTYPE Datatype Sizes?
      Hi, This is probably come up before, but I'm not having any luck tracking down info on it. Does anyone have a list of datatype sizes for each type...
    2. Problem with cfsqltype attribute of cfprocparam
      I am using Microsoft SQL server 2000. The cfsqltype attribute of cfprocparam supports the following as shown below (extract from in its...
    3. Invalid data error for CFSQLTYPE CF_SQL_VARBINARY
      I'm testing out our news release posting application with our new CF MX 7 server and I'm getting an error posting a news release: Invalid data...
    4. Boolean Searches
      I am trying to implement a boolean type search . The current search that I have searches for exact matches, if the input has multiple words. I want...
    5. Boolean constructor...
      Hello, When I instanciate a boolean with a string for an argument, and the display the variable for example var b:Boolean = new Boolean("ASDF");...
  3. #2

    Default Re: boolean cfsqltype

    OK. I've tried boolean with cf_sql_integer and it works. Thanks anyway.
    doramon Guest

  4. #3

    Default Re: boolean cfsqltype

    If it's a boolean, you should use bit and pass either a one (1) or zero (0).

    Ken
    The ScareCrow Guest

  5. #4

    Default Re: boolean cfsqltype

    That works too. Thanks Ken
    doramon 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