#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Emneth, UK
    Posts
    49
    Rep Power
    14
    Having updated from version 3.21.33 to 3.23.24, this select statement which used to work now brings no results.

    SELECT dates.date FROM dates LEFT JOIN holiday ON dates.date = holiday.date
    LEFT JOIN workdays ON dayname(dates.date) = workdays.workday WHERE
    workdays.workday IS NOT NULL AND holiday.date IS NULL

    If there's anyone out there who has kept up to date with the change log and can point out the error of my ways, I would be ever so grateful.
    Cheers
    Martin.
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    WHERE
    workdays.workday IS NOT NULL AND holiday.date IS NULL

    should be

    where not isnull(workdays.workday) AND isnull(holiday.date)
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Emneth, UK
    Posts
    49
    Rep Power
    14
    Thanks Rod K for taking the time to reply however the query still brings no results. I can get results if I leave off the "AND isnull(holiday.date)" but it would be nice to do the query in one table.

Similar Threads

  1. Flash in apache - wont work!
    By Fish_12345 in forum Apache Development
    Replies: 2
    Last Post: October 11th, 2004, 01:43 PM
  2. php script won't work inside "cgi-local" directory
    By Volitics in forum PHP Development
    Replies: 5
    Last Post: April 26th, 2004, 10:50 PM
  3. Experienced undergrad senior ... freelance work wanted
    By carrja99 in forum Hire A Programmer
    Replies: 0
    Last Post: January 28th, 2004, 11:32 PM
  4. I'll pay someone $150 to do some PHP work for me!
    By Noah Neiman in forum Hire A Programmer
    Replies: 16
    Last Post: January 23rd, 2004, 03:15 AM
  5. I need some specific php work done for my website
    By Noah Neiman in forum Hire A Programmer
    Replies: 1
    Last Post: January 20th, 2004, 11:31 PM

IMN logo majestic logo threadwatch logo seochat tools logo