note 61847 added to function.odbc-exec
| From: | php-general at lists dot php dot net | Date: | Mon, 13 Feb 2006 18:55:03 +0000 |
| Subject: | note 61847 added to function.odbc-exec | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-103638@lists.php.net to get a copy of this message | ||
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.
----
Server IP: 203.121.145.116
Probable Submitter: 58.10.133.18
----
Manual Page -- http://www.php.net/manual/en/function.odbc-exec.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+61847
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+61847&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+61847&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+61847&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+61847&report=yes&reason=useless
Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+61847&report=yes&reason=non-english
Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+61847&report=yes&reason=already+in+docs
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+61847&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+61847&report=yes
Search -- http://master.php.net/manage/user-notes.php