On Jan 25, 1:17 pm, Kevin <[email protected]> wrote: > Hello, > > I have a many to many relationship in an object that also has several > text fields. This works perfectly on my dev environment, where I have > MSSQL 2005. Unfortunately, on production, which is running MSSQL 2000 > it produces this error when I try to .get(): > > Error Type: Database : HY000 > Error Messages: Error Executing Database Query. > [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. > > Assuming there is nothing I can do about the production database, is > there a way I can fix this? Thanks! > > Using Transfer v1.1
Unfortunately Transfer does some "creative" querying and doesn't just select the columns for that one table in a lot of cases. Try the lazy="true" attribute on the relationship since that changes the query and if I remember right removes the UNION statement Transfer is using to combine the records. I think you might need lazy="true" on all the relationships of the object on the other side of the many to many too. We switched all our text fields to varchar(2000) for this reason. You could also remove the text property from the transfer.xml and manually select and update it with cfquery using a decorator. -- 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
