Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

Comment on

( #3333=superdoc: print w/replies, xml ) Need Help??

I'm trying to figure out an SQL problem I'm having and I would like to see what's going on when I do


Because what I think is in there works fine when I do it manually...

The full problem is, I need to find Related Content. Say I have a blog post with id 99. I find one Related story by one method: select from blog where id <> ?. So far so good. But then I need to find another by another method and I don't want to find the same one twice.

So I changed the select to select from blog where id not in(?), that way I can find the first one, then make sure I get a different post for the second one by joining the id of the original post and the first Related post.

So the first time it should do select from blog where id not in(99) then I find Related post 88 and the second time around it should do select from blog where id not in(99,88).

The second run isn't working as expected and I'm getting post 88 again.

In reply to Is there a way to display the statement generated by DBD on execute() by Cody Fendant

Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":

  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?

    What's my password?
    Create A New User
    and all is quiet...

    How do I use this? | Other CB clients
    Other Users?
    Others surveying the Monastery: (3)
    As of 2018-04-23 04:57 GMT
    Find Nodes?
      Voting Booth?