Row_Rendered

PHPMaker General Discussion (PHPMaker)
1

This is my row_rendered event, apparently no update is done from the UITSLAGT and UITSLAGU fields.
Maybe another event so that these fields are stored in my MySQL database ?function Row_Rendered() {
$this->UITSLAGT->EditValue=$this->US1T->CurrentValue;
$this->UITSLAGU->EditValue=$this->US1U->CurrentValue;$varut=$this->UITSLAGT->EditValue;
$varuu=$this->UITSLAGU->EditValue;
$varnr=$this->NR->CurrentValue;
Execute(‘UPDATE formwed SET UITSLAGT=“$varut”,UITSLAGU=“$varuu” WHERE NR=“$varnr”’);thx

2

Show the SQL to verify if it is valid. For example:$sql = “UPDATE … SET … WHERE …”;
//***die($sql); // Show the SQL for debugging
Execute($sql);

3
  1. You would normally update the DB during the Row_Updating / Row_Updated / Row_Inserting / Row_Inserted events, so consider your logic carefully.2) Your SQL statement is not valid - token replacement only works in double-quoted strings so you need to use:Execute("UPDATE formwed SET UITSLAGT=‘$varut’,UITSLAGU=‘$varuu’ WHERE NR=‘$varnr’ ");