RE: [Reactor For CF] RE: Reactor For CF Numeric datatype problems

[Michael Lantz]

Doug,   I don't know about what is happening when it is written, as I have never written the data using Reactor.   I confirmed that it does work OK for the REAL and FLOAT datatypes, though.   Michael   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: Monday, February 20, 2006 4:02 PM To: reactor@doughughes.net Subject: RE: [Reactor For CF] RE: Reactor For CF Numeric datatype problems That’s weird.  It sounds like the truncation is occurring when the data is read, not written.  That means it’s not a cfqueryparam issue.   I assume that the getMyfieldname() is in a record and getByQuery() is on a gateway?   I’ll test this out when I have time and see what I can do.   Doug   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Lantz Sent: Monday, February 20, 2006 5:55 PM To: reactor@doughughes.net Subject: [Reactor For CF] RE: Reactor For CF Numeric datatype problems   Doug,   This error was from SQL Server 2000. It relates to the DECIMAL datatype only, as far as I can tell...   So, when I tried to get the value out using the .getMyfieldname() syntax, as well as using getbyquery, it was truncated.   Michael   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: Monday, February 20, 2006 3:16 PM To: reactor@doughughes.net Subject: RE: Reactor For CF Numeric datatype problems Michael,   Can you please provide a little more info on this problem?  What SQL server are you using?  What db data type?  In which object type does the value get truncated?    I just need more help with the details.  I can’t spend the time to reverse engineer this bug report.   Doug   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Lantz Sent: Wednesday, February 08, 2006 4:18 PM To: reactor@doughughes.net Subject: Reactor For CF Numeric datatype problems   So, I am working on a project that includes the use of a Decimal datatype.   When I look at the values in SQL Server Management Studio, the values look fine, but when they are inside a Reactor object, the value gets truncated to an integer.   Anyone else experience this?  I haven't had time to look at the xml metadata, but I am guessing it has something to do with how a datatype is setup when it reads in the database schema.   Michael -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/