MySQL and ADO Help

2002-09-12 Thread Lukoni, Bryan AG:EX
mysql All: Here is a snippet I am using in a Select Statement using VB with ADO ... Entry_Date, CONCAT_WS( ' - ',Employee_Number,CONCAT_WS(',',last_name,first_name)) AS Employee,Cat_Description,Stat_hours,If(EXCLUDE_FTEX = 'FALSE', 'YES','') .. It works fine when run from the

RE: load data local infile

2002-09-12 Thread Lukoni, Bryan AG:EX
I have had luck by removing the word LOCAL from the statement. -=Bryan=- -Original Message- From: nellA hciR [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:33 AM To: MySQL List Subject: load data local infile i have read several archives/docs on this but

RE: questions about IF(expr1,expr2,expr3)

2002-09-12 Thread Lukoni, Bryan AG:EX
..If(qualify = true,'Qualified','Not Qualified') as Whatever ... -=Bryan=- -Original Message- From: Norris, Joseph [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 2:37 PM To: Mysql_List (E-mail) Subject: FW: questions about IF(expr1,expr2,expr3)

RE: Windows XP Installation Problems

2002-09-11 Thread Lukoni, Bryan AG:EX
10, 2002 7:22 PM To: Lukoni, Bryan AG:EX; 'Michael Bunzel' Cc: '[EMAIL PROTECTED]' Subject: RE: Windows XP Installation Problems At 16:40 10/9/2002 -0700, Lukoni, Bryan AG:EX wrote: Hi, Thanks Michel: Enabled the error reporting, but no luck. I'm stumped why I am not seeing any error

Data Type Advice

2002-09-11 Thread Lukoni, Bryan AG:EX
Hello mysql users: Would appreciate some advice on data types for a column. The value for the field would be a number that would never exceed 1000 but would have two decimal points limited to .25 increments e.g 5.25 or 7.75 There may be some simple calculations such as totals etc. What would be

RE: Windows XP Installation Problems

2002-09-10 Thread Lukoni, Bryan AG:EX
]] Sent: Monday, September 09, 2002 5:27 PM To: Lukoni, Bryan AG:EX; '[EMAIL PROTECTED]' Subject: Re: Windows XP Installation Problems If it installed on Pro at home, it should do the same on another pc running Pro.(in a perfect world maybe) try these troubleshooting steps. FIRST: check you

RE: Windows XP Installation Problems

2002-09-10 Thread Lukoni, Bryan AG:EX
the complete directory from the other computer onto a CD and recopy to the problem computer. -=Bryan=- -Original Message- From: Michael Bunzel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 3:49 PM To: Lukoni, Bryan AG:EX Cc: [EMAIL PROTECTED] Subject: Re: Windows XP Installation

FW: XP Installation

2002-09-09 Thread Lukoni, Bryan AG:EX
I am unable to install either version My SQL 4.03 or the release My SQL 3.23 on a XP professional operating system. No error message is produced, double clicking the setup.exe file only produces a flashing hourglass for a second and then nothing, no error messages. Suggestions anyone. Stange

Windows XP Installation Problems

2002-09-09 Thread Lukoni, Bryan AG:EX
I am unable to install either version MySQL 4.03 or the release MySQL 3.23 on a XP professional operating system. No error message is produced, double clicking the setup.exe file only produces a flashing hourglass for a second and then nothing, no error messages. Suggestions anyone. Stange