Hi,
when I am using render_sql, the java connector creates a wrong sql condition.
This is the connector code sniplet:
FormConnector c = new FormConnector(conn);
// c.enable_log("c:\\temp\\log.txt", false);
// c.event.attach(new ThemaConnectorBehavior());
if(c.is_select_mode()){//code for loading data
c.render_sql("Select AnredeID,Geschlecht,ifnull(Vorname,'') as Vorname,ifnull(Nachname,'') as Nachname,ifnull(Strasse,'') as Strasse,ifnull(PLZ,'') as PLZ,ifnull(Ort,'') as Ort,ifnull(Telefon,'') as Telefon,ifnull(Mobil,'') as Mobil,ifnull(eMail,'') as eMail from Verkuendiger",
"id",
"AnredeID,Geschlecht,Vorname,Nachname,Strasse,PLZ,Ort,Telefon,Mobil,eMail");
} else {
c.render_table("Verkuendiger",
"id",
"AnredeID,Geschlecht,Vorname,Nachname,Strasse,PLZ,Ort,Telefon,Mobil,eMail");
}
here the javascript part
nameAddressDialogForm = nameAddressDialogWindow.attachForm(str);
nameAddressDialogRefreshFormData(nameAddressDialogPersonid);
var nameAddressDialogFormDP = new dataProcessor ("SekNameAddressFormConnector.do?id=" + nameAddressDialogPersonid + "&dummy=" + new Date().getTime());
nameAddressDialogFormDP.init(nameAddressDialogForm);// initializes dataProcessor. As the parameter you should specify your grid
this is the sql command created by the connector:
[code]
SELECT AnredeID,Geschlecht,ifnull(Vorname,‘’) as Vorname,ifnull(Nachname,‘’) as Nachname,ifnull(Strasse,‘’) as Strasse,ifnull(PLZ,‘’) as PLZ,ifnull(Ort,‘’) as Ort,ifnull(Telefon,‘’) as Telefon,ifnull(Mobil,‘’) as Mobil,ifnull(eMail,‘’) as eMail FROM Verkuendiger
WHERE = ‘6388’ AND id = ‘6388’
Why is the fieldname missing at the first condition? Why is a second condition created?
any comments are welcome
kind regards
Robert