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
Solved

Referencing a local recordset on another ASP page

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Suggested Solutions

Title # Comments Views Activity
SQL Filter Question 8 86
If-Then-Else ASP problem 6 67
IP API - need data... 4 27
Select record with the most recent date 14 67
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…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

839 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