|
 |
access_asp thread: Adding 0
Message #1 by "Daniel Groh" <daniel.groh@s...> on Wed, 21 Aug 2002 10:30:27 -0300
|
|
Hi Guys, Everything ok?
Well, I'm adding in a numeric field, we will suppose that I insert 00123
When I give "response.write", I see 123
I have to convert to Char? for example:
response.write CStr(rs("numeric_field"))
Isn't it?
Thanks a lot
Message #2 by "Zee Computer Consulting" <zee@t...> on Wed, 21 Aug 2002 08:28:46 -0700
|
|
Try this:
Response.Write( right ( "00000" & cStr(rs("numeric field")), 5 ) )
-- Zee
----- Original Message -----
From: "Daniel Groh" <daniel.groh@s...>
To: "Access ASP" <access_asp@p...>
Sent: Wednesday, August 21, 2002 6:30 AM
Subject: [access_asp] Adding 0
> Hi Guys, Everything ok?
>
> Well, I'm adding in a numeric field, we will suppose that I insert 00123
>
> When I give "response.write", I see 123
>
> I have to convert to Char? for example:
>
> response.write CStr(rs("numeric_field"))
>
> Isn't it?
>
> Thanks a lot
>
>
Message #3 by "Daniel Groh" <daniel.groh@s...> on Wed, 21 Aug 2002 12:26:38 -0300
|
|
Are you sure?
I need of zeros in the report, so: 000123 or 0012 or 0000000040
It doesn't right the number of zeros...
----- Original Message -----
From: Zee Computer Consulting <zee@t...>
To: Access ASP <access_asp@p...>
Sent: Wednesday, August 21, 2002 12:28 PM
Subject: [access_asp] Re: Adding 0
> Try this:
>
> Response.Write( right ( "00000" & cStr(rs("numeric field")), 5 ) )
>
> -- Zee
>
>
> ----- Original Message -----
> From: "Daniel Groh" <daniel.groh@s...>
> To: "Access ASP" <access_asp@p...>
> Sent: Wednesday, August 21, 2002 6:30 AM
> Subject: [access_asp] Adding 0
>
>
> > Hi Guys, Everything ok?
> >
> > Well, I'm adding in a numeric field, we will suppose that I insert 00123
> >
> > When I give "response.write", I see 123
> >
> > I have to convert to Char? for example:
> >
> > response.write CStr(rs("numeric_field"))
> >
> > Isn't it?
> >
> > Thanks a lot
> >
> >
>
>
>
>
|
|
|
View Cart
