[Javascript] Database and SQL

[Billy Reisinger]

Javascript is event-driven.  The "change" event fires when the user  
changes a drop down (select) value.  You can use Ajax to pass data  
between the client and server, so you could build the GET or POST  
query from the change event (fired by the drop down), hit the url  
with Ajax, use whatever server side technology you want to do the db  
query, and return the content to the client.   You'll then need to  
drop the returned content onto the page using Javascript.


On Jan 30, 2007, at 7:00 AM, Henrique Rennó wrote:

> Hello!!!
>
> I have an Access Database and a form I had created to do some  
> queries on the data. One of the things I do is when the user clicks  
> to open a dropdown box it executes some code in VBA to compose a  
> SQL statement and search for all values stored in the field that  
> this dropdown box will contain. Now I need to put this database on  
> the web and I'm using the perl module DBD::ODBC that works very  
> fine in order to access the Access database tables.
>
> I had put a html "form" tag with a "select" tag that I want to work  
> the same way the dropdown box works in the Access form. What I'm in  
> doubt is if there is a way of executing a script (with the form's  
> action method) every time a "select" (dropdown) box is open to load  
> into it all the values from the field in the database. Usually when  
> a script is executed it loads the results into another page (or a  
> new window) but in this case the values should go into a component  
> without loading some other page.
>
> I don't know if doing it using Javascript is possible but I'd like  
> some hints of other kinds of technology I should learn like JSP or  
> Servlets, whatever could make this SQL query works the way I  
> described.
>
> Thanks!!!
>
> -- 
> Henrique
> _______________________________________________
> Javascript mailing list
> Javascript at LaTech.edu
> https://lists.LaTech.edu/mailman/listinfo/javascript