advanced search

I have 2 tables. Town and country which are linked. How can I get coldfusion to automatically populate the town select box when a particular country is selected. e.g England selected and the town select box only shows the towns of england. I've done the sql setup. Does anyone now how to do the cfm part?

Thanks peter

You'll have to do this with Javascript, or you'll have to refresh the page to populate the second select box.

Are there any examples you know about to do either of these.

Cheers Peter

There's a custom tag called cf_2selectsrelated at the Macromedia Exchange that does this sort of thing. It take the query and generates the Javascript automatically.

Hi Kiteless,

Found the file you suggested and kave put my select boxes and sql queries into it but am getting the following error message. I,ve attached my files.

Any ideas?

Peter

The required parameter ATTRIBUTES.QUERY was not provided.
This page uses the CFPARAM tag to declare the parameter ATTRIBUTES.QUERY as required for this template. The parameter is not available.Please verify that you have passed or initialized the parameter correctly. If you wish to set a default value for the parameter you should use the DEFAULT attribute of the CFPARAM tag.

The Error Occurred in C:\CFusionMX\wwwroot\iplanet3\signup\TwoSelectsRelated.cfm: line 188

186 : <CFOUTPUT></SELECT></CFOUTPUT>
187 :
188 :

The error is saying that you're not passing a query into the custom tag with the attribute name "query".

You may need to do some reading on custom tags. You don't put your query code IN the custom tag code. The custom tag is a "black box", you just pass stuff into it like this:

<cf_twoselectsrelated query="#myQuery#" .... >