Solved

Referencing a local recordset on another ASP page

Posted on 2001-06-22
3
244 Views
Last Modified: 2012-06-27
I have this application which uses databinding. On one page I'm using a recordset to populate a table. When the user adds a new record to the table they are also adding it to the recordset but it is not being saved to the database until the user clicks the Save button. The problem arises because on another page i want to reference that same recordset so that I can populate a <select> box. I can't seem to reference it all. I can create a new recordset on that page and fill up the select box but it is only populated with fields that have been saved to the database. If the user added a new one to the local recordset then it doesnt' appear in the select box because it wasnt' saved first. This is a problem. Any suggestions.
0
Comment
Question by:SmokinDiesel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 20

Assisted Solution

by:Silvers5
Silvers5 earned 45 total points
ID: 6218184
you can't save to the database from a client grid without posting! (saving)  .. I don't see any suggestions except that to make a client side script that will auto submit the form when the client fills out and unfocus from the last field.. but hence.. nothing to add
0
 
LVL 7

Accepted Solution

by:
weesiong earned 30 total points
ID: 6218464
SmokinDiesel,

You need using ActiveX to do this, asp canot do this :)

Regards,
Wee Siong
0
 
LVL 14

Expert Comment

by:puranik_p
ID: 9019033

        No comment has been added lately, so it's time to clean up this TA.
        I will leave a recommendation in the Cleanup topic area that this question is:

->    Split Points b/w Silvers5(50) and weesiong(25)

         Please leave any comments here within the next seven days.
         
        PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
         
        puranik_p
         EE Cleanup Volunteer  

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question