-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Pandurang_Nayak
Message 2 in Discussion
OK.. Writing untested code (it is assumed that this page name is index.asp): <%@
Language=VBScript %> <HTML> <head><title>page title</title> <script> function
getResult(keyValue) { window.location='index.asp?key=' + keyValue; } </script>
</head> <body> <form name="frmMain" action="" method=POST> <select
name="lstOptions" onchange="getResult(this.selectedValue)"> <option
value="key1">value1 <option value="key2">value2 <option value="key3">value3
<option value="key4">value4 </select> <textarea name="txtResult" rows=6 cols=30> <%
If Trim(Request.QueryString("key")) <> "" Then ' Make database connection here
Set DBConn = Server.CreateObject("ADODB.Connection") DBConn.Open
"connectionstring" Set RS = DBConn.Execute("select datacolumn from tablename
where keycolumn = '" & Request.QueryString("key") & "'" If Not RS.EOF Then
Response.Write RS(0) End If %> </textarea> </form> </body> </html>
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
