SitePoint Sponsor

User Tag List

Page 3 of 3 FirstFirst 123
Results 51 to 57 of 57
  1. #51
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,250
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Forbes View Post
    The query returned with an error:
    you don't want to use that query anyway
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  2. #52
    It's been real... Forbes's Avatar
    Join Date
    Dec 2004
    Location
    Yorkshire, England
    Posts
    676
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    you don't want to use that query anyway
    What do I need to do next?

    Breaking each of the queries down and testing them makes sense.

  3. #53
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,250
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    that's right, take each of the subqueries, run them separately, with an EXPLAIN on them
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #54
    It's been real... Forbes's Avatar
    Join Date
    Dec 2004
    Location
    Yorkshire, England
    Posts
    676
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    that's right, take each of the subqueries, run them separately, with an EXPLAIN on them
    OK, I'm onto to it!

    I shall return...

  5. #55
    It's been real... Forbes's Avatar
    Join Date
    Dec 2004
    Location
    Yorkshire, England
    Posts
    676
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OK, I've absolutely no idea what's going on here with EXPLAIN.

    I've had a look around, trying to understand, but it's so beyond me, I don't even know where to begin.

    Right now, I don't even know what I don't understand, which is troubling.

    There's just far too much to learn and I simply don't have the time to commit to this project, when client work is more pressing.

    I can't expect people to just do all of this for me, so I think the best thing to do is call the whole thing off, and then come back to this, perhaps, at some later date.

    Guys, thanks for your time! Always appreciated.

  6. #56
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,250
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    call the whole thing off?? when you were so close??

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  7. #57
    It's been real... Forbes's Avatar
    Join Date
    Dec 2004
    Location
    Yorkshire, England
    Posts
    676
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    call the whole thing off?? when you were so close??

    Yeah, but you're doing all of the work, which just isn't right.

    If I could take the advice and run with that, that would be fine. But I have no idea what I'm doing!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •