Hi, first time user, long time listener. Came across Par::Packer today and have been testing it to see if we can use it to hide our code in a commercial app. I have read several posts that frown upon this type of use, but that's our aim in any case. We managed to compile a seciprt which uses the depracted Mysql Perl Module, and requires several other scripts, and managed to execute it with some results. The problem we're having is this : When run as a regular script, the following code correctly returns 1 row :

    $VAR{q} = qq~SELECT * FROM table~;
    $VAR{x} = $DBCONN->query($VAR{q});
    $VAR{n} = $VAR{x}->numrows;
[download]

However, as the exe, it always returns 0. What's baffling is that the following code returns 1 record in both versions :

    $VAR{q} = qq~SELECT COUNT(*) FROM table~;
    $VAR{x} = $DBCONN->query($VAR{q});
    $VAR{n} = $VAR{x}->numrows;
[download]

Could it be some sort of Mysql privilege problem? I search high and low in google, and only found one case of a similar problem, but no solution, here :

http://perlguru.com/gforum.cgi?post=44983;guest=
[download]

With any luck, there'll be more potential solutions, than negative comments, provided here. What else could the problem be?

==========================================
Update
==========================================
[download]

Connecting to the wrong database :)