Index: openacs-4/packages/ecommerce/www/admin/products/extras-upload-2-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/extras-upload-2-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/www/admin/products/extras-upload-2-oracle.xql	27 Feb 2005 17:07:19 -0000	1.3
+++ openacs-4/packages/ecommerce/www/admin/products/extras-upload-2-oracle.xql	30 Aug 2008 14:29:26 -0000	1.4
@@ -7,15 +7,15 @@
     <querytext>
       update ec_custom_product_field_values
         set last_modified=sysdate, last_modifying_user=:user_id, modified_ip_address=:ip $moresql
-        where product_id = :var_$product_id_column
+        where product_id = :product_id
     </querytext>
   </fullquery>
 
-  <fullquery name="product_update_with_sku">      
+  <fullquery name="product_insert_custom_fields_with_product_id">      
     <querytext>
-      update ec_custom_product_field_values
-        set last_modified=sysdate, last_modifying_user=:user_id, modified_ip_address=:ip $moresql
-        where product_id = (select product_id from ec_products where sku = :var_$sku_column)"
+    insert into ec_custom_product_field_values (last_modified, last_modifying_user, modified_ip_address, product_id
+       ${moresqlinsert_columns} )
+values (sysdate, :user_id, :ip, :product_id $moresqlinsert_values )
     </querytext>
   </fullquery>
   
Index: openacs-4/packages/ecommerce/www/admin/products/extras-upload-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/extras-upload-2-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ecommerce/www/admin/products/extras-upload-2-postgresql.xql	24 Feb 2005 13:33:15 -0000	1.2
+++ openacs-4/packages/ecommerce/www/admin/products/extras-upload-2-postgresql.xql	30 Aug 2008 14:29:26 -0000	1.3
@@ -6,16 +6,17 @@
   <fullquery name="product_update_with_product_id">      
     <querytext>
       update ec_custom_product_field_values
-        set last_modified=now(), last_modifying_user=:user_id, modified_ip_address=:ip $moresql
-        where product_id = :var_$product_id_column
+        set last_modified=now(), last_modifying_user=:user_id, modified_ip_address=:ip $moresqlupdate
+        where product_id = :product_id
     </querytext>
   </fullquery>
 
-  <fullquery name="product_update_with_sku">      
+  <fullquery name="product_insert_custom_fields_with_product_id">      
     <querytext>
-      update ec_custom_product_field_values
-        set last_modified=now(), last_modifying_user=:user_id, modified_ip_address=:ip $moresql
-        where product_id = (select product_id from ec_products where sku = :var_$sku_column)"
+    insert into ec_custom_product_field_values (last_modified, last_modifying_user, modified_ip_address, product_id
+       ${moresqlinsert_columns} )
+values (now(), :user_id, :ip, :product_id $moresqlinsert_values )
+
     </querytext>
   </fullquery>