pop up menu

@fyanymMay 11.2005

i want to make a pop up menu to display data from database, after that i want to pass the record i selected into a text box…i work jz like a combo box…how to i do it….any recommend page or sample? thanx

to post a comment

JavaScript

@buntineMay 11.2005 — #Why can't you just use a combo box? This will require some pretty extensive DHTML and/or JavaScript programming.

@fyanymauthorMay 11.2005 — #because my field name are very long, if display in the combo box its not such pretty... and i need to add some description in the selection box...

example:

product code description

00000000001 Super Genius 3.564 USB Optical mouse

@buntineMay 11.2005 — #Why not just use a table or something to display the data? Cramping everything into a selection box will probably look bad aswell.

@fyanymauthorMay 11.2005 — #i want to do something like in the yahoo mail addressbook, when i click a link, the addressbook appear, i can select my frend's email there, the email address i was selected will pass to the text box address field...tats my objective...

@buntineMay 11.2005 — #Ok. That must be done with JavaScript as ASP can only execute from the server. I will move this thread to the JavaScript forum for you.

Regards.

@fyanymauthorMay 11.2005 — #anyway...thanx 4 help!

@fyanymauthorMay 11.2005 — #*****I FOUND THE WAY******

<html>

set con=server.CreateObject("ADODB.Connection")

set rs=server.CreateObject("ADODB.Recordset")

con.open "Driver={MySQL ODBC 3.51 Driver};server=localhost;uid=root;database=restaurant"

strSQLPrct="SELECT item1, desp FROM table"

rqKey = request("key")

rqFieldName = Request("field")

<script LANGUAGE="JavaScript">

function ignore(){
   return true;
  }
  function sendback(stockcode){
   window.onerror=ignore;
   window.opener.<%=rqFieldName%>.value = stockcode;
   self.close();
  }

</script>

<body>

<form name="f1">

<%

rs.Open strSQLPrct, con

If rs.EOF Then

Response.Write "No record found."

Else

Response.Write "<center><h3>Select from the following item</h3>"

Response.Write "<BR><INPUT TYPE=BUTTON VALUE=""Cancel"" ONCLICK=""window.close();return(false);"" id=BUTTON1 name=BUTTON1>"

Response.Write "<TABLE>"

Do Until rs.EOF

Response.Write "<TR><TD><a href=""javascript:sendback('" & rs("stockcode") & "','" & rs("stockdesp") & "');"">" & _

rs("stockcode") & " " & rs("stockdesp") & "</a></TD></TR>"

rs.MoveNext

Loop

Response.Write "</TABLE>"

End If

rs.Close

Set rs = Nothing

con.Close

Set con = Nothing

Response.Write "<BR><INPUT TYPE=BUTTON VALUE=""Cancel"" ONCLICK=""window.close();return(false);"" name=BUTTON1>"

%>

</center>

</body>

</html>

@buntineMay 11.2005 — #Good job!

pop up menu

8 Comments(s) _↴

Also in #JavaScript _↴

Success!

Social

Version

pop up menu

8 Comments(s) ↴

Also in #JavaScript ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

8 Comments(s) _↴

Also in #JavaScript _↴