No results being displayed. (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

billyd380 -> No results being displayed. (9/14/2004 9:52:08)

I have a simple form with one drop down box and 3 text boxes that are supposed to enter data into a database. Then I use the DRW to display those results on another page. The problem is no data is going from my form to my database. What could this be?

Thanks for any help,

Bill



BeTheBall -> RE: No results being displayed. (9/14/2004 13:06:12)

If you are not receiving an error message when the form is submitted, then I suggest you begin by checking permissions. The anonymous account for the server needs read, write and delete permissions on the fpdb folder. The account should look something like:

<IUSR_ComputerName>

If the site is hosted, ask your host to correct the permissions.



billyd380 -> RE: No results being displayed. (9/14/2004 13:17:49)

Sorry if I forgot to mention that this was a company Intranet and is being hosted on our file server. The anonymous account is set with the correct permissions. Could it be anything else?



BeTheBall -> RE: No results being displayed. (9/14/2004 13:23:32)

The site is hosted on the file server? No IIS?



billyd380 -> RE: No results being displayed. (9/14/2004 13:27:52)

Yes IIS is installed and Front Page Extensions. I didn't want to call a Web server because it is not.



BeTheBall -> RE: No results being displayed. (9/14/2004 13:44:17)

Gotcha. So when you view permissions on the fpdb folder, the IUSR_ComputerName account has read, write and delete?



billyd380 -> RE: No results being displayed. (9/14/2004 13:48:46)

Yes that's correct. I gave it full permissions.



BeTheBall -> RE: No results being displayed. (9/14/2004 14:34:12)

OK, so I assume your form just uses the "Send to Database" option via FrontPage? When you submit, do you get a confirmation saying the record has been submitted?



billyd380 -> RE: No results being displayed. (9/14/2004 15:19:54)

Yes, you assume right and I get a conformation page and it does display what was entered in the form.



BeTheBall -> RE: No results being displayed. (9/14/2004 16:57:05)

Please post the HTML code for the form page.



billyd380 -> RE: No results being displayed. (9/14/2004 17:05:07)

Here is the code for the Form:



<%
' FP_ASP ASP Automatically generated by a FrontPage Component. Do not Edit.

On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 1252
Err.Clear

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
Err.Clear

Set fp_conn = Server.CreateObject("ADODB.Connection")
FP_DumpError strErrorUrl, "Cannot create connection"

Set fp_rs = Server.CreateObject("ADODB.Recordset")
FP_DumpError strErrorUrl, "Cannot create record set"

fp_conn.Open Application("LogBook1_ConnectionString")
FP_DumpError strErrorUrl, "Cannot open database"

fp_rs.Open """Log Book""", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
FP_DumpError strErrorUrl, "Cannot open record set"

fp_rs.AddNew
FP_DumpError strErrorUrl, "Cannot add new record set to the database"
Dim arFormFields0(4)
Dim arFormDBFields0(4)
Dim arFormValues0(4)

arFormFields0(0) = "Names"
arFormDBFields0(0) = "Name"
arFormValues0(0) = Request("Names")
arFormFields0(1) = "Reason"
arFormDBFields0(1) = "Reason"
arFormValues0(1) = Request("Reason")
arFormFields0(2) = "TimeOut"
arFormDBFields0(2) = "TimeOut"
arFormValues0(2) = Request("TimeOut")
arFormFields0(3) = "TimeIn"
arFormDBFields0(3) = "TimeIn"
arFormValues0(3) = Request("TimeIn")

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0

If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"), "Browser_type1"
End If
If Request.ServerVariables("REMOTE_HOST") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"), "Remote_computer_name1"
End If
FP_SaveFieldToDB fp_rs, Now, "Timestamp1"
If Request.ServerVariables("REMOTE_USER") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"), "User_name1"
End If

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

fp_rs.Close
fp_conn.Close

FP_FormConfirmation "text/html; charset=windows-1252",_
"Form Confirmation",_
"Thank you for submitting the following information:",_
"Default.asp",_
"Return to the form."

End If
End If

Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")

%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Log Book Entry</title>
<meta name="Microsoft Theme" content="network-blitz-2 0011, default">
<meta name="Microsoft Border" content="tb">
</head>

<body topmargin="0" leftmargin="0"><table border="0" width="98%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top" width="170"></td>
<td valign="top"></td>
</tr>
<tr>
<td valign="top" width="170">
<!--webbot bot="Navigation" S-Type="children"
S-Orientation="vertical" S-Rendering="graphics" B-Include-Home="FALSE"
B-Include-Up="FALSE" S-Theme="DeepBlue 0110" -->
<p> </p>
</td>
<td valign="top">
<form method="POST" name="Logbook" action="--WEBBOT-SELF--">
<!--webbot bot="SaveDatabase" SuggestedExt="asp" S-DataConnection="LogBook1" S-RecordSource="Log Book" U-Database-URL="../logbook.mdb" S-Builtin-Fields="HTTP_USER_AGENT REMOTE_HOST Timestamp REMOTE_USER" S-Builtin-DBFields="Browser_type1 Remote_computer_name1 Timestamp1 User_name1" S-Form-Fields="Names Reason TimeOut TimeIn" S-Form-DBFields="Name Reason TimeOut TimeIn" startspan U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" endspan i-checksum="34604" -->
<p> </p>
<p><span style="vertical-align: top">Name:</span>
<select size="3" name="Names" multiple>
<option>Amy</option>
<option>Bill</option>
<option>Bev</option>
<option>Diane</option>
<option>Don</option>
<option>Greg</option>
<option>Heather</option>
<option>Jim</option>
<option>Josh</option>
<option>Mike</option>
<option>R.J.</option>
</select>  Time Out:
<input type="text" name="TimeOut" size="20"></p>
<p>Time In:  <input type="text" name="TimeIn" size="20"> 
Reason:  <input type="text" name="Reason" size="20"></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
<p> </p>
<p><b><font face="Verdana" size="2">Note</font></b><font face="Verdana" size="2"> 
Microsoft Office 2000 and Internet Explorer 5 or greater are required to use these
applications. </font><a href="http://www.microsoft.com/windows/ie/downloads/critical/ie6sp1/default.mspx"><font size="2">Download
the latest Internet Explorer.</font></a></p>
</td>
</tr>
</table></body>

</html>



BeTheBall -> RE: No results being displayed. (9/14/2004 18:11:30)

Try renaming your database table without a space in it. Looks like your table is called Log Book. Try changing it to LogBook and then edit the page accordingly.



billyd380 -> RE: No results being displayed. (9/15/2004 10:08:50)

Duane,

Ok when you told me to do that I relized I had but forgot to change the form to point to the correct database. When I fixed that problem it worked but only on the drop down box and the text box called Reason. The two text boxes that are named Time In and Time Out don't seem to be working. I tried to rename them just IN and Out and I recieved an error. Here is the way the code looks now. Is there something that I am missing here? I looked throught it and it seems to look like it is pointing to the right field in the database but I can't tell if everything is where it needs to be. Thanks for all of your help I really appreciate it.

Bill



BeTheBall -> RE: No results being displayed. (9/15/2004 10:13:35)

quote:

Here is the way the code looks now.


Where exactly is "here"? [;)] I can joke about that because I am famous for referring to links or attachments and then not attaching them.



