ID: 10155
Updated by: kalowsky
Old-Status: Feedback
Status: Closed
Bug Type: ODBC related
Operating system: 
PHP Version: 4.0.4pl1
Assigned To: 

no feedback, considered closed.  if untrue, please reopen the bug.

Previous Comments:

[2001-04-16 23:14:21] [EMAIL PROTECTED]
can you please provide a very simple test case for me?  all local attempts here have 
not yielded the same results as you are seeing.

a sample schema, and script to reproduce this would be very nice.  but please make 
sure it's all in the simplest form...


[2001-04-04 07:02:58] [EMAIL PROTECTED]
The database is  Access 2000 with a few tables and relations set up in the 
relationships area.

Put simply the update, insert and, possibly, delete querys all appear to work 
perfectely with no errors reported, except that the database ends up being unchanged 
afterwards. The only way I have been able to fix this is to query the same table with 
a select before the end of the script, the changes are then implemented.

I have played with autocommit and commit with no effect so I figure it must be a bug 
in either PHP or the ODBC drivers.

Here is one of the scripts with  a totally unecessary select towards the end to make 
it work.

        Site by Just Biz
         + 44 (0)870 841 3040

        Project:        Space Windows
        Routine:        ModifySeries2.php
        Created:        23/03/01
        Descrip:        Modify series number, title and description, update database. 
Also inserts new records.

        Revision:       a
        Rev. Date       23/03/01
        Descrip:        Created.

        Parameters - From ModifySeries.php form

if($SeriesId == "-1") {
        // Create append query
        $Query = "insert into tbl_Series ";
        $Query .= "(SeriesNumber, ShortSeriesTitle, Description) ";
        $Query .= "values('$SeriesNumber', '$ShortSeriesTitle', '$Description')";
else {
        // Create update query
        $Query = "update tbl_Series ";
        $Query .= "set SeriesNumber= '$SeriesNumber', ShortSeriesTitle= 
'$ShortSeriesTitle', ";
        $Query .= "Description= '$Description' where (SeriesId = $SeriesId)";
$Result = odbc_do($Connect, $Query);


<title>Space Windows - Series modified</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<body bgcolor="#FFFFFF">
$Query = "select SeriesId, SeriesNumber, ShortSeriesTitle, Description from 
$Result = odbc_do($Connect, $Query);

while(odbc_fetch_row($Result)) {
if(!$Result) print("<br>Failed");
Print("<h3>Database Updated for Series ".$SeriesNumber."</h3>");
?> <a href="ProductSeries.php">Return to Series Page</a> 


ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to