can you get window.opener data in server side code

edmicman · August 25th, 2005, 02:29 PM

i am building a sql statement that is executed at the beginning of the page, and this page is a popup. I want to be able to use some of the values from window.opener.whateverfields in the building of the sql statement. can I even do this?? I'm having a heck of a time here....thanks!

Greg Griffiths · August 25th, 2005, 06:32 PM

you certinaly can if you can pass them to the server side in either the Query String of the Form post submission.

edmicman · August 26th, 2005, 08:15 AM

that's what i was afraid of. the popup window is from a window.open call....I am passing some info in the querystring, but I have a rather large text field that I don't want to have to try and send in the querystring. It would be too much to hope for to be able to use window.opener.getelementbyid("something").value in the server side script, wouldn't it!

joefawcett · August 27th, 2005, 03:41 AM

How could the server possibly know what a client is doing?
When you open the popup you ust need to pass the required values, as Greg suggested, via the POST or GET method. You then read these server-side and build your SQL (or use a stored procedure which is far safer).
A simple example, on the main page:

Code:

function openPopup()
{
  //Get the surname from the textbox
  var sSurname = document.getElementById("txtSurname").value;
  //Encode surname in case of non ASCII characters
  sSurname = encodeURIComponent(sSurname);
  //Build the URL to the popup
  var sUrl = "myPopupPage.htm?Surname=" + sSurname;
  var oWin = window.open(sUrl);
}

Then server-side, assuming ASP and SQL Server or such:

Code:

<%
  var sSurname = Request.Querystring.item("Surname") + "";
  //In real life use Adodb.command etc with stored proc
  //to avoid SQL injection and single quote problems etc.
  var sSql = "Select * FROM tblCustomer WHERE Surname = '"
           + sSurname + "'" 
  //Execute SQL and show results
%>

--

Joe (Microsoft MVP - XML)