Re: [PHP-DB] PDO and MS Sql Server

2007-07-05 Thread Chris
Bruce Cowin wrote: Thanks for replying. According to the PDO doco: "If the database driver supports it, you may also bind parameters for output as well as input." So maybe this driver doesn't support it? I don't know. I'll try and get the stored proc to return the value, but not sure how I'

Re: [PHP-DB] PDO and MS Sql Server

2007-07-05 Thread Bruce Cowin
Thanks for replying. According to the PDO doco: "If the database driver supports it, you may also bind parameters for output as well as input." So maybe this driver doesn't support it? I don't know. I'll try and get the stored proc to return the value, but not sure how I'll capture that yet.

Re: [PHP-DB] PDO and MS Sql Server

2007-07-05 Thread Chris
Bruce Cowin wrote: I'm using PHP 5.1. The documentation for PDO doesn't list MS Sql server as one of the drivers that support PDO but there is a php_pdo_mssql.dll which seems to work so I'm using that. I need to get the id of a new record just inserted. I can't use lastInsertId() as I get a

[PHP-DB] PDO and MS Sql Server

2007-07-05 Thread Bruce Cowin
I'm using PHP 5.1. The documentation for PDO doesn't list MS Sql server as one of the drivers that support PDO but there is a php_pdo_mssql.dll which seems to work so I'm using that. I need to get the id of a new record just inserted. I can't use lastInsertId() as I get a message saying it's