Silly Newbie Submit Question

jofarrell · Jul 5, 2001

I have been struggling with getting an ASP page to do what I want it to WHEN I want it to. Because I am querying a database I have basically Three states:
1. user just gets to page and enters all information (an obvious Insert SQL no reloading of page and just submit - works fine)
2. user enters dates tries to get previous data but has none in database (Not an edit so add mode is required but page has to reload with dates still there)
3. User has entered dates hits button to bring back previous data (Works) Now we are into an Update mode.

Here is my question .... can I onclick on the submit button do my Update Set Where ... without ever saying Form.submit??
Or is this needed for something other than what I am seeing as I do not go to another page so I do not need to hand the variables there. This will allow my to separate my UPDATE and INSERT code without all the variables I am seemingly toggling to prevent and set actions I mentioned above.

Sorry if this is confusing and long winded but I am just going crazy and wondered if anyone may be able to shed some light on my problem.

Joanne

FengShui1998 · Jul 5, 2001

Joanne,

If I understand your question correctly, you do not want to post to two separate ASP page, but have the data show on the same form. It would probably look something like this.
If not, reply.

Fengshui1998

<html>
<body>
<form name="myform" method="post" action="thispage.asp">
<%
strdate1 = request.form("date1&quot

strdate2 = request.form("date2&quot

strSQL = "SELECT * FROM table WHERE DATE='" & strdate1 & "'"

rs.open strSQL , Conn
if rs.recordcount = 0 then
rs.addnew
..
..
date1 = strdate1
date2 = strdate2

else
rs.movefirst
date1 = rs("date1&quot

date2 = rs("date2&quot

End if

%>

<br>
<input type="text" name="date1" value="<%=date1%>">
<input type="text" name="date2" value="<%=date2%>">
<br><input type="submit" value="Submit">
</body>
</html>

jofarrell · Jul 5, 2001

Thanks .. I gave up on the thoghts of saving from same page to the database.

I was trying to get the form to allow me to retrieve, add, and edit but as long as you did it in the right order it was ok ... but if you thought you had a retrieval of data and there was none there then it wasnt toggling to allow a save of any new data ...

Because there is a dynamic table on the page it makes it very hard to submit the data to a new form where as on same form I could use the getrows property of the array I created.

Its a little(lot) more complicated then just sending a few fields over ...

Thank you very much for responding

Joanne

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Silly Newbie Submit Question

jofarrell

Programmer

FengShui1998

MIS

jofarrell

Programmer

Similar threads

Part and Inventory Search

Sponsor