Re: Problems with Oracle/ASP/VBScript
From: Edwin <vanmeerendonk_at_wxs.nl>
Date: 1 May 2002 04:26:12 -0700
Message-ID: <31354201.0205010326.16912f0b_at_posting.google.com>
Date: 1 May 2002 04:26:12 -0700
Message-ID: <31354201.0205010326.16912f0b_at_posting.google.com>
you could try to alter the database-session by changing the , in something else with alter session set nls_numeric_characters= '. ' (I don't programm in ADO, but I'm sure you can alter a session with it) then the server will give you the number back with the right decimal-sign.
SQL*PLUS:
alter session set nls_numeric_characters= ', ';
select 10000000/13 from dual;
769230,769
alter session set nls_numeric_characters= '. ';
select 10000000/13 from dual;
769230.769 Received on Wed May 01 2002 - 13:26:12 CEST