Index: openacs-4/packages/clickthrough/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/clickthrough/www/index-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/clickthrough/www/index-oracle.xql	4 Jun 2001 03:19:13 -0000	1.1
@@ -0,0 +1,12 @@
+<?xml version="1.0"?>
+<queryset>
+<fullquery name="parent_package_sql">
+	<querytext>
+select sn2.object_id as parent_package_id, 
+                                   site_node.url(sn2.node_id) as parent_package_url
+                              from site_nodes sn1, site_nodes sn2 
+                             where sn1.object_id = :clickthrough_package_id 
+                               and sn1.parent_id = sn2.node_id
+	</querytext>
+</fullquery>
+</queryset>
\ No newline at end of file
Index: openacs-4/packages/clickthrough/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/clickthrough/www/index-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/clickthrough/www/index-postgresql.xql	4 Jun 2001 03:19:13 -0000	1.1
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+<fullquery name="parent_package_sql">
+	<querytext>
+select sn2.object_id as parent_package_id, 
+                                   site_node__url(sn2.node_id) as parent_package_url
+                              from site_nodes sn1, site_nodes sn2 
+                             where sn1.object_id = :clickthrough_package_id 
+                               and sn1.parent_id = sn2.node_id
+	</querytext>
+</fullquery>
+</queryset>
\ No newline at end of file
Index: openacs-4/packages/clickthrough/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/clickthrough/www/index.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/clickthrough/www/index.xql	4 Jun 2001 03:19:13 -0000	1.1
@@ -0,0 +1,12 @@
+<?xml version="1.0"?>
+<queryset>
+<fullquery name="parent_package_sql">
+	<querytext>
+select sn2.object_id as parent_package_id, 
+                                   site_node.url(sn2.node_id) as parent_package_url
+                              from site_nodes sn1, site_nodes sn2 
+                             where sn1.object_id = :clickthrough_package_id 
+                               and sn1.parent_id = sn2.node_id
+	</querytext>
+</fullquery>
+</queryset>
\ No newline at end of file