formatted numbers returned when they should not be.

Adrian Parker · Nov 5, 2003

I have tables that contain columns declared as numeric(18,6)

When i do the following vb code..

lstr_val = CStr(reader.Item("numeric_column_name"))

lstr_val contains a zero padded number.

e.g.

say I put 3.2 into the column, the string would contain 3.200000 when it was displayed.

However..this has only been a problem (I think) since framework 1.1 was installed.

Any ideas ?

EricJ · Nov 5, 2003

as to the couse no :/
as to a sollution
lstr_val = CStr(reader.Item("numeric_column_name")).trimend("0"c)

eric

Adrian Parker · Nov 5, 2003

yeah, solution is easy if I know it's a numeric column I'm reading, but unfortunately, I don't know at runtime whether it's a
numeric or a string field with training zeros in it, so I can't just unilaterally chop trailing zeros.
--
Adrian Parker

EricJ said:
as to the couse no :/
as to a sollution
lstr_val = CStr(reader.Item("numeric_column_name")).trimend("0"c)

eric

EricJ · Nov 5, 2003

if isnumeric(CStr(reader.Item("numeric_column_name"))) then
'you can also use the format function

format(CStr(reader.Item("numeric_column_name")),"###########################
##.###################")
end if

but you seem to know the column?

eric

Adrian Parker said:
yeah, solution is easy if I know it's a numeric column I'm reading,

but unfortunately, I don't know at runtime whether it's a

numeric or a string field with training zeros in it, so I can't just

unilaterally chop trailing zeros.

Adrian Parker · Nov 5, 2003

Unfortunately, I don't know the column type at runtime.. it could be a varchar or a numeric, all I know is the column name.. When it
just returned the 3.2 it worked fine, now it's adding the extra zeros it's causing a problem.

-Adrian

EricJ · Nov 5, 2003

1st you are converting to string 2nd you check if the string is numeric (i
fail to c the problem, but thats probably me)
it could help if you gie a list of different values that are returned (with
the type)

Adrian Parker said:
Unfortunately, I don't know the column type at runtime.. it could be a

varchar or a numeric, all I know is the column name.. When it

Adrian Parker · Nov 5, 2003

What we're doing is allowing users to select the columns they want to appear in a web form.. we're building the form up just knowing
the name of the columns.. the data could be anything, but was working perfectly ok using the CStr function to convert whatever it
was to a stirng.. now it isn't wokring.
I can't just remove trailing zeros because a varchar field could contain 1000.

EricJ · Nov 5, 2003

go for the format function then normally it should work, if not you could
have a look at formatNumber 2

eric

Adrian Parker said:
What we're doing is allowing users to select the columns they want to

appear in a web form.. we're building the form up just knowing

the name of the columns.. the data could be anything, but was working

perfectly ok using the CStr function to convert whatever it

Cor · Nov 5, 2003

Hi Eric and Adrian,

I think the problem is you both are not using upercases

:-)

))) just for fun what is above

If all fails, maybe this is a possibillity

lstrval = lstrval.Substring(0, lstrval.LastIndexOf(".") + 3)

Cor

EricJ · Nov 5, 2003

hi Cor

the question would be is there a . if there are no decimals? ;p

but it did make me think of something

if str.indexof(".") <> -1 then
strNew = str.trimEnd("0"c)
end if

Adrian Parker · Nov 5, 2003

Thanks for the responses guys, but I have no idea what data I'm getting back so can't use formatting to resolve the problem..

I have to find out why the either the CStr function or the reader.item() property has stopped returning what it did in the past.

Adrian Parker · Nov 5, 2003

I've upgraded to dotnet 2003 and therefore using framework 1.1 and it's still a problem.

keyur shah · Nov 6, 2003

1) You have the column numeric scale and precision that is responsible
for the return value
2) You are retrieving it after converting it to str this is the complete
issue...

Store it in a int or number variable... it would resolve ur issue.

Keyur Shah
Verizon Communications
732-423-0745

Kevin Yu [MSFT] · Nov 6, 2003

Thanks all for your response.

Hi Adrian,

I think you can first put the value into an float variable. You can use
ToString() method to convert the float to whatever type you wish, as
ToString has an overload like ToString(string).

