ID: 47803
Comment by: tom dot graham at jadu dot co dot uk
Reported By: egil at wp dot pl
Status: Open
Bug Type: ODBC related
Operating System: Windows XP SP 3
PHP Version: 5.2.9
New Comment:
I have exactly the same problem, two rows inserted fine and the third
row is not inserted and the following error is thrown: "[Microsoft][ODBC
SQL Server Driver]Invalid character value for cast specification".
Previous Comments:
------------------------------------------------------------------------
[2009-03-27 09:10:43] egil at wp dot pl
Description:
------------
I do odbc_prepare and then I would like to be able to execute this
statement with different paramas. This is what it is for, right?
Fortunately not after 2 odbc_execute calls third call gives (mssql 2005
as you may see):
[Microsoft][SQL Native Client]Invalid character value for cast
specification
Reproduce code:
---------------
<?
$sql = "UPDATE category
SET name = ?
WHERE cat_id = ?";
$result = $odbc_prepare($link, $sql);
if (!$result)
{
trigger_error ('[sql] prep: '.$sql, E_USER_ERROR);
}
foreach ($upd_cats as &$k)
{
if(!odbc_execute($result, array($k['name'], $k['id'])))
{
trigger_error ('[sql] exec: '."array({$k['name']}, {$k['id']})",
E_USER_ERROR);
}
}
?>
Expected result:
----------------
successful execution (note that it works fine if I move prepare to
foreach block)
Actual result:
--------------
After third execution I get an error:
[Microsoft][SQL Native Client]Invalid character value for cast
specification
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=47803&edit=1
