On 7/31/05, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> problem is that the variables in the config are not being translated into
> there actual values before they get used.
So you have a plaintext config file with variable names in it that you
want perl to interpolate at some point once the config data is loaded.
> my $sth = $dbh->prepare(qq{$QUERY});
> #print "DEBUG: $QUERY\n";
What does this debug print give you?
> query= <<END
> SELECT N.IP_ADDRESS,
[snip]
> AND CAA.ADDRESS_ID = AD.ADDRESS_ID
> AND P.NODE_ADDRESS = $dslam
> AND N.IP_ADDRESS = $ip_address
> END
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
