hey hi...
this in in continuation to my other post. i am trying hard
and cannot find out whats the problem. i am getting
crazy...please asp experts ...do resolve the problem...its
something very simple which i am doign wrong.
wehn i clcik to the submit button ....its absolutely dead
nothing happens!!!!!!!! !!!!!!! why so :-(((((((
this is my select.asp script:
<html>
<head>
<title> monika </title>
</head>
<body>
<form method="post" action="submit. asp">
<table><tr><t d bgcolor="SILVER ">
<BIG> <B> <FONT COLOR=blue>
WELCOME 'STUDENT_NAME'
TODAY IS <%=DATE()%></b></td><p></p></tr>
</table><p></p>
<input type = "text" size ="50" maxlength=90 name
= "txtStory"> <p></P>
<input type="button" value="SUBMIT" >
</form>
</body>
</html>
this is my submit.asp script:
<html>
<head>
<title>monika m</title>
</head>
<body>
<%
Dim strStoryContent
DIM RSA
DIM QUERY1
DIM ConnString
DIM Conn
response.write "comes in submit"
ConnString = "Driver={My SQL ODBC 3.51 Driver};"
ConnString = ConnString & "Port=3306; "
ConnString = ConnString & "DATABASE=t est; "
strStoryContent = Request.form("t xtStory")
If Request.form("S UBMIT") <> "" then
response.write "come1"
If Request("txtSto ry")<>"" then
response.write "come2"
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Conn.Open ConnString
set RSA = Server.CreateOb ject("ADODB.Rec ordset")
QUERY1 = "INSERT INTO student_content
(student_id,sto ry_id,status_st udent,story_ori ginal_story_wo
rd_count) VALUES
('1','100','dra ft','"&strStory Content&"',4)"
Set rsa = conn.Execute(QU ERY1)
End If
ELSE
RESPONSE.WRITE ("SUBMIT IS A ZERO LENGTH STRING")
end if
%>
</body>
</html>
