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/
