Classic asp page to send value of combo box

**vmaxx** · 05-30-2012, 06:08 PM

I have a simple asp page that has a dropdown combo box that is populated from a query to a database when the page is loaded and a text box. The user makes a selection from the drop down box and enters some data in the text boxe. Once everything is ok - hits submit. I want the value of the combobox and data in the text boxes to be sent to another asp page with a form post:

<form name="MyForm" method="post" action="Add.asp">

The problem is the <form is outside the %> of the asp code and the data from the combobox is not making it to the other page (the text box data is making it). I assume this is the issue. Any ideas on how to get the value of a combo box to be sent by a form post?

**alexsts** · 06-04-2012, 03:23 PM

what exactly does this means:

the <form is outside the %> of the asp code

Are you sending data to other domain? Html page?

**vmaxx** · 06-04-2012, 04:18 PM

Thanks for replying. The 2 parts of the page are the asp part (inside the <% %>) and the plain html part. The asp part loads the combo box with values from a database. The html part has the <form name="MyForm" method="post" action="Add.asp"> code which takes values from some text boxes which are entered manually after the page loads.

The problem is that when I try to send the value of the text boxes and the combo box to another asp page, the value of the combo box is nothing no matter what I select in the combo box. I tried putting the <form name="MyForm" method="post" action="Add.asp"> code in the asp portion but get an error so I assume the post action has to be outside the asp section. The code is at work or I would post it. I did some searches and the only samples I could find for sending data from one page to another are straight html pages and none sending values from combo boxes.

So I guess the generic question is once a combo box is loaded - how do I send its value to another page via <form name="MyForm" method="post" action="Add.asp">?

Thanks for any ideas

**alexsts** · 06-05-2012, 08:20 AM

Can you post your code. Most likely you have something wrong with request on your code.
Can not say without code.
for example you have combo box id=cmbState inside form.
On the post you need to str_cmbState=request("cmbState")
and then pass this value to what ever you trying to do with it.
You can not do it on straight HTML pages unless you have JavaScript URL processing function. And from your form code I can see that you are submitting to add.asp page.
Best way to help you is to see your code.

**vmaxx** · 06-06-2012, 06:12 PM

Here is the code. It does everything except send the value of the drop down box.

Code:

<html><head><title></title><script type="text/vbscript"></script></head><body>
<%
Dim adoCon
Dim rsDrill
Dim strSQL

Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Drill.mdb")
Set rsDrill = Server.CreateObject("ADODB.Recordset")

   strSQL = "SELECT distinct Table1.DrillInfo from Table1 order by table1.DrillInfo asc;"
   rsDrill.Open strSQL, adoCon

response.write("<select name='TheSerial'>")
do while not rsDrill.EOF
   response.write("<option value=" & rsDrill("DrillInfo") & ">" & rsDrill("DrillInfo") & "</option>")
   rsDrill.movenext
loop
response.write("</select>")

rsDrill.close
Set rsDrill = Nothing
Set adoCon = Nothing
%>

<form name="MyForm" method="post" action="Drill_Add.asp">
TextBox Text: &nbsp;&nbsp;&nbsp;<input type="text" name="thename" maxlength="13">
<input type="submit" name="submit" value="Submit">

</form>
</script>
</body></html>

**alexsts** · 06-06-2012, 07:28 PM

Here it is.
Try.

HTML Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<&#37;
session("orderid")=session.SessionID
session.Timeout=20
%>

<title></title>
</head><body>
<%
Dim adoCon
Dim rsDrill
Dim strSQL

Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Drill.mdb")
Set rsDrill = Server.CreateObject("ADODB.Recordset")

   strSQL = "SELECT distinct Table1.DrillInfo from Table1 order by table1.DrillInfo asc;"
   rsDrill.Open strSQL, adoCon
str_select="" 
str_select=str_select & "<select name='TheSerial'>"
do while not rsDrill.EOF
   str_select=str_select & "<option value=" & rsDrill("DrillInfo") & ">" & rsDrill("DrillInfo") & "</option>"
   rsDrill.movenext
loop
str_select=str_select & "</select>"

rsDrill.close
Set rsDrill = Nothing
Set adoCon = Nothing
%>

<form name="MyForm" method="post" action="Drill_Add.asp">
Drop Down: &nbsp;&nbsp;&nbsp;<%=str_select%>
TextBox Text: &nbsp;&nbsp;&nbsp;<input type="text" name="thename" maxlength="13">
<input type="submit" name="submit" value="Submit">

</form>

</body></html>

**vmaxx** · 06-07-2012, 06:20 PM

That's awesome. There is an issue with some of the entries with spaces in the values, but it is good to figure out what I was initially doing wrong.

**vmaxx** · 06-07-2012, 08:56 PM

I put quotes in the code and everything works like I was hoping...Thanks

**alexsts** · 06-08-2012, 08:08 AM

You can user variable session("orderid") as your session verification and to make sure that same value not submitted more than once. Normally that is where database indexes comes handy but sometimes it is good idea not to overload database...
Especially access database.
Plus I do not see in your code closing connection. Since your database is Access make sure that you do close connection or your website will die by slow and painful death.

**vmaxx** · 06-11-2012, 04:45 PM

Got it and got the close db as well. Thanks again for the helps and tips. I finished that project over the weekend and it does everything I wanted.

Cheers

Thread: Classic asp page to send value of combo box

Thread Tools

Display

Classic asp page to send value of combo box

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions