Join the Pain!
Friday, November 28th, 2008Wenns mal wieder länger dauert – weil irgendjemand die Datenbankanbindung so geregelt hat…
public override List GetAllServicesByLang(string lang)
{
string query = "SELECT sc.fk_order_type_id, s.fk_service_category_id, s.id, s.nr, t.name, t.text, a.factor, a.amount, u.name AS unit, labo_sample_text.code, s.price, d.fk_parent_service_id";
query += " FROM labo_service_text t ";
query += " LEFT JOIN labo_service s ON t.fk_service_id = [...]
