Hello,
I have a strange problem while using mssql server driver:
when i update/insert in/delete a table and want to redirect after, i have
the following error message:
CGI Error
The specified CGI application misbehaved by not returning a complete set of
HTTP headers. The headers it did return are:
The strange thing is that if i do a select or use mysql driver (with select,
insert, delete or update) i have no problem. Also if i update a none
existant row (ie usId = -1) there is no problem.
Here is a sample code that produce the error :
<?php
$conn = mssql_connect($server, $user, $password);
mssql_select_db($db);
$result = mssql_query("UPDATE Users SET usFirstName = 'Guillaume' WHERE usId
= 20");
mssql_close();
header("Location: $redirect");
exit();
?>
When i call this page, the database is updated and my browser goes to the
$redirect page but displays the aboved error message instead of the page.
System infos:
os : windows 2k server sp3
web: iis 5.0
php: 4.3.2
db : sql server 2000 entreprise sp2
Anyone knows the cause of this problem and/or how to resolve it ?
Thanks,
Guillaume