Working with Arrays

arnabghosh · October 5th, 2005, 04:47 AM

Hi,
I have 2 asp pages a.asp & b.asp. In a.asp I have 2 text boxes for name & age respectively in a form which can be submitted to b.asp. In b.asp I have to retrieve the value of names and ages. I also want to have buttons which when clicked will display the names & ages in a sorted way. I have to test the values sorted in b.asp page for 5-10 values. The values cannot be stored in a database and only arrays have to be used.
What should be the code for storing the names & ages in array and display them in sorted way with the click of buttons.

Please help me.

Steven · October 5th, 2005, 05:54 PM

even though you said you can't use a database, you can still put that array into a recordset, and then muck around with it that way (For example, using .Sort)

I am a loud man with a very large hat. This means I am in charge

arnabghosh · October 8th, 2005, 04:14 AM

Hi Steven,
Probably I could not get what you want to say.It would be better if you help me with the coding, then it might be clear.

vinod_yadav1919 · October 11th, 2005, 12:27 AM

Hii arnabghosh!!

Not possible without using cookies/sessions/application object.
Since you are not using database for storing previous values.
How could you maintain it using only array in ur b.asp ,since when you come back to your a.asp page, all values in that array will be lost :)
It's better if possible you can post your code

Cheers :)

vinod

Steven · October 20th, 2005, 12:52 AM

vinod yadav1919, I'll have to disagree with you.
QueryStrings can be used!

Arnabghosh,

perhaps this will help:

Code:

Dim strSorter
If Not IsEmpty(Request.QueryString("sort")) Then
  strSorter = Request.QueryString("sort")
Else
  strSorter = "FieldA"
End If
Dim Rs
Set Rs = Server.CreateObject("ADODB.RecordSet")
With Rs
  .Fields.Append "FieldA", 200, 20
  .Fields.Append "FieldB", 200, 20
  .Open

  .AddNew
  .Fields("FieldA") = "FirstName1"
  .Fields("FieldB") = "LastName1"
  .Update

  .AddNew
  .Fields("FieldA") = "FirstName2"
  .Fields("FieldB") = "LastName2"
  .Update
' ...and so on - you could use a possibly loop for this getting the details out of your array such as
  For i=0 to UBound(YourArray, 2)
   .AddNew
   .Fields("FieldA") = YourArray(i,0)
   .Fields("FieldB") = YourArray(i,1)
   .Update
  Next

' or something like that

  .Sort = strSorter
End With

'Then you can actually present your data
Rs.MoveFirst
Do While Not Rs.EOF
 Response.Write Rs(0) & " - " & Rs(1)
 Rs.MoveNext
Loop

Hope this gives you some ideas

I am a loud man with a very large hat. This means I am in charge

vinod_yadav1919 · October 20th, 2005, 11:50 PM

Hii Steven!!
I agree with you :)

Cheers :)

vinod