DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Combo options from recordset

  1. #1
    Join Date
    Aug 2008

    Exclamation Combo options from recordset

    I need to populate a combo box options list from data gathered via recordset on an iSeries. Currently, I populate all combo boxes on the page (25) by ASP recordsets on page load. This takes an incredible amount of time. I want to try and reduce the user wait time by using AJAX and load the options on a focus or onkeydown or onclick event handler. I am just unsure how to do this. I have tried several ways and been unsuccessful.

    Can anyone push me in the right direction for this please?


  2. #2
    Join Date
    Apr 2007
    Sterling Heights, Michigan
    Welcome to DevX

    What have you tried that hasn't worked?

  3. #3
    Join Date
    Aug 2008
    I have included ASP pages in the head that run the query and write out an XML file that I then use to populate the combo boxes. This takes the same amount of time though. (I am assuming since they are includes in the header) I have tried to trigger the asp page to run/open with an onclick, onfocus and onkeydown event with javascript. but it doesn't write the xml file in time for the combo box to populate and gives me invalid xml file errors.

Similar Threads

  1. recordset is so slow to fill the combo box
    By Nomi in forum Database
    Replies: 3
    Last Post: 06-18-2002, 03:49 PM
  2. Replies: 0
    Last Post: 11-13-2001, 12:34 PM
  3. Creating a Recordset
    By Scott in forum ASP.NET
    Replies: 0
    Last Post: 11-12-2001, 10:14 PM
  4. Requerying a reshaped recordset
    By Jonathan Gibbs in forum VB Classic
    Replies: 0
    Last Post: 08-09-2001, 02:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center