[farcry-dev] Re: data type numeric

[Michael @Four Eyes]

Well I updated the code  and there seems to be an issue with PLP's.  Any time I try to do approve content, save, etc with a data type of numeric I get the following.  Is there any where I should be adjusting the code?     [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type nvarchar to numeric.     Exceptions 16:58:09.009 - Database Exception - in C:\_WebDev\FarCry\fourq\_fourq\setData.cfm : line 174 Error Executing Database Query.   -- Regards, Michael J. Sammut ________________________________________________ F O U R  E Y E S  P R O D U C T I O N S   think | plan | create :: web site design & development :: NYC   E. [EMAIL PROTECTED] | T: 718.254.9557 ext. 101 | F: 718.254.0399   W. http://www.foureyes.com "Michael @Four Eyes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... I noticed in the alterType.cfc, that setting a cfproperty to numeric yields an INT      //numeric    db.type = 'int';    db.length = 4;    stPropTypes['numeric'] = duplicate(db);     However, I see no reference for creating a numeric type?   Adding:        //numeric    db.type = 'numeric';    db.length = 4;    stPropTypes['number'] = duplicate(db);     had some really weird results on the system.  I need to setup a type that is numeric so I can so some calcs in SQL.  Any thoughts?     -- Regards, Michael J. Sammut ________________________________________________ F O U R  E Y E S  P R O D U C T I O N S   think | plan | create :: web site design & development :: NYC   E. [EMAIL PROTECTED] | T: 718.254.9557 ext. 101 | F: 718.254.0399   W. http://www.foureyes.com --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004