Is it a case of it coming out of the database in Scientific notation, b/c it is so large?
How does it work usually with normal CFML Queries and Query Params? Mark On Tue, Mar 3, 2009 at 10:36 AM, Chris Woerz <[email protected]> wrote: > > I completely agree with you about the nightmare that this will be :P > > the data_type in the database(oracle) is NUMBER(22,0) > and in the transfer def is <id name="id" type="numeric" column="id" > generate="true"/> > > most of the time it works fine, but every once in a while it gets > converted to scientific notation. which is fine if it happens in a > <form> because i can javacast() it on the page but for transfer there > is no workaround that i could find. > > as much as i would love to slash and burn we have 30 years of historic > data in there so not much i can do about the keys. > > > On Mar 2, 3:54 pm, Brian Kotek <[email protected]> wrote: >> Is this a string field or a numeric field? It sounds like the type defined >> in the Transfer config is not the correct type? >> >> Aside from that, I'm having a hard time understanding why anyone would use a >> value like this as a primary key. If two records are created at the same >> time, what happens? One just throws an error? If you have control of the >> schema, can you change it to an autoincrementing id or at least a UUID? This >> sounds like it's going to turn into a nightmare later. >> >> On Mon, Mar 2, 2009 at 5:20 PM, Chris Woerz <[email protected]> wrote: >> >> > I have a table with a primary key that based on the datetime at record >> > creation (ie 20090226114107) recently when i invoke save() i get an >> > error because the primary key that transfer tries to insert is >> > '2.0090226114107E13'. is there anyway to resolve this? im pretty new >> > to transfer and i inherited an app that im not sure was setup >> > correctly. > > > -- E: [email protected] 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 -~----------~----~----~----~------~----~------~--~---
