I should also add that each column is built around its own query. The only difference between them is the value of TRO.Weight. If anyone wants to see the existing website code, let me know, but I gotta warn ya it's uuugly and confusing (which is why I'm trying to streamline it with cfc's).
On Wed, 15 Dec 2004 11:46:33 -0600, Chris Gomez <[EMAIL PROTECTED]> wrote: > 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
