Index: openacs-4/packages/ecommerce/www/admin/products/edit-3.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/edit-3.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/products/edit-3.tcl	20 Apr 2001 20:51:14 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/products/edit-3.tcl	20 Jul 2001 06:00:11 -0000	1.2
@@ -55,10 +55,12 @@
 # we have to generate audit information
 # First, write as insert
 set audit_fields "last_modified, last_modifying_user, modified_ip_address"
-set audit_info "sysdate, :user_id, :peeraddr"
+# set audit_info "sysdate, :user_id, :peeraddr"
+set audit_info [db_map audit_info_sql]
 
 # Or otherwise write as update
-set audit_update "last_modified=sysdate, last_modifying_user=:user_id, modified_ip_address=:peeraddr"
+#set audit_update "last_modified=sysdate, last_modifying_user=:user_id, modified_ip_address=:peeraddr"
+set audit_update [db_map audit_update_sql]
 
 db_transaction {
 
Index: openacs-4/packages/ecommerce/www/admin/products/edit.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/edit.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/products/edit.tcl	20 Apr 2001 20:51:14 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/products/edit.tcl	20 Jul 2001 06:00:11 -0000	1.2
@@ -32,7 +32,18 @@
 "
 set multiple_retailers_p [util_memoize {ad_parameter -package_id [ec_id] MultipleRetailersPerProductP ecommerce} [ec_cache_refresh]]
 
-db_1row product_select "select * from ec_products where product_id=:product_id"
+db_1row product_select "
+select product_id, sku, product_name, 
+to_char(creation_date, 'YYYY-MM-DD') as creation_date, one_line_description, 
+detailed_description, search_keywords, price, no_shipping_avail_p, shipping, 
+shipping_additional, weight, dirname, present_p, active_p, 
+to_char(available_date, 'YYYY-MM-DD') as available_date, announcements, 
+to_char(announcements_expire, 'YYYY-MM-DD') as announcements_expire, url, 
+template_id, stock_status, color_list, size_list, style_list, 
+email_on_purchase_list, to_char(last_modified, 'YYYY-MM-DD') as last_modified, 
+last_modifying_user, modified_ip_address
+from ec_products where product_id=:product_id
+"
 
 doc_body_append "<form enctype=multipart/form-data method=post action=edit-2>
 [export_form_vars product_id]
Index: openacs-4/packages/ecommerce/www/admin/products/edit.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/edit.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/products/edit.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/products/edit.xql	20 Jul 2001 06:00:11 -0000	1.2
@@ -3,7 +3,7 @@
 
 <fullquery name="product_select">      
       <querytext>
-      select * from ec_products where product_id=:product_id
+select product_id, sku, product_name,                                           to_char(creation_date, 'YYYY-MM-DD') as creation_date, one_line_description,    detailed_description, search_keywords, price, no_shipping_avail_p, shipping,    shipping_additional, weight, dirname, present_p, active_p,                      to_char(available_date, 'YYYY-MM-DD') as available_date, announcements,         to_char(announcements_expire, 'YYYY-MM-DD') as announcements_expire, url,       template_id, stock_status, color_list, size_list, style_list,                   email_on_purchase_list, to_char(last_modified, 'YYYY-MM-DD') as last_modified,  last_modifying_user, modified_ip_address                                        from ec_products where product_id=:product_id
       </querytext>
 </fullquery>