about retrieving, modifying and updating data using Asp with minimum calls to server

[AnandaTirtha.NR]

How can data from database (from more than one table) be read into a client
code modified and written back (updated) to the data base with minimum calls/cisits
to the server.

Suppose using javascript , is there a way in which the data can be copied(read)
unto client variables modified and then written back to the database.

if there is , what is the way to code the functionality?

kindly aprise me at the earliest.

thanks
Bye
anandatirtha

[Ray Connolly]

"AnandaTirtha.NR" <a.tirtha@excite.com> wrote:
>
>How can data from database (from more than one table) be read into a client
>code modified and written back (updated) to the data base with minimum calls/cisits
>to the server.

My first suggestion is that any retrieving of data by grouped together.
What I mean by that is to create views/queries which group the information
you are looking for into one database call and use that to minimize your
retrieval of data.

My other suggestion only applies if you are using a database server with
stored procedures. Use them to minimize the number of calls to update data.
Also good for speed. I don't know if you can call Access functions from
ASP pages (haven't tried), but it may be worth looking at.

Ray