Display sql records dynamically

[styx218]

Hi guys,

Just a quick question.I am developing a jsp application an dwould like to display records from my sql database dynamically from a drop down box.Is this possible.And would the page have to be reloaded everytime a user selected a record from the drop down box.Any help appreciated.

Regards,
styx218

 

[mrdenny]

You could do it one of two ways.

1. Have the page refresh each time the drop down is selected pulling down the record that the user selects.

2. Download all the records into a large (or HUGE) array and then simply update the page via javascript every time the drop down is changed.

If you have a small table (only a few records) then use option 2. If you have a larger table use option 1 to decrease database load, network traffic from the web server to the clients and web page load time.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[styx218]

Ok i settled on using sql:query tag to display my data,which is working fine.

How would i go about appending the choice selected in my drop down menu to a table on the same page? i am developing a fantasy football application which requires 11 drop down boxes and for the choices to be displayed as the user picks them

 

[philhege]

This is better asked in a Javascript forum. But I think I have some code around here that does what you're after. Let me look for an example and get back to you in a bit.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Not NULL-terminated yet.

 

[philhege]

Serendipity. I couldn't find my local code example, but I found a JS Web page that explains a possible solution.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Not NULL-terminated yet.

 

[styx218]

That helped a lot thanks phil