CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 variable value transfer between 2 tables and two forms

Print topic Send  topic

Author Message
bossawwm

Posts: 4
Posted: 03/31/2006, 2:30 PM

Hi there,

for one week I have been trying to do transfer the value of apl_Time_Target_q from the form apl_q1
to
apl_Time_Target in the form apl_a1

both are on page q.asp

You can take at the look at the page here"

http://www.computerhelpsos.com/apl/q.asp?Index=1

The logic explained:
An applicant answers a question which comes from the table apl_q and has the filed question, question nr and how many miliseconds the applicant has to answer the questions, before it redirects to the next question.
All the answers are saved in the table apl_a. It records the answer, time started, time taken, question nr and applicant number.
So this is the logic what I am trying to achieve.

Thank you in advance for helping me out!

Best regards Andy

_________________
Best regards
Andy
http://www.computerhelpsos.com
View profile  Send private message
Andreas Barth
Posted: 03/31/2006, 8:02 PM

The solution, took me a week to figure this out.

1. Declare a variable in common.asp, in my case TimeTemp (Dim TimeTemp)
2. Fill the variable with data from the first form - table with TimeTemp = apl_Time_Target_q.Value
3. In the second form/table on the same page create a before show code called apl_a.apl_Time_Target.Value = TimeTemp where apl_a is the form name.
4. The value of TimeTemp will show up whereever you put under default value TimeTemp.
Really usefull was me to use the print command in order to see if TimeTemp was populated, so whenever you do something you can put print TimeTemp to see how the value changes. You have to publish the page first.
bossawwm

Posts: 4
Posted: 03/31/2006, 8:41 PM

I wrote Nr. 4 a little bit wrong. Any control mentioned in Nr.3 apl_a.apl_Time_Target.Value take on the value of timetemp
_________________
Best regards
Andy
http://www.computerhelpsos.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.