Quick CEILING question

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

  1. #1

    Default Quick CEILING question

    De query <cfquery name='UpdateRating' datasource='#dSn#'> update tableName
    set columnA = CEILING(columnA - 1) , columnB = CEILING(columnB + 1)
    where id = 89 </cfquery> I can't\don't seem to use\ing CEILING correctly. I
    want to try and use the Transact SQL numerical function of CEILING to keep
    columnA from ever going negitave. BTW, yes I suck and am using MSAccess as my
    DS. I can ROUND but I can't CEILING... Am I just syntaxually-tarded.

    Knum Guest

  2. Similar Questions and Discussions

    1. very quick question
      In my database a field is designated as 0 or -1 . When i make my form how do i set up the drop down menu so that the user chooses yes or no and...
    2. quick MX question....
      how do you get rid of that window on the right where it says 'color swatches', 'components', etc.. it really bothers me, it makes the working area...
    3. Quick question
      if you want to select top 100 records, you will use SELECT TOP 100 * FROM tableName Is there anyone knows how to find bottom 100 records? ...
    4. A Quick Question
      Does anyone know if it is possible to create a Flash movie that has the ability to let the user click on a button to begin the installation of a...
    5. QUICK SSA QUESTION
      AIXers, I'm looking for a quicker way to determine the physical locations of ssa drives in a SSA drawer w/o having to use diag/ssa service aides...
  3. #2

    Default Re: Quick CEILING question

    Update: I am still looking and I think that CEILING it not the right tack for
    me to turn to... I am only dealing with the number 1. That is adding it or
    subtracting with the number one. So I came up with a dim-witted, dull,
    feebleminded, half-witted, imbecile, moronic, simpleminded, unenlightened,
    reactionary, obtuse, stupid, thickheaded, unenlightened, uninformed,
    underdeveloped, undeveloped and unprogressive way of doing it. <cftransaction>
    <cfquery name='UpdateTable' datasource='#dNs'> update tableName set ColumnA =
    ColumnA - 1 where id = 89 and ColumnA <> 0 </cfquery> <cfquery
    name='UpdateRating' datasource='ourgardens'> update Books set ColumnA =
    ColumnA + 1 where id = 89 and ColumnA <> 32767 </cfquery> </cftransaction>
    Still doesn't solve the root problem of not allowing the column to fall into
    negitave numbers. Please help... I can't find Jack or his brother Dit-a-Lee on
    the net about how to keep it positive.

    Knum 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