runtime how many fields? How can I put the (?,?,?)
into a variable and have it recognised as placeholders?
Thanks,
Tim Bowden
-bind_param($i, $pass_type_id, SQL_VARCHAR); $i++;
$sth-bind_param($i, $device_id, SQL_VARCHAR); $i++;
$sth-execute;
On Oct 22, 2012, at 9:16 AM, Tim Bowden tim.bow...@mapforge.com.au wrote:
Is it possible, and if so, how can I set the number of placeholders in a
prepared statement
On Tue, 2009-10-20 at 11:00 +0200, Peter J. Holzer wrote:
On 2009-10-20 15:54:30 +0800, Tim Bowden wrote:
On Tue, 2009-10-20 at 18:07 +1100, Ron Savage wrote:
Hi Folks
[for those who don't know the sqlplus (or dbish) spool command: It's
similar to the Unix tee(1) command: It copies all
the two ?'s in the 'POINT(? ?)' argument to the
ST_GeomFromText function are not being identified as placeholders.
Any suggestions as to how I should approach this?
Thanks,
Tim Bowden
On Wed, 2009-06-17 at 11:23 +0100, Tim Bunce wrote:
On Wed, Jun 17, 2009 at 04:13:35PM +0800, Tim Bowden wrote:
my $sth = $dbh-prepare(INSERT INTO mygeom (description, mypoint)
VALUES (?, ST_GeomFromText('POINT(? ?)', ?)));
$sth-bind_param(1, $_);
$sth-bind_param(2, $coord