Thanks a lot Gabriel. I will follow your advices.
As soon as I will get good query. Julien On 16 nov, 15:15, dev-sg1 <[email protected]> wrote: > Sorry, i'm stupid that's the query generated when i'm getting my > data.... > > On 16 nov, 15:12, Dorioo <[email protected]> wrote: > > > I still think there's value in taking that query, replacing the question > > marks with their respective values, and running it directly against the > > database. If it fails, you keep removing parts of the input data until it > > works. Once it works, you can add parts back until you zero in on the data > > that is causing it to fail. > > > Additionally, I would simplify the problem for testing by creating a new > > table with one column for the input you posted, hook it up with transfer, > > and see if it still fails. If it doesn't fail, I'd then work backwards by > > slowly adding properties and relationships between my test tables until they > > match real tables and relationships and it fails. > > > Debugging likes this will take time but it should lead you to the cause of > > the problem. > > > - Gabriel > > > On Mon, Nov 16, 2009 at 8:38 AM, dev-sg1 <[email protected]> wrote: > > > > 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 -~----------~----~----~----~------~----~------~--~---
