freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Micaele Ereshenco" <mic AT ic.ru>
- To: freetds
- Subject: PHP+FreeBSD+FreeTDS - connection lost.
- Date: Thu, 30 Dec 1999 8:25:15
Hello everybody!
I can't do update my table from php-script. After sending query with
"update ....; commit" or anything distinct from "select", i lost connect to
SyBase server. Example my script:
==================================
$res=sybase_query("select id,CheckOk from mic.web_Links where CheckOk=1")
or die("Error select 1!<br>\n");
$row=sybase_fetch_row($res);
echo "ID=$row[0], CheckOk=$row[1]<br>\n";
sybase_free_result($res);
//sybase_query("update mic.web_Links set CheckOk=0 where id=$row[0]");
//sybase_query("commit");
/*
This is may be anything query. Working only "select". :(
*/
$res=sybase_query("select id,CheckOk from mic.web_Links where CheckOk=1")
or die("Error select 2!<br>\n");
sybase_fetch_row($res);
echo "ID=$row[0], CheckOk=$row[1]<br>\n";
==================================
This script stably returned to me "Error select 2!", if i do "update...".
Update however is executed, i see it from next time, when run this script
again, but i want updating in loop!
FreeBSD 3.2; FreeTDS 0.50; PHP 3.0.12.
Best regards,
Mic.
- PHP+FreeBSD+FreeTDS - connection lost., Micaele Ereshenco, 12/30/1999
Archive powered by MHonArc 2.6.24.