Webmaster Forum - View Single Post - URGENT HELP!!! simple problem but I cant fix it...

wulf2001 · 02-14-2006, 06:04 PM

I'm having some serious problems... well not serious its probably pretty basic, just like the problems I have in class... funny when u ask for help and the professor points out a spelling error DOH!! anyways heres my little problem...

I keep getting this error on my asp page...

Error Type:
Provider (0x80004005)
Unspecified error
/indifini/connection.inc, line 4

I also get the error below sometimes right after I make a change save and then refresh the page... but it goes away if I refresh the error page and up comes the one above...

Error Type:
Microsoft VBScript runtime (0x800A01A

Object required: 'recset'
/indifini/test.asp, line 8

LINE 4 is the dim line and con is the variable for the connection to my database. PLEASE HEELLLLLPPP!!!! HEELLLPPP A POOR POOR NOOBIE!!!

now here is my code



<%
dim pagex, recsetx, beginx
pagex = Request("page")
set recsetx = Server.CreateObject("ADODB.Recordset")
beginx = "SELECT * FROM Table1 WHERE number = " & pagex & ""
recset.open beginx , con

%>
<html>
<body>
<%
do until recset("number") = page + 9 or recset.EOF
response.write recset("conx")
response.write "<br>"
recset.movenext
loop

%>

<a href="test.asp?page=<% = pagex + 9 %>">NEXT</a>
<% = pagex %>
<br><br>

</body>

</html>

P.S - for those of you wondering WTF is that... I'm trying to make my own little paging script... just a young web mage trying to fill up his spell book. Its obviously going to be more complex than this but I gotta start somewhere.

02-14-2006, 06:04 PM	#1 (permalink)
wulf2001 Inactive Join Date: 08-01-05 Posts: 199 iTrader: 0 / 0% Latest Blog: None	URGENT HELP!!! simple problem but I cant fix it... I'm having some serious problems... well not serious its probably pretty basic, just like the problems I have in class... funny when u ask for help and the professor points out a spelling error DOH!! anyways heres my little problem... I keep getting this error on my asp page... Error Type: Provider (0x80004005) Unspecified error /indifini/connection.inc, line 4 I also get the error below sometimes right after I make a change save and then refresh the page... but it goes away if I refresh the error page and up comes the one above... Error Type: Microsoft VBScript runtime (0x800A01A Object required: 'recset' /indifini/test.asp, line 8 LINE 4 is the dim line and con is the variable for the connection to my database. PLEASE HEELLLLLPPP!!!! HEELLLPPP A POOR POOR NOOBIE!!! now here is my code <!--#include file = "connection.inc" --> <!--#include file="adovbs.inc"--> <% dim pagex, recsetx, beginx pagex = Request("page") set recsetx = Server.CreateObject("ADODB.Recordset") beginx = "SELECT * FROM Table1 WHERE number = " & pagex & "" recset.open beginx , con %> <html> <body> <% do until recset("number") = page + 9 or recset.EOF response.write recset("conx") response.write "<br>" recset.movenext loop %> <a href="test.asp?page=<% = pagex + 9 %>">NEXT</a> <% = pagex %> <br><br> </body> </html> P.S - for those of you wondering WTF is that... I'm trying to make my own little paging script... just a young web mage trying to fill up his spell book. Its obviously going to be more complex than this but I gotta start somewhere.