SQL not executed after redirect

[Kornuun]

Hi!

I am using oracle 9i + OCI + php 5.0

I have written some SQL updates and they are executed properly if i load the page normally.

It is NOT executed if i redirect to this page by an javascript window.open command! - The code IS executed, but no changes are made!

Can anyone give me a hint?

[MikeSnead]

Can we see some code of the problem areas... at least the parts that control that javascript redirect.

[Kornuun]

Hi! OK here is the javascript code - it is executed when the user presses a button:

window.open("http://infocube.gud.siemens.at:81/CCS_Solutions/Solution_maint_onunload.php" + window.location.search, "_blank");

When the page opens the following code is executed (i am using a program to generate the code, so its not php - sorry, but if you want i can post the code that is called, but its really huge)

$NewGrid1->Label1->SetValue("test");

$db = new clsDBOracle();
$SQL = "UPDATE CCS_SOLUTIONS SET EDIT_BY = NULL WHERE NAME = 'Aktuelles Datum'";
$db->query($SQL);
$db->query("COMMIT");
$db->close();

The code IS executed because the "label1" field is set to the "test" string!