manipulate data returned using client script

alyeng2000 · December 6th, 2003, 08:36 AM

do any one know a ways to manipulate returned data in recordset using client script i mean i needn't to return to server while these operations is happening..
i have a solution but i haave not test it yet is to store theses data in hidden objects but any one know an array object to use???

need help

Ahmed Ali
Software Developer

alyeng2000 · December 7th, 2003, 01:16 PM

another idea
instead of hidden object i could also use session object to be storage for returned data from the server ,do any one face my situation.!!!

Ahmed Ali
Software Developer

planoie · December 8th, 2003, 01:40 PM

You cannot access the server's session object from the client without doing a post to the server.

What do you mean by "manipulate returned data"? You can do whatever you please on the client side with the data if the data is in something that you can manipulate. But it won't have any affect on the data that stored if that is what you are intending.

Peter
------------------------------------------------------
Work smarter, not harder.

alyeng2000 · December 8th, 2003, 08:41 PM

sorry for "session" idea , but refearing to

Quote:

quote:What do you mean by "manipulate returned data"?

i mean,
i need to calculate and show to client some statistics based on some calculations from returned Stored Hidden data.

this is a kind of storing to client side:
response.write "<script> var ar(RScount);"
for i=0 to RScount-1
response.write "ar(" $i & ")" & rs("name")
next
response.write "</script>"

do any have acomment on that simple sol.

Ahmed Ali
Software Developer

jacob · December 9th, 2003, 10:50 AM

I do not quite get it! Why do you want to use client script!? Isn't it possible to do the calculations/manipulations serverside?

And if is a question about looping through some recordset, then this might help...

Code:

    Dim db
    Set db = Server.CreateObject ("ADODB.Connection")
    db.Open ("[some connection string]")

    Dim rs
    Set rs = Server.CreateObject ("ADODB.Recordset")

    rs.Open "SELECT someColumn FROM someTable", db

    While Not rs.EOF

        Response.Write "value: " & rs("someColumn") & "<BR>"
        rs.MoveNext
          
    Wend

    rs.Close
    Set rs = Nothing

    db.Close
    Set db = Nothing

Hope it helps!

Jacob.

alyeng2000 · December 9th, 2003, 01:39 PM

hi jacob,
all I need from Client Calculations is to decrease no of hits to the server for multi user system so decrease load on the server

Ahmed Ali
Software Developer