Hey forum,
I found a bug in the SQL of scriptcase. I have made a multiple forms application in which users can change the images of a cultivar.
Unfortunately scriptcase posts a comma in the SQL statement after SET.
The following statement gets produced
(pdo-mysql): UPDATE cultivar SET , cultivarImage = 0xffd8ff(part of the binary) WHERE cultivar = ‘Test’ and Sortering = ‘1’ and Fustcode = 1010
Part of the scriptcase code with the mistake:
if ($SC_ex_upd_or)
4068| {
4069| if (in_array(strtolower($this->Ini->nm_tpbanco), $this->Ini->nm_bases_ibase))
4070| {
4071| $comando_oracle .= “, cultivarImage = ‘’”;
4072| }
4073| elseif (in_array(strtolower($this->Ini->nm_tpbanco), $this->Ini->nm_bases_informix))
4074| {
4075| $comando_oracle .= “, cultivarImage = null”;
4076| }
4077| else
4078| {
4079| $comando_oracle .= “, cultivarImage = empty_blob()”;
4080| }
4081| }