473,230 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,230 software developers and data experts.

querying database to update list box on client side through java

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
Jun 16 '06 #1
2 1615
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

Jun 16 '06 #2
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


Jun 16 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

18
by: cjl | last post by:
Hey all: I know that it is silly in the age of Google to 'lose' something on the internet, but I recently checked out a project that had implemented a database with a subset of SQL in pure...
6
by: Greg | last post by:
I am working on a project that will have about 500,000 records in an XML document. This document will need to be queried with XPath, and records will need to be updated. I was thinking about...
6
by: Marvin Libson | last post by:
Hi All: I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I have created a java UDF and trigger. When I update my database I get the following error: SQL1224N A database...
2
by: Manish | last post by:
Hey folks I am having a weird problem in ASP .Net. My page is in C#. I have a datagrid, which populates based on selection in drop down box on ASP page. This datagrid has template textbox colum in...
2
by: Ron St-Pierre | last post by:
We're developing a java app and are using postgres as the database. On our dev server I started the app, closed it, but the java process was still open so I killed it, which caused the above error....
18
by: Ty Salistean | last post by:
I think it would be nice if we could have a SQL engine available on the client side. I primarily do Windows Forms programming and it seems that I have to make alot of calls accross the wire to...
2
by: bwana.mpoa | last post by:
Hi, We're using a mySQL database as a replica of another (Sybase) DB for reporting purposes. The Sybase is part of a real-time mission critical system - hence the separate database where people...
1
by: amritranjan | last post by:
How to retrive image file from MS access database and display this in another JSPpage -------------------------------------------------------------------------------- This is my Jsp code for...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.