Database access by browser?

[Jon Glazer]

I was looking for thoughts on having a piece of a web page updated when a
button or drop down is selected. The update would have to be via the
results of a database lookup/query. Any ideas on this? I am thinking of
having to do it through javascript/asp mixture but unsure.

What are your thoughts?

As an example, say you have a drop down of, say, 100 names to choose. When
the person chooses a name, a query is fired and the person's address is
populated in a box. I'd rather not have this happen via a full-page update
if possible.

Whatcha think?

Thanks!
Jon

[James Baker]

Personally, I'd have the dropdown post to the same page with the onChange
event and fire a submit or a redirect with a querystring (based on your
layout). Then I'd just request the variable and display all of the data.
You seem like you're on the right track and most likely you'll need/want
JavaScript and VBScript.

[Jeff Cochran]

On Wed, 16 Jun 2004 16:34:40 GMT, "Jon Glazer"
<jg**************@adconn.com> wrote:

I was looking for thoughts on having a piece of a web page updated when a
button or drop down is selected. The update would have to be via the
results of a database lookup/query. Any ideas on this? I am thinking of
having to do it through javascript/asp mixture but unsure.

What are your thoughts?
I think I'm out of oarnge juice, and probably low on milk too.
As an example, say you have a drop down of, say, 100 names to choose. When
the person chooses a name, a query is fired and the person's address is
populated in a box. I'd rather not have this happen via a full-page update
if possible.

Whatcha think?

I think I better pick them up on the way home.

If you're looking for information on how to accomplish your "thoughts'
you might want to try a Google for examples.

Jeff

[Bullschmidt]

"Personally, I'd have the dropdown post to the same page with the
onChange event and fire a submit or a redirect with a querystring (based
on your layout). Then I'd just request the variable and display all of
the data.
You seem like you're on the right track and most likely you'll need/want
JavaScript and VBScript."

I agree as that's what I do on my Web database demo and several projects
I've done.

Best regards,
J. Paul Schmidt, Freelance ASP Web Consultant
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!