note 61847 added to function.odbc-exec

From: 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

« previous php.notes (#103638) next »