Index: openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql,v
diff -u -r1.9.2.1 -r1.9.2.2
--- openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql	12 Dec 2002 01:32:48 -0000	1.9.2.1
+++ openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql	12 Dec 2002 22:02:01 -0000	1.9.2.2
@@ -167,4 +167,27 @@
 </querytext>
 </fullquery>
 
+
+<fullquery name="sp_get_page_id.page_and_package_ids">
+<querytext>
+select sp.static_page_id, f.package_id
+from static_pages sp, sp_folders f
+where sp.filename = :filename
+and sp.folder_id = f.folder_id
+-- Only want pages from the Static Pages package.
+and f.package_id in (
+  select package_id  from apm_packages
+  where package_key = :package_key )
+-- If the same page is in more than one instance of
+-- Static Pages for some reason, we only want one of
+-- them, and we don't care which.
+-- Oracle
+and rownum <= 1
+-- PostgreSQL
+--limit 1
+</querytext>
+</fullquery>
+
+
+
 </queryset>