How do I use JavaScript to do this?

[pointreyes]

I need to allow for a simple way to populate a HTML Form with data from an Oracle database. However, I don't want to use push/pull technology for a simply viewing of the data. I want to load the many records of data in the database (limited by only one value in the table) into a multi-array variable in JavaScript and then allow the user to simply move back and forth through the array for display onto the form. Is this possible and how? Or is there a better way to do this? Remember I don't want to use push/pull between each record. There is a potential for as many as 100,000 hits a day so 100,000 push/pulls for a simply viewing of the data seems a rather foolish way to use the server.

Oh yeah, I forgot to mention that the form will only display one record at a time due to amount of data in each record (one of the fields is even a CLOB). So scrolling through say a 1,000 records in this type of form is better by allowing a view of one record at a time and allow the user to use the Next and Previous buttons.

[ph34r]

So every connection to your webpage is going to get your entire database, whether or not they want to, and whether or not they view more than one record? So 100,000 hits a day gets your entire database?

I'd stick with the single record per request, and provide some record navigation buttons.

[pointreyes]

Not the entire database-just a portion of the database with the largest amount of records being 1,500 running on 100Mbps connection (takes two seconds or less to pull in). Most of the time I suspect the records will never exceed 300. The Oracle database is obviously not limited to just this one schema. There are other schemas on the database and some of them can get as many as 1,000,000 hits so I'm trying to cut back the pushing/pulling as much as possible.

[ 03 April 2002: Message edited by: pointreyes ]