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

  1. #1

    Default padding question

    I have a field that I am trying to pad with zeros to 10 places. I am trying
    this but it is not working, can someone shed some light? This is a mysql db.

    update test
    set padme = lpad(padme,10,'0')

    tia

    rmorgan Guest

  2. Similar Questions and Discussions

    1. padding in IE suckerfish menu
      Yes I incorporated the workarounds. But IE is still showing padding under the top tier div-- please see http://www.copelandcasati.com/test. As...
    2. Padding\Margin Problems
      http://www.iankovi.com/edno.html http://www.iankovi.com/edno.css I'm having a problem with IE, and Opera with .content in IE the boxes are...
    3. How do you get rid of padding???
      Forum- I know it's something simple that I am not doing correctly, but I can't figure it out.... ...
    4. cryptostream,padding
      My application produces BLOB's which need to be compressed and encrypted prior to transfer over the internet. I have inplemented a class called...
    5. padding numbers
      How can I take a number and truncate/round it to n decimal places, -or- pad it with 0's to n decimal places? Is there a method in the language for...
  3. #2

    Default Re: padding question

    Nevermind, figured it out. Thanks.

    rmorgan Guest

  4. #3

    Default Re: padding question

    Thanks for sharing.
    MikerRoo 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