what do I do with the cfinvoke and cfinvokeargument? Another consideration, which is getting bigger and bigger with every second, is that there are four interlinked queries on this page.
basically, the existing page has four columns of data. the contents are determined by four variables: XVType, XEra, XFaction and TRO.Weight. The TRO.Weight var is static for each column. The other vars determine what will content will appear. fyi, my website is www.chaosmarch.com. go to the Technical Readout section, then select a faction, equipment type and time period to see the lists. I used a lot of cfif's to get it to keep track of what gets displayed. Chris 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
