Index: openacs-4/packages/curriculum-central/www/staff-member-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/staff-member-postgresql.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/curriculum-central/www/staff-member-postgresql.xql	4 Dec 2005 13:08:27 -0000	1.1
+++ openacs-4/packages/curriculum-central/www/staff-member-postgresql.xql	4 Dec 2005 13:21:18 -0000	1.2
@@ -7,7 +7,9 @@
      <querytext>
        SELECT s.title || ' ' || u.first_names || ' ' || u.last_name AS name,
          s.position, s.department_id, d.department_name, s.staff_id,
-	 u.email, u.url, s.address, s.phone, s.fax, s.homepage_url
+	 u.email, u.url, s.address_line_1, s.address_line_2, s.address_suburb,
+         s.address_state, s.address_postcode, s.address_country, s.phone,
+         s.fax, s.homepage_url
        FROM cc_users u, cc_staff s, cc_department d
        WHERE s.staff_id = u.user_id
        AND s.staff_id = :staff_id