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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to