Thanks Guys, That makes good sense.
Robert On Oct 22, 1:04 pm, Mark Mandel <[email protected]> wrote: > Transfer uses unions in the sql to keep the number of duplicate rows down. > > If you hit the issue described above, just make the relationship lazy, so > they don't get called all in one query. > > Mark > > On Fri, Oct 22, 2010 at 10:00 PM, Stephen Moretti <[email protected] > > > > > > > > > > > wrote: > > Robert, > > > What happens if you alias the columns? (See the updated pastebin) > > > Stephen > > > On 22 October 2010 11:16, Rawlins <[email protected]> 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-qu... > > >> 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 [email protected] > >> To unsubscribe from this group, send email to > >> [email protected]<transfer-dev%2bunsubscr...@google > >> groups.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-qu... > > > 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 [email protected] > > To unsubscribe from this group, send email to > > [email protected]<transfer-dev%2bunsubscr...@google > > groups.com> > > For more options, visit this group at > >http://groups.google.com/group/transfer-dev?hl=en > > -- > E: [email protected] > T:http://www.twitter.com/neurotic > W:www.compoundtheory.com > > cf.Objective(ANZ) - Nov 18, 19 - Melbourne > Australiahttp://www.cfobjective.com.au > > Hands-on ColdFusion ORM Trainingwww.ColdFusionOrmTraining.com -- 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 [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
