Removing .0 from record

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

  1. #1

    Default Removing .0 from record

    Another easy one, I hope.
    I have records in a database that read like 3654.0
    How can I get CF to remove the .0 for me, so I can access an image called image3654 ??
    keller18 Guest

  2. Similar Questions and Discussions

    1. Find record w/ conditions met in the same child record
      I'll use 2 files to demonstrate my question. The first file is Animal. It has 4 fields. Id (serial number) ZooId (number) Name (text) Food...
    2. using dropdown box to display db record & update record
      Hi Folks, I have a web database written in asp and using access97. I have many projects, but each project is being held responsible by a person....
    3. Stop adding record in subform after record count = 1
      Can someone help in in what to put after the THEN statment to allow one entry if the Record count is =>1 in the Before insert or should I set the...
    4. Adding a new record when the record source is a query.
      Hello All, I have a form that runs a query. The reason it runs on a query is because prior to it opening I have a form from which you can pick...
    5. Removing desktop icon from one account is removing from all accounts
      Using XP Professional. I want the Guest account to have only a few icons. The other two accounts should have many more. When I remove the icon...
  3. #2

    Default Re: Removing .0 from record

    CF function NumberFormat(<number>,) will do it for you. define "0000" as the

    <cfset readNumber = NumberFormat(<number>,)>
    <cfset imagecalled = image&""&readNumber>
    name=Azpen Guest

  4. #3

    Default Re: Removing .0 from record

    I'd use the round function myself. Less typing, than numberformat.
    Dan Bracuk 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