numberformat coverting a variable containing 1,000 to a variable containing 1000

Posted on 2004-11-23
Last Modified: 2013-12-24
Hey folks,

A quick question to ask how i should:

pass a variable (number) in the url
extract it on another page and save it to a variable
do a database search on this variable and then bring back the details

My application works when the number is less than 1000 but once it gets to 1000 or more it trys to do a search on the database where ID = 1,234.

I have tried to convert this to  #numberformat(variable, 9999)# but it converts it to a random number somehow,

Any help would be much appreciated.

Question by:jturkington
    LVL 6

    Accepted Solution

    Apparently you use formatting like 1,000 and your database needs it to be 1000. You can achieve that using #lsParseNumber(variable)#. Provided the locale is set to one that understands 1,000 (Like English (US))
    LVL 5

    Assisted Solution

    As mosphat pointed out you would use LsParseNumber liek so

    LSParseNumber -
    #LSParseNumber(LSNumberFormat(1234.5678, "_________"))#

    you can also use numberformat to format the number to a certain locale but that's probably not what you are looking for
    LSNumberFormat -

    Author Comment

    Thanks guys that done the trick !
    LVL 5

    Expert Comment

    Glad I could help


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    A web service ( is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
    In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now