Hi,
I remember I had the same problem before, by change the SQL statement to
"Select distinct....." the problem was gone.
I don't know if your problem is the same, but give it a try won't hurt.
Hope it will help.
Sima
----- Original Message -----
From: W Luke <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 8:17 AM
Subject: Re: Populating more than one Select
> OK. I have a "Main Categoies" table (categories) and a "Sub Categories"
> table (sub_categories). 'categories' has columns of ID and cat_name and
> 'sub_categories' has columns of sub_name, cat_id, sub_id - cat_id is in
> place to link to the ID in 'categories'.
>
> I'm unsure of the query needed, and of what to put in VALUE1 and VALUE2.
At
> the moment, the first box is being populated fine, but the 2nd displays
> *all* records in 'sub_categories'. Below is the code - any help of advice
> is appreciated.
>
> Will
>
> <cfquery name="findcats" datasource="localads">
> SELECT ID, cat_id, cat_name, sub_name FROM categories, sub_categories
> ORDER by cat_name
> </cfquery>
>
>
> <CF_TwoSelectsRelated
> QUERY="findcats"
> NAME1="Cat"
> NAME2="Selected"
> DISPLAY1="cat_name"
> DISPLAY2="sub_name"
> VALUE1="cat_id"
> VALUE2="sub_name"
> 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">
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, September 14, 2000 2:06 PM
> Subject: RE: Populating more than one Select
>
>
> > As long as it's a fairly short bit of code, post away.
> >
> > -----Original Message-----
> > From: W Luke [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, September 14, 2000 8:56 AM
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: Re: Populating more than one Select
> >
> >
> > Thanks. I've tried it out - unfortunately it's populating the same in
the
> > 2nd box every time. Have you set this up before and/or would you mind
me
> > pasting my code here?
> >
> > Cheers,
> >
> > Will
> > ----- Original Message -----
> > From: <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, September 14, 2000 1:19 PM
> > Subject: RE: Populating more than one Select
> >
> >
> > > You would want
> > >
> >
>
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347197-2830-11D4-AA
> > > 9700508B94F380&method=Full
> > >
> > > -----Original Message-----
> > > From: W Luke [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, September 14, 2000 8:08 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: Populating more than one Select
> > >
> > >
> > > Hi,
> > >
> > > One one of my pages I have a Select which is dynamically populated
using
> > > some simple SQL. What I
> > > now need to do is dynamically populate another Select, based on the
> > > selection of the first Select Box. I don't want to load the page
twice.
> > >
> > > Is this possible? I hope I've made my question clear..
> > >
> > > Thanks,
> > >
> > > Will
> > >
> > >
> > >
> >
>
> --------------------------------------------------------------------------
> > --
> > > --
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > >
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > > the body.
> >
>
> --------------------------------------------------------------------------
> > ----
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> > >
> >
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
