[cfaussie] RE: CFC weirdness

[Janssens, Simon]

Title: Message

not really much to show but here's the call to the cfc

 

<cfinvoke
    component="ITR.cfcs.sites.itrinternet.navigation"
    method="getContent"
    returnvariable="qResult"
   >
    <cfif session.preferences.sortby IS "date">
     <cfinvokeargument name="strOrderBy" value="dateLastReview DESC" />
    </cfif>
    <cfinvokeargument name="strSiteUUID" value="#request.site.objectid#" />
    <cfinvokeargument name="lIndexPageUUIDs" value="#attributes.lobjectids#,#attributes.listdata.objectid#" />        
   </cfinvoke>

 

<cfdump var="#qResult#"> <!--- returns empty query --->

 

 

 

function

   

 

 <!--- Query cached recordset --->
  <cfquery name="qContent" dbtype="query">
   SELECT #arguments.lColumnsToReturn#
   FROM qContentRecordset
   WHERE 1=1
     <!--- filter by index types --->
     <cfloop list="#trim(arguments.lIndexPageUUIDs)#" index="thisIndexPage">
      AND lIndexPages LIKE '%#thisIndexPage#%'
     </cfloop>
     <!--- filter for section content only --->
     <cfif arguments.bSectionContentOnly>
      <cfloop list="#qContentRecordset.columnList#" index="thisColumn">
       <cfif left(thisColumn,1) EQ "L" AND NOT listFindNoCase("LINDEXPAGES,LSECTIONS,LITRDIVISIONS,LDOCUMENTTYPES",thisColumn)>
        and #thisColumn# = ','
       </cfif>
      </cfloop>
     </cfif>
     <!--- filter for cross industry only --->
     <cfif arguments.bCrossIndustryOnly>
      AND lIndustries = ','
     </cfif>
     <!--- filter for program content only --->
     <cfif arguments.bProgramContentOnly>
      AND lProgramsAndServices != ','
     </cfif>
     
   ORDER BY #arguments.strOrderBy#,title ASC
  </cfquery>
  
  <cfreturn qContent>

-----Original Message-----
From: Andrew Scott [mailto:[EMAIL PROTECTED]
Sent: Friday, 23 January 2004 1:25 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: CFC weirdness

Would you like to show us the code...

Regards
Andrew Scott
Technical Consultant

NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: 03 9686 0485  -  Fax: 03 9699 7976  

 

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janssens, Simon
Sent: Friday, 23 January 2004 1:18 PM
To: CFAussie Mailing List
Subject: [cfaussie] CFC weirdness

Has anyone had any problems with a CFC returning a blank result?

 

If I do a dump 1 line before the cfreturn the query i'm returning is fine, but if I do a dump 1 line after the cfinvoke the result query is empty??

 

Can anyone shed some light?

 

Regards,

 

Simon

---
You are currently subscribed to cfaussie 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

**********************************************************************
The information contained in this e-mail, and any attachments to it, is
intended for the use of the addressee and is confidential. If you are not the intended recipient you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in
error, please delete it and notify the sender by return e-mail or telephone.
The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage or other consequences which may arise from opening or using the attachments.
***********************************************************************************
---
You are currently subscribed to cfaussie 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