what is the column data type? Mark
On Mon, Nov 9, 2009 at 7:39 AM, Clint <[email protected]> wrote: > > 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 > > > -- 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 -~----------~----~----~----~------~----~------~--~---
