This is driving me up the wall

[Paul milner]

Hi
I Have posted this question a few times without avail
Someone must know how to do this.
I have created a drop down list of all the countries of
the world in a FP form. can I import this drop down list
into a search page created by the results wizard.I can
copy/paste it but I dont know how/where to code it.I can
probably handle the SQL I'ts the asp.
I have been looking on the internet all night and found
nothing
Please someone
Paul M

 

[Thomas A. Rowe]

What do you mean by coding it, how will it be used on the search page, need details.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Paul Milner]

Thanks
It is intended to be like the flight search facility at
http://www.jet2.com
You can choose from where you want to fly from a pre-
listed selection.
I created a form in FP 2003 it has a drop down list of
countries.
I then created a database from the form
When I then run the results wizard and use the add search
form option. The result is just a text box to search with
some asp code in the initial value field

<%=Server.HtmlEncode(Request("worldregions"))%>

What I wish to do is insert a drop down list with the
same list of countries as the original form
When I cut and past the list box from the original form,
you can see the countries listed but no search happens
on selection as it does when you manualy type in a
country in the text box version created by the wizard.
How can I connect the drop down list box to the database
so it works?
Thanks for helping

 

[Thomas A. Rowe]

Insert the drop down with the list of countries into the search page, give it the same name as the
text box field that you are replacing, should solve the problem.

If the above doesn't work or doesn't do what you want, then either you will have to wait for someone
else to help the uses the FP database components or you will have to learn to code your ASP
application by hand, especially if you are truly trying to do the exact same thing as on jet2.com.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================