billyd380 -> RE: No results being displayed. (9/15/2004 10:17:30)

Oh Yeah, I guess that would be good. I do it all the time too. Here ya go.[:)]

<%
' FP_ASP ASP Automatically generated by a FrontPage Component. Do not Edit.

On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 1252
Err.Clear

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
Err.Clear

Set fp_conn = Server.CreateObject("ADODB.Connection")
FP_DumpError strErrorUrl, "Cannot create connection"

Set fp_rs = Server.CreateObject("ADODB.Recordset")
FP_DumpError strErrorUrl, "Cannot create record set"

fp_conn.Open Application("LogBook1_ConnectionString")
FP_DumpError strErrorUrl, "Cannot open database"

fp_rs.Open """LogBook""", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
FP_DumpError strErrorUrl, "Cannot open record set"

fp_rs.AddNew
FP_DumpError strErrorUrl, "Cannot add new record set to the database"
Dim arFormFields0(4)
Dim arFormDBFields0(4)
Dim arFormValues0(4)

arFormFields0(0) = "Names"
arFormDBFields0(0) = "Name"
arFormValues0(0) = Request("Names")
arFormFields0(1) = "Reason"
arFormDBFields0(1) = "Reason"
arFormValues0(1) = Request("Reason")
arFormFields0(2) = "TimeOut"
arFormDBFields0(2) = "TimeOut"
arFormValues0(2) = Request("TimeOut")
arFormFields0(3) = "TimeIn"
arFormDBFields0(3) = "TimeIn"
arFormValues0(3) = Request("TimeIn")

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0

