Hello All, The sql query generated by Transfer which creates bug is :
SELECT NULL as mnul_title, va_menu_1.mnu_mfd_id, NULL as mnul_lng_id, va_menu_1.mnu_timestamp, NULL as mnul_mnu_id, va_menu_1.mnu_id, va_menu_1.mnu_libelle_bo, NULL as mnul_html_content, NULL as mnul_timestamp, '' as transfer_compositeid,NULL as transfer_parentKey, 1 as transfer_orderIndex,'prestation.Menu' as transfer_className,'' as transfer_parentClassName,'' as transfer_parentParentClassName,'' as transfer_parentCompositeName,'false' as transfer_isArray,'' as transfer_compositeName, 'false' as transfer_isProxied FROM va_menu va_menu_1 WHERE va_menu_1.mnu_id = ? AND va_menu_1.mnu_id IS NOT NULL UNION ALL SELECT va_menu_lng_2.mnul_title, NULL as mnu_mfd_id, va_menu_lng_2.mnul_lng_id, NULL as mnu_timestamp, va_menu_lng_2.mnul_mnu_id, NULL as mnu_id, NULL as mnu_libelle_bo, va_menu_lng_2.mnul_html_content, va_menu_lng_2.mnul_timestamp, CAST (va_menu_lng_2.mnul_lng_id as varchar(1000)) + '|' + CAST (va_menu_lng_2.mnul_mnu_id as varchar(1000)) + '|' as transfer_compositeid,CAST(va_menu_1.mnu_id as varchar(1000)) as transfer_parentKey, 2 as transfer_orderIndex,'locale.Menu' as transfer_className,'prestation.Menu' as transfer_parentClassName,'' as transfer_parentParentClassName,'' as transfer_parentCompositeName,'true' as transfer_isArray,'Locales' as transfer_compositeName, 'false' as transfer_isProxied FROM va_menu va_menu_1 INNER JOIN va_menu_lng va_menu_lng_2 ON va_menu_1.mnu_id = va_menu_lng_2.mnul_mnu_id WHERE va_menu_1.mnu_id = ? ORDER BY transfer_orderIndex ASC If anyone has an idea. Best Regards. Julien --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
