On Tue, Jun 19, 2001 at 10:38:01AM -0700, Alan E. Derhaag wrote:
> "Christian Heiss" <[EMAIL PROTECTED]> writes:
>
> > Hi,
> >
> > I'm using Apache::AuthDBI to verifying the users on my web site.
> > then I put it in the database with:
> >
>----------------------------------------------------------------------------------------------------------------------------------------
> > >my $sql = "INSERT INTO <table name> VALUES($userid, $groupid, $pass, ...);
> > of course, before I'm using the quote funktion ($dbh->quote($userid)...)...
maybe do this instead:
@vars = ($alpha,$bravo,$charlie,$delta);
my $sql = "insert into sometable values(" . (join '.',('?') x @vars) . ")";
$sth = $dbh->prepare($sql);
$sth->execute(@vars);
$sth->finish();
just a suggestion...
--
I figure: if a man's gonna gamble, may as well do it
without plowing. -- Bama Dillert, "Some Came Running"
[EMAIL PROTECTED]
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!