Robert, What happens if you alias the columns? (See the updated pastebin)
Stephen On 22 October 2010 11:16, Rawlins <rob...@supporttime.com> wrote: > Hello Guys, > > I've stumbled across a problem this morning which is an unusual one. > It MAY be documented or expected behaviour but it caught me out so I > thought I would start conversations off here. > > When I have two objects that have matching column names (http:// > pastebin.com/x272btY7 *note the 'Quantity' column) but these two > columns have different data types, when loading from the database > Transfer throws a SQL error if the data in the child entity column > doesn't match the datatype of the parent entity. > > [Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when > converting the varchar value '1.25' to data type int. > > The quantity column in my Fabric table is a varchar, and contains the > value 1.25. The quantity column in the OrderItem table is int. > > This does not occur when inserting the entity, only when loading it. > > Any ideas? is this normal? or a bug? Sorry for the sketchy > explanation, it was difficult to describe. > > Thanks, > > Robert > > -- > Before posting questions to the group please read: > > http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer > > Try out the new Transfer ORM Custom Google Search: > http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 > > You received this message because you are subscribed to the Google Groups > "transfer-dev" group. > To post to this group, send email to transfer-dev@googlegroups.com > To unsubscribe from this group, send email to > transfer-dev+unsubscr...@googlegroups.com<transfer-dev%2bunsubscr...@googlegroups.com> > For more options, visit this group at > http://groups.google.com/group/transfer-dev?hl=en > -- Stephen Moretti Blog : http://nil.checksite.co.uk/ Twitter : http://twitter.com/mr_nil More Twitter : http://twitter.com/CFOverflow -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer Try out the new Transfer ORM Custom Google Search: http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en