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
> **********************************************************************
>
--
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
**********************************************************************
