[Dbix-class] escaping input

Matt S Trout dbix-class at trout.me.uk
Tue May 15 17:14:01 GMT 2007


On Tue, May 15, 2007 at 10:45:04AM -0400, John Goulah wrote:
> I'm doing something like this:
> 
> 
> my $schools = $c->model('RegistrationDB::University')->search(
> { name => \'LIKE ?' },
> {
> rows => 20,
> select => [qw/name university_id state city zip/],
> order_by => [
  "LOCATE(?,name)",
> "name",
> "state",
> "city"
  ],
  bind => [ "%${query}$", $query ]
> }
> );

Slightly mental. Should work.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director    Want a managed development or deployment platform?
 Shadowcat Systems Ltd.  Contact mst (at) shadowcatsystems.co.uk for a quote
http://chainsawblues.vox.com/             http://www.shadowcatsystems.co.uk/ 



More information about the Dbix-class mailing list