I have a simple ASP recordset being returned that I create a table from with a checkbox in the final column.
Once the values are into the array I will be looking at a method of searching that array for City_Name. So eg if I typed in Paris - as long as the item was in the array - I would get returned the ID for Paris (which I would then automatically check the checkbox for that ID)
So in short - I need to add the Recordset items of City_ID and City_Name into a 2 dimensional array.
Then I need a method or example of how I would search for a string in that array based on City_Name that would return the corresponding City ID.
<table class="data" id="tblTrips" sort="yes">
Do While Not RsX.EOF
<td width="75"><% Response.Write RsX("City_ID") %> </td>
<td><% Response.Write RsX("City_Name") %> </td>