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