John Deighan wrote:
>
> In the code below, you can probably see what I'm trying to do - execute an
> object method within a "HERE document".
1. You can't call methods within HERE docuemnts, but you can use
variables.
2. fetchrow_array is a statement handle method, not a database handle
method - I guess you meant selectrow_array?
3. use placeholders to do what you want to do.
my $db = DBI->connect("DBI:ODBC:dsn", $name, $pwd);
my $CustomerName = 'wilma\'s';
my $sql = 'select SchoolSystemName from SchoolSystems
where CustomerName = ?';
my $name = $db->selectrow_array($sql, undef, $CustomerName);
--
Simon Oliver
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
