Professional Web Applications Themes

convert numerical value to text? - Macromedia Contribute Connection Administrtion

Hi, I have a currency field in an Access database. I'm using VBScript/ASP. If the currency field is showing as 0.00, I would like to display the word "Free". Is this possible? Thanks. Nath,...

  1. #1

    Default convert numerical value to text?

    Hi,

    I have a currency field in an Access database. I'm using VBScript/ASP.

    If the currency field is showing as 0.00, I would like to display the word
    "Free".
    Is this possible?

    Thanks.
    Nath,


    Nathon Jones Guest

  2. #2

    Default convert numerical value to text?

    Hi,

    I have a currency field in an Access database. I'm using VBScript/ASP.

    If the currency field is showing as 0.00, I would like to display the word
    "Free".
    Is this possible?

    Thanks.
    Nath,


    Nathon Jones Guest

  3. #3

    Default Re: convert numerical value to text?

    Oops,

    Wrong forum....accidental post. Sorry.

    Nath.


    "Nathon Jones" <nathonjonesNOTkirkmoor.com> wrote in message
    news:d0ju33$gad$1forums.macromedia.com...
    > Hi,
    >
    > I have a currency field in an Access database. I'm using VBScript/ASP.
    >
    > If the currency field is showing as 0.00, I would like to display the
    > word "Free".
    > Is this possible?
    >
    > Thanks.
    > Nath,
    >

    Nathon Jones Guest

  4. #4

    Default Re: convert numerical value to text?

    Ok, to answer my own question:

    <%IF (rsEventInfo.Fields.Item("eventprice").Value) > "0" Then%>
    <%=
    FormatCurrency((rsEventInfo.Fields.Item("eventpric e").Value), -1, -2, -2, -2)
    %><br>
    <% Else %>
    FREE<br>
    <%End IF%>

    Hurrah!
    Nath.

    "Nathon Jones" <nathonjonesNOTkirkmoor.com> wrote in message
    news:d0juca$gm7$1forums.macromedia.com...
    > Hi,
    >
    > I have a currency field in an Access database. I'm using VBScript/ASP.
    >
    > If the currency field is showing as 0.00, I would like to display the
    > word
    > "Free".
    > Is this possible?
    >
    > Thanks.
    > Nath,
    >

    Nathon Jones Guest

Similar Threads

  1. Convert text to Paths
    By HaileP in forum Macromedia Freehand
    Replies: 1
    Last Post: June 25th, 10:15 PM
  2. How do I convert a pdf to excel or to text
    By Sarah_Petterson@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 3
    Last Post: May 14th, 03:42 AM
  3. convert text to text field
    By Arch@ngel webforumsuser@macromedia.com in forum Macromedia Director Basics
    Replies: 2
    Last Post: November 11th, 02:22 PM
  4. rasterize/path text/convert text to art
    By Laura in forum Web Design
    Replies: 0
    Last Post: September 22nd, 09:03 PM
  5. How to convert text to tables?
    By colm in forum Macromedia Dreamweaver
    Replies: 2
    Last Post: July 22nd, 02:28 PM

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