Forums

This topic is locked

Decimal problem

Posted 01 Oct 2002 02:25:14
1
has voted
01 Oct 2002 02:25:14 Matt Flood posted:
This should be an easy problem to fix. There are a couple ways to solve it but i want the best solution. I am ussing Dreamweaver MX, IIS, and Access 2002. I am pulling data from the database. I am pulling a number like
1704370 I want it to show up as 1.704370 who has the best idea of fixing the problem.

Replies

Replied 02 Oct 2002 16:50:47
02 Oct 2002 16:50:47 Ned Frankly replied:
This should work (off the top of my head, though, so check syntax):

<%
var OriginalNumber = String(rsTable.Fields.Item("Number".Value)
var NewNumber = OriginalNumber.substr(0,1)+"."+OriginalNumber.substr(1,OriginalNumber.length-1)
%>

Then
<%=NewNumber%>
where you want to display it.

Good luck!

Ned Frankly

Reply to this topic