querying database to update list box on client side through java

[Eli Silverman]

I am attempting to develop a form that lists available speakers for a meeting.
One of my clients can have as many as about 800 contracted speakers and a
variety of 100 topics that they can speak on.

What I am trying to create is a form that has a text box in which you can
type in part of a speakers name.

After hiting enter I want to query our SQL database for the speakers with
the matching last names and populate a speaker select box with that list.

After selecting a speaker I again want to query the database and and get the
topics that speaker is authorized to speak on and populate a topic select
list.

I want to be able to do this without posting the page so that I don't have
to keep track of the different processes and orriginal data.

I know AJAX is a possible solution but and Atlas but we are on the 1.1
framework and using studio 2003.
I heard that AJAX was suns response to the programming capabilities of ASP.
Is there a way to achieve this through ASP and vb or java client side
scripting
I know I need to create a web service and an XML response page but I am
havingn difficulty figuring out some of the details.
Any advice as to the simplest most efficient way would be greatly appreciated.

Thanks in advance

[Balasubramanian Ramanathan]

You can use xmlhttp object in the client side.

"Eli Silverman" <El**********@discussions.microsoft.com> wrote in message
news:68**********************************@microsof t.com...

I am attempting to develop a form that lists available speakers for a
meeting.
One of my clients can have as many as about 800 contracted speakers and a
variety of 100 topics that they can speak on.

What I am trying to create is a form that has a text box in which you can
type in part of a speakers name.

After hiting enter I want to query our SQL database for the speakers with
the matching last names and populate a speaker select box with that list.

After selecting a speaker I again want to query the database and and get
the
topics that speaker is authorized to speak on and populate a topic select
list.

I want to be able to do this without posting the page so that I don't have
to keep track of the different processes and orriginal data.

I know AJAX is a possible solution but and Atlas but we are on the 1.1
framework and using studio 2003.
I heard that AJAX was suns response to the programming capabilities of
ASP.
Is there a way to achieve this through ASP and vb or java client side
scripting
I know I need to create a web service and an XML response page but I am
havingn difficulty figuring out some of the details.
Any advice as to the simplest most efficient way would be greatly
appreciated.

Thanks in advance

[Eli Silverman]

Thanks. That was the impression I was getting but I am having difficulty
finding an example to guide me. do you know of any that might be helpful?
Again I want to be able to send a text string or numeric value and receive
an object (dataset , recordset, datareader ... that I can parse through to
clear and repopulate a list box with.
Thanks again
"Balasubramanian Ramanathan" wrote:

You can use xmlhttp object in the client side.

"Eli Silverman" <El**********@discussions.microsoft.com> wrote in message
news:68**********************************@microsof t.com...

I am attempting to develop a form that lists available speakers for a
meeting.
One of my clients can have as many as about 800 contracted speakers and a
variety of 100 topics that they can speak on.

What I am trying to create is a form that has a text box in which you can
type in part of a speakers name.

After hiting enter I want to query our SQL database for the speakers with
the matching last names and populate a speaker select box with that list.

After selecting a speaker I again want to query the database and and get
the
topics that speaker is authorized to speak on and populate a topic select
list.

I want to be able to do this without posting the page so that I don't have
to keep track of the different processes and orriginal data.

I know AJAX is a possible solution but and Atlas but we are on the 1.1
framework and using studio 2003.
I heard that AJAX was suns response to the programming capabilities of
ASP.
Is there a way to achieve this through ASP and vb or java client side
scripting
I know I need to create a web service and an XML response page but I am
havingn difficulty figuring out some of the details.
Any advice as to the simplest most efficient way would be greatly
appreciated.

Thanks in advance