Hello ALL, I finally get the query generated by TRANSFER ! (filewrite in transfer/ com/sql/QueryExecution.cfc with "ExecuteQuery" method)
When i tried to query my database directly : SAME ERROR... After my research : On SQLSERVER 2005, when you try to update a "text" field over 8000 bytes (and not characters). The query processor can't provide a query plan from the optimizer because a query can't update at the same time a text, ntext, or image and a clustering key. The SOLUTION : DECLARE @Pointer_Value varbinary(16) SELECT @Pointer_Value = TEXTPTR(mnul_content) FROM va_menu_lng WHERE mnul_lng_id = 2.0 AND mnul_mnu_id = 346.0 WRITETEXT va_menu_lng.mnul_content @Pointer_Value 'valueover8000byes' mnul_content = my text field. mnul_menu_lng = my table. ---------------------------------------------------------------------- If your field contains over 8000 bytes you must use 'READTEXT' command to retrieve your data. Have a nice day. Julien On 16 nov, 15:20, dev-sg1 <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
