 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ASP / Database Access / January 2007comma as decimal point?
I need to be able to write numbers to an Access database using comma as decimal point like 22,5 (using the comma-sign). This won't work, if I use 22,5 it gets rounded up to 23, id I use 22.5 (which i can't anyway for other reasons) nothing gets stored at all. ? Kim wrote on 12 jan 2007 in microsoft.public.inetserver.asp.db: > I need to be able to write numbers to an Access database using comma > as decimal point like 22,5 (using the comma-sign). 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!  SignatureEvertjan. The Netherlands. (Please change the x'es to dots in my emailaddress) > You mean using ASP and the Jet engine? > The above should be named a string, numbers have no points or commas. [quoted text clipped - 19 lines] > > 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 (?) Kim 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. [quoted text clipped - 22 lines] >> > 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! SignatureEvertjan. The Netherlands. (Please change the x'es to dots in my emailaddress) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.