[Erp5-report] r9139 - /erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/

[nobody at svn.erp5.org]

Author: chris
Date: Thu Aug 10 17:58:33 2006
New Revision: 9139

URL: http://svn.erp5.org?rev=9139&view=rev
Log:
- fixed SQL search in OOo import

Modified:
    erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/ERP5Site_getCategoriesFullPath.xml

Modified: erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/ERP5Site_getCategoriesFullPath.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/ERP5Site_getCategoriesFullPath.xml?rev=9139&r1=9138&r2=9139&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/ERP5Site_getCategoriesFullPath.xml (original)
+++ erp5/trunk/bt5/erp5_base/SkinTemplateItem/portal_skins/erp5_base/ERP5Site_getCategoriesFullPath.xml Thu Aug 10 17:58:33 2006
@@ -88,13 +88,12 @@
 for category_name in category_dict.keys():\n
   subcat_code = category_dict[category_name]\n
   category_object = context.getPortalObject().portal_categories[category_name]\n
-  result_list = context.portal_catalog(portal_type=\'Category\', reference=str(subcat_code), relative_url=category_name+\'%\')\n
+  result_list = context.portal_catalog(portal_type=\'Category\', reference=\'=\'+str(subcat_code), relative_url=category_name+\'%\')\n
   if len(result_list) != 0:\n
     result_cat_fullpath = \'/\'.join(result_list[0].getRelativeUrl().split(\'/\')[1:])\n
     result_dict[category_name]=result_cat_fullpath\n
   else:\n
-    # XXX: this request does a LIKE "%xxxx%", We should find a way to remove the %%\n
-    result_list = context.portal_catalog(portal_type=\'Category\', title=str(subcat_code), relative_url=category_name+\'%\')\n
+    result_list = context.portal_catalog(portal_type=\'Category\', title=\'=\'+str(subcat_code), relative_url=category_name+\'%\')\n
     if len(result_list) != 0:\n
       result_cat_fullpath = \'/\'.join(result_list[0].getRelativeUrl().split(\'/\')[1:])\n
       result_dict[category_name]=result_cat_fullpath\n