I am having an issue displaying data that I look up using object records. I have an ASP page that uses the input employee number, looks up the Emp_ID (Primary key) and brings back all of the emplyee data via ObjRec's so the user can verify this is the correct
employee they are entering info for. I save each value to a correspnding variable.
Other data is entered into the form such as hours and benefit type, like vacation, and if it is used or earned time. Then using the Form tag the data is submitted to an ASP page to perform the insert into my DB2 table.
The issue I'm having is that once the POST/Submit button is pushed, I cannot seem to grab any of the information that was looked up via objRecs and stored to the variable to use to insert into the proper emplyee row. Specifically, I'd like to use the Emp_ID
field from the lookup and using that as a key to insert the new data in the table.
The issue I'm having is that once the POST/Submit button is pushed, I cannot seem to grab any of the information that was looked up via objRecs and stored to the variable to use to insert into the proper emplyee row.
In the button click event, please try to get the information that was looked up via objRecs and then insert into the proper employee row.
tekwizrd
0 Points
2 Posts
How to display Object Records once submitted via ASP
Jul 10, 2012 01:54 PM|LINK
I am having an issue displaying data that I look up using object records. I have an ASP page that uses the input employee number, looks up the Emp_ID (Primary key) and brings back all of the emplyee data via ObjRec's so the user can verify this is the correct employee they are entering info for. I save each value to a correspnding variable.
Other data is entered into the form such as hours and benefit type, like vacation, and if it is used or earned time. Then using the Form tag the data is submitted to an ASP page to perform the insert into my DB2 table.
The issue I'm having is that once the POST/Submit button is pushed, I cannot seem to grab any of the information that was looked up via objRecs and stored to the variable to use to insert into the proper emplyee row. Specifically, I'd like to use the Emp_ID field from the lookup and using that as a key to insert the new data in the table.
Any help is appreciated. Thanks.
Mudasir.Khan
All-Star
15346 Points
3142 Posts
Re: How to display Object Records once submitted via ASP
Jul 10, 2012 02:07 PM|LINK
var id = Request["Emp_ID"];
tekwizrd
0 Points
2 Posts
Re: How to display Object Records once submitted via ASP
Jul 10, 2012 02:33 PM|LINK
I appreciate the response, but I wasn't to get this work. It didn't like the brackets. I can display the value(s) of my object records using
strEmpID=objRec("Emp_ID")
on the page, but once I POST I cannot seem to grab those values again from the Object or the variables.
Sage Gu - MS...
Contributor
6693 Points
578 Posts
Microsoft
Re: How to display Object Records once submitted via ASP
Jul 17, 2012 11:26 AM|LINK
Hi tekwizrd,
Could you please provide your main code below?
In the button click event, please try to get the information that was looked up via objRecs and then insert into the proper employee row.
Regards,
Sage Gu - MSFT
If you have any feedback about my replies, please contact msdnmg@microsoft.com
Microsoft One Code Framework