in reply to DBI Efficiency

What about
$sth = $dbh->prepare("select ? from databasename");
$sth->execute( age );

For your password question:
I have no idea what a MUD is ( Yes, I live under a rock ),
but assuming that it uses a telnet interface you can just
not echo the password back to the user ( if local echoing
is on for them its inevitable that the pw will be seen)

-bl0rf

Replies are listed 'Best First'.
Re: Re: DBI Efficiency
by mpeppler (Vicar) on Jan 17, 2003 at 01:33 UTC
    Be very careful with 
    $dbh->prepare("select ? from ...");

    [download]
    While this may work with MySQL, it is completely non-standard. Placeholders should not be used to pass column or table names to the query - only to pass column values that will affect the query.

    Michael

[reply]
[d/l]

In Section Seekers of Perl Wisdom