| Author |
 Topic  |
|
|
Suamere
Starting Member
27 Posts |
 Posted - 02 January 2005 : 20:45:57
|
Web URL: www.HyruleRP.com/MemberForm.asp
You see a list of members, short but sweet
You see a long list of blank spaces.
Those blank spaces are the outcome of the HTML Form. Doesn't matter what you put, the page freezes, and there is no input into the database. I try to do the "insert record" thing, but it just isn't working, no matter what way I do it. Should I post the asp code here, or email it or what, I need a lil help. The database is obviously opening, it's displaying the members table. What's wrong?
~Suamere |
If something goes wrong, find the source of the problem and break it's legs. |
|
|
Suamere
Starting Member
27 Posts |
Posted - 02 January 2005 : 22:27:39
|
Here is the Script for my page at www.HyruleRP.com/MemberForm.asp...
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=windows-1252">
<TITLE>MemberForm</TITLE>
</HEAD>
<BODY>
<%
If IsObject(Session("HRPDB_conn")) Then
Set conn = Session("HRPDB_conn")
Else
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "HRPDB","",""
Set Session("??HRPDB_conn") = conn
End If
%>
<%
If IsObject(Session("MemberForm_rs")) Then
Set rs = Session("MemberForm_rs")
Else
sql = "SELECT * FROM [Members]"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
If rs.eof Then
rs.AddNew
End If
Set Session("MemberForm_rs") = rs
End If
%>
<TABLE BORDER=1 BGCOLOR=#ffffff CELLSPACING=0><FONT FACE="Arial" COLOR=#000000><CAPTION><B>MemberForm</B></CAPTION></FONT>
<THEAD>
<TR>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:10pt FACE="Arial" COLOR=#000000>Field1</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT style=FONT-SIZE:10pt FACE="Arial" COLOR=#000000>Field2</FONT></TH>
</TR>
</THEAD>
<TBODY>
<%
On Error Resume Next
rs.MoveFirst
do while Not rs.eof
%>
<TR VALIGN=TOP>
<TD BORDERCOLOR=#008080 ><FONT style=FONT-SIZE:8pt FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Field1").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#008080 ><FONT style=FONT-SIZE:8pt FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("Field2").Value)%><BR></FONT></TD>
</TR>
<%
rs.MoveNext
loop%>
</TBODY>
<TFOOT></TFOOT>
</TABLE>
<form name="YourFormName" method="Post" action="MemberForm.asp">
<table>
<tr><td>ScreenName</td>
<td><input type="text" name="ScreenName" size="50"></td></tr>
<tr><td>Character Name</td>
<td><input type="text" name="Character" size="50"></td></tr>
</table>
<input type="submit" name="Submit" value="Submit">
<%
rs.AddNew
rs.Field("Field1").Value = Request.Form("ScreenName")
rs.Field("Field2").Value = Request.Form("Character")
rs.Update
%>
<%
rs.Close
Set rs = Nothing
conn.Close
conn = Nothing
%>
</BODY>
</HTML>
Please Help? |
 |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 03 January 2005 : 14:11:25
|
Are you talking about this error?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
/MemberForm.asp, line 12
If so it sounds like either the db is open on the web server or its maybe locked being uploaded. If you have access to the server just restart the server and it will fix it. If you don't have access to the server I would just upload try reuploading the database and if that does not work rename the database on your local pc then upload it and change the database name in the config.asp file. |
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets |
|
|
| |
Topic |
|
|
|
Topic Locked