Please refer to the following link for more information.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemsingleclasstostringtopic.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfSystemGlobalizationNumberFormatInfoClassTopic.asp

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| From: keyur shah <[email protected]>
| References: <[email protected]>
| X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
| Subject: Re: formatted numbers returned when they should not be.
| Mime-Version: 1.0
| Content-Type: text/plain; charset="us-ascii"
| Content-Transfer-Encoding: 7bit
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Date: Wed, 05 Nov 2003 16:37:31 -0800
| NNTP-Posting-Host: actionjackson133.dsl.frii.net 216.17.147.133
| Lines: 1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:65571
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| 1) You have the column numeric scale and precision that is responsible
| for the return value
| 2) You are retrieving it after converting it to str this is the complete
| issue...
|
| Store it in a int or number variable... it would resolve ur issue.
|
|
| Keyur Shah
| Verizon Communications
| 732-423-0745
|
|
| Don't just participate in USENET...get rewarded for it!
|

Adrian Parker · Nov 6, 2003

No, the problem is that they seem to have changed how it works between framework 1.0 and 1.1.

EricJ · Nov 6, 2003

we know to little of all your possible values

give me an example where this can't work

if str.indexof(".") <> -1 and isnumeric(str) then
strNew = str.trimEnd("0"c)
end if

Kevin Yu [MSFT] · Nov 7, 2003

Hi Adrian,

The behavior of Cstr() has changed a bit from VS .net 2002 to VS .net 2003.
You can resolve this by using the following code:

dim s as single = reader.Item("numeric_column_name")
lstr_val = Cstr(s)

This works both in 2002 and 2003.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| From: "Adrian Parker" <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: Re: formatted numbers returned when they should not be.
| Date: Thu, 6 Nov 2003 06:53:54 -0000
| Lines: 19
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <#[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| NNTP-Posting-Host: 82-37-130-6.cable.ubr01.telf.blueyonder.co.uk
82.37.130.6
| Path:
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:65590
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| No, the problem is that they seem to have changed how it works between
framework 1.0 and 1.1.
|
| > 1) You have the column numeric scale and precision that is responsible
| > for the return value
| > 2) You are retrieving it after converting it to str this is the complete
| > issue...
| >
| > Store it in a int or number variable... it would resolve ur issue.
| >
| >
| > Keyur Shah
| > Verizon Communications
| > 732-423-0745
| >
| >
| > Don't just participate in USENET...get rewarded for it!
|
|
|

Adrian Parker · Nov 7, 2003

Ach! ok, so we will have to rewrite it all, given we were relying on cstr
returing an already truncated string when dealing with fields of unknwon
datatype. Is there any way of determining the datatype of a resultset column
in an oldbdatareader ?

-Adrian

Kevin Yu [MSFT] · Nov 7, 2003

Hi Adrian,

You can get the data type by calling GetType() on an object. For example,
you can use datareader["column"].GetType() to get the type of the value in
the column.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| From: "Adrian Parker" <[email protected]>
| References: <[email protected]>
<[email protected]>
<#[email protected]>
<[email protected]>
| Subject: Re: formatted numbers returned when they should not be.
| Date: Fri, 7 Nov 2003 08:21:47 -0000
| Lines: 69
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <#[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| NNTP-Posting-Host: 82-37-130-6.cable.ubr01.telf.blueyonder.co.uk
82.37.130.6
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:65729
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| Ach! ok, so we will have to rewrite it all, given we were relying on cstr
| returing an already truncated string when dealing with fields of unknwon
| datatype. Is there any way of determining the datatype of a resultset
column
| in an oldbdatareader ?
|
| -Adrian
|
| > Hi Adrian,
| >
| > The behavior of Cstr() has changed a bit from VS .net 2002 to VS .net
2003.
| > You can resolve this by using the following code:
| >
| > dim s as single = reader.Item("numeric_column_name")
| > lstr_val = Cstr(s)
| >
| > This works both in 2002 and 2003.
| >
| > Kevin Yu
| > =======
| > "This posting is provided "AS IS" with no warranties, and confers no
| > rights."
| >
| > --------------------
| > | From: "Adrian Parker" <[email protected]>
| > | References: <[email protected]>
| > <[email protected]>
| > | Subject: Re: formatted numbers returned when they should not be.
| > | Date: Thu, 6 Nov 2003 06:53:54 -0000
| > | Lines: 19
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | Message-ID: <#[email protected]>
| > | Newsgroups: microsoft.public.dotnet.framework.adonet
| > | NNTP-Posting-Host: 82-37-130-6.cable.ubr01.telf.blueyonder.co.uk
| > 82.37.130.6
| > | Path:
| >
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
| > phx.gbl!TK2MSFTNGP11.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.adonet:65590
| > | X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| > |
| > | No, the problem is that they seem to have changed how it works between
| > framework 1.0 and 1.1.
| > |
| > | > | > 1) You have the column numeric scale and precision that is
responsible
| > | > for the return value
| > | > 2) You are retrieving it after converting it to str this is the
complete
| > | > issue...
| > | >
| > | > Store it in a int or number variable... it would resolve ur issue.
| > | >
| > | >
| > | > Keyur Shah
| > | > Verizon Communications
| > | > 732-423-0745
| > | >
| > | >
| > | > Don't just participate in USENET...get rewarded for it!
| > |
| > |
| > |
| >
|
|
|

