Insert of elements in a form using ASP and save into a DB

Question

I create this richiesta.html:

<HTML>
<BODY>
<table border> //create a simple table
<tr>
<td>
<form  ACTION="richiesta.asp"> //open the file richiesta.asp
<table> //start a table format
<tr><td><input name="cognome" size="20"/></tr> //contain a input text 
</table>
</form>
</td>
</tr>
<td><input type="submit" value="Invia"></td><td> // contein a button to send value to DB
</table>
</BODY>
</HTML>

I create richiesta.asp:

<HTML>
<BODY>
<%
cognome = Request.Form("cognome")
%>
<%
Session.timeout = 1 //Check the session
If IsObject(Session("iscrizioni")) Then
Set conn = Session("iscrizioni")
Else
Set conn = Server.CreateObject("ADODB.Connection") //Check the connection
conn.open "iscrizioni"
Set Session("iscrizioni") = conn
End If
%>
<% 
If Stato = "" Then 
SQL="INSERT INTO iscrizioni (Cognome) VALUES ("SQL=SQL & "'" & cognome & "', "SQL=SQL ")
response.write(SQL) //
conn.execute(SQL) // Insert value
conn.close  //Close the connection
%>

// // End Page I want to insert in the BD Anagrafica, table Anagrafica the name of a student. DB structure: enter image description here

place the submit button inside your form :)

Murali Murugesan
– Murali Murugesan

2013-12-26 22:01:31 +00:00
Commented Dec 26, 2013 at 22:01 — Murali Murugesan
– Murali Murugesan, Commented Dec 26, 2013 at 22:01

Murali Murugesan · Accepted Answer · 2013-12-26 22:01:03Z

2

HTML Form action should be a valid (relative/absolute) url and not a physical location.

Also the input control and submit button should be inside form for default form submit.

Please change your <form> tags action attribute

<form action="riciesta.asp" >

 <table>
  <tr><td><input name="cognome" size="20"/></td></tr>
  <tr><td><input type="submit" value="submit"/></td></tr>
  </table>
</form>

edited Dec 26, 2013 at 22:01

answered Dec 20, 2013 at 15:56

Murali Murugesan

22.6k18 gold badges76 silver badges124 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Francesco Irrera Over a year ago

I try your solution on monday. Thamks for your availability :-)

Collectives™ on Stack Overflow

Insert of elements in a form using ASP and save into a DB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related