Beefy Boxes and Bandwidth Generously Provided by pair Networks Cowboy Neal with Hat
Perl Monk, Perl Meditation
 
PerlMonks  

Re^3: Encoding issue from DBI to string

by ev0lution (Initiate)
on Jan 07, 2013 at 20:09 UTC ( #1012103=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Encoding issue from DBI to string
in thread Encoding issue from DBI to string

Well, I found the problem and almost have a solution worked out.

It appears there's some issues between the version of ActivePerl being implemented on the NFS that we use and data being pulled from the DB. When I made a separate Perl script to pull from the DB and ran it using a fresh Perl install, things worked fine.

Unfortunately, a lot of other things are dependent on the version of Perl on the NFS. Not a huge issue, just going to leave the DB work in a separate Perl script and call it from a different version of Perl.

That being said, running into a small problem with passing arguments from the initial Perl script to the now separated one. Code below:

Initial Perl:

system('/usr/bin/perl /home/SQLtoXML.pl $source_id $OutputXMLDir');
Perl script that is being called:
my $PassedSource = $ARGV[0]; my $FinalDir = $ARGV[1];

Unfortunately, $PassedSource and $FinalDir are both ending up as null when the program runs. Am I just passing the 2 arguments incorrectly?

Thanks again for all the help. You've been wonderful.


Comment on Re^3: Encoding issue from DBI to string
Select or Download Code
Re^4: Encoding issue from DBI to string
by choroba (Abbot) on Jan 07, 2013 at 20:20 UTC
    Single quotes do not interpolate variables.
    لսႽ† ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ
      D'oh. It's been a long day, thanks. Haha all is working fine now. Appreciated.
Re^4: Encoding issue from DBI to string
by karlgoethebier (Deacon) on Jan 07, 2013 at 21:02 UTC

    Thank you ev0lution for the feedback. It's nice to hear that you worked it out.

    I hope that the hint from choroba helped to fix the last remaining issue.

    Best regards, Karl

    «The Crux of the Biscuit is the Apostrophe»

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1012103]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (5)
As of 2014-04-20 04:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (485 votes), past polls