|Just another Perl shrine|
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.