Converting Boolean into Bit

[peteyjr]

Hi

Can anybody help to to transfer a value from Controlbox (boolean) into an
SQL-Server (saved as bit). How am I able to convert boolean to bit. Any help
is well appreciated.

Thanks Peter

[Ray at]

Function CBit(BooleanVar)
CBit = Abs(CInt(BooleanVar))
End Function

Ray at work


"peteyjr" <peteyjr@web.de> wrote in message
news:bvb90h$4mp$1@news.BelWue.DE...

> Hi
>
> Can anybody help to to transfer a value from Controlbox (boolean) into an
> SQL-Server (saved as bit). How am I able to convert boolean to bit. Any

help

> is well appreciated.
>
> Thanks Peter
>
>

[peteyjr]

Cant change boolean into integer without getting a error msg


"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> schrieb im
Newsbeitrag news:OGvt21n5DHA.1664@TK2MSFTNGP11.phx.gbl...

> Function CBit(BooleanVar)
> CBit = Abs(CInt(BooleanVar))
> End Function
>
> Ray at work
>
>
> "peteyjr" <peteyjr@web.de> wrote in message
> news:bvb90h$4mp$1@news.BelWue.DE...

> > Hi
> >
> > Can anybody help to to transfer a value from Controlbox (boolean) into

an

> > SQL-Server (saved as bit). How am I able to convert boolean to bit. Any

> help

> > is well appreciated.
> >
> > Thanks Peter
> >
> >

>
>

[Ray at]

Can you show an example and indicate what the error message is?

Ray at work

"peteyjr" <peteyjr@web.de> wrote in message
news:bvbb04$6us$1@news.BelWue.DE...

> Cant change boolean into integer without getting a error msg
>
>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> schrieb im
> Newsbeitrag news:OGvt21n5DHA.1664@TK2MSFTNGP11.phx.gbl...

> > Function CBit(BooleanVar)
> > CBit = Abs(CInt(BooleanVar))
> > End Function
> >
> > Ray at work
> >
> >
> > "peteyjr" <peteyjr@web.de> wrote in message
> > news:bvb90h$4mp$1@news.BelWue.DE...

> > > Hi
> > >
> > > Can anybody help to to transfer a value from Controlbox (boolean) into

> an

> > > SQL-Server (saved as bit). How am I able to convert boolean to bit.

Any

> > help

> > > is well appreciated.
> > >
> > > Thanks Peter
> > >
> > >

> >
> >

>
>

[Bob Barrows]

peteyjr wrote:

> Cant change boolean into integer without getting a error msg

Yes you can. This line of code does not generate an error:

Response.Write cint(true)

I think the issue is that you are not dealing with a boolean value. Convert
the value explicitly using CBool before using CInt. If the CBool function
raises an error, then you need to figure out what the value actually is,
using response.write.

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Evertjan.]

peteyjr wrote on 29 jan 2004 in microsoft.public.inetserver.asp.db:

> Cant change boolean into integer without getting a error msg

if boolean then result=1 else result=0



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