Re: problem loading dates from txt file

2005-05-31 Thread Jeff Mao
ginal data, have excel display it with a 4 digit year, then copy it, reformat to text, and paste it back). Then you can pull them all together in another cell,... =C1 & "-" & D1 & "-" & right(A1,2) Look at the functions left, right, mid to see how to pull o

RE: php conection problems

2005-02-11 Thread Jeff Mao
upgraded a 3.23 server to the 4.1 and ran that script and my php seems to work fine using the 3.23 client. I had to "fix" other instances where I had used the password('pass') method in MySQL to populate a column, but as far as connecting I had no problems. Michael -----Original

Re: php conection problems

2005-02-11 Thread Jeff Mao
Thanks,...that's the info I needed to help me know where to look for a solution,..I'll direct my work on the php side of things! Jeff At 9:07 AM -0800 2/11/05, Hassan Schroeder wrote: Jeff Mao wrote: I'm back,...I've removed MySQL completely and reinstalled it using the b

RE: php conection problems

2005-02-11 Thread Jeff Mao
suggested earlier,... Is this a Mac OS X thing? Or is this normal? Do all the rest of you have newer version of MySQL recognized by php/apache? Thoughts? Thanks in advance Jeff -- ******** Jeff Mao [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.co

RE: php conection problems

2005-02-10 Thread Jeff Mao
t spot for your mysql client libraries. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message----- From: Jeff Mao [mailto:[EMAIL PROTECTED] Sent: Friday, 11 Feb

RE: php conection problems

2005-02-10 Thread Jeff Mao
built in on unix and rebuild it linking in the latest library. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Jeff Mao [mailto:[EMAIL PRO

RE: php conection problems

2005-02-10 Thread Jeff Mao
ne of your user and give it a try. good luck! From: Jeff Mao <[EMAIL PROTECTED]> To: Jay Blanchard <[EMAIL PROTECTED]>, mysql@lists.mysql.com Subject: RE: php conection problems Date: Thu, 10 Feb 2005 15:36:19 -0500 I've tried using a variety of very wide open permissions just to get

RE: php conection problems

2005-02-10 Thread Jeff Mao
st did this,did I miss something? [/snip] Permissions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Jeff Mao [EMAIL PROTECTED] -- MySQL General Mailing List For list archi

php conection problems

2005-02-10 Thread Jeff Mao
did I miss something? Thanks Jeff -- ******** Jeff Mao [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Restoring from a mysqldump file

2003-03-01 Thread Jeff Mao
erver, but I can connect to it remotely using the normal tools,... Thanks, Jeff -- Jeff Mao [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Help to install Mysql on Macos X 10.2

2003-02-23 Thread Jeff Mao
e 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/unsubscri

backup script

2003-02-19 Thread Jeff Mao
rget about it, the backup folder soon blossoms as it collects a new backup each day, and I'd like to automate the process more so I'm not holding on to tons of old backups. Thanks Jeff -- ******