ASP/VB database w/fp2000

[havey]

could someone have a look at my coding, i get this error "webbot self" "page cannot be displayed"
Who ever knows frontpage components to access db really well, could you please help me?

[tresesert]

Did you ever get help with your webbot problem? I am facing the same situation. Thanks.

[coolbiz]

Post the code.

-Cool Bizs

[tresesert]

Well, I am not using VB. I just came across the first posting looking for webbot problems. I am using frontpage to make a simple form. I want to save the form results to a file.

Here is what my code looks like. (It is possible that my problem may lie in the server needing frontpage extensions enabled on it, yet I don't know why when I test it, it doesn't work) Thanks.

<form name="MainForm" method="post" action="--WEBBOT-SELF--" onSubmit="return validate();" enctype="text/plain">

<!--webbot bot="SaveResults" U-File="c:\changes" S-Format="TEXT/CSV"
S-Label-Fields="FALSE" B-Reverse-Chronology="FALSE" S-Email-Format="TEXT/PRE"
S-Email-Address="[email protected]" B-Email-Label-Fields="TRUE"
B-Email-Subject-From-Field="FALSE" S-Email-Subject="Change submission"
S-Builtin-Fields U-Confirmation-Url="file:///c:/confirm.htm" -->

<p><strong><center>Change Request Form</center></strong></p>

<p><strong> Name:&nbsp; </strong><input type="text" name="Name" size="27"></p>
<p><strong> Slide Number: </strong><input type="text" name="SlideNumber"></p>

<!-- more form info -->

</form>

If you know why it won't create the file nor email me the results that would be of great help. Thanks.

[coolbiz]

If you want to just save it into a file, then do not specify the email address. If you want to email it, then you need to configure your web server frontpage extension email options. Download the correct fp server extension for your server from http://msdn.microsoft.com/library/de...tml/fpovrw.asp and configure the email options.

-Cool Bizs

[tresesert]

Ok, it sounds easy to save it to a file, but how? Can you provide any sample code, because I have been unable to save it to a file. Thank you for you time and other responses.

[coolbiz]

Here is the code that was generated by Frontpage for me:

<form method="POST" action="--WEBBOT-SELF--">
  <!--webbot bot="SaveResults" u-file="_private/form_results.csv" 
  s-format="TEXT/CSV" s-label-fields="TRUE" b-reverse-chronology="FALSE" 
  s-date-format="%A %B %d, %Y" s-time-format="%I:%M:%S %p %Z" 
  s-builtin-fields="REMOTE_NAME REMOTE_USER HTTP_USER_AGENT Date Time" 
  startspan --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0">
  <!--webbot bot="SaveResults" endspan i-checksum="43374" --><p>
  <textarea rows="2" name="S1" cols="20">
  </textarea><input type="submit" value="Submit" name="B1">
  <input type="reset" value="Reset" name="B2"></p>
</form>

Here is a sample result of the CSV file:

S1 B1 Remote Name Remote User HTTP User Agent Date Time
testse Submit 127.0.0.1 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705) Wednesday September 04, 2002 11:29:08 AM -0400

Good Luck,
-Cool Bizs

[tresesert]

Thanks for the detail in the code. I went back and tried the making a new test form and it worked. There must be something wrong with my current file, that it is not working. Thanks again for all your time.