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',
boolVarsENUM ('T', 'F') DEFAULT 'F'
)
SELECT ipAddress
ris 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
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
pro
"RD" == Russ Davies [EMAIL PROTECTED] writes:
RD Thanks for the suggestion, but this would still mean converting the data
RD type from within ASP (the 'True' type) down to a char ('T') would it not?
then use
ENUM('False','True')
instead. Enum can have any string you want. I personally
efforts,
Russ Davies
- Original Message -
From: "Matt Friedman" [EMAIL PROTECTED]
To: "Russ Davies" [EMAIL PROTECTED]; "MySQL List" [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 9:11 PM
Subject: Re: Boolean Datatype
Try using enum in mysql. That mi
, February 06, 2001 2:44 PM
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
to be for an ENUM data type?
Russ Davies
- Original Message -
From: "Vivek Khera" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 9:09 PM
Subject: Re: Boolean Datatype
"RD" == Russ Davies [EMAIL PROTECTED] writes:
RD Thanks for the suggestion, but t
"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,
Subject: Re: Boolean Datatype
Enum would allow me to have two values such as 'True' and 'False' ?
The problem is when I pass in this SQL statement to mySQL:
INSERT INTO tableName (fieldName) VALUES (True);
-mySQL does not recognise the word True - it would need to be in quotes,
which means changes
, February 06, 2001 3:56 PM
Subject: Re: Boolean Datatype
http://www.mysql.com/doc/A/d/Adding_functions.html
Could this help him out? Creating a User Defined Function?
Gregg
- Original Message -
From: Russ Davies [EMAIL PROTECTED]
To: Matt Friedman [EMAIL PROTECTED]; MySQL List
[EMAIL
uot; [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 l
11 matches
Mail list logo