From 606217e7af6eddbb9381ec71daa5d9c410d3bfd2 Mon Sep 17 00:00:00 2001
From: deva <deva>
Date: Wed, 18 Mar 2009 14:05:49 +0000
Subject: Updated medicine macro to fit new medicine db.

---
 server/xml/macros/B.1.2.xml | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

(limited to 'server')

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>
 
-- 
cgit v1.2.3