note 61847 deleted from function.odbc-exec by nlopess
| From: | nlopess@php.net | Date: | Mon, 13 Feb 2006 18:58:41 +0000 |
| Subject: | note 61847 deleted from function.odbc-exec by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-103639@lists.php.net to get a copy of this message | ||
Note Submitter:
----
I got : odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could
not delete from specified tables., SQL state S1000 in SQLExecDirect in
C:\Inetpub\wwwroot\www2\admin\DelBus.php on line 19
code :
$bus_id = $_GET["Bus"];
$link = @odbc_connect("tour", "", "");
if (!$link){
exit("Error" . odbc_error() . " ! - " . odbc_errormsg() . ".");
}
echo $bus_id;
$sqlStr = "delete from tb_bus where id_bus like '$bus_id' " ;
$result = odbc_exec($link,$sqlStr);
and I can't handle this fail.