OK, so basically i went into the dmFile.cfc and changed numeric to string <cfproperty name="fileSize" type="numeric" hint="The size of the file on the webserver (in bytes)" required="no" default="">
to <cfproperty name="fileSize" type="string" hint="The size of the file on the webserver (in bytes)" required="no" default=""> Perhaps this should be brouhgt into the core? -- 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 just noticed with FC v2.2 that when you upload images and files via the > PLP process (say dmHTML) and then try to make a draft object live, you get > the following error. I am still poking around but it lloks like there are > some values floating around in the dmFile that are not making the rest of > the code happy: > > > Exceptions > > 12:38:33.033 - Database Exception - in > C:\_FourEyesWebDev\FarCry\fourq\_fourq\setData.cfm : line 113 > Error Executing Database Query. > > > > Error Executing Database Query. > Invalid data for CFSQLTYPE CF_SQL_FLOAT. > > The error occurred in > C:\_FourEyesWebDev\FarCry\fourq\_fourq\setData.cfm: line 113 > Called from C:\_FourEyesWebDev\FarCry\fourq\fourq.cfc: line 98 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\packages\types\types.cfc: line 125 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\tags\navajo\objectStatus.cfm: line 304 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\tags\navajo\objectStatus.cfm: line 120 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\tags\navajo\objectStatus.cfm: line 118 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\tags\navajo\objectStatus.cfm: line 1 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\admin\navajo\approve.cfm: line 4 > Called from C:\_FourEyesWebDev\FarCry\fourq\_fourq\setData.cfm: line > 113 > Called from C:\_FourEyesWebDev\FarCry\fourq\fourq.cfc: line 98 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\packages\types\types.cfc: line 125 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\tags\navajo\objectStatus.cfm: line 304 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\tags\navajo\objectStatus.cfm: line 120 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\tags\navajo\objectStatus.cfm: line 118 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\tags\navajo\objectStatus.cfm: line 1 > Called from > C:\_FourEyesWebDev\FarCry\farcry_core\admin\navajo\approve.cfm: line 4 > > 111 : </cfif> > 112 : </cfloop> > 113 : WHERE objectID = <cfqueryparam value="#objectID#" > cfsqltype="CF_SQL_VARCHAR"> > 114 : </cfquery> > > > -------------------------------------------------------------------------- > > SQL UPDATE dbo.dmFile SET objectID = (param 1) , fileType = > (param 2) , fileSubType = (param 3) , documentDate = (param 4) , filepath = > (param 5) , fileExt = (param 6) , fileSize = (param 7) , filename = (param > 8) , description = (param 9) , title = (param 10) , createdby = (param 11) , > locked = (param 12) , datetimelastupdated = (param 13) , label = (param 14) > , datetimecreated = (param 15) , lastupdatedby = (param 16) , lockedBy = > (param 17) WHERE objectID = (param 18) > > > > -- > 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] Aussie Macromedia Developers: http://lists.daemon.com.au/
