Re: format masks for a Masked edit control
I would also like to add to this, that I think it would be a good addition to the documentation. Gregg - Original Message - From: Gregg Housh [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 20, 2001 4:08 PM Subject: format masks for a Masked edit control I am working on an auto-generating form in VB. Its time to add a mask control, if the FieldType is a number. I need input and display masks for each of the numeric field types. (for the Microsoft MaskEdBox control that comes with VB 6). If anyone is any good at masks, please help me out here. I just dont seem to be good at getting them right. Gregg - 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
format masks for a Masked edit control
I am working on an auto-generating form in VB. Its time to add a mask control, if the FieldType is a number. I need input and display masks for each of the numeric field types. (for the Microsoft MaskEdBox control that comes with VB 6). If anyone is any good at masks, please help me out here. I just dont seem to be good at getting them right. Gregg
Re: Embedded MySQL: Opinion Please
http://www.qnx.com/ Tey actually have a headline right now about BerkleyDB being ported. While I take nothing away from the Mysql/Linux combo as a stable OS. I would stay that a specifically designed RTOS for embeded devices might be better in this situation. Gregg - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 15, 2001 1:00 PM Subject: Embedded MySQL: Opinion Please Hi! I've been monitoring this list for a while now (re: lurking), I've seen only passing comments about embedding MySQL, so I thought I would come out and directly ask the MySQL community for your opinions, or better yet, actual facts - based on experience. I am evaluating MySQL / Linux for use in a line of deeply embedded, multi-node, real-time SCADA products. Where: deeply embedded = headless platform, no user interaction (not even via telnet), no administration interaction, required to operate for years without restart. multi-node = 1 to N processor boards, sharing a common bus (VME, CPCI), not SMP. And, * Database size: between 10K - 250K records - where once the records have been created, they are only updated, typically between several 100 to several 1,000 UPDATES / second. * No moving parts (no fan, no hard disk, no CD, no floppy, no noth'n). * Memory size is not an issue (can add more as required); CPU power is not an issue (re: Moore's Law) (The actual requirements are not as extreme as depicted here, but I want to push the envelope.) I am convinced that MySQL / Linux will work in such as environment. But, the real question(s) is: Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? For this environment, is the MySQL / Linux combo a good idea? Or, should I stick with Linux, but seek out an alternate DBMS? Or, should I drop Linux and go with Windows CE, or some other RTOS? Or, should I stop being a software developing and become a sheepherder? David Vance Senior Software Developer GE Harris Energy Control Systems Canada, Inc. 2728 Hopewell Place NE Calgary, Alberta,Canada T1Y 7J7 +1 (403) 214-4543 +1 (403) 287-7946 [EMAIL PROTECTED] - 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
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 PROTECTED]
Sent: Tuesday, February 06, 2001 3:42 PM
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 in the code on the web server. It would mean passing in
a string instead of a boolean. This is what I'm trying to avoid.
True and False are not keywords in mySQL. Would there be any way I could
perhaps make them so (giving them values of 1 and 0 respectively would solve
my problem completely).
Thanks in advance for your 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 might help you out a bit.
Matt Friedman
Spry New Media
http://www.sprynewmedia.com
Lead Programmer/Partner
email: [EMAIL PROTECTED]
phone: 250 744 3655
fax: 250 370 0436
- Original Message -
From: "Russ Davies" [EMAIL PROTECTED]
To: "Oson, Chris M." [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 12:45 PM
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',
boolVarsENUM ('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
Re: Boolean Datatype
Let me add to this. I meant to say: He could create a function that would
do it, and use it in his queries?
Gregg
- Original Message -
From: Gregg Housh [EMAIL PROTECTED]
To: Russ Davies [EMAIL PROTECTED]; Matt Friedman [EMAIL PROTECTED];
MySQL List [EMAIL PROTECTED]
Sent: Tuesday, 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 PROTECTED]
Sent: Tuesday, February 06, 2001 3:42 PM
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 in the code on the web server. It would mean passing in
a string instead of a boolean. This is what I'm trying to avoid.
True and False are not keywords in mySQL. Would there be any way I could
perhaps make them so (giving them values of 1 and 0 respectively would solve
my problem completely).
Thanks in advance for your 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 might help you out a bit.
Matt Friedman
Spry New Media
http://www.sprynewmedia.com
Lead Programmer/Partner
email: [EMAIL PROTECTED]
phone: 250 744 3655
fax: 250 370 0436
- Original Message -
From: "Russ Davies" [EMAIL PROTECTED]
To: "Oson, Chris M." [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 12:45 PM
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',
boolVarsENUM ('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
Re: 'USE_RAID' in mysql-3.22.32?
In the create table documenttation, it explains the USE_RAID, and a few other options pertaining to it. Gregg - Original Message - From: Brian Reichert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 4:22 PM Subject: 'USE_RAID' in mysql-3.22.32? In pawing though the source for mysql-3.22.32 (our current version in production), I noticed in acconfig.h, a macro 'USE_RAID', which in term seems to set up the use of include/raid.h. But, I can't find any documentation for this, and the configure program doesn't seem to set it one way or another. What is the state of that code? For that version of MySQL, it it useful/meaningful to activate it, if I intend to make use of a RAID array? -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
