I am surprised you said that. There are many programming languages that do
not recognise boolean datatypes. To define a boolean variable in these
languages, declare a variable as integer then 0 = false and any other number
= true.
In your case, I suggest you could try changing your Access/ASP datatype to
integers instead. It should still be able to handle normal boolean
comparisons. Ie "if myboolean then", you shouldn't need to change to "if
myboolean <> 0 then"
----- Original Message -----
From: "Russ Davies" <[EMAIL PROTECTED]>
To: "Oson, Chris M." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 4:45
Subject: Re: Boolean Datatype
> I can't do that for 2 reasons :
> 1] 'True' and 'False' are reserved words in ASP
> 2] 'True' would then be a variant holding the value 'T' - which would mean
I
> could not carry out logical comparisons with the two variants, evaluating
> things against True or False.
>
> I have to say after all the reccomendations I received for mySQL, I really
> am shocked to find there are no BOOLEAN values/datatypes. Unless I'm
missing
> something (and Im happy to admit I probably am) this seems like a very
> serious and time consuming omission from the mySQL spec.
> If anyone is aware of a solution to this, please email me, I quite like
> mySQL but I think I'd probably move to another DBMS rather than spend a
long
> time and get messy coding around this problem.
>
> Russ Davies
>
>
> ----- Original Message -----
> From: "Oson, Chris M." <[EMAIL PROTECTED]>
> To: "Russ Davies" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, February 06, 2001 8:02 PM
> Subject: RE: Boolean Datatype
>
>
> > Maybe, but you could define a constant..
> >
> > CONST TRUE "T"
> > CONST FALSE "F"
> >
> > INSERT INTO logInfo2 (logID, ipAddress, boolVars) VALUES (null,
> > '192.192.192.192', TRUE)
> >
> > -----Original Message-----
> > From: Russ Davies [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, February 06, 2001 11:44 AM
> > To: Oson, Chris M.; [EMAIL PROTECTED]
> > Subject: Re: Boolean Datatype
> >
> >
> > Thanks for the suggestion, but this would still mean converting the data
> > type from within ASP (the 'True' type) down to a char ('T') would it
not?
> >
> > It is more sensical than using 1/0 but still involves the same number of
> > processes?
> >
> > Russ Davies
> >
> >
> >
> > ----- Original Message -----
> > From: "Oson, Chris M." <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Tuesday, February 06, 2001 6:36 PM
> > Subject: RE: Boolean Datatype
> >
> >
> > > Why not try using ENUM?
> > >
> > > http://www.mysql.com/doc/E/N/ENUM.html
> > >
> > > You could setup your table like this:
> > >
> > > CREATE TABLE logInfo2
> > > (
> > > logID INT NOT NULL UNIQUE,
> > > ipAddress VARCHAR(20) NOT NULL DEFAULT 'None',
> > > boolVars ENUM ('T', 'F') DEFAULT 'F'
> > > )
> > >
> > > SELECT ipAddress FROM logInfo2 WHERE boolVars = 'F';
> > >
> > > -----Original Message-----
> > > From: russ [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, February 06, 2001 9:10 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: Boolean Datatype
> > >
> > >
> > > Im new to the list, apologies if this has been asked before.
> > >
> > > Im developing a backend for a personal site (www.russd.com) using
mySQL.
> > > The site is hosted on NT4 and has myODBC installed, I have some
database
> > > access working, but I'm looking for a way to implement boolean types.
> > >
> > > Using Access/SQL server I can simple do an insert using SQL like the
> > > following (from within ASP):
> > >
> > > INSERT INTO tblMyTable (booleanField) VALUES (" & myBooleanVariant &
> ");"
> > >
> > > Unfortunately, mySQL doesn't appear to have a boolean datatype and
> myODBC
> > > doesn't seem to convert True/False to 1/0.
> > > The best solution I have so far is to use a TINYINT and change the
> > > True/False values within my ASP code to 1/0. This isn't perfect
howevere
> > as
> > > its more code, more work for the server and far less readable. I also
> have
> > > to cast to boolean when I SELECT data from the mySQL database.
> > >
> > > Could anyone suggest a better way of implementing this, or am I
missing
> > > something?
> > > I have done a Google search and searched the mySQL manual, but got
> > nothing.
> > >
> > > Many thanks in advance of your efforts.
> > > Russ Davies
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
