Solved

incrementation of saved files

Posted on 2001-06-28
11
166 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 

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

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

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

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…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
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…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…
Suggested Courses

617 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