Nope, it only shows up the one time. :\
The odd thing is that I also have a note field in the database table
for users (the table I'm inserting into) and if I set the value of the
notes field, which is VARCHAR, the value goes in correctly for that
field but incorrectly for the customID field.
user = instance.Transfer.new("users.user");
user.setCustomID(1474075992);
user.setNote(1474075992);
instance.Transfer.save(user);
In this case, the note value comes through correctly and the customID
value is wrong.
Nothing else happens after this save. So, when saving it puts in one
value fine and the other incorrectly. If I use the query directly
instead of Transfer, the insert works as expected.
On Jul 31, 11:23 am, Jennifer Larkin <[email protected]> wrote:
> That sounds like maybe the value is getting saved to the database by a
> second function. Does the inserted value show up elsewhere in the
> debug?
>
> On Fri, Jul 31, 2009 at 10:49 AM,
>
>
>
>
>
> whostheJBoss<[email protected]> wrote:
>
> > Ok, so some odd behavior...
>
> > When doing the insert via Transfer the debug shows:
>
> > Source C:\Program Files (x86)\Apache Software Foundation\Tomcat
> > 6.0\sites\foo\ROOT\transfer\com\sql\QueryExecution.cfc
> > Execution Time 0
> > Recordcount 0
> > Query INSERT INTO users(email,password,accountType,customID,hash)
> > VALUES ( '' , '' , 0 , 1474075991 , '' )
>
> > But the value in the database shows up as: 1474076030
>
> > If I copy and paste the query exactly and run it without Transfer like
> > this:
>
> > <cfquery datasource="foo" name="add">
> > INSERT INTO users(email,password,accountType,customID,hash) VALUES
> > ( '' , '' , 0 , 1474075992 , '' )
> > </cfquery>
>
> > The value is inserted correctly and the debug shows:
>
> > Source C:\Program Files (x86)\Apache Software Foundation\Tomcat
> > 6.0\sites\foo\ROOT\playground\insert.cfm
> > Execution Time 0
> > Recordcount 0
> > Query INSERT INTO users(email,password,accountType,customID,hash)
> > VALUES ( '' , '' , 0 , 1474075992 , '' )
>
> > So when inserting with Transfer the value gets inserted incorrectly,
> > but running the EXACT same query without Transfer inserts it fine.
>
> > Any thoughts???
>
> > On Jul 23, 1:17 pm, Mark Mandel <[email protected]> wrote:
> >> 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
>
> --
> "Nothing says mother's love like a giant robotic platypus butt!"
> Phineas and Ferb
>
> Now
> blogging....http://www.blivit.org/blog/index.cfmhttp://www.blivit.org/mr_urc/index.cfm
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
