SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast cragthehack's Avatar
    Join Date
    Jul 2001
    Location
    Ft. Lauderdale, FL. USA
    Posts
    94
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    currency functions - ASP

    Are there any currency functions in MySQL? Im using ASP (Im being forced).. and Im trying to format a numeric field to display a currency. I figured there might be a way to do this with-in the SQL statement- you know something like: SELECT name, sale_no, currency_function(price) etc. Any ideas?

    Thanks
    - crag
    net geek for non profits and political campaings

  2. #2
    SitePoint Enthusiast hendo's Avatar
    Join Date
    Jun 2001
    Location
    Australia
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Why not just pull out the number from your database and then use the FormatCurrency() function in ASP?

    I looked in the MySQL manual and there is no currency fuunction as far as I can see.

    Hope that helps!

    hendo
    Steve 'Hendo' Henderson
    EnVivo!CS: Fast and Affordable Web Content Management for ASP. 100% Script, No DLLs.
    www.netsystemsco.com

  3. #3
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    There may not be a currency function, but there should be a currency datatype (it's fairly standard).
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  4. #4
    SitePoint Enthusiast cragthehack's Avatar
    Join Date
    Jul 2001
    Location
    Ft. Lauderdale, FL. USA
    Posts
    94
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I agree MySQL should have a currency datatype. And thnaks for the headsup with FormatCurrency(). It's a VB Script and I didn't even think of looking there. Dum...
    - crag
    net geek for non profits and political campaings


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
  •