Sure.

>I think I've got this figured out. Do you want the code for this process?
>
>ray
>>I don't understand the question. Could you be more specific?
>>
>>>How would you handle Hospital where hospital may be something like Oakland Osteopathic Hospital. You can;t use a prime.
>>>
>>>
>>>>I sent you an internet email. The UT didn't like the script I had in my message body. Let me know if you don't receive it.
>>>>
>>>>
>>>>>Using SQL 6.5 and developing an ADO recordset on the Server Side and passing it through IIS this is the server side script that populates an array "LocalArray".
>>>>>This array does not seem to accessible on the client side VBScript. How do we make this array accessible from client-side vbscript procedures such as Combo1_OnChange().
>>>>>
>>>>>My problem is i need to populate a combo box based upon a users selection from a different combo box. The values for the second combo box must come from an ado recordset. I thought the way to do this is to create an array on the client side that can be used from a vbscript procedure. My code for creating the array is below.
>>>>>
>>>>><%
>>>>>rsHosp.MoveFirst
>>>>>Dim LocalArray(2, 14)
>>>>>For i = 0 to 14
>>>>> LocalArray(0, i) = rsHosp.fields("occco")
>>>>> LocalArray(1, i) = rsHosp.fields("hosp")
>>>>> LocalArray(2, i) = rsHosp.fields("HospitalName")
>>>>> rsHosp.MoveNext
>>>>>Next
>>>>>'Response.Write LocalArray(2, 5)
>>>>>'Session("ServerArray") = LocalArray
>>>>>%>
>>>>>
>>>>>Then, my code for the combo1_OnChange() event is:
>>>>>
>>>>>sub Combo1_OnChange()
>>>>>dim tmp, hos
>>>>> for i = 0 to 15
>>>>> set oOption = document.createElement("OPTION")
>>>>> tmp = LocalArray(1, i)
>>>>> hos = LocalArray(2, i)
>>>>> oOption.text = hos
>>>>> oOption.value = tmp
>>>>> form.Combo2.add(oOption)
>>>>> next
>>>>>end sub
>>>>>
>>>>>
>>>>>
>>>>>>Why not just use the ADO Recordset to populate the client side combo box?
>>>>>>
>>>>>>>I did not want to take advantage of anyone's largesse by posting a question only tangentially related to VFP. However, if you insist. I need to know how to build a client side array from a SQL server recordset using VBScript. Example, on SQL Server I have a table with 3 columns, a, b, and C. I want to use ADO to build a recordset and pass these data down to a client side array to populate a drop-down combo box. I can hard code the values of a, b, and c into the VBScript, but the rows in the Server side table will constantly change so that is not a good idea.
>>>>>>>
>>>>>>>If this too far afield for this forum just nuke it ...
>>>>>>>
>>>>>>>thanks
>>>>>>>>Why don't you post your VBScript question??? You will probably get your question answered.....correctly..< bg >
>>>>>>>>
>>>>>>>>
>>>>>>>>>Does anyone know of a good VBScript forum like the UT and VFP. I've got a VBScript question.
>>>>>>>>>
>>>>>>>>>thanks