Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

incrementation of saved files

thanks for takling the time to read this

is it possible to increment the saved txt file that frontpage can save form data as ?

thanks in advance

stelogic
0
stelogic
Asked:
stelogic
  • 7
  • 4
1 Solution
 
ClassyLinksCommented:
Again..no..it overwrites everytime.  You'd need to use a database of some sort and add new records to it with each form submission.
0
 
stelogicAuthor Commented:
can you give me an example or good link to an easy tutorial to do this please
0
 
ClassyLinksCommented:
Sure thing....can your server support ASP??
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
stelogicAuthor Commented:
yes it can

cheers

steve
0
 
ClassyLinksCommented:
Great...that certainly makes life easier  8-)


You may want to check out www.asp101.com and get more code snippets and tutorials, but here is the basic idea.

First, you need a database, such as Microsoft Access.  For our purposes here, we'll call it test.mdb

The database has a table called tblData with fields called Name and Comments.

We make a page called Form.asp

The code for that page is:
<%
set conn = server.createobject("adodb.connection")
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("../database/test.mdb")&";"
conn.Open

sql = "SELECT * from tblData"

   Set rs = Server.CreateObject("ADODB.Recordset")
   rs.Open sql, conn, 3, 3

addSQL = "INSERT INTO tblData (name, comments) VALUES ('" & request.form("name") & "','" & request.form("comments") & "')"


     If (Request("Add") <>"") Then
          conn.execute addSQL
response.write "Your comments have been added!  Thank You!"
End If
%>
<form method="POST" action="Form.asp" name="FormSubmission">
            <table>
      <tr>
        <td width="83%" bgcolor="#FFFFFF<font face="Arial">Add Your Comments Here:</font></a></td>
        <td width="17%" align="center" bgcolor="#FFFFFF">&nbsp;</td>
      </tr>
      <tr>
        <td width="83%" bgcolor="#FFFFFF" valign="top">
          <p><font face="Arial"><b>Your Name:<br>
          </b><input type="text" name="Name" size="59"></font></p>
          <p><font face="Arial"><b>Comments:<br>
          </b>&nbsp; <textarea rows="10" name="Comments" cols="47"></textarea></font></td>
        <td width="17%" align="center" bgcolor="#FFFFFF" valign="bottom"><input type="submit" value="Add New" name="Add"></td>
      </tr></table>
</form>
<%rs.close
conn.close
%>

I just wrote this off the top of my head, so typos may create errors.  In any case, you get the idea..I hope.
0
 
ClassyLinksCommented:
Steve...are you having any success with this?
0
 
stelogicAuthor Commented:
not really but i am still messing about with it .. but only get a few hours here and there so bear with me ..

cheers

steve
0
 
ClassyLinksCommented:
Please let me know what parts you are having difficulty with.
0
 
ClassyLinksCommented:
stelogic...how's the ASP going??
0
 
stelogicAuthor Commented:
sorted ... thanks for the help

stelogic
0
 
ClassyLinksCommented:
NP...cu next time.  Thanks for the points!
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now