How to clear form results

S

salsweb

How do I clear form results when they are saves as a .asp page that can be
viewed from the internet. (if the correct URL is changed)?
 
R

Ronx

The answer to my interpretation of your question is to write the asp
page so that it processes the form data, but does not display the form
results.

Or did you mean something else?
 
S

salsweb

i just read it over and it was confusing what i said. How do I clear the
results when it is in that format?
 
R

Ronx

Form results can be DISPLAYED by an asp page, but they are never stored
in one - unless you are using a text file with a .asp extension as a
database of sorts. In this case, delete the file.

As I said before, the form handler can STORE the form results, either in
a text database (example: csv format text file), an Access database (or
mySQL, MS SQL, Oracle etc.) or email the results. You can change the
script to not DISPLAY the results. To clear the results, edit or delete
whatever is storing the results.

--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp
 
S

salsweb

ok now how do i email it. because it always says it will not work. and how do
i get it into the access database because i can see the table and subjects
and everything, but no results
 
R

Ronx

Email will not work unless you are using a server with email facilities.
If using the extensions for email then email transport must be enabled
in the extensions, and the page must NOT have an .asp extension - .htm
or .html are the only options.

How are you attempting to add data to the database? Database Results
Wizard or Custom code? Are you accessing the pages on a server? Does
the server support asp and Access?
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp
 
S

salsweb

Ok im goin to forget about email. Now as for the Access database...
I go into the form page of my site, right click, send to datatbase, options,
and it creates a database called "feedback". and thats all fine and done.
Then i go and click on the feedback access file in my recent documents. I can
click results and get to the database. on the top it shows all the fields
such as name date etc. but i cannot get the results to display underneath.
 
R

Ronx

The database should be in the fpdb folder. Then you MUST publish to a
web server on a Windows server running FrontPage extensions (the
extensions will ensure the correct permissions are on the fpdb folder.
Then test the pages. Nothing will work correctly unless you use a web
server and open the form page using a URL in the form http://example.com
(replace example.com with your own domain name or IP address).

If you are editing live on the server, then try importing an Access
database into the website. FrontPage should ask you to place the
database in the fpdb folder, and then set the correct permissions on the
folder.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp
 
S

salsweb

ok thanks. that sounds like it should help. but for some reason as of last
night i cant get it to publish right and cant view the site. so when i get
that figured out i will let ya know if i got it
 
R

Rob Giordano \(Crash\)

You're passwording the root?

--
~~~~~~~~~~~~~~~~~~
Rob Giordano
Microsoft MVP Expression
 
S

salsweb

well on the original stuff (the pages i want) i tried it and it stopped
uploading to the internet correctly and i cant figure out how to fix it. so i
tried this. its all just one big disaster now
 
R

Rob Giordano \(Crash\)

baby steps dood :)



--
~~~~~~~~~~~~~~~~~~
Rob Giordano
Microsoft MVP Expression
 
S

salsweb

haha ya. well i got it for the most part. but now it shows a page i deleted
as the home page. the only way to get to the real one is by typing /home.htm
at the end
 
S

salsweb

ok i think i did everything right. on the form i checked update to database
or whatever, and it will send to an access database in the fpdb folder. i
filled out the form as a test and it worked i got the confirmation page. then
i went to the fpdb folder clicked the database, opened it, and i clicked
tables, then "results", a table comes up and displays all the form fields at
the top, but no results...
 
R

Rob Giordano \(Crash\)

where did you get that form from?
are you trying to fix web pages created with Publisher or something else?
home.htm page has multiple body tags.


--
~~~~~~~~~~~~~~~~~~
Rob Giordano
Microsoft MVP Expression
 
S

salsweb

no just the form page wizard in frontpage

Rob Giordano (Crash) said:
where did you get that form from?
are you trying to fix web pages created with Publisher or something else?
home.htm page has multiple body tags.
 
S

salsweb

I have tried that it does the same thing. and if i get what you said right...
i upload it with FTP
 
R

Ronx

DO NOT upload with FTP - You MUST use the FrontPage HTTP method to
upload, and the server MUST have the FrontPage extensions. If you use
FTP you will have to set the correct permissions on the fpdb folder
yourself. The server must be able to read and write to files in the
folder, but anonymous users must not be able to browse the folder, or
download files from it.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp
 
R

Rob Giordano \(Crash\)

Slightly OT;

Ron, can you see my last reply to salsweb post? I can't, the only way I can
tell its there is by looking at his response to my post. This has been
happening sporadically for the past week or so.

Reader: Windows Live Mail or OE and only on some messages..and only on ms
public server ng.

Anyone have any clues lemme know...TNX



--
~~~~~~~~~~~~~~~~~~
Rob Giordano
Microsoft MVP Expression
 
R

Ronx

Rob,

The last post from you was dated Wed 23/7/2008 at 03:11 BST (19:11 PDT)
replying to salsweb. But I cannot find any post from salweb that shows
his website URL - was there one?

--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top