Display values in input text box on clicking link in popup window

[Sonasang]

Hi all,
I am creating a web page using ASP and JavaScript.
In my page i have an entry form which asks the user to enter details like their name , age,platform,language....... etc.
Near the input box of language i have link which opens a seperate window....
In that window i have the details of the code no and languages
like 1 C
2 C++ etc...... which i get from the database and display in the window.

Now i have create the same in link which when i clik shd displayed in the text box

[acoder]

Welcome to TSDN!

I've changed the thread title to better describe the problem.

Post what code you have so far.

To access the parent window, use window.opener.

[Sonasang]

Hi

 <td>&nbsp;&nbsp;
&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;
&nbsp;&nbsp;<span style="font-weight: bold;">Languages
&nbsp;</span> &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;<input
 name="lang_id" id="langid" maxlength="25"
 size="25" type="text">&nbsp;&nbsp;<a
 href="javascript:open()">Details</a></td>
                                          <td><a
 href="javascript:open_win()"><br>
                                          </a></td>

In JS file
it will open the window and display the details

function open()
{
window.open("Open.asp","_blank","toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=no, copyhistory=no, width=320, height=400")
}
 

In Open.asp
Just to display the values in the table.

<%
Dim tt_Connection
Dim tt_Recordset
Dim counter
counter=0
Set tt_Connection = Server.CreateObject("ADODB.Connection")
Set tt_Recordset = Server.CreateObject("ADODB.Recordset")
tt_Connection.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER`=localhost;PORT=3306;DATABASE=table1;USER=root;PASSWORD=pass;OPTION=3;" 
tt_Recordset.ActiveConnection = tt_Connection    
tt_Recordset.open "Select Language_ID,Language from table1",tt_Connection
 Response.Write "<table class='SearchTable' border='3' cellpadding='2' cellspacing='2' width='100%'>" &_
                                                           "<tbody> <tr>"
                                                   While (counter < tt_Recordset.fields.Count )
                                                         Response.Write "<td><b>" & tt_Recordset.fields(counter).Name & "</b></td>"  
                                                         counter = counter + 1
                                                     Wend
                                                     counter = 0
                                                     Response.Write "</tr> <tr>"
                            While Not tt_Recordset.EOF
                                 While (counter < tt_Recordset.fields.Count )
                                           Response.Write "<td>" & tt_Recordset.fields(counter).Value & "</td>"
                                           counter = counter + 1
                                     Wend
                                     Response.Write "</tr>"
                                 tt_Recordset.MoveNext
                                 counter = 0
                            Wend
                                                   Response.Write "</tbody></table>"
%>
 

I have finished till display. Now my task is to display the Language_ID in the textbox, which id i am selecting from the table.... Also it shd be in A href. I don knw how to proceed... pls help me...


Thanks

[acoder]

On line 21 in Open.asp, change it to something like:

Response.Write "<td><a href='#' onclick='setVal(\"" & tt_Recordset.fields(counter).Value & "\"); return false;'>" & tt_Recordset.fields(counter).Value & "</a></td>"

Then the function setVal could be:

function setVal(val) {
 window.opener.document.getElementById("langid").value = val;
}

PS. remember to use code tags when posting code:
[CODE=javascript]
Javascript code here...
[/code]

[Sonasang]

On line 21 in Open.asp, change it to something like:

Response.Write "<td><a href='#' onclick='setVal(\"" & tt_Recordset.fields(counter).Value & "\"); return false;'>" & tt_Recordset.fields(counter).Value & "</a></td>"

Then the function setVal could be:

function setVal(val) {
 window.opener.document.getElementById("langid").value = val;
}

PS. remember to use code tags when posting code:

Javascript code here...
 

Hi Acoder,
Thanks a lot.....
And it is working fine........
Thanks a lot for ur timely help.....


Also just give me an idea as how to trigger a mail when we made a change in database


Thank U .... thanks a lot....

[acoder]

Glad to hear you got it working.

Also just give me an idea as how to trigger a mail when we made a change in database

Why not just use the script which makes the change to send the mail?