By simply making the numeric a default of 0, it worked -- 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 also updated the following: > > > /fourq/_fourq/deploytype.cfc: > > db.numeric = "[NUMERIC]"; > > > /fourq/_fourq/deployArrayTable.cfc: > > db.numeric = "[NUMERIC]"; > > > with no chnage in the error. > > If I do a debug, I can see the data be followed through the PLP, wbut once I > reach the complete the debug shows all the fields as null. > > > -- > 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:... > > OK, so the following needed to be chnaged to . > > > > I also updated: > > > > > > /fourq/_fourq/deploytype.cfc: > > > > db.numeric = "[NUMERIC]"; > > > > > > /fourq/_fourq/deployArrayTable.cfc: > > > > db.numeric = "[NUMERIC]"; > > > > > > and still no go. > > > > > > -- > > 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 Sammut" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > > > > Will do, Thanks!!! > > > > > > -- > > > 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 > > > "Brendan Sisson" <[EMAIL PROTECTED]> wrote in message > > > news:[EMAIL PROTECTED] > > > > > > > > Michael @Four Eyes wrote: > > > > > 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? > > > > > > > > > > > > This should be numeric, well spotted. You will also need to change > > > > fourq.cfc to reflect this change (I have committed these changes for > > > > next build). You will see conflicts showing up in the types COAPI > > > > screen, but you should be able to "repair type" to change the field > from > > > > INT to Numeric. > > > > > > > > -Brendan > > > > http://farcry.daemon.com.au > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --- 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
