my $u = "jsmith";
my $p = "password('$u')";
my $user = $users_rs->single({ username => $u, pass => \"$p" });



results into this error:


SELECT me.id, me.username, me.pass, me.first_name, me.last_name FROM users me WHERE ( ( pass password('jsmith') AND username = ? ) ): 'jsmith'
DBI Exception: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'password('jsmith') AND username = 'jsmith' ) )' at line 1 [for Statement "SELECT me.id, me.username, me.pass, me.first_name, me.last_name FROM users me WHERE ( ( pass password('jsmith') AND username = ? ) )" with ParamValues: 0='jsmith'] at /Library/Perl/5.8.8/DBIx/Class/Schema.pm line 1027