Thank you very much,
i am really very sorry for bothering you.
It was my fault not putting the <Form> tag..
I have got it right.
Thanks a lot for your patience.
Please tell me if you have used
"CF_Threeselectsrelated".
I was trying this and I wanted all the 3 to be
dropdown list.The example there on the site
"http://nateweiss.com/taggallery/" is of Radio buttons
and 2 dropdown list .As I said I want all the 3 to be
drop down list.
Can you please help me.
Thanks a lot.
Shally
++++++++++++++++++++++++++++++++++++++++++++++++++++++
--- James Taavon <[EMAIL PROTECTED]> wrote:
> This is a multi-part message in MIME format.
> --------------4A576A0EB0C5055670C186FA
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> um, i dont see the opening form tag? can you cut and
> paste the entire
> file as you have it please?
>
> monika kon wrote:
> >
> > 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"
>
=== 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
