SAP SQL Anywhere

Question

In most databases (MSSSQL, Postgre, MySql, etc...) I can use prepared statements with labels instead of "?" question marks. It's even possible to bind more than one parameter without respecting the order of parameters. Example using PHP's PDO:

$dbh = new PDO(' ** connection dsn ** ');
$stmt = $dbh->prepare('SELECT * FROM products WHERE product_status = :statusid AND product_code = :productcode');
$stmt->execute(array(
    ':productcode' => 'ABCDEF',
    ':statusid' => 123,
));

Is there a way to obtain the same behaviour also on SQLAnywhere functions? It would be more confortable using parameters labels instead of question marks '?'.

Answer 1

1

If you are more comfortable using PDO to access data, you could try the SQL Anywhere PDO Driver

permanent link

answered 28 Apr '14, 11:28

Mikel Rychliski
2.1k●16●41
accept rate: 32%

Does this driver manage the parameters by itself internally simulating the DBMS behaviour (sending to the database only the final "valued" query), or does it send the parameters right to the database along with the statement?

(29 Apr '14, 03:19) tzanarella

Replies hidden

The input/output parameters are bound using the sqlany_bind_param method. Statements are executed using the sqlany_execute method. The actual parameters should be sent as host variables separate from the statement.

(29 Apr '14, 12:00) Mikel Rychliski

flat view

SAP SQL Anywhere

PHP functions for prepared statements with labels instead of question marks

Follow this question

Related questions