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 -~----------~----~----~----~------~----~------~--~---
