Update:
I swapped a few things round, and have got it working somehow. Yet, for
some unknown reason, when I choose something from the second list and click
submit it's not submitting what I asked it to. I clicked on "Reading," and
it submitted "Windsor." Why's that happening!?
Thanks
Will
----- Original Message -----
From: "W Luke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 03, 2000 3:59 PM
Subject: TwoSelectsRelated question
> Hi,
>
> I've used TwoSelectsRelated tag before - but for some reason can't get it
> working on another section of my site. I have a table, locations, with
> "County" and "Town" - I've populated one of the select with counties, but
> the second isn't being populated. I think it's probably due to my query,
> not having a "where" in it - but I don't understand how I *can* put in a
> "where" statement, nor why I'd need one. Should I create another table
with
> all the counties in it, and link that to the existing table? If anyone can
> work out what I need to, it'd be greatly appreciated (code shown below),
>
> Thanks
>
> Will
>
> <cfquery name="findcats" datasource="localads">
> SELECT county,town FROM Locations
> ORDER by county
> </cfquery>
>
> <CF_TwoSelectsRelated
> QUERY="findcats"
> NAME1="thecounty"
> NAME2="thetown"
> DISPLAY1="county"
> DISPLAY2="town"
> VALUE1="county"
> VALUE2="town"
> FORCEWIDTH1="70"
> FORCEWIDTH2="70"
> SIZE1="1"
> SIZE2="1"
> HTMLBETWEEN="<BR>"
> AUTOSELECTFIRST="Yes"
> EMPTYTEXT1="(choose a county)"
> EMPTYTEXT2="(now choose a town)"
> ONCHANGE=""
> FORMNAME="MyOtherForm">
>
------------------------------------------------------------------------------------------------
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]
