mpol_ch wrote:
I do not see any unusual records in Debug lines. >
You should, the error clearly said that “You have an error in your SQL syntax”.You should follow enable Debug carefully, enable logging SQL and errors and check the actual error in the log file. Do it slowly and correctly. Post the errors in the log file for discussion.You should also check your SQL (“UPDATE projekte SET Spenden=(SELECT BBetrag from view_ProjektSpenden WHERE JId =”.$rsold[‘Projekt’].“) WHERE JId =”.$rsold[‘Projekt’]) in the Debug panel. For example, if $rsold[‘Projekt’] has no value, it fails.