-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Chris Gomez
Sent: Wednesday, December 15, 2004 10:33 AM
To: [EMAIL PROTECTED]
Subject: CFC help
> 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?
Chris:
Try this:
<cfcomponent hint="my hint" displayname="mechlist">
<cffunction name="HvyList" access="public" returntype="query">
<cfargument name="XEra" default="2" required="no">
<cfargument name="XFaction" default="1" required="yes">
<cfargument name="XVType" default="1" required="no">
<cfargument name="flag" default="1" required="no">
<cfquery name="qget_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>
</cfcomponent>
<cfscript>
if(NOT IsDefined("variables.XFaction")) { variables.XFaction = 1; }
my_obj = CreateObject('component','your_mapping.mechlist');
my_obj.HvyList( XFaction: variables.XFaction, Flag: url.flag, Xera:
url.Xera )
</cfscript>
Warmest Regards,
Phillip B. Holmes
---
[This E-mail has been scanned for viruses.]
----------------------------------------------------------
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
