Re: Number of records returned

-3.rhl9 > > Thanks, > Eve > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To > unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > __

Re: Question about IF statements...

OUP BY project_id HAVING total>0; > > > > Cory Hicks wrote: > > >Hello, > > > >I must be having a goober moment.I am running the following sql > >query with no problems: > > > >SELECT project_id, > >IF (SUM( time_worked ) > '0.00&#

Question about IF statements...

GROUP BY project_id However, having 'NULL' appear where the total is 0.00 doesn't do me much good :-) How do I write this query to only show me the results where the total is > 0.00...so where the results that total 0.00 don't appear at all. I am sure I am missing something..

Help with #1111 - Invalid use of group function

ep getting the # errno.- Invalid use of group function - I don't want to pull out any rows where the SUM of time_hours_worked is '0.00'... I would be most grateful if anyone has any suggestions Many thanks! Cory -- Cory Hicks <[EMAIL PROTECTED]> TRI Internat

RE: Finding a record BETWEEN two dates

Duh! I need '' around my datesorry for the traffic. sql, query Duh! -- Cory Hicks Texas Research International, Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (

Finding an ID between two dates

esult form the query, the id, but I get no results. Advice? Helpful hints always welcome.. Many thanks! Cory -- Cory Hicks Texas Research International, Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.

Re: Automatically start MySQLServer on RedHat Linux 7.3

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? T

Re: DateTime Calculations

p://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 -- Cory Hicks <[EMAIL PROTECTED]> TRI-Internat

Re: Query Help

Jeff, Try a JOIN: http://www.mysql.com/doc/en/JOIN.html or for some good articles: http://www.onlamp.com/pub/ct/19 HTH! Cory On Fri, 2002-11-01 at 10:01, jeff wrote: > Hello > > I am having some trouble writing a query that will pull the information I > need from the database. I hope i

Re: date/time calc

Chris, This is how I do it: SELECT UNIX_TIMESTAMP(time_sign_out) -UNIX_TIMESTAMP(time_sign_in)/3600 AS hours HTH! Cory On Wed, 2002-10-30 at 13:50, Raymer, Chris wrote: > Having trouble getting the syntax to calculate the time difference given 2 dates >like so: > > A.) 2002-01-02 21:33:0