If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"), "Browser_type1"
End If
If Request.ServerVariables("REMOTE_HOST") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"), "Remote_computer_name1"
End If
FP_SaveFieldToDB fp_rs, Now, "Timestamp1"
If Request.ServerVariables("REMOTE_USER") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"), "User_name1"
End If

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

fp_rs.Close
fp_conn.Close

FP_FormConfirmation "text/html; charset=windows-1252",_
"Form Confirmation",_
"Thank you for submitting the following information:",_
"Default.asp",_
"Return to the form."

End If
End If

Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")

%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Log Book Entry</title>
<meta name="Microsoft Theme" content="network-blitz-2 0011, default">
<meta name="Microsoft Border" content="tb">
</head>

<body topmargin="0" leftmargin="0"><table border="0" width="98%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top" width="170"></td>
<td valign="top"></td>
</tr>
<tr>
<td valign="top" width="170">
<!--webbot bot="Navigation" S-Type="children"
S-Orientation="vertical" S-Rendering="graphics" B-Include-Home="FALSE"
B-Include-Up="FALSE" S-Theme="DeepBlue 0110" -->
<p> </p>
</td>
<td valign="top">
<form method="POST" name="Logbook" action="--WEBBOT-SELF--">
<!--webbot bot="SaveDatabase" SuggestedExt="asp" S-DataConnection="LogBook" S-RecordSource="LogBook" U-Database-URL="../fpdb/logbook.mdb" S-Builtin-Fields="HTTP_USER_AGENT REMOTE_HOST Timestamp REMOTE_USER" S-Builtin-DBFields="Browser_type1 Remote_computer_name1 Timestamp1 User_name1" S-Form-Fields="Names Reason TimeOut TimeIn" S-Form-DBFields="Name Reason TimeOut TimeIn" startspan U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><!--webbot bot="SaveDatabase" endspan -->
<p> </p>
<p><span style="vertical-align: top">Name:</span>
<select size="3" name="Names" multiple>
<option>Amy</option>
<option>Bill</option>
<option>Bev</option>
<option>Diane</option>
<option>Don</option>
<option>Greg</option>
<option>Heather</option>
<option>Jim</option>
<option>Josh</option>
<option>Mike</option>
<option>R.J.</option>
</select>  Time Out:
<input type="text" name="TimeOut" size="20"></p>
<p>Time In:  <input type="text" name="TimeIn" size="20"> 
Reason:  <input type="text" name="Reason" size="20"></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
<p> </p>
<p><b><font face="Verdana" size="2">Note</font></b><font face="Verdana" size="2"> 
Microsoft Office 2000 and Internet Explorer 5 or greater are required to use these
applications. </font><a href="http://www.microsoft.com/windows/ie/downloads/critical/ie6sp1/default.mspx"><font size="2">Download
the latest Internet Explorer.</font></a></p>
</td>
</tr>
</table></body>

</html>



billyd380 -> RE: No results being displayed. (9/15/2004 10:40:13)

Ok so I changed something and don't know what but now when ever I pick One name from the drop down box it won't display anything, but if I pick more than one it will display everything even the Time In and Time Out. Here is the current code. Then only thing I remember changing is the name for Time In and Time Out in the database.


