|
-
Can Someone have a look & help??
i am having some connection problems which i do not understand all.
Error Type:
Active Server Pages, ASP 0126 (0x80004005)
The include file 'functions.inc' was not found.
/Staff.asp, line 1
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
Page:
GET /Staff.asp
i have a
functions.inc
<html>
<head>
<title></title>
</head>
<body>
<%
Function NewConn()
Set NewConn= Server.CreateObject("ADODB.Connection")
NewConn.ConnectionTimeout=100
NewConn.Open "Provider=sqloledb;Data Source=[porsche];uid=[sa ];pwd=[topland]"
NewConn.CommandTimeout=1200
End Function
%>
</body>
</html>
Staff.asp
<!--#INCLUDE FILE="functions.inc"-->
Set objConn = NewConn()
objConn.execute SQLstatement
<HTML>
<HEAD>
<TITLE>Staff Info</TITLE>
</HEAD>
<BODY>
<%
SQL = "SELECT * FROM Staff where Staff ID=" & request("Staff ID")
DbConn = Server.CreateObject("ADODB.Connection")
DSName = Session("192.168.160.1.db") DbConn.Open("192.168.160.1.db;")
RS = DbConn.execute(SQL)
%>
<font size="+3" face="arial"><%=rs("Name")%></font><hr>
<table>
<tr>
<td>
<A href="updateStaff.asp?Customer ID=<%=RS("Staff ID")%>Update</a><br>
<td>
<A href="deleteStaff.asp?Staff ID=<%=RS("Staff ID")%>Delete</a><br>
<td>
<A href="addStaff.asp?SID=<%=RS("Staff ID")%>Add</a><br>
</td>
</tr>
</table>
<a href="javascript:history.back(1)">Back Button</A>
<a href="javascript:history.forward(1)">Forward Button</A>
</BODY>
</HTML>
i want it to retrieve all staff then from there one will be able to add, update or delete
-
there are goo dinclude tutorial around... search for that. The syntax an dth efile location might not be correct.
Fk
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote