Ask a Question related to ASP Database, Design and Development.
-
John Squirrell #1
Number Format
Hi,
In the FrontPage Database Wizard I have the following custom query:
Select *, FORMAT(Number, '#.00') AS fNumber FROM MyFile
When I view the resulting page on my Local Server I get the correct result:
00.00
When I view the page on my remote server I get:
00,00
I also have the following script in my global.asa file:
<SCRIPT RUNAT=Server Language=VBScript>
SUB Session_OnStart
Session.lcid=1033
END SUB
</SCRIPT>
Any help greatly appreciated.
Regards
John
John Squirrell Guest
-
Format Phone Number
I have a text feild (homephone) in MSAccess that hold phone numbers (410)543-3333 When I display these in a <CFOUTPUT>#HOMEPHONE#<\CFOUTPUT> the... -
Format a number on SELECT
I know Fusion has a function called NumberFormat() for formatting numbers on the fusion side during display, but I was wondering if I can select the... -
Phone Number Format
Ken, your regex has to be mapped to the INPUT, not the output. by including parens and dashes in the regex, you are guaranteeing that the... -
Number format problems with SUM and AVG
Hie everybody, I have a problem with the following, I have a table with a row containing numbers with 2 decimal places. I want to count the... -
format number into currency format ($1,000,000.00)
SELECT '$' + CONVERT(VARCHAR, CONVERT(MONEY, 1000000), 1) "lamP" <phantlam@yahoo.com> wrote in message...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
