thanks jeff
On Fri, 11 Mar 2005 16:47:18 -0500, Jeff Fleitz <[EMAIL PROTECTED]> wrote: > I meant 'form' not 'forum'. > > Can you tell it's Friday? > > > Jeff Fleitz wrote: > > Hi Tim, > > > > > > The forum is built inside of a table, so you need to place a row/cell > > set inside the tag. > > <cf_DisplayExtraFormContent> > > <tr> > > <td>Label</td> > > <td><cf_TwoSelectsRelated></td> > > </tr> > > </cf_DisplayExtraFormContent> > > > > I would consider running your query outside of the presentation code, > > via a call to the DatabaseBlocks component. It should really be used for > > all your data calls. You can either place it up above the header code, > > or in a separate cfm template and call it via a cfinclude if you want to > > reuse it. > > > > > > <cfscript> > > // Select data > > selectClause = "*"; > > fromClause = "SVR_SUP_MANUFACTURER, SVR_SUP_MODEL"; > > whereClause = "SVR_SUP_MANUFACTURER.MAN_ID = SVR_SUP_MODEL.MAN_ID"; > > qry_manmodel = > > Application.DatabaseBlocks.SelectRecords(selectClause:selectClause, > > fromClause:fromClause, whereClause:whereClause); > > </cfscript> > > > > HTH, > > > > Jeff > > _______________________________ > > > > Jeff Fleitz > > Tekquest, Ltd > > Integrated Digital Solutions > > http://www.tekquest.com > > _______________________________ > > > > > > Tim Blankenship wrote: > > > >> Alright know I have the cf_twoselectsrelated working beutiful but It > >> shows up in the top of my form. How do I get the correct placement. > >> Here is the page as it stands > >> > >> <cf_DisplayAddForm table="SVR_HARDWARE" label="Add a SVR HARDWARE" > >> action="#Application.absoluteUrlRoot#/svr/SVR_HARDWAREAddAction.cfm" > >> displayALinkToThisList="SVR_HARDWAREList.cfm"> > >> <cf_DisplayFilteredSelect parentTable="SVR_GENERAL" primaryKey="SN" > >> primaryKeyType="varchar(100)" foreignKey="SN" displayColumn="SN" > >> displayColumnType="varchar(100)" label="SVR GENERAL" required="Yes"> > >> <cf_DisplayFilteredSelect parentTable="SVR_SUP_SVRTYPE" > >> primaryKey="SVRTYPE_ID" primaryKeyType="varchar(10)" > >> foreignKey="TYPE_ID" displayColumn="TYPE" > >> displayColumnType="varchar(100)" label="SVR SUP SVRTYPE" > >> required="Yes"> > >> <!--- > >> <cf_DisplayFilteredSelect parentTable="SVR_SUP_MANUFACTURER" > >> primaryKey="MAN_ID" primaryKeyType="integer" foreignKey="MAN_ID" > >> displayColumn="MANUFACTURER" displayColumnType="varchar(50)" > >> label="SVR SUP MANUFACTURER" required="Yes"> > >> <cf_DisplayFilteredSelect parentTable="SVR_SUP_MODEL" > >> primaryKey="MOD_ID" primaryKeyType="integer" foreignKey="MOD_ID" > >> displayColumn="MODEL" displayColumnType="varchar(50)" label="SVR SUP > >> MODEL" required="Yes"> > >> ---> > >> <cf_DisplayExtraFormContent> > >> <cfquery name="qry_manmodel" datasource="#Application.dbDSN#"> > >> SELECT * > >> FROM SVR_SUP_MANUFACTURER, SVR_SUP_MODEL > >> WHERE SVR_SUP_MANUFACTURER.MAN_ID = SVR_SUP_MODEL.MAN_ID > >> </cfquery> > >> <CF_TwoSelectsRelated > >> Name1="Manufacturer" > >> Name2="Model" > >> Query="qry_manmodel" > >> Value1="MAN_ID" > >> Value2="MOD_ID" > >> Display1="MANUFACTURER" > >> Display2="MODEL" > >> EmptyText1="(Choose One:)" > >> EmptyText2="(Choose One:)"> > >> </cf_DisplayExtraFormContent> > >> > >> <cf_DisplayTextInput column="PROCESSOR" label="PROCESSOR" > >> type="varchar(100)" required="No" size="40"> > >> <cf_DisplayTextInput column="PROCESSOR_AMT" label="PROCESSOR AMT" > >> type="varchar(10)" required="No" size="10"> > >> <cf_DisplayTextInput column="MEMORY" label="MEMORY" > >> type="varchar(10)" required="No" size="10"> > >> <cf_DisplayTextInput column="NOTES" label="NOTES" > >> type="varchar(4000)" required="No" size="40"> > >> <cf_DisplaySubmitButton buttonText="Save"> > >> </cf_DisplayAddForm> > >> > >> > >> On Fri, 11 Mar 2005 14:33:44 -0500, Jeff Fleitz <[EMAIL PROTECTED]> > >> wrote: > >> > >>> Read up on the tag in the help file, or enter the tag in a script, > >>> right click and go into the tag editor for the tag. > >>> Tag help for it is available there as well. > >>> > >>> It basically allows you to wrap custom code within the context of the > >>> Plum form, so that it only executes once. There > >>> are multiple execution cycles per form, and you only want custom code > >>> to process/display once. > >>> > >>> Jeff > >>> > >>> Tim Blankenship wrote: > >>> > >>>> Could you explain the tag <cf_DisplayExtraFormContent>? > >>>> > >>>> basically just wanted some basics, like do I put my <cfquery> & my > >>>> <cf_TwoSelectsRelated> or each in there own > >>>> <cf_DisplayExtraFormContent>. > >>>> Just not sure where to go on this. > >>>> > >>>> ----form code crap > >>>> <cfquery> > >>>> select some crap from my 2 tables > >>>> where some crap is the same > >>>> </cfquery> > >>>> <cf_DisplayExtraFormContent> > >>>> <cf_TwoSelectsRelated blah blah blah> > >>>> </cf_DisplayExtraFormContent> > >>>> ----form code crap continues > >>>> > >>>> > >>>> > >>>> On Fri, 11 Mar 2005 12:53:04 -0600, Tim Blankenship > >>>> <[EMAIL PROTECTED]> wrote: > >>>> > >>>> > >>>>> I think you sent me one but it was over my head. I am a simple man. Do > >>>>> you have a simple example of this or shall I actually code sometthing > >>>>> myself? > >>>>> > >>>>> > >>>>> On Fri, 11 Mar 2005 12:53:58 -0500, Jeff Fleitz > >>>>> <[EMAIL PROTECTED]> wrote: > >>>>> > >>>>> > >>>>>> Hi Tim, > >>>>>> > >>>>>> Gotta code that yourself, Filtered Selects don't support that > >>>>>> functionality. I actually am tuning an app right now > >>>>>> where I am using Nate Weiss' TwoSelectsRelated tag to do this. > >>>>>> http://projects.nateweiss.com/nwdc/workcode.htm > >>>>>> > >>>>>> You will have to build custom queries to populate them and place > >>>>>> each the tag calls inside a > >>>>>> <cf_DisplayExtraFormContent> tag set. > >>>>>> > >>>>>> Didn't I send you a code sample of this a while back? > >>>>>> > >>>>>> Anyway, this would be a nice ER for v 1.1 The qForms library > >>>>>> support up to 5 levels I think, and since Plum uses that > >>>>>> for validation, it ought to be doable. > >>>>>> > >>>>>> Jeff > >>>>>> > >>>>>> > >>>>>> Tim Blankenship wrote: > >>>>>> > >>>>>> > >>>>>>> Alrighty I have some pretty filtered selects on a page now I want > >>>>>>> more. > >>>>>>> I have a form with 2 filtered selects. > >>>>>>> One filtered select shows parent data, lets call it "PIMPS" with > >>>>>>> values of "ADAM, DAVE, JEFF". > >>>>>>> Second filtered select has "BIOTCHES" with values of "RITA, FLO, > >>>>>>> BETSY, BIRTHA, SHASTA, STANKHO, GARGLE, LOOSEY" > >>>>>>> > >>>>>>> TABLE 1 - WORKORDER > >>>>>>> COLUMN 1 - UID (PK) > >>>>>>> COLUMN 2 - PIMP_ID (FK) > >>>>>>> COLUMN 3 - BIOTCH_ID (FK) > >>>>>>> COLUMN 4 - RATE > >>>>>>> COLUMN ...... > >>>>>>> > >>>>>>> TABLE 2 - PIMPS > >>>>>>> COLUMN 1 - PIMP_ID (PK) > >>>>>>> COLUMN 2 - PIMP > >>>>>>> > >>>>>>> TABLE 3 - BIOTCHES > >>>>>>> COLUMN 1 - BIOTCH_ID (PK) > >>>>>>> COLUMN 2 - BIOTCH > >>>>>>> > >>>>>>> So I want to got to my WORKORDERaddform.cfm page that is built > >>>>>>> off of > >>>>>>> the workorder table. I use the filtered select showing me my pimps, > >>>>>>> for example I choose DAVID. > >>>>>>> When I choose DAVID I want to see only DAVID's BIOTCHES, but > >>>>>>> currently > >>>>>>> I am seeing everyone's biotches. Can the dependant selects be > >>>>>>> accomplished through the PLUM IDE or do I need to code this myself? > >>>>>>> > >>>>>>> Thanks in advance. > >>>>>>> > >>>>>> > >>>>>> ********************************************************************** > >>>>>> > >>>>>> You can subscribe to and unsubscribe from lists, and you can change > >>>>>> your subscriptions between normal and digest modes here: > >>>>>> > >>>>>> http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > >>>>>> > >>>>>> ********************************************************************** > >>>>>> > >>>>>> > >>>>> > >>>>> -- > >>>>> Tim Blankenship > >>>>> [EMAIL PROTECTED] > >>>>> > >>>> > >>>> > >>>> > >>> ********************************************************************** > >>> You can subscribe to and unsubscribe from lists, and you can change > >>> your subscriptions between normal and digest modes here: > >>> > >>> http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > >>> ********************************************************************** > >>> > >> > >> > >> > > > > ********************************************************************** > > You can subscribe to and unsubscribe from lists, and you can change > > your subscriptions between normal and digest modes here: > > > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > > ********************************************************************** > > > > > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > -- Tim Blankenship [EMAIL PROTECTED] ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
