What does the SQL debug say for the values going into the Database? Mark
On Fri, Jul 24, 2009 at 3:04 AM, whostheJBoss <[email protected]>wrote: > > squeek! No ideas on this? > > On Jul 16, 10:17 pm, whostheJBoss <[email protected]> wrote: > > <object name="user" table="users" > > decorator="components.decorators.users"> > > <id name="userID" type="numeric" /> > > <property name="customID" type="numeric" > column="customID" > > nullable="true" /> > > <property name="note" type="string" column="note" > nullable="true" / > > > > </object> > > > > My decorator has: > > > > <cfproperty name="customID" type="numeric" default="" /> > > > > On Jul 16, 2:27 pm, Mark Mandel <[email protected]> wrote: > > > > > ..what is your config for you this object? > > > > > Mark > > > > > On Thu, Jul 16, 2009 at 10:48 PM, whostheJBoss > > > <[email protected]>wrote: > > > > > > I am doing the following: > > > > > > user = instance.Transfer.new("users.user"); > > > > user.setCustomID(rc.customID); > > > > user.setNote(rc.customID); > > > > > > The value of rc.customID is 1474075992 > > > > > > When I check my database, the note field, VARCHAR(45), is shown > > > > correctly as: 1474075992 > > > > > > But the customID field which is BIGINT(20) is shown as: 1474076030 > > > > > > Any idea what is going on here? I am inserting the same value into > > > > both. > > > > > > I've tried INT and BIGINT. > > > > > > When I check user.getCustomID() the value is correct as: 1474075992 > > > > > > What would be the proper type for my database field for this? I need > > > > numeric, not VARCHAR. > > > > > > I am using MySQL 5 with an innoDB table. > > > > > > Thanks! > > > > > -- > > > 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 -~----------~----~----~----~------~----~------~--~---
