Index: openacs-4/contrib/packages/events/www/admin/event-edit-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/www/admin/Attic/event-edit-oracle.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/contrib/packages/events/www/admin/event-edit-oracle.xql	9 Mar 2003 12:08:22 -0000	1.1
+++ openacs-4/contrib/packages/events/www/admin/event-edit-oracle.xql	18 Mar 2003 01:47:48 -0000	1.2
@@ -15,6 +15,25 @@
 	</querytext>
 </fullquery>
 
+<fullquery name="product_update">
+	<querytext>
+	update ec_products
+	set product_name='$activity_info(name) $date_time',
+	sku='event_$event_id',
+	one_line_description='$activity_info(name); $date_time; $pretty_location',
+	detailed_description='$activity_info(description)',
+	email_on_purchase_list=:email,
+	search_keywords='$activity_info(name), $venue_info(venue_name), $pretty_location',
+	url='$activity_info(detail_url)',
+	price=:event_price,
+	no_shipping_avail_p='t',
+	present_p='$event_info(available_p)',
+	available_date=sysdate,
+	$audit_update
+	where product_id=:product_id
+	</querytext>
+</fullquery>
+
 <fullquery name="audit_update_sql">
 	<querytext>
 	last_modified=sysdate, last_modifying_user=:user_id, modified_ip_address=:peeraddr
@@ -61,4 +80,4 @@
       </querytext>
 </fullquery>
 
-</queryset>
\ No newline at end of file
+</queryset>