Question
Related Selects - Cannot get it to work
I am creating a report and need to use related selects,
second pulldown dependent of first pulldown selection.
I found this example off the internet and it does exactly what I want to do :
http://www.webtricks.com/code/code.cfm?CodeID=18
However, when I attempt to make my substitution in the code, all I get for my second pulldown is the id numbers, no names. I am frustrated beyond belief ! Seems simple enough but I just cannot get it to work and I have been playing with this for over two weeks now.
Can somebody please show me how to do it ? Here is my query (the example uses two but I think it can be done in one)
<cfquery name="GetSites" datasource="dbName">
select distinct
s.siteID,
s.site,
a.siteID as areaID,
a.area as depot
from table1 s, table2 a
where s.siteID = a.siteID
and s.siteID <> 1
My first pulldown will be the site, and depending on what is selected, the second pulldown will be populated with the area (depot) for that site. I tried to substitute my varialbes into the url code and it did not work, Can somebody please show me the proper way to do this ? Thanks
I found this example off the internet and it does exactly what I want to do :
http://www.webtricks.com/code/code.cfm?CodeID=18
However, when I attempt to make my substitution in the code, all I get for my second pulldown is the id numbers, no names. I am frustrated beyond belief ! Seems simple enough but I just cannot get it to work and I have been playing with this for over two weeks now.
Can somebody please show me how to do it ? Here is my query (the example uses two but I think it can be done in one)
<cfquery name="GetSites" datasource="dbName">
select distinct
s.siteID,
s.site,
a.siteID as areaID,
a.area as depot
from table1 s, table2 a
where s.siteID = a.siteID
and s.siteID <> 1
My first pulldown will be the site, and depending on what is selected, the second pulldown will be populated with the area (depot) for that site. I tried to substitute my varialbes into the url code and it did not work, Can somebody please show me the proper way to do this ? Thanks
AdChoices