Forums
This topic is locked
Requery or Session Variable
Posted 23 Oct 2001 19:06:40
1
has voted
23 Oct 2001 19:06:40 Alex Xander posted:
Hi again sorry for bothering with another question. My question is I have an insert page with a combo box(names) which have the values from an recordset and beside of the combro theres an add name link and it go to the add name page then after add the name it goes back to the insert page and the combo box its ok but all the form values are empty again?? any suggestion??
Replies
Replied 24 Oct 2001 09:51:31
24 Oct 2001 09:51:31 Viktor Farcic replied:
Simplest solution is to open insert page in new window.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi again sorry for bothering with another question. My question is I have an insert page with a combo box(names) which have the values from an recordset and beside of the combro theres an add name link and it go to the add name page then after add the name it goes back to the insert page and the combo box its ok but all the form values are empty again??
any suggestion??
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi again sorry for bothering with another question. My question is I have an insert page with a combo box(names) which have the values from an recordset and beside of the combro theres an add name link and it go to the add name page then after add the name it goes back to the insert page and the combo box its ok but all the form values are empty again??
any suggestion??
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 24 Oct 2001 17:00:39
24 Oct 2001 17:00:39 Alex Xander replied:
Yes is a simple solution but if i open the add form in a new window the combobox will not be updated until the user press f9 or refresh button
Replied 24 Oct 2001 17:46:51
24 Oct 2001 17:46:51 Viktor Farcic replied:
After you insert new record (from new window) redirect to other page (let's say confirmation.asp). in that page insert something like:
<html>
<head>
<script language="JavaScript">
<!--
function refreshParent() {
window.opener.location.href = window.opener.location.href;
if (window.opener.progressWindow)
window.opener.progressWindow.close();
window.close();
}
//-->
</script>
</head>
<body onLoad="refreshParent()">
</body>
</html>
This way after inserting data you're going to confirmation.asp with codes to refresh parent page and close itself.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Yes is a simple solution but if i open the add form in a new window the combobox will not be updated until the user press f9 or refresh button.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<html>
<head>
<script language="JavaScript">
<!--
function refreshParent() {
window.opener.location.href = window.opener.location.href;
if (window.opener.progressWindow)
window.opener.progressWindow.close();
window.close();
}
//-->
</script>
</head>
<body onLoad="refreshParent()">
</body>
</html>
This way after inserting data you're going to confirmation.asp with codes to refresh parent page and close itself.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Yes is a simple solution but if i open the add form in a new window the combobox will not be updated until the user press f9 or refresh button.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 24 Oct 2001 18:26:06
24 Oct 2001 18:26:06 Alex Xander replied:
ok im understanding but the code does not make nothing maybe i'm wrong in something,
i have the page with the combobox with the option to add if is pressed it popup a window to add values to the combo box, then on that window i add a value then send me to the confirmation.asp (with you code) and this page does not do nothing =(
i have the page with the combobox with the option to add if is pressed it popup a window to add values to the combo box, then on that window i add a value then send me to the confirmation.asp (with you code) and this page does not do nothing =(
Replied 24 Oct 2001 19:06:22
24 Oct 2001 19:06:22 Alex Xander replied:
I dont have to change anything on you code???
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
After you insert new record (from new window) redirect to other page (let's say confirmation.asp). in that page insert something like:
<html>
<head>
<script language="JavaScript">
<!--
function refreshParent() {
window.opener.location.href = window.opener.location.href;
if (window.opener.progressWindow)
window.opener.progressWindow.close();
window.close();
}
//-->
</script>
</head>
<body onLoad="refreshParent()">
</body>
</html>
This way after inserting data you're going to confirmation.asp with codes to refresh parent page and close itself.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Yes is a simple solution but if i open the add form in a new window the combobox will not be updated until the user press f9 or refresh button.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
After you insert new record (from new window) redirect to other page (let's say confirmation.asp). in that page insert something like:
<html>
<head>
<script language="JavaScript">
<!--
function refreshParent() {
window.opener.location.href = window.opener.location.href;
if (window.opener.progressWindow)
window.opener.progressWindow.close();
window.close();
}
//-->
</script>
</head>
<body onLoad="refreshParent()">
</body>
</html>
This way after inserting data you're going to confirmation.asp with codes to refresh parent page and close itself.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Yes is a simple solution but if i open the add form in a new window the combobox will not be updated until the user press f9 or refresh button.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 25 Oct 2001 09:31:54
25 Oct 2001 09:31:54 Viktor Farcic replied:
I assumed that you are opening new window as popup with its name.
P.S. I'll send you via email some working example later.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I dont have to change anything on you code???
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
P.S. I'll send you via email some working example later.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I dont have to change anything on you code???
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 25 Oct 2001 18:26:56
25 Oct 2001 18:26:56 Alex Xander replied:
Thanks You
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I assumed that you are opening new window as popup with its name.
P.S. I'll send you via email some working example later.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I dont have to change anything on you code???
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I assumed that you are opening new window as popup with its name.
P.S. I'll send you via email some working example later.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I dont have to change anything on you code???
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 26 Oct 2001 11:51:27
26 Oct 2001 11:51:27 Viktor Farcic replied:
My computer went to hell and I need to format it and install everything again. Becouse of this I will not be able to send you example before monday.
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Thanks You
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Thanks You
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>