Erk :P Basically in SQL2000...looks almost like you won't be able to use text columns..
http://support.microsoft.com/kb/888494 Mark On Thu, Oct 30, 2008 at 9:46 AM, Luis Majano <[EMAIL PROTECTED]> wrote: > > Hi Mark, > I might have found something. Using latest 1.1 using MS SQL 2000. > > The problem I receive is when retrieving a Interface object as you > will see below. The error is a SQL error: > > [Macromedia][SQLServer JDBC Driver][SQLServer]Only text pointers are > allowed in work tables, never text, ntext, or image columns. The query > processor produced a query plan that required a text, ntext, or image > column in a work table. > > Error on line 115 - com\sql\QueryExecution.cfc > > The interfering columns are Description which is a text field and > Inactive Message which is also a text field. If I remove the many to > many relationship, it works. If I remove both text fields, it works. > All together, bombs out. > > This is the transfer.XML Snippet > <object name="Interface" table="Interfaces" > decorator="SearchAdmin.controlpanel.model.search.Interface"> > <id name="InterfaceID" type="UUID" > generate="true"/> > <property name="Name" type="string" /> > <property name="Alias" type="string" > column="alias" /> > <property name="isActive" type="boolean" /> > <property name="FilterPacket" type="string" > nullable="true"/> > <property name="ModifyDate" type="date" > ignore-insert="true" /> > <property name="Description" type="string" > nullable="true" /> > <property name="InactiveMessage" > type="string" nullable="true" /> > <property name="URL" type="string"/> > <!-- Collections --> > <manytomany name="Collections" > table="InterfaceCollections"> > <link to="search.Interface" > column="InterfaceID"/> > <link to="search.Collection" > column="CollectionID"/> > <collection type="array"></collection> > </manytomany> > </object> > <!-- Collections --> > <object name="Collection" table="Collections" > decorator="SearchAdmin.controlpanel.model.search.Collection"> > <id name="CollectionID" type="UUID" > generate="true"/> > <property name="Name" type="string" /> > <property name="Description" type="string" > nullable="true" /> > </object> > > > The SQL produced is the following: > > SELECT NULL as CollectionID, Interfaces_1.URL, > Interfaces_1.InactiveMessage, > Interfaces_1.Description, Interfaces_1.ModifyDate, > Interfaces_1.FilterPacket, > Interfaces_1.isActive, Interfaces_1.alias, Interfaces_1.Name, > Interfaces_1.InterfaceID, NULL as transfer_parentKey, > 1 as transfer_orderIndex,'search.Interface' as transfer_className, > '' as transfer_parentClassName,'' as transfer_parentParentClassName,'' > as transfer_parentCompositeName, > 'false' as transfer_isArray,'' as transfer_compositeName, > 'false' as transfer_isProxied > FROM Interfaces Interfaces_1 > WHERE Interfaces_1.InterfaceID = 'E22A0774-D1F2-0707-7BAD2C54D2D5029B' > AND Interfaces_1.InterfaceID IS NOT NULL > UNION ALL > SELECT Collections_2.CollectionID, NULL as URL, NULL as > InactiveMessage, > Collections_2.Description, NULL as ModifyDate, NULL as FilterPacket, > NULL as isActive, NULL as alias, Collections_2.Name, NULL as > InterfaceID, > CAST(Interfaces_1.InterfaceID as varchar(1000)) as transfer_parentKey, > 2 as transfer_orderIndex,'search.Collection' as transfer_className, > 'search.Interface' as transfer_parentClassName,'' as > transfer_parentParentClassName, > '' as transfer_parentCompositeName,'true' as > transfer_isArray,'Collections' as transfer_compositeName, > 'false' as transfer_isProxied > FROM Interfaces Interfaces_1 > > left INNER JOIN InterfaceCollections InterfaceCollections_2 ON > Interfaces_1.InterfaceID = InterfaceCollections_2.InterfaceID > left INNER JOIN Collections Collections_2 ON > InterfaceCollections_2.CollectionID = Collections_2.CollectionID > > WHERE Interfaces_1.InterfaceID = 'E22A0774-D1F2-0707-7BAD2C54D2D5029B' > AND > Collections_2.CollectionID IS NOT NULL ORDER BY transfer_orderIndex ASC > > > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
