Calling a Function to Refresh a Select Object on the Same Page 1

c2compliant · Jun 21, 2000

I am attempting to create a function which will retrieve a recordset that contains names from a SQL Server table using a stored procedure.  The criteria for what names to retrieve will be passed from a button the user will click.  The recordset of names will then be placed in a select object using a loop.   I would like to be able to call the function each time the user selects a button and the select object will refresh with a list of names. 1)Can this be achieved on one page and is so how? 2)Or is there a way to do this without having to make multiple trips to the server (returning the entire unfiltered recordset of names and then sorting them after a user clicks a button and refreshing the select object)?

palbano · Jun 21, 2000

Dear c2Compliant, 1) Use a hidden form variable to pass the SQL filter value to the server code. Then use it in your stored procedure and build the <select><option>.... tags from the resultant rows. <%   var category = "1"; // default value   if ( !isNaN(Request("CATID&quot

) )     category = new String(Request("CATID&quot

);   ... create a ADODB.Recordset and connection objects or whatever to call the stored proc sending it category filter   var sel = "<select name='validnames'>\r\n";   while ( !rs.EOF)     sel += "<option value='" + rs("nameID&quot

+ "'>" + rs("name&quot

+ "</option>\r\n";   sel += "</select>\r\n"; %> <form name="form1" ....> <input type=hidden name="CATID" value="<%=category%>"> <input type=button value="Cat One" onclick="document.form1.CATID.value = 1; document.form1.submit();"> <input type=button value="Cat Two" onclick="document.form1.CATID.value = 2; document.form1.submit();"> <%=sel%> </form> 2) Yes you can send all the data to the client if you like as well. There are several designs you could use. You can generate separate <select> tags for each category and place each one in it's own <div> tag and control their visibility using CSS and DHTML. If you only have to support IE this is very simple. With Nutscrap it get's a little more difficult but you might get it to work. Or... you could build script arrays for each category and dynamically change the contents of the <select> tag using DHTML. Still more but that's all I will do for now... Hope this helps -pete

c2compliant · Jun 21, 2000

The first solution appears to be what I'm looking for and I'm excited get it working. However, I'm a beginner and do not understand all of the code.   var category = "1"; // default value   if ( !isNaN(Request("CATID&quot

) )     category = new String(Request("CATID&quot

);   var sel = "<select name='validnames'>\r\n"; Questions: 1) "var" does that mean I should declare a variable for both category and sel or is this a function? 2) "!isNaN" is this a function that does something with the category id? 3) "new string" is this a function (it is highlighted blue in Interdev)? 4) Do I not need to use a "then" and "end if"? Thank you

palbano · Jun 21, 2000

Dear c2compliant, I apologize for the confusion. My sample code is written in Javascript. I don't use VBScript much. The variable named 'category' is used to store the value of the 'request' variable named 'CATID' which comes from the HTML form element of the same name. The isNaN() code is merely setting a default value of '1' for the CATID since the first time someone visits the page the request variable will not exist. In VB it would look something like this: category = Request("CATID&quot

if strlen(category) < 1 then   category = "1" end if Then you would use the 'category' variable to pass the value to your stored procedure that returns your filtered rowset based on the category ID. The variable named 'sel' is short for 'select' and will be built to contain the complete html for a <select> tag and all it's enclosed <option> tags. So the VBScript code must perform string concatination, it would look something like this: sel = "<select name='validnames'>" while NOT rs.EOF then   sel = sel & "<option value='" & rs("nameID&quot

& "'>" & rs("name&quot

& "</option>" loop There may be some syntax errors in my VBScript code. Hope this helps -pete

unicorn11 · Jun 24, 2000

You can first use javascript to create arrays form the sql server then onChange function of the select field you can then create a function to reload the select values i live demo of that is <A HREF="

http://www.dskdl.com/"

TARGET="_new">

http://www.dskdl.com/</A> i

do not remember the exact link to it but i know is is the it was used when i created the page about a year back it is the current projects page and at the bottom of the page there are a few dorp downlists where i have used some thing like this Unicorn11 <a href=mailto:webmaster@tripmedia.com>webmaster@tripmedia.com</a> <a href= > </a> Hi there it all likeminded fellows!!!!!!

c2compliant · Jun 26, 2000

I was able to successfully fill the select object from the server. However, now I would like to be able to pass the value of the the selection made from the user from within the select object.  The error I get is "object required" when I try to use client side scripting such as the following: <SCRIPT LANGUAGE=VBS> SUB BUTTON1_ONCLICK() msgbox validatenames.value END SUB </SCRIPT> Any suggestions?

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Calling a Function to Refresh a Select Object on the Same Page 1

c2compliant

Programmer

palbano

Programmer

c2compliant

Programmer

palbano

Programmer

unicorn11

Programmer

c2compliant

Programmer

Similar threads

Part and Inventory Search

Sponsor