<%
' FP_ASP ASP Automatically generated by a FrontPage Component. Do not Edit.

On Error Resume Next
Session("FP_OldCodePage") = Session.CodePage
Session("FP_OldLCID") = Session.LCID
Session.CodePage = 1252
Err.Clear

strErrorUrl = ""

If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
If Request.Form("VTI-GROUP") = "0" Then
Err.Clear

Set fp_conn = Server.CreateObject("ADODB.Connection")
FP_DumpError strErrorUrl, "Cannot create connection"

Set fp_rs = Server.CreateObject("ADODB.Recordset")
FP_DumpError strErrorUrl, "Cannot create record set"

fp_conn.Open Application("LogBook1_ConnectionString")
FP_DumpError strErrorUrl, "Cannot open database"

fp_rs.Open """LogBook""", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable
FP_DumpError strErrorUrl, "Cannot open record set"

fp_rs.AddNew
FP_DumpError strErrorUrl, "Cannot add new record set to the database"
Dim arFormFields0(4)
Dim arFormDBFields0(4)
Dim arFormValues0(4)

arFormFields0(0) = "Names"
arFormDBFields0(0) = "Name"
arFormValues0(0) = Request("Names")
arFormFields0(1) = "Reason"
arFormDBFields0(1) = "Reason"
arFormValues0(1) = Request("Reason")
arFormFields0(2) = "TimeOut"
arFormDBFields0(2) = "TimeOut"
arFormValues0(2) = Request("TimeOut")
arFormFields0(3) = "TimeIn"
arFormDBFields0(3) = "TimeIn"
arFormValues0(3) = Request("TimeIn")

FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0

If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"), "Browser_type1"
End If
If Request.ServerVariables("REMOTE_HOST") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"), "Remote_computer_name1"
End If
FP_SaveFieldToDB fp_rs, Now, "Timestamp1"
If Request.ServerVariables("REMOTE_USER") <> "" Then
FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"), "User_name1"
End If

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

fp_rs.Close
fp_conn.Close

FP_FormConfirmation "text/html; charset=windows-1252",_
"Form Confirmation",_
"Thank you for submitting the following information:",_
"Default.asp",_
"Return to the form."

End If
End If

Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")

%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Log Book Entry</title>
<meta name="Microsoft Theme" content="network-blitz-2 0011, default">
<meta name="Microsoft Border" content="tb">
</head>

<body topmargin="0" leftmargin="0"><table border="0" width="98%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top" width="170"></td>
<td valign="top"></td>
</tr>
<tr>
<td valign="top" width="170">
<!--webbot bot="Navigation" S-Type="children"
S-Orientation="vertical" S-Rendering="graphics" B-Include-Home="FALSE"
B-Include-Up="FALSE" S-Theme="DeepBlue 0110" -->
<p> </p>
</td>
<td valign="top">
<form method="POST" name="Logbook" action="--WEBBOT-SELF--">
<!--webbot bot="SaveDatabase" SuggestedExt="asp" S-DataConnection="LogBook" S-RecordSource="LogBook" U-Database-URL="../fpdb/logbook.mdb" S-Builtin-Fields="HTTP_USER_AGENT REMOTE_HOST Timestamp REMOTE_USER" S-Builtin-DBFields="Browser_type Remote_computer_name Timestamp User_name" S-Form-Fields="Names Reason TimeOut TimeIn" S-Form-DBFields="Name Reason Time\ Out Time\ In" startspan U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><!--webbot bot="SaveDatabase" endspan -->
<p> </p>
<p><span style="vertical-align: top">Name:</span>
<select size="3" name="Names" multiple>
<option>Amy</option>
<option>Bill</option>
<option>Bev</option>
<option>Diane</option>
<option>Don</option>
<option>Greg</option>
<option>Heather</option>
<option>Jim</option>
<option>Josh</option>
<option>Mike</option>
<option>R.J.</option>
</select>  Time Out:
<input type="text" name="TimeOut" size="20"></p>
<p>Time In:  <input type="text" name="TimeIn" size="20"> 
Reason:  <input type="text" name="Reason" size="20"></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
<p> </p>
<p><b><font face="Verdana" size="2">Note</font></b><font face="Verdana" size="2"> 
Microsoft Office 2000 and Internet Explorer 5 or greater are required to use these
applications. </font><a href="http://www.microsoft.com/windows/ie/downloads/critical/ie6sp1/default.mspx"><font size="2">Download
the latest Internet Explorer.</font></a></p>
</td>
</tr>
</table></body>

