If it helps here is the other report window of the same problem.
The only thing I changed in the code it's the path to the component. But don't worry, this is not the problem, cause it's set properly and the code is exactly the same as already posted.
Here's my code again just to be sure...
CODE
<component>
<cffunction name="MakeBreadCrumb" access="public" returntype="array">
<cfargument name="id" type="numeric" required="yes" default=0 >
<cfargument name="cnt" type="numeric" required="yes" default=0 >
<cfargument name="dataSource" type="any" required="yes">
<cfargument name="dataTable" type="any" required="yes">
<!--- we make a new array which will hold all the parents (parentid values), but we declare it only the
first time in the recursive call --->
<cfif arguments.cnt IS 0>
<cfset breadCrumbArray=ArrayNew(1)>
</cfif>
<!--- selecting the current parentid --->
<cfquery name="qryItem" datasource="#arguments.dataSource#">
SELECT parentid
FROM #arguments.dataTable#
WHERE id = #arguments.id#
</cfquery>
<!--- saving the current parentid to the array --->
<cfset breadCrumbArray[#arguments.cnt#]=arguments.id>
<cfif qryItem.parentid IS NOT 0> <!--- if we reached the root level of the navigation --->
<!--- HERE WE MAKE THE RECURSIVE CALL of "MakeBreadCrumb" function - the input argument
becomes the current <parentid> from the <qryItem> query --->
<cfset MakeBreadCrumb(id = qryItem.parentid, cnt = arguments.cnt + 1) >
<cfelse> <!--- if we still haven't reached the root level --->
<!--- we reverse the breadCrumb array so we can "follow the bread crumbs" from start to the end
in the correct order --->
<!--- here is where we use the above written "reverseArray" function --->
<cfset reversedBreadCrumbArray = reverseArray(inputArray = breadCrumbArray)>
</cfif>
<cfreturn reversedBreadCrumbArray>
</cffunction>
</component>
CODE
<cfset databaseSource = "test"> <!--- defining the datasource (database name) --->
<cfset sourceTable = "testnavigation"> <!--- defining the table we will be getting the data from --->
<cfinvoke
component="cfdocs.GlobeKrasCMS.cfcomponents.navigation"
method="MakeBreadCrumb"
returnvariable="MakeBreadCrumbRet">
<cfinvokeargument name="id" value="#URL.item#"/>
<cfinvokeargument name="cnt" value="1"/>
<cfinvokeargument name="dataSource" value="#databaseSource#"/>
<cfinvokeargument name="dataTable" value="#sourceTable#"/>
</cfinvoke>
The funny thing is that it accepts the first two arguments I am passing in the exact way as the last two, but somehow it doesn't recognize the last two I need for the database. Very very odd. It must be some stupid error I am doing. It always is in cases like this.
I just cannot see it.
I guess I found out where the problem was. I wasn't reading the error report well enough.
Let me try to add some more arguments in the line 67.
This post has been edited by ComboAlex: 12 Aug, 2009 - 08:05 AM
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
| 
