diff options
Diffstat (limited to 'server')
-rw-r--r-- | server/xml/macros/B.1.2.xml | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/server/xml/macros/B.1.2.xml b/server/xml/macros/B.1.2.xml index 9c8b3e5..20463e3 100644 --- a/server/xml/macros/B.1.2.xml +++ b/server/xml/macros/B.1.2.xml @@ -33,11 +33,11 @@ ${medicin}</resume> <metawidget name="medicin_list_entry" layout="hbox" format="${prep} x ${dosis}${eye}"> <frame layout="vbox"> <label caption="Præparat:"/> - <dbwidget name="prep" driver="QPSQL" server="sensei.j.auh.dk" user="postgres" database="lms" - select="drugname, dosageform_code, strength_text" - from="lms01" - where="drugname || ' ' || strength_text || ' (' || dosageform_code || ')'" - format="${drugname} ${strength_text} (${dosageform_code})" + <dbwidget name="prep" driver="QPSQL" server="sensei.j.auh.dk" user="lmsread" database="lms" + select="drugname, form, strength" + from="package" + where="drugname || ' ' || strength || ' (' || form || ')'" + format="${drugname} ${strength} (${form})" width="250"/> </frame> |