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
> options
> > > from
> > > > > the
> > > > > > > >first dropdown list then the second
> > > dropdown
> > > > > list
> > > > > > > >gets populated from the database
> > > accordingly.I
> > > > > want
> > > > > > > >this to happen in the same template.
> > > > > > > >Please help>
> > > > > > > >
> > > > > > > >Shally
> > > > > > > >
> > > > > > >
> > > > >
> > >
> >__________________________________________________
> > > > > > > >Do You Yahoo!?
> > > > > > > >Yahoo! Messenger - Talk while you surf!
> > > It's
> > > > > FREE.
> > > > > > > >http://im.yahoo.com/
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
>---------------------------------------------------------------------------
> > > > > > > ---------------------
> > > > > > > >Archives:
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
http://www.mail-archive.com/[email protected]/
> > > > > > > >Unsubscribe:
> > > > > > >
>
=== 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]
