It's confiugred as follows: <property name="shFormat" type="numeric" column="shFormat" ignore- insert="true" ignore-update="true" />
We're on SQL Server 2005. Also, the issue isn't just this one column. If I change the type to string, Railo/Transfer doesn't freak out and the implicit conversion will happen when SQL Server executes the query- but that relies on specific database behavior. Other columns in the same TO will have these same casting issues and will require changed configuration, making me think that there's a bigger issue at stake here than just a couple of data types on an isolated column. On Nov 8, 2:31 pm, Mark Mandel <[email protected]> wrote: > How is shFormat configured, and what is its database type? > > What database are you on? > > Mark > > > > > > On Mon, Nov 9, 2009 at 7:30 AM, Clint <[email protected]> wrote: > > > Full stacktrace (stripped path leader): > > > /webroot/com/worshiphousemedia/model/data/transfer/Products.Product > > $7DE02DF48635A93F7F656E8C6518F84E.transfer (1373) > > /webroot/com/worshiphousemedia/model/data/transfer/Products.Product > > $7DE02DF48635A93F7F656E8C6518F84E.transfer (1304) > > /webroot/com/worshiphousemedia/model/data/transfer/ > > [email protected] (937) > > /webroot/transfer/com/dynamic/TransferPopulator.cfc (59) > > /webroot/transfer/com/dynamic/DynamicManager.cfc (72) > > /webroot/transfer/com/Transfer.cfc (120) > > > On Nov 8, 2:26 pm, Mark Mandel <[email protected]> wrote: > > > What's the full tag stack? > > > > Mark > > > > On Mon, Nov 9, 2009 at 7:24 AM, Clint <[email protected]> wrote: > > > > > I'm having issues with a simple transfer load by PK operation as > > > > follows: > > > > > <cfset freeProduct.product = beans.transfer.get("Products.Product", > > > > freeProduct.id) /> > > > > > The freeProduct.id is a member of a struct with the primary key of the > > > > Products.Product TO that we want to load. When Transfer tries to load > > > > this object we get an Expression exception with the following message: > > > > > invalid call of the function setshFormat (/Users/clintmiller/Downloads/ > > > > railo-3.1.1.000-railo-express-macosx/webroot/com/worshiphousemedia/ > > > > model/data/transfer/Products.Product > > > > $7DE02DF48635A93F7F656E8C6518F84E.transfer), first Argument (shFormat) > > > > is of invalid type, can't cast String [] to a value of type [numeric] > > > > > Now that message seems to indicate it's a simple type mismatch- but if > > > > you think you can solve that by wrapping the freeProduct.id in a call > > > > to the VAL() function, you'd be wrong. (freeProduct.id is truly a > > > > string value, but Adobe's CF engine does an implicit conversion here > > > > and this code works fine). Is this an issue with Railo (compatibility > > > > difference with Adobe?) or an issue with Transfer on Railo? > > > > > Thanks, > > > > > Clint > > > > -- > > > E: [email protected] > > > T:http://www.twitter.com/neurotic > > > W:www.compoundtheory.com > > -- > E: [email protected] > T:http://www.twitter.com/neurotic > 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 -~----------~----~----~----~------~----~------~--~---
