I think the <cfargument required> fixed the problem. I tried the <cfscript> block, but couldn't get it to work. I worked around it by adding <cfparam name="XFaction" default="1"> to the .cfm page. It's working fine now. www.chaosmarch.com/test/mechtest.cfm
On Wed, 15 Dec 2004 11:01:45 -0600, Phillip Holmes <[EMAIL PROTECTED]> wrote: > > > -----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 > > ---------------------------------------------------------- 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
