Hello!!!<br><br>I don't have an example of my page but I'll try to describe the whole idea behind it:<br><br>There are two fields where will be put an initial date and a final date which will be part of the SQL filter statement.
<br><br>There will be a dropdown box (select box) that when the user clicks on it, he/she will select a country's state where all the values (state's names) are stored in a field from a table in the Access database and will be loaded into the select box being at most 30 values (I did it in a form inside Access using VBA for the event onClick and using a ADODB component to access the table and get the values executing an SQL statement constructed and stored in a String variable).
<br><br>Then the user will select an option from these ones that were loaded into the select box (he/she will select a state's name) and there will be another select box that will show values (cities' names) according to the one selected inside the first select box where the first select box with states works as a filter for the second one with cities (again, using VBA I did with no problems, just created the SQL statement and executed it).
<br><br>I think that solving these issues is almost all the work done as the other things that the page will contain I know how to deal with simple Javascript.<br><br>Thanks a lot for the attention of all!!!!<br><br><div>
<span class="gmail_quote">On 1/30/07, <b class="gmail_sendername">Mike Dougherty</b> <<a href="mailto:mdougherty@pbp.com">mdougherty@pbp.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Do you have an example of your page so we can look at it?<br><br>I ddin't assume ajax. I thought the idea was to make an option list from a database. That can be<br>done on the web server before the page is downloaded. You wouldn't even need javascript (unless
<br>you're using server-side javascript)<br><br>If you want two selects such that the choice in the first select determines the contents of the<br>second select, then try an old-school dhtml solution. (you have less than a hundred options per
<br>select, correct?)<br><br><br><br>On Tue, 30 Jan 2007 11:00:27 -0200<br> "Henrique Rennó" <<a href="mailto:henrique.renno@gmail.com">henrique.renno@gmail.com</a>> wrote:<br>> Hello!!!<br>><br>> I have an Access Database and a form I had created to do some queries on the
<br>> data. One of the things I do is when the user clicks to open a dropdown box<br>> it executes some code in VBA to compose a SQL statement and search for all<br>> values stored in the field that this dropdown box will contain. Now I need
<br>> to put this database on the web and I'm using the perl module DBD::ODBC that<br>> works very fine in order to access the Access database tables.<br>><br>> I had put a html "form" tag with a "select" tag that I want to work the same
<br>> way the dropdown box works in the Access form. What I'm in doubt is if there<br>> is a way of executing a script (with the form's action method) every time a<br>> "select" (dropdown) box is open to load into it all the values from the
<br>> field in the database. Usually when a script is executed it loads the<br>> results into another page (or a new window) but in this case the values<br>> should go into a component without loading some other page.
<br>><br>> I don't know if doing it using Javascript is possible but I'd like some<br>> hints of other kinds of technology I should learn like JSP or Servlets,<br>> whatever could make this SQL query works the way I described.
<br>><br>> Thanks!!!<br>><br>> --<br>> Henrique<br><br>_______________________________________________<br>Javascript mailing list<br><a href="mailto:Javascript@LaTech.edu">Javascript@LaTech.edu</a><br><a href="https://lists.LaTech.edu/mailman/listinfo/javascript">
https://lists.LaTech.edu/mailman/listinfo/javascript</a><br></blockquote></div><br><br clear="all"><br>-- <br>Henrique