forms not sending results.

  • Thread starter Thread starter marc
  • Start date Start date
M

marc

I'm filling out my own feedback forms online. results get sent to the server
database. I'm downloading the feedback.mdb file to my computer and opening it
with MS Access. Tables yes, but zero results in the rows. Any idea what is
going on?
 
#1 Is it possible that when a feedback.asp has both, a send to email and a
save, or send to database in it, that it will not save it to database?
#2 I have deleted, 3 times, my feedback.asp on server and published my new
feedback.asp to it. Everytime it adds that "send to email" code to it. How is
that possible?
 
Is the following code in feedback form correct, or am I missing something to
send it to database? Am I missing the host name? How do I put it in there?

FP_SaveFormFields fp_rs, arFormFields1, arFormDBFields1

If Request.ServerVariables("REMOTE_HOST") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"),
"Remote_computer_name"
End If
If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"),
"Browser_type"
End If
FP_SaveFieldToDB fp_rs, Now, "Timestamp"
If Request.ServerVariables("REMOTE_USER") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"), "User_name"
End If

fp_rs.Update
FP_DumpError strErrorUrl, "Cannot update the database"

fp_rs.Close
fp_conn.Close
 
Back
Top