Selectbox from Database Table

[Guest_imported]

I do have a problem. I have an Access Database with some tables("Player"; "Sportkind" etc..) and I would like to create in Javascript (Client side)a dynamic select Box, which hold automaticly all players who exists in the database. When I select one of them, so the second Selectbox will be updated and shows all sports which the selected player is doing.
The connection to the Database is done with "ADODB" And I´ve already created the Recordsets which I need. I hope you can help me please!!!
Thanks!
Mamo
PS. Pleas write me on: Elmam@gmx.de

 

[DubnerM]

All that I can say - it's not recommended. If you want i'll explain in details why.
Recommended style is connecting to database on serverside. So you should do something like following:
[ol][li]If number of players and number of sportkinds by player is resonable
grab both tables to javascript array. On server-side generate something like following:

pArr = new Object()
pArr['John'] = new Array('Football', 'Skiing')
pArr['Sam'] = new Array('Tennis')
...

[/li]
[li]If number of players is resonable, but number of sportkinds by player is big

sArr = new Array('Football', 'Skiing', 'Chess', 'Tennis')
pArr = new Object()
pArr['John'] = new Array(0, 1)
pArr['Sam'] = new Array(3)
...

[/li]
[li]If numbers are big you have no other choice except reload page sending selected player as parameter.[/li][/ol] [sig]<p>Michael Dubner<br>Brainbench MVP/HTML+JavaScript<br>

http://www.brainbench.com<br>

[/sig]