I'm trying out cfc's for the first time. I can get it to invoke
correctly, but I'm having problems changing the default arguments. It
won't accept any URL vars (besides 1). I tried cfinvokeargument and it
didn't work either. Any ideas?
Thanks,
Chris
Here's the current cfc code:
<cffunction name="HvyList" access="public" returntype="query">
<cfargument name="XEra" default="2">
<cfargument name="XFaction" default="1">
<cfargument name="XVType" default="1">
<cfargument name="flag" default="1">
<cfquery name="HvyList" datasource="touman">
SELECT TRO.Faction, TRO.Name, TRO.Class, TRO.VType AS XVType,
TRO.Weight, TRO.APrev as Prev, TRO.ANext as Next, TRO.UnitID,
Mass.TMass as uMass, TRO.TMass, TRO.Faction AS XFaction, TRO.Era AS
XEra, TRO.Votes AS AVotes
FROM Era INNER JOIN (Faction INNER JOIN (Weight INNER JOIN (VType
INNER JOIN (Mass INNER JOIN (Class INNER JOIN TRO ON Class.ClassID =
TRO.Class) ON Mass.MassID = TRO.TMass) ON VType.VTID = TRO.VType) ON
Weight.ID = TRO.Weight) ON Faction.FactionID = TRO.Faction) ON
Era.EraID = TRO.Era
WHERE <cfif (flag is 1) AND (XVType is 1)>
(TRO.Era = #Arguments.XEra#) AND
</cfif>
(((TRO.Faction)=#Arguments.XFaction#) AND
((TRO.VType)=#Arguments.XVType#) AND ((TRO.Weight)=3))
ORDER BY TRO.TMass, TRO.Name;
</cfquery>
<cfreturn HvyList>
</cffunction>
test page code:
<cfparam name="XFaction" default="1">
<cfinvoke component="mechlist" method="HvyList"
returnvariable="MechQuery"><cfinvokeargument name="XFaction"
value="#XFaction#"></cfinvoke>
----------------------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