</html>



BeTheBall -> RE: No results being displayed. (9/15/2004 11:03:06)

OK, we're talking two different issues here. First, we have to make sure the records are being inserted. If there is a problem with just the display, we will need to look at the page that does the display. So, submit a record with just one name selected and then submit a record with multiple names selected. Then, open the database table and see if both records were indeed submitted.



billyd380 -> RE: No results being displayed. (9/15/2004 11:15:13)

Ok I figured out the problem. I had the Name field set as a primary key in Access and it wouldnt allow duplicates so everytime I would use a name that was previously submitted then it wouldn't take it. I got rid of the Primary Key and now everything works fine for now. I thank you very much for you expertise and if I know I will have more question when I am ready to improve this Intranet so be prepared to hear from me in the future.

Thanks again,

Bill



BeTheBall -> RE: No results being displayed. (9/15/2004 11:21:56)

quote:

so be prepared to hear from me in the future


Look forward to it. Good luck.



billyd380 -> RE: No results being displayed. (9/24/2004 12:44:22)

Hey Duane,

I'm back with a simple securtiy question. In the same forum we talked about earlier everything was working fine then all of a sudden when people want to view the results page it makes them enter a username and password. I have all the users and the iusr account with full permissions. This was all working yesterday and this morning and I don't remember changing anything big especially permissons. Let me know if you need to see the code again. I will keep working on it and let you know if I figure it out.



BeTheBall -> RE: No results being displayed. (9/24/2004 12:51:56)

I assume this is an intranet? If users are being prompted for a username and password, that is definitely a permissions issue, not anything in your code. Do you know whether your web requires NT authentication or not? Go to Tools - Server - Permissions. Then click the tab labeled "Users". If the box labeled, "Valid username and password required to browse this web" is checked, then the site is using NT authentication and the users who are being asked for their username and password have not been give individual permissions or are not part of a NT group that has permissions. Try unchecking the box and see if that resolves it. Also, if the box is greyed out, it means you are inheriting permissions from a web above yours and perhaps the permissions on that web have been changed.



billyd380 -> RE: No results being displayed. (9/24/2004 12:59:59)

Yes it is an intranet. And the Server option is greyed out. How do I figure out what web I am inheriting permissions from? This makes since but I just don't know how it just came to be all of a sudden.



BeTheBall -> RE: No results being displayed. (9/24/2004 13:18:29)

If the Server option is greyed-out then I suspect you are opening your local copy (on your PC). You need to open the published site. Perhaps the easiest way to do that is to browse to your site with Internet Explorer and then click the Edit with FrontPage icon. Then you should have access to view the permissions unless you yourself don't have sufficient permissions in which case you may need to enlist the help of your IT dept.



billyd380 -> RE: No results being displayed. (9/24/2004 13:27:20)

Well I don't know how this could be but I am the network administrator and I have tried it and the server option is stilled greyed out. The computer that has Front Page 2003 is the same computer that has the site on it. Would that matter. I tried it on my comptuer but I have Front Page 2000 and the Security option is greyed out.



BeTheBall -> RE: No results being displayed. (9/24/2004 13:31:17)

And the site is published on a server runnning IIS???



billyd380 -> RE: No results being displayed. (9/24/2004 13:40:51)

Yes



BeTheBall -> RE: No results being displayed. (9/24/2004 13:52:20)

Maybe the server extensions? Try reinstalling them.



billyd380 -> RE: No results being displayed. (9/24/2004 14:01:28)

Nothing, same thing. Should I try reinstalling IIS?



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.109375