Quote:
|
Originally Posted by stuckonaproject
yeah, its in the folder the book said to put it in. I wonder why the book didn't tell me to put that bit in? Oh well.. thanks so much for all your help, I can try your advice on Thursady when im next with my project. Fingers crossed, it will work!
|
Ahhh! It still won't work! And the wierd thing is it says the error is on line 10, then shows me line 5. I'll show you the whole code.
<%
dim orseof
set db=server.createobject("adodb.connection")
set orseof=server.createobject("adodb.recordset")
db.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&_Server.MapPath("Staff Qualifications.mdb")
orseof.open "Contact Details",db
orseof.movefirst
response.write"<table boarder='1'>"
response.write"<tr><td>Staff_number</td>"
response.write"<td>Staff_type</td>"
response.write"<td>Employee_name</td>"
response.write"<td>Based_at</td>
response.write"<td>Street_name_and_number</td>
response.write"<td>Area</td>
response.write"<td>Town/city</td>
response.write"<td>Post_code</td>
response.write"<td>Home_phone_number</td>
response.write"<td>Mobile_number</td>
response.write"<td>Email_address</td>
response.write"<td>Inactive_member_of_staff</td></tr>"
do while not orseof.eof
response.write"<td>"&orseof("Staff_number")&"</td>"
response.write"<td>"& orseof("Staff_type")&"</td>"
response.write"<td>"& orseof("Employee_name")&"</td>"
response.write"<td>"& orseof("based_at")&"</td>"
response.write"<td>"& orseof("street_name_and_number")&"</td>"
response.write"<td>"& orseof("area")&"</td>"
response.write"<td>"& orseof("town/city")&"</td>"
response.write"<td>"& orseof("post_code")&"</td>"
response.write"<td>"& orseof("home_phone_number")&"</td>"
response.write"<td>"& orseof("mobile_number")&"</td>"
response.write"<td>"& orseof("email_address")&"</td>"
response.write"<td>"& orseof("inactive_member_of_staff")&"</td>"</tr>"
orseof.movenext
loop
response.write"</table><br>"
%>