I got it it right James with the 3 drop down lists. Thanks +++++++++++++++++++++++++++++++++++== --- James Taavon <[EMAIL PROTECTED]> wrote: > This is a multi-part message in MIME format. > --------------49B842EC9410C3D199900F0E > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > No, I have not used the Three Selects Related, but > it should work on the > same principle as Two Selects Related. > > monika kon wrote: > > > > 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)" > === 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]
