I am sending the code again,
CODE:
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
</head>
<cfquery name="getresult"
datasource="Catalog"
dbtype="ODBC">
SELECT Distinct MnGrp, MnGrp_Desc, ProductType,
ProductType_Desc
FROM globalkeys_FLAT
</cfquery>
<body bgcolor="#FFFFFF">
<CF_TwoSelectsRelated
QUERY="getresult"
NAME1="select1"
NAME2="Select2"
DISPLAY1="Mngrp_desc"
DISPLAY2="Producttype_Desc"
value1="mngrp"
value2="producttype"
FORCEWIDTH1="70"
FORCEWIDTH2="70"
SIZE1="1"
SIZE2="1"
HTMLBETWEEN="<BR>"
AUTOSELECTFIRST="Yes"
EMPTYTEXT1="(choose a category)"
EMPTYTEXT2="(now choose a subcategory)"
ONCHANGE="Submit!"
FORMNAME="MyOtherForm">
</form>
</body>
</html>
I AM UNABLE TO UNDERSTAND WHICH CFFORM YOU ARE TALKING
ABOUT ,THANKS FOR YOUR REPLY AND PATIENCE
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
--- James Taavon <[EMAIL PROTECTED]> wrote:
> This is a multi-part message in MIME format.
> --------------7E483AE1B1188D700B230AAD
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> what does your CFFORM tag look like?
>
> monika kon wrote:
> >
> > Hi James,
> >
> > I am able to see only the First dropdown list with
> > unique MnGrp_Desc.The second dropdown list is
> showing
> > up nothing even if I select any thing from the
> first
> > drop down list.
> > Did you see the database I have sen in the
> previous
> > mail?
> > Shally
> > --- James Taavon <[EMAIL PROTECTED]> wrote:
> > > This is a multi-part message in MIME format.
> > > --------------79EE260D231C723574DB0849
> > > Content-Type: text/plain; charset=us-ascii
> > > Content-Transfer-Encoding: 7bit
> > >
> > > What exactly are youe seeing? How is the list
> > > different from your
> > > database?
> > >
> > > monika kon wrote:
> > > >
> > > > --0-2049339050-973275290=:67150
> > > > Content-Type: text/plain; charset=us-ascii
> > > > Content-Disposition: inline
> > > >
> > > > Hi James and Vaughan Evans!
> > > > Thanks a lot for ur reply.
> > > > I am now stuck in the query.Please help me.I
> am
> > > > sending the code as well as the database in
> excel
> > > as
> > > > an attachment.I have placed
> TwoSelectsRelated.cfm
> > > in
> > > > the folder CFUSION.But my query is not giving
> me
> > > the
> > > > proper values.
> > > >
> > >
> >
>
++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > > <CFQUERY NAME="getresult" datasource="global">
> > > > select MnGrp,
> > > > MnGrp_Desc,ProductType,ProductType_Desc,
> > > > from Global
> > > > where MnGrp=Left([ProductType],1)
> > > > </CFQUERY>
> > > >
> > > >
> > > > Calling Cusstom Tag below (I have mine in a
> > > table)
> > > > <tr valign="top">
> > > > <td><font face="arial"
> > > > size="2"><b>Name:<br><br><br>Email:</b></td>
> > > > <td>
> > > > <CF_TwoSelectsRelated
> > > > query="GetResult"
> > > > name1="Select1"
> > > > name2="selet2"
> > > > display1="MnGrp_Desc"
> > > > display2="ProductType_Desc"
> > > > size1="1"
> > > > size2="1"
> > > > HtmlBetwwen="<BR>"
> > > > AutoSelectFirst="Yes"
> > > > EmptyText1="(choose a category)"
> > > > EmptyText2="(now choose a
> subcategory)"
> > > > Onchange="Submit!"
> > > > Formname="MyOtherForm"></font></td>
> > > >
> > > > </tr>
> > > >
> > >
> >
>
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > > --- James Taavon <[EMAIL PROTECTED]>
> wrote:
> > > > > This is a multi-part message in MIME format.
> > > > > --------------E6147946B6907CB6F06EC99E
> > > > > Content-Type: text/plain; charset=us-ascii
> > > > > Content-Transfer-Encoding: 7bit
> > > > >
> > > > > You place the Tag in your Custom Tag folder
> > > under
> > > > > CFUSION and then call
> > > > > the tag from your cfm file.
> > > > >
> > > > >
> > > > > My QUERY:
> > > > >
> > > > > <CFQUERY NAME="GetPerson"
> datasource="OIMDBADM">
> > > > > select name, address
> > > > > from oimdbadm.assignee
> > > > > where manager = 'Hub'
> > > > > </CFQUERY>
> > > > >
> > > > >
> > > > > Calling Cusstom Tag below (I have mine in a
> > > table)
> > > > > <tr valign="top">
> > > > > <td><font face="arial"
> > > > > size="2"><b>Name:<br><br><br>Email:</b></td>
> > > > > <td>
> > > > > <CF_TwoSelectsRelated
> > > > > query="GetPerson"
> > > > > name1="assigned"
> > > > > name2="address"
> > > > > display1="name"
> > > > > display2="address"
> > > > > htmlbetween="<p>"
> > > > > size1="1"
> > > > > size2="1"></font></td>
> > > > > <td align="right"><font face="arial"
> > > > > size="2"><b>Date:</b></td>
> > > > > <td><font face="arial"
> > > > >
> > >
> size="2"><cfoutput>#DateFormat(getassignment.date,
> > > > > "mm/dd/yyyy")#</cfoutput></td>
> > > > > </tr>
> > > > > <tr>
> > > > >
> > > > >
> > > > > monika kon wrote:
> > > > > >
> > > > > > Thanks a lot for considering my problem.
> > > > > > I found <CF_ThreeSelectsRelated> on the
> site
> > > > > > http://nateweiss.com/taggallery/
> > > > > > but one more question where do I run the
> > > query.I
> > > > > went
> > > > > > through the CF program but no where
> CFQUERY
> > > has
> > > > > been
> > > > > > run.Please explain..
> > > > > >
> > > > > > --- James Taavon
> <[EMAIL PROTECTED]>
> > > wrote:
> > > > > > > This is a multi-part message in MIME
> format.
> > > > > > > --------------79B146EDDC6C8F75FF1B27F5
> > > > > > > Content-Type: text/plain;
> charset=us-ascii
> > > > > > > Content-Transfer-Encoding: 7bit
> > > > > > >
> > > > > > > You can find the custom tag at
> > > > > > >
> > > > > > >
> > > > > > > monika kon wrote:
> > > > > > > >
> > > > > > > > Please tell me where I can find this
> > > custom
> > > > > tag.
> > > > > > > > Secondly how am I suppose to use Java
> > > script
> > > > > ,as I
> > > > > > > > don't know much of it.
> > > > > > > > If I use onchange() of javascript ,I
> will
> > > have
> > > > > to
> > > > > > > call
> > > > > > > > javascript coe in it.
> > > > > > > > Please help..
> > > > > > > > --- Vaughan Evans
> > > <[EMAIL PROTECTED]>
> > > > > > > wrote:
> > > > > > > > >
> > > > > > > > > There is a custom tag called
> > > > > twoSelectsRelated
> > > > > > > that
> > > > > > > > > may be of help.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >Hi every one,
> > > > > > > > > >I have 2 drop down lists ,the first
> one
> > > has
> > > > > > > options
> > > > > > > > > >which are hard coded.
> > > > > > > > > >When the user selects one of these
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one Place.
http://shopping.yahoo.com/
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
