Passing a JavaScript variable to be used in ASP

[tseh]

I have the following code for a dynamic linked list but am stuck. How do I make varCategory = selectedItem?

<SCRIPT LANGUAGE=&quot;JavaScript&quot;>
function fillOptions(selectedItem){
<% Dim varCategory
varCategory = &quot;???&quot;
rs.MoveFirst
Do While Not rs.EOF
If (rs(&quot;category_&quot = varCategory) Then
%>
document.selectedOption.optionList.options[document.selectedOption.optionList.options.length] = new
Option(&quot;<% Response.Write(rs(&quot;option_id_&quot & &quot; &quot; & rs&quot;name_&quot)%>&quot;, &quot;<% Response.Write(rs(&quot;option_id_&quot) %>&quot;

<% End IF
rs.movenext
LOOP
%>
}
</SCRIPT>

Thanks,
Howard
Thanks,
Howard

 

[dmhirsch]

Remember that selectedItem is not available at the time the ASP is being processed. You could do this as a two-stage process: load all of the options into an array in a function that is built dynamically in ASP. Then have a client-side only function that uses the array to fill the option list according to selectedItem.
Basically, the ASP (server-side) can't respond to user input (client-side javascript) without a return trip to the server.

 

[tseh]

How do I load an js array from an asp recordset?

 

[dmhirsch]

var arr = new Array();
function loadArray() {
<% dim i
rs.MoveFirst
Do While Not rs.EOF
Response.Write &quot;arr[&quot; & i & &quot;] = '&quot; & rs(&quot;field&quot & &quot;';&quot;
Response.Write vbCrLf
i = i + 1
rs.MoveNext
Wend %>
}

Something like that.

 

[dmhirsch]

For some reason, the square brackets didn't show up in my post... I'll retype it using curly braces, but they need to be changed to square brackets.
Response.Write &quot;arr{&quot; & i & &quot;} = '&quot; & rs(&quot;field&quot & &quot;';&quot;

 

[onpnt]

use the

tags to encapsulate your code and they should be formatted as written

_____________________________________________________________________
Please help! I'm falling asleep over here!

http://www.onpntwebdesigns.com

 

[Mr3Putt]

Rather than going through your entire, one-field recordset to create an array... try:

<%
' --- I assume you've already created recordset &quot;rs&quot; by now
dim rsArray, rsString
rsArray = rs.getRows
rsString = join(rsArray,&quot;|&quot;)
rs.Close : set rs = nothing     ' close recordsets
conn.Close : set Conn = nothing ' close connection
%>

...at this point you've now got a long string of the record values, separated by a vertical-bar...

So, now to get it into javascript...

<script type=&quot;text/javascript&quot; language=&quot;javascript&quot;>
var jsArray= '<%=rsString%>'.split('|');
</script>

...and now your Array is in javascript.