Table with each record displayng

Results 1 to 4 of 4

Thread: Table with each record displayng

  1. #1
    Cuong Nguyen Guest

    Default Table with each record displayng

    We have a large SQL datable with a table with a few hundred records. When we displaying those records in a table, it usually takes a while to have them displayed on the browser. Ofcourse it is grapping the fields from the SQL server and once it finishes it is then display. We want this table to be dynamic where once a field is downloaded it is then display immediately and query for the next field and so on.. this way the user thinks that it is doing something rather then thought it frooze up.

  2. #2
    Join Date
    Dec 1969
    Posts
    240

    Default RE: Table with each record displayng

    The server sends the code once the ASP code has finished executing.<BR><BR>If you&#039re having speed problems then you could consider indexing the fields that you&#039re accessing.

  3. #3
    Imar Spaanjaars Guest

    Default RE: Table with each record displayng

    If you query your database and then loop through the recordset with ASP then you could do the following:<BR><BR>Keep a counter within your do while loop.<BR>do while not recordset.eof<BR> Response.write("&#060;tr&#062;&#060;td&#062;Your field" & recordset("yourfield") & "&#060;/td&#062;&#060;/tr&#062;")<BR> counter = counter + 1<BR> Recordset.movenext()<BR> if counter = 10 then<BR> response.flush<BR> counter = 0<BR> end if<BR>loop<BR><BR>This way, the flush statement will send the buffered output to the browser.<BR>Don&#039t forget to use Response.buffer = true in the top of your ASP-page.<BR><BR>Hope this helps.<BR><BR>Imar<BR>

  4. #4
    Cuong Nguyen Guest

    Default RE: Table with each record displayng

    thank you!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •