Solved

Referencing a local recordset on another ASP page

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
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…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

717 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