summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authordeva <deva>2009-03-18 14:05:49 +0000
committerdeva <deva>2009-03-18 14:05:49 +0000
commit606217e7af6eddbb9381ec71daa5d9c410d3bfd2 (patch)
tree5da0df308b58e530c772180be0609b9eeda5e801
parentfe56b832d8781db11911b778630d344bcc834145 (diff)
Updated medicine macro to fit new medicine db.
-rw-r--r--server/xml/macros/B.1.2.xml10
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>