Solved

incrementation of saved files

Posted on 2001-06-28
11
164 Views
Last Modified: 2013-12-24
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
Comment
Question by:stelogic
  • 7
  • 4
11 Comments
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6236092
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
 

Author Comment

by:stelogic
ID: 6237741
can you give me an example or good link to an easy tutorial to do this please
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6237788
Sure thing....can your server support ASP??
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 

Author Comment

by:stelogic
ID: 6242176
yes it can

cheers

steve
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6242227
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
 
LVL 7

Accepted Solution

by:
ClassyLinks earned 50 total points
ID: 6249897
Steve...are you having any success with this?
0
 

Author Comment

by:stelogic
ID: 6251932
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
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6252389
Please let me know what parts you are having difficulty with.
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6264860
stelogic...how's the ASP going??
0
 

Author Comment

by:stelogic
ID: 6265242
sorted ... thanks for the help

stelogic
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6265290
NP...cu next time.  Thanks for the points!
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Visual Source Safe 2005 on Windows Server 2012 R2 10 1,724
free webina streaming recording software 5 104
Netbeans Open project initial dir 5 47
Column Spacing 3 108
When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question