List Info

Thread: note 61847 added to function.odbc-exec




note 61847 added to function.odbc-exec
user name
2006-02-13 18:55:03
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 -- h
ttp://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 -- htt
p://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.p
hp.net/manage/user-notes.php?action=delete+61847&report=
yes&reason=useless
Delete: non-english         -- http://mast
er.php.net/manage/user-notes.php?action=delete+61847&rep
ort=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://ma
ster.php.net/manage/user-notes.php

-- 
PHP Notes Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub
.php

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )