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
