conditional submit

[Jeet2004]

Here is what i want to achieve
Create a page which displays all the comments by a user in a table and has a text box and a button to submit new comments.

Now what i have achieved till now is --
fetch the data from database and display the data.

I need help in following.
1. i want to insert new comments via the webpage to database
a. how cna i check using vbscript if there was something entered in the box.
b. if entered in the box take the data and put it in database.
i need help with the above. Dont know how to do the above items.

Also i need to display the same page with new comments added as the last row in the table so if the above things are checked submit the form to reload.

Any help woud be highy appreated

 

[DotNetGnat]

your page should look something like this:

comments.asp
<%
if request.form("submit")<>"" then

'declare all your variables
'set connection and recordset object
'open connection string
'write your sql to retrieve all the comments
'execute the sql
'until the end of the recordset display
all the records in the table format
'start your form
end if
<form name="myform" method="post" action="comments.asp">
<input type="text" name="comments">
<input type="submit" name="submit" value="submit">
</form>
%>

-DNG

 

[Jeet2004]

dotnetgnat,

first of all with the above logic you are not inserting anything in the database.
Second there are no validations if anything was put in the comments text box
Third if the form loaded for the first time there is no form.submit so with the above logic it wont hsow the existing comments

let me knwo if i am missing something
Thanks

 

[DotNetGnat]

ok...you got that straight...i missed some points...

comments.asp
<script>
'put a little javascript here to check that comments box is not empty when the user clicked submit...if it is empty a pop says asks the user to enter the comments
</script>
<%
'declare all your variables
'set connection and recordset object
'open connection string
'write your sql to retrieve all the comments
'execute the sql
'until the end of the recordset display
all the records in the table format

if request.form("submit")<>"" then
'do the insert here
INSERT INTO Mytable(comments) Values('"&request.form("comments")&"')
rs.execute(mysql)
response.redirect "comments.asp"
end if

'start your form

<form name="myform" method="post" action="comments.asp">
<input type="text" name="comments">
<input type="submit" name="submit" value="submit">
</form>
%>


let me know if you need help with the actual code...the above is just logic

-DNG

 

[DotNetGnat]

ok here is the javascript that you need

<script type="text/javascript">
function validate_required(field,alerttxt)
{
with (field)
{
if (value=="0")
  {alert(alerttxt);return false}
else {return true}
}
}function validate_form(thisform)
{
with (thisform)
{
if (validate_required(Comments,"Please enter your comments")==false)
  {reportname.focus();return false}
}
}
</script>

and here are the changes to the form:

<form name="Form1" method="post" action="" onsubmit="return validate_form(this)">
<input type="textarea" name="comments"
<input type="submit" name="submit" value="submit">

</form>

hope that helps...

-DNG

 

[DotNetGnat]

oops...need two changes...
change this line
if (value=="0")
to
if (value=="")

and


change this line
{reportname.focus();return false}

{comments.focus();return false}


-DNG