How to use DB functions while doing a create?

[prev] [thread] [next] [Date index for 2005/01/11]

Dear list,

MySQL provides a function called "password" to store passwords encrypted
in the DB. I was wondering how I could use that while using Class::DBI
and its create method.

Here's what I do now:
my $dbh =3D MyClass->db_Main();
$dbh->do( "INSERT INTO users VALUES ( $id, $name, password( '$pwd' ) "
);

Is there a way to better integrate this with Class::DBI?

Thanks,
Daniel.