?
Solved

incrementation of saved files

Posted on 2001-06-28
11
Medium Priority
?
171 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
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 

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 200 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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

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

Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
Suggested Courses

593 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