Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
icon5.gif   Problems with execute delete, posted by Stefan Kanitz on Tue Dec 23 11:02:26 2008 
    icon2.gif   Re: Problems with execute delete, posted by Stefan Ritt on Tue Dec 23 11:34:25 2008 
       icon2.gif   Re: Problems with execute delete, posted by Stefan Kanitz on Tue Dec 23 12:17:06 2008 
          icon2.gif   Re: Problems with execute delete, posted by Stefan Ritt on Tue Dec 23 12:22:51 2008 
             icon2.gif   Re: Problems with execute delete, posted by Stefan Kanitz on Tue Dec 23 12:31:39 2008 
Message ID: 66125     Entry time: Tue Dec 23 11:02:26 2008     Reply to this: 66126
Icon: Question  Author: Stefan Kanitz  Author Email: skmainz@web.de 
Category: Question  OS: Windows  ELOG Version: 2.7.5-2140 
Subject: Problems with execute delete 

Hi all,

i have problems with execute delete (execute new works fine) in following config (the attribute 'Counter' will not evaluated). Can anybody help me?

 

Here is the config:

 

Attributes = Counter, Autor, Adressat, Start, Ende, Mitteilung, TextBeachten

Show Attributes = Counter, Autor, Adressat, Start, Ende, Mitteilung, TextBeachten
Show Attributes Edit = Counter, Autor, Adressat, Start, Ende, Mitteilung, TextBeachten


Type Start = date
Type Ende = date
Required Attributes =  Autor, Adressat, Start, Ende, Mitteilung
Extendable options = Adressat
Preset Autor = $long_name
Preset Counter = SoMi-#####



Locked Attributes = Autor, Counter
Required Attributes =  Adressat, Start, Ende, Mitteilung

Options Adressat = Alle, 1. Semester, 2. Semester, 3. Semester, 4. Semester, 5. Semester, 6. Semester, 7. Semester, 8. Semester
MOptions Textbeachten = Bitte Mitteilungs-Text anzeigen lassen



Execute new = C:\xampp\mysql\bin\mysql.exe -h localhost -u root -p123456 -D screen -e "insert into somi (counter,adressat,start,ende,kumi,mitlami,lami) values ('$Counter', '$Adressat', '$Start', '$Ende', '$Mitteilung',  '$TextBeachten', '$text')"


Execute delete = C:\xampp\mysql\bin\mysql.exe -h localhost -u root -p123456 -D screen -e "delete from somi where counter='$Counter'"

 

 

 

Thanks in advance and Merry Christmas!!

 

Steve

 

ELOG V3.1.5-fe60aaf