Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

incrementation of saved files

Posted on 2001-06-28
11
Medium Priority
?
169 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
Simplify Your Workload with One Tool

How do you combat today’s intelligent hacker while managing multiple domains and platforms? By simplifying your workload with one tool. With Lunarpages hosting through Plesk Onyx, you can:

Automate SSL generation and installation with two clicks
Experience total server control

 

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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
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 update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

721 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