Re: MySQL Install on OS X Leoperd

2007-10-26 Thread Craig Hoffman
fix the pref pane. __ Craig Hoffman iChat/AIM: m0untaind0g __ On Oct 26, 2007, at 3:59 PM, Craig Hoffman wrote: Hi There, Has anyone been successful installing and running MySQL (current version) on the new Mac OS (Leopard

MySQL Install on OS X Leoperd

2007-10-26 Thread Craig Hoffman
Hi There, Has anyone been successful installing and running MySQL (current version) on the new Mac OS (Leopard)? __ Craig Hoffman iChat/AIM: m0untaind0g __ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

converting access (.mdb) files...

2005-09-15 Thread Craig Hoffman
Anyone know a way to convert MS Access DB files (.mdb) into a format MySQL can import? I'm on a Mac hence I don't have Access. Best, CH _______ Craig Hoffman www.eclimb.net [EMAIL PROTECTED] iChat / AIM: m0untaind0g ___ -- MySQL General Ma

Like statement help

2005-01-18 Thread Craig Hoffman
Hi There, I have web form where a user can search certain fields and then have them displayed aggregated. For example, find all the routes I climbed with partner A in area(s) ALL (% - wildcard) between date1 and date2 -- so on. See below for the complete query. I'm using pull down menu's and

Re: Error - #1251

2005-01-18 Thread Craig Hoffman
Thanks - I got it working. On Jan 18, 2005, at 12:35 AM, Mattias J wrote: At 2005-01-18 04:53, Craig Hoffman wrote: I upgrade to 4.1.9 last night and I keep getting this error in PhpMyAdmin after I changed the root password (yes I changed both pw's). Does anyone have a solution on how t

Error - #1251

2005-01-17 Thread Craig Hoffman
I upgrade to 4.1.9 last night and I keep getting this error in PhpMyAdmin after I changed the root password (yes I changed both pw's). Does anyone have a solution on how to fix this? I'm running a Mac 10.3.x #1251 - Client does not support authentication protocol requested by server; conside

Re: AVG Function

2004-08-25 Thread Craig Hoffman
Mark, Yes its close and thank you. The problem I am having is I am able to generate the correct ranking.id for that particular user but I can't seem to make it equal the ranking.rating. ID ranking.rating 9 = 5.6 (example) Here's my query: SELECT routes.user_id, ranking.rating, ROUND(A

AVG Function

2004-08-24 Thread Craig Hoffman
Hey Everyone, I can you some assistance on this query. I have three tables one is called ranking and the other is called routes and finally the users table. The users table is not really important. The ranking table looks like this: id rating 1 5.0 2 5.1 3 5.2 4 5.3

ORDER BY rand()

2004-08-19 Thread Craig Hoffman
Hey Folks, I have a query where it pulls random data and display's it. SELECT route_photo, route, route_count, area FROM routes WHERE ORDER BY RAND() LIMIT 1 The query works fine, however, the "route_photo" field is partially populated. This results in just a "route" name appearing but no p

Re: Between Operator

2004-07-09 Thread Craig Hoffman
'Eldorado Canyon' AND style = 'Traditonal' GROUP BY route ORDER BY id DESC Thanks, Craig On Jul 9, 2004, at 1:17 PM, Pete Harlan wrote: On Fri, Jul 09, 2004 at 09:39:02AM -0500, Craig Hoffman wrote: Style: Traditional Area: Yosemite Rating: From: 5.5 To: 5.10c ... "SEL

Between Operator

2004-07-09 Thread Craig Hoffman
Hey Everyone, I have query where one selects an "style" then a "area" and finally "rating". When some selects a rating they select a range of ratings. For example: Style: Traditional Area: Yosemite Rating: From: 5.5 To: 5.10c This should pull up all the rock climbs that are in Yosemite, that

Re: Long numbers

2004-04-11 Thread Craig Hoffman
that worked - Thanks a bunch! CH __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Apr 11, 2004, at 3:14 PM, Mike Blezien wrote: I think your looking for the ROUND(N,D

Long numbers

2004-04-11 Thread Craig Hoffman
uot;SELECT TURNCATE(AVG(distance)), rest of the query Thanks - CH ______ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- MySQL General Mailing List For list arch

Re: Truncating long numbers

2004-04-02 Thread Craig Hoffman
Yes your right - I thought the numbers in the DB were something else. __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Apr 2, 2004, at 11:11 AM, Paul DuBois wrote: At

Truncating long numbers

2004-04-02 Thread Craig Hoffman
e field in MySQL is a double, if that helps. __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]