sql - How can I call a function in another CFC file from within a query of a function in one cfc file? -

-

i have 1 cfc file (info.cfc) multiple functions shown below.

<cfcomponent output="true" extends="datefunctions">     <cffunction name="getstatuses" access="remote" returntype="any" output="true" returnformat="plain">        ...     </cffunction>      <cffunction name="viewdate" access="remote" returntype="any" output="true" returnformat="plain">         <cfquery  name="records">               select                  dbo.tickets.incident,                  dbo.tickets.start_date,                  dbo.tickets.days_due                                dbo.tickets             </cfquery>     </cffunction> </component>

and other cfc file (datefunctions.cfc) containing function 2 arguments , returning date. datefunctions.cfc file follows:

<cfcomponent output="true" name="datefunctions"">     <cffunction name="addbusinessdays" access="remote" returntype="any" output="true" returnformat="plain">        <cfargument name="daystoadd"                  required="yes"                  type="numeric"                  hint="the number of whole business days add or subtract given date">         <cfargument name="date"                  required="no"                  type="date"                  hint="the date object start counting from.."                  default="#nowdatetime#">           ...          ... <!--- perform tasks --->           <cfreturn date>     </cffunction> </cfcomponent>

question: how can invoke "addbusinessdays" within query in (info.cfc) producing column of results.

i thought might have been able like:

<cffunction name="viewdate" access="remote" returntype="any" output="true" returnformat="plain">     <cfquery  name="records">           select              dbo.tickets.incident,              dbo.tickets.start_date,              dbo.tickets.days_due,              (                <cfinvoke component="datefunctions" method="addbusinessdays" returnvariable="date">                   <cfinvokeargument name="daystoadd" value="#dbo.tickets.days_due#">                   <cfinvokeargument name="date" value="#dbo.tickets.start_date#">                </cfinvoke>              ) due_date                        dbo.tickets         </cfquery> </cffunction>

you following caveat of there additional processing loop.

edit: per discussion below, updated cfoutput cfloop 

 <cffunction name="viewdate" access="remote" returntype="any" output="true" returnformat="plain">     <cfquery  name="records">           select              dbo.tickets.incident,              dbo.tickets.start_date,              dbo.tickets.days_due,              '' due_date                        dbo.tickets         </cfquery>      <cfset df = createobject("component","datefunctions")>      <cfloop query="records">         <cfset records.due_date = df.addbusinessdays(days_due, start_date)>     </cfloop>     <cfreturn records> </cffunction>

Comments

Post a Comment

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array( ...
Read more

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub ...
Read more

Using django-mptt to get only the categories that have items -

-
sample structure: all uppercase: category mixed case: item root ├── books │   ├── fiction │   │   └── classics │   └── non-fiction ├── clothing └── electronics ├── laptops ├── phones │   ├── apple │   │   ├── iphone 6 │   │   ├── iphone 6 plus │   │   ├── iphone 6s │   │   └── iphone 6s plus │   ├── motorola │   │   ├── moto g4 │   │   ├── moto g4 play │   │   ├── moto g4 plus │   │   └── moto x │   └── samsung └── tablets └── apple i'm trying have index page show "electronics" category. "clothing" category shouldn't show since it's empty , "books" category shouldn't show either since, although has child categories, child categories don't have items. similarly, "electronics" page should show "phones" category. "laptops" category shouldn't show since it's empty , "tablets" category shouldn't show either since...
Read more