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.cfm http://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 -~----------~----~----~----~------~----~------~--~---
