My site got it's Sybase 'auto_commit' disabled, I mean, if I type a (INSERT, UPDATE, DELETE) query on ISQL's console I got the correct result, but the same doesn't happen when I run the query via PHP. Check the code below:
<? //includes with database connection and stuff $xSql= "INSERT INTO oab_mailing_logs (nvaNomeMailing, nvaInicioEnvio, nvaFimEnvio, dtDataEnvio, numTamanhoMailing, intLidos) VALUES ('teste', '0', '0', '2003-01-01', 0, 0)"; $xQuery = sybase_query($xSql); if($xQuery) //sybase_query returns me nothing. $xQuery is not tested on the 'if' clause, it just pass through both 'if' and 'else'. { "OK!<br>"; } else { "Erro!<br>"; } //sybase_query("commit"); //if I uncomment 'sybase_query("commit")' I got what I want, I mean, the INSERT is done correctly, but note that I hadn't to do this before, it's just stop running as it used to //echo "xQuery-> ".$xQuery."<br>"; //it outputs '1' echo "Executando a query: <b>".$xSql."</b><br>"; echo "Linhas afetadas: ".sybase_affected_rows($xQuery); //there's not output here... it's kinda empty sybase_free_result($xQuery); ?> I haven't got any kind of error message, even on Sybase errorlog. Can you help me ? Thanks and the best regards ---------------------------------------------------------------------------- -- Nilo Desenvolvedor WEB A B I L I T Y Soluçőes interativas +55 21 38526657 www.ability.com.br -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php