Solved

Referencing a local recordset on another ASP page

Posted on 2001-06-22
3
239 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

932 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now