Home arrow ASP arrow Page 2 - Grabbing Data On The Fly
ASP

Grabbing Data On The Fly


When we're querying a database, we will usually need to press a submit button on a form to pass data to another ASP page, which would generate the query, and return the results. In some situations, this page refresh is just plain annoying and takes too long to complete. In this article, Phanix will describe another way to query a database using a combination of web technologies.

Author Info:
By: Phanix Chen
Poor Best
Rating: 4 stars4 stars4 stars4 stars4 stars / 3
December 08, 2001
TABLE OF CONTENTS:
  1. · Grabbing Data On The Fly
  2. · Some methods for passing data around
  3. · Using frames to solve the refresh problem
  4. · Query and return
  5. · The processframe.asp page
  6. · Conclusion

print this article
SEARCH DEVARTICLES

TOOLS YOU CAN USE

advertisement
Grabbing Data On The Fly - Some methods for passing data around
(Page 2 of 6 )

There are three well-known methods that are used to gather data, and return results to the user, these are:
  1. Remote Scripting Technologies
  2. Collect users query on one page, and return the results in another
  3. Submit users query to the same page
As with any web technology, though, each method has its drawbacks:

Remote Script:
  • Remote scripting is very hard to debug and maintain
  • Sometimes, the performance of remote scripting is appalling
Collect in one, query in another:
  • The number of pages increases quickly
  • If the form contains a huge number of variables that need to be stored, then we may need to enable session state
  • Hard to maintain
Submit users query to same page:
  • The page size may become large and contain too much logic
  • As a result, managing code would turn into a nightmare
There is, however another way to handle data submission and retrieval without refreshing the page or using session state. We can use a hidden frame.
blog comments powered by Disqus
ASP ARTICLES

- Central Scoreboard with Flash and ASP
- Calorie Counter Using WAP and ASP
- Creating PGP-Encrypted E-Mails Using ASP
- Be My Guest in ASP
- Session Replacement in ASP
- Securing ASP Data Access Credentials Using t...
- The Not So Ordinary Address Book
- Adding and Displaying Data Easily via ASP an...
- Sending Email From a Form in ASP
- Adding Member Services in ASP
- Removing Unconfirmed Members
- Trapping HTTP 500.100 - Internal Server Error
- So Many Rows, So Little Time! - Case Study
- XDO: An XML Engine Class for Classic ASP
- Credit Card Fraud Prevention Using ASP and C...
Find More ASP Tutorials

Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 



© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 4 - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials