RE: Nesting

2001-03-09 Thread John Halladay
I found the error. I was using "" around the "+" where I should have been using '', like '+'. SELECT IFNULL(IF(CMBYR=CMEYR,CMBYR,IF(CMEYR="+",CONCAT(CMBYR,CMEYR),CONCAT(CMBYR,' - ',CMEYR))),' - ') FROM TABLE; Thanks

Nesting

2001-03-09 Thread John Halladay
#x27; - ') FROM TABLE; Is it not possible to nest an "if, then, else" statement? Thanks. John Halladay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

If, then, else . . .

2001-02-15 Thread John Halladay
If I am querying a field that has either "a" or "b" as a value and I want a second field's value to be dependant on the first field's value, how would I right that? SELECT field1, IF(field1="a",100,IF(field1="b",200,"ERROR") FROM table; The IF,THEN,ELSE is the only thing I can think of, but that

RE: Percent?

2001-02-15 Thread John Halladay
: Thursday, February 15, 2001 1:36 PM To: John Halladay Cc: MySQL List (E-mail) Subject: Re: Percent? SELECT CONCAT(data1*100,'%') as percdata1, data2, data3 FROM table; John Halladay <[EMAIL PROTECTED]> wrote: I can't find this in the manual (maybe I'm looking in the wro

Percent?

2001-02-15 Thread John Halladay
I can't find this in the manual (maybe I'm looking in the wrong place). How do I show a value as a percent? For example. SELECT data1, data2, data3 FROM table; Assuming data1 is 0.25, how do I show it as 25%? SELECT PERC(data1), data2, data3 FROM table;? Thanks. Joh

MS Access - This Recordset is not updateable

2001-02-12 Thread John Halladay
ything, where can I change the setting so I can read/write and not just read? I also have another table that lets me make changes, but won't let me save them. Thanks, John Halladay - Before posting, please check: htt

MS Access Checkbox equivalent format in MySQL

2001-02-06 Thread John Halladay
If I am using MS Access and linking to tables in MySQL through MyODBC, what is the equivalent format of a checkbox (Yes/No) in MySQL? Would it be ENUM('Yes','No') or ENUM('True','False')? All caps TRUE, YES, etc.? Thanks ahea

PK, SK, FK . . . ?

2001-02-06 Thread John Halladay
reating the table in MySQL? Would I need to create a composite key, etc.? Thanks. John Halladay BISYS - Commission Accounting Phone: 801.532.6660 x7973 Fax: 801.533.7879 www.ascensus.com Life LTC Annuities Variable Disability

RE: MyODBC - but how?

2001-02-01 Thread John Halladay
somehow use the command CONNECT [] to change the database? -Original Message- From: Scott Baker To: John Halladay; MySQL List (E-mail) Sent: 1/31/2001 2:09 PM Subject: Re: MyODBC - but how? You just create a DSN in the control panel, and tell your ODBC compliant software to use that data

MyODBC - but how?

2001-01-31 Thread John Halladay
I have just installed MyODBC on my machine (Windows ME) and everything is working fine, but I've looked through the manual and I can't find anything showing commands on how to connect to other databases. Can someone point me in the right direction? Thanks. Joh

Windows ME / Licensing

2001-01-31 Thread John Halladay
00 to automate reporting and queries for my work. It will be on my machine and only used by myself. Thanks ahead of time for your input. John Halladay - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: newbie grant problems

2001-01-23 Thread John Halladay
Normally when you log in you would type: ->mysql -u username -p [Enter] It would then prompt you for a password if you have one. (By the way, substitute "username" with your username.) It shouldn't matter what prompt you're in, root, etc. John Halladay -Original

Apache - MySQL - PHP (Auto-start Apache)

2001-01-23 Thread John Halladay
will start up automatically when I boot up Linux? (I know it's a little off the MySQL subject, but I figured someone would have a similar setup.) Thanks, John Halladay - Before posting, please check: http://www

RE: installing and configuring Mysql on red hat linux 6.2

2001-01-19 Thread John Halladay
To install will you be using a tarball or RPM? -Original Message- From: Stephen Lambert,CSI [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 11:18 AM To: [EMAIL PROTECTED] Subject: installing and configuring Mysql on red hat linux 6.2 Hi, I would like to know where i can find i

RE: Replicating MySQL

2001-01-19 Thread John Halladay
"Mirror" is the word you're looking for. -Original Message- From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 11:55 AM To: MySql list Subject: Replicating MySQL Hello, How could we replicate our MySQL DB from one server to another? As a back up measure,