On Jan 26, 10:04 am, Elliott Sprehn <[email protected]> wrote: > 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.
Also make sure you don't order the relationship collection by the text properties. SQL Server 2000 can't do an order by on a text column. -- 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
