|Problems? Is your data what you think it is?|
Is there a way to display the statement generated by DBD on execute()by Cody Fendant (Pilgrim)
|on May 05, 2013 at 00:05 UTC||Need Help??|
Cody Fendant has asked for the
wisdom of the Perl Monks concerning the following question:
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$sth->execute($foo,$bar);
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.