MySQL and ADO Help
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 command prompt or from the CC GUI returning the correct column EMPLOYEE. But when run from VB the column is not returned and no error is received. I suspect I am using the quotes wrong, can anybody help me out? -=Bryan=- - 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: load data local infile
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 still can not get this to work from the mysql command line, load data local infile DOES work, am trying to get this to work from Perl $sth = $dbh-prepare(load data local infile '/users/hcir/desktop/t2/0001' into table s0001); $sth-execute() or warn : $DBI::errstr\n; returns The used command is not allowed with this MySQL version Mac OS X mysql 4.0.3 /etc/my.cnf contains [mysqld] local-infile=1 [mysql] local-infile=1 thanks - hcir - 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: questions about IF(expr1,expr2,expr3)
..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) -Original Message- From: Norris, Joseph Sent: Thursday, September 12, 2002 12:39 PM To: Mysql_List (E-mail) Subject: questions about IF(expr1,expr2,expr3) Hello, Can any one give me some examples of how they have used this function in a practical way? I would like to get a better understanding of how it can be used in a select. Thanks. - 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: Windows XP Installation Problems
Well, I finally figured out the problem, it was a corrupt installation package. Funny thing is I downloaded three different times from different sites. Working now, thanks. -=Bryan=- -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 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 messages when it fails to install. Do you know if the MYSQL installation makes any modifications to the registry or adds files to the system directory. Nothing is copied to registry. If not I could probably just copy the complete directory from the other computer onto a CD and recopy to the problem computer. The above will works. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - 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
Data Type Advice
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 the appropriate data type, float(single precision), double, decimal etc. Of course accuracy in the calculations is important, but I assume double data type is overkill. Thanks -=Bryan=- - 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: Windows XP Installation Problems
Thanks, I have the installation files on the HD, not using the CD. I do have admin access to the machine, never had a problem installing programs before. Can you explain how to make XP can run in 16 bit mode. -=Bryan=- -Original Message- From: b.ware [mailto:[EMAIL PROTECTED]] 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 Privileges. Make sure you are authorized to install software on the system. 2ND: instead of double clicking the setup.exe, use XP's add software app, and let XP find the setup.exe and auto install it. 3RD: check the settings, i.e. DMA, Disconnect, etc. of the CD Rom Drive you are using to install the software. Some large apps dont install properly due to the CD Drive's buffer not being large enough to handle a continueous feed of data to the HD. 4TH: copy the complete CD to the HD and install from the hard drive, if necessary. 5TH: Try to install it while in 16-bit mode. (XP option) good luck dude... --- Lukoni, Bryan AG:EX [EMAIL PROTECTED] wrote: 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 thing, is it installed fine on my home computer which is running XP professional. -=Bryan=- - 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 __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com - 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: Windows XP Installation Problems
Thanks Michel: Enabled the error reporting, but no luck. I'm stumped why I am not seeing any error messages when it fails to install. Do you know if the MYSQL installation makes any modifications to the registry or adds files to the system directory. If not I could probably just copy 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 Problems Hi Bryan, could it be that you deactivated the Windows XP error reporting function? Activate it for the Windows Operating System and All Programs and try installing MySQL again. If an error message occurs the provided data might help you track down the problem... If not don't forget to deactivate it again ;-) -- Michael Bunzel LintraNex Systems Vienna, Austria Lukoni, Bryan AG:EX wrote: 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 thing, is it installed fine on my home computer which is running XP professional. -=Bryan=- - 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
FW: XP Installation
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 thing, is it installed fine on my home computer which is running XP professional. -=Bryan=- -=Bryan=- - 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
Windows XP Installation Problems
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 thing, is it installed fine on my home computer which is running XP professional. -=Bryan=- - 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