Re: [plum] Dependant selects (filetered)

Fri, 11 Mar 2005 16:43:58 -0500 

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

Reply via email to