Index: openacs-4/packages/ecommerce/tcl/ecommerce-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-procs-oracle.xql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/ecommerce/tcl/ecommerce-procs-oracle.xql 23 Sep 2002 20:43:26 -0000 1.10
+++ openacs-4/packages/ecommerce/tcl/ecommerce-procs-oracle.xql 28 Aug 2003 09:41:53 -0000 1.11
@@ -40,6 +40,14 @@
+
+
+ select category_id, subcategory_id, subsubcategory_id, product_id
+ from ($common_sql) as dummy
+ where rownum < 2
+
+
+
select decode(sign(sysdate-available_date),1,1,null,1,0) as available_p,