Adrian Parker · Nov 7, 2003

Ah, ok Kevin, many thanks.

-Adrian

Kevin Yu said:
Hi Adrian,

You can get the data type by calling GetType() on an object. For example,
you can use datareader["column"].GetType() to get the type of the value in
the column.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| From: "Adrian Parker" <[email protected]>
| References: <[email protected]>
<[email protected]>
<#[email protected]>
<[email protected]>
| Subject: Re: formatted numbers returned when they should not be.
| Date: Fri, 7 Nov 2003 08:21:47 -0000
| Lines: 69
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <#[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| NNTP-Posting-Host: 82-37-130-6.cable.ubr01.telf.blueyonder.co.uk
82.37.130.6
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:65729
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| Ach! ok, so we will have to rewrite it all, given we were relying on cstr
| returing an already truncated string when dealing with fields of unknwon
| datatype. Is there any way of determining the datatype of a resultset
column
| in an oldbdatareader ?
|
| -Adrian
|
| > Hi Adrian,
| >
| > The behavior of Cstr() has changed a bit from VS .net 2002 to VS .net
2003.
| > You can resolve this by using the following code:
| >
| > dim s as single = reader.Item("numeric_column_name")
| > lstr_val = Cstr(s)
| >
| > This works both in 2002 and 2003.
| >
| > Kevin Yu
| > =======
| > "This posting is provided "AS IS" with no warranties, and confers no
| > rights."
| >
| > --------------------
| > | From: "Adrian Parker" <[email protected]>
| > | References: <[email protected]>
| > <[email protected]>
| > | Subject: Re: formatted numbers returned when they should not be.
| > | Date: Thu, 6 Nov 2003 06:53:54 -0000
| > | Lines: 19
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | Message-ID: <#[email protected]>
| > | Newsgroups: microsoft.public.dotnet.framework.adonet
| > | NNTP-Posting-Host: 82-37-130-6.cable.ubr01.telf.blueyonder.co.uk
| > 82.37.130.6
| > | Path:
| >
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
| > phx.gbl!TK2MSFTNGP11.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.adonet:65590
| > | X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| > |
| > | No, the problem is that they seem to have changed how it works between
| > framework 1.0 and 1.1.
| > |
| > | > | > 1) You have the column numeric scale and precision that is
responsible
| > | > for the return value
| > | > 2) You are retrieving it after converting it to str this is the
complete
| > | > issue...
| > | >
| > | > Store it in a int or number variable... it would resolve ur issue.
| > | >
| > | >
| > | > Keyur Shah
| > | > Verizon Communications
| > | > 732-423-0745
| > | >
| > | >
| > | > Don't just participate in USENET...get rewarded for it!
| > |
| > |
| > |
| >
|
|
|

formatted numbers returned when they should not be.

Adrian Parker

EricJ

Adrian Parker

EricJ

Adrian Parker

EricJ

Adrian Parker

EricJ

Cor

EricJ

Adrian Parker

Adrian Parker

keyur shah

Kevin Yu [MSFT]

Adrian Parker

EricJ

Kevin Yu [MSFT]

Adrian Parker

Kevin Yu [MSFT]

Adrian Parker