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