Professional Web Applications Themes

Access Database Currency - Macromedia ColdFusion

I am trying to have my page show dollar values from my access Database to show in the same format as in Access. Right now the field in Access is set as a Currency field with 2 decimal's and default value of zero. I programmed the page to show the field on the website. How ever the value shows up as (example) 5000.0000!! How do I go about fixing this problem? Any help on this will be greatly appreciated! Thank you!!!...

  1. #1

    Default Access Database Currency

    I am trying to have my page show dollar values from my access Database to show
    in the same format as in Access. Right now the field in Access is set as a
    Currency field with 2 decimal's and default value of zero. I programmed the
    page to show the field on the website. How ever the value shows up as (example)
    5000.0000!! How do I go about fixing this problem? Any help on this will be
    greatly appreciated! Thank you!!!

    GabXav1852 Guest

  2. #2

    Default Re: Access Database Currency

    have you tried cf's dollarFormat?
    PaulH Guest

  3. #3

    Default Re: Access Database Currency

    I found that and tried to use it. However the example doesn't explain exactly where and how to input it in.
    GabXav1852 Guest

  4. #4

    Default Re: Access Database Currency

    seems pretty clear to me, DollarFormat(number).


    <cfoutput>
    <cfset quarter=0.25>
    #dollarFormat(quarter)#<br>
    #dollarFormat(quarter+1.00)#<br>
    #dollarFormat(quarter+10.00)#<br>
    #dollarFormat(quarter+1000.00)#<br>
    #dollarFormat(quarter+1000000.00)#<br>
    </cfoutput>

    PaulH Guest

Similar Threads

  1. Inserting Currency into database
    By dtubbs in forum Macromedia ColdFusion
    Replies: 2
    Last Post: February 25th, 06:57 PM
  2. Web access to database
    By Geroon in forum FileMaker
    Replies: 6
    Last Post: October 21st, 03:58 AM
  3. Write Access to Access DataBase
    By Microsoft in forum ASP.NET Security
    Replies: 0
    Last Post: August 14th, 07:56 PM
  4. Access vs DBF database??
    By Mad Dog in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 28th, 04:41 AM
  5. Replies: 5
    Last Post: July 22nd, 07:32 AM

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