agora inbox for pgsql-interfaces@postgresql.org  

help / color / mirror / Atom feed

From: Greg Sabino Mullane <greg@turnstep.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: DBD::Pg - question on using LIKE operator with bind variable
Date: Tue,  5 Jul 2011 14:31:51 -0000
Message-ID: <d7e283d0e41eef8e2dd5981b5850b627@biglumber.com> (raw)
In-Reply-To: <55377.71.167.232.56.1309786189.squirrel@webmail.brama.com>


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> I would like to use a bind variable with a LIKE operator.
>
> An example of the query that I'm trying to use is the following:
> SELECT ? , aa.f1, aa.f2, aa.f3, aa.f4 FROM orgs aa WHERE aa.f1 LIKE '%?%'
> How do I get the conditional part of the query (WHERE aa.f1 LIKE '%?%') to
> accept a bind variable?

(What did you try? What did you get?)

It's not clear why you have a question mark in the SELECT clause, but 
you can solve the WHERE clause part by making the placeholder cover 
the entire condition, rather than try to pass in only part of it 
via the arguments. So try this instead:

$SQL = 'SELECT relname FROM pg_class WHERE relname LIKE ?';
$sth = $dbh->prepare($SQL);
$count = $sth->execute('%a%');
print "Count is $count\n";

- -- 
Greg Sabino Mullane greg@turnstep.com
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201107051030
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk4TIEIACgkQvJuQZxSWSsgLCQCgtD6CdcTr8mpKeoBzYtaKtPjH
tfgAnA68obgfGN5dcORG4rZfqvejjkkC
=QZaM
-----END PGP SIGNATURE-----

view thread (2+ messages)

Message-ID: <d7e283d0e41eef8e2dd5981b5850b627@biglumber.com>
Permalink:  ../d7e283d0e41eef8e2dd5981b5850b627@biglumber.com/
Also on:    postgresql.org/message-id/d7e283d0e41eef8e2dd5981b5850b627@biglumber.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: greg@turnstep.com
  Subject: Re: DBD::Pg - question on using LIKE operator with bind variable
  In-Reply-To: <d7e283d0e41eef8e2dd5981b5850b627@biglumber.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox