OnChange Lookup ASP recordset

[Ryan]

I have a form on a webpage that someone enters a number (SponsorID).
After then enter that SponsorID into the form, I need to somehow query
my SQL database and find the record that has the same ID as the
SponsorID entered into the form and return the SponsorName (and write
it out on the page using a <div> tag or something of the like) WITHOUT
reloading the entire page (because I will loose the other information
already input on this page).

Now, I don't necessarly have to query the database, I *could* create
an Array when the page loads, using ASP, that will contain the
SponsorIDs and the SponsorNames and then compare the SponsorIDs within
that array with the number that was entered on the form.

My problem, is that I cannot figure out how to do any of this. Any
help would be greatly appreciated.

Thanks!

Ryan

[Manohar Kamath [MVP]]

Use an IFRAME to load only a part of the page, no need to preload all
records. You will have to use a client-side javascript to capture the change
of the recordID, and load thsi IFRAME. SOmething like

<script language=javascript>
function loadRecord()
{
recordFrame.src = 'mypage.asp?id=' + document.form.recordID.value;
}
</script>

<input type=text onblur="loadRecord()" name="recordID">
<iframe id=recordFrame src="" height=100 width=100></iframe>
--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Ryan" <we*******@moboysstate.org> wrote in message
news:e5*************************@posting.google.co m...

I have a form on a webpage that someone enters a number (SponsorID).
After then enter that SponsorID into the form, I need to somehow query
my SQL database and find the record that has the same ID as the
SponsorID entered into the form and return the SponsorName (and write
it out on the page using a <div> tag or something of the like) WITHOUT
reloading the entire page (because I will loose the other information
already input on this page).

Now, I don't necessarly have to query the database, I *could* create
an Array when the page loads, using ASP, that will contain the
SponsorIDs and the SponsorNames and then compare the SponsorIDs within
that array with the number that was entered on the form.

My problem, is that I cannot figure out how to do any of this. Any
help would be greatly appreciated.

Thanks!

Ryan

[Aaron Bertrand [MVP]]

Please don't multi-post.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Ryan" <we*******@moboysstate.org> wrote in message
news:e5*************************@posting.google.co m...

I have a form on a webpage that someone enters a number (SponsorID).
After then enter that SponsorID into the form, I need to somehow query
my SQL database and find the record that has the same ID as the
SponsorID entered into the form and return the SponsorName (and write
it out on the page using a <div> tag or something of the like) WITHOUT
reloading the entire page (because I will loose the other information
already input on this page).

Now, I don't necessarly have to query the database, I *could* create
an Array when the page loads, using ASP, that will contain the
SponsorIDs and the SponsorNames and then compare the SponsorIDs within
that array with the number that was entered on the form.

My problem, is that I cannot figure out how to do any of this. Any
help would be greatly appreciated.

Thanks!

Ryan