Re: comma as decimal point?

Kim wrote on 12 jan 2007 in microsoft.public.inetserver.asp.db:

You mean using ASP and the Jet engine?
The above should be named a string, numbers have no points or commas.

usng ASP-vbs:

s1 = "22.5"
s2 = replace(s1,".",",")

usng ASP-jscript:

s1 = '22.5';
s2 = s1.replace(/\./,',');

This won't work, if I use 22,5 it gets rounded up to 23

So why do you need it then?

The field mut be an integer field.

id I use 22.5 (which i can't anyway for other reasons) nothing gets
stored at all. ?

Wouldn't it be sensible to show your code, only the offending part
please!

I have to sum up these numbers later, can't use string for that (?)

If you are talking about a number with either point/period or a comma as
a decimal devider, you must be talking about a string reprsentation of a
number, since numbers in itself are just that and are stored in memory or
in a database in various not human readable often floating point ways.

So if you want to store these numbers AS A NUMBER in your database,
and you are right to do that, you loose the format in which they were
represented on your screen.

1e3, 1000, 1000.0, 501+499 are al stored in the same floating point
numeric database field the same way.

You could store 22.5 or 22,5 as a string in a database field, but there
is not much sense in that. [Only you would skip the conversion of
fractioal numbers to and from binary, that makes some numbers not having
exactly the same value after retrival.]

However, you did not yet answer my 2 Qs above:

You mean using ASP and the Jet engine?

Wouldn't it be sensible to show your code, only the offending part
please!


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
.

Relevant Pages

  • Re: Show lines of Text Based on delmited String
    ... you might be able to do the lookup using a DATABASE field, but these days, DATABASE fields are more badly behaved than they used to be because they insert an extra carriage return after the result, even when the result is a single field ... The field that contanis the string is dbo.tblDeals.ProductLookup ... "Peter Jamieson" wrote: ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Merge - Data Table
    ... First of all I have tried the DATABASE Field as suggested ... and after a fassion it works, I will show you the String ... emitting the two fields from the query source ... >depending on how the formatting is applied. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Error 3163 problems
    ... OTHER than trying to put too much data in a database field? ... In the sub where I open the database: ... Desc$ and SeqNum are passed in to the sub) ... The single space is added to Desc$ to assure that the string will have ...
    (microsoft.public.vb.general.discussion)
  • Re: Show lines of Text Based on delmited String
    ... "Peter Jamieson" wrote: ... string that contains 33 that the product 3 description will also show. ... Make sure you can update the DATABASE field successfully ... is a single field ...
    (microsoft.public.word.mailmerge.fields)
  • Re: invalid use of null
    ... Other fairly common errors are to pass a Null Argumant to a user ... within it that the Argument is actually a Date or a String and pass it ... difficult to track down if the source of the Null is a database field ... Any other debugging techniques that might ...
    (microsoft.public.access.modulesdaovba)
Loading