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.

Kalina · 02-14-2006, 11:13 PM

I think it's from some open <td>'s.

wulf2001 · 02-15-2006, 03:47 PM

haha very funny colleen

but I am seriously stumped here...

Kalina · 02-15-2006, 03:54 PM

Is that visual basic? I don't know anything about it.

wulf2001 · 02-15-2006, 08:26 PM

well I've kinda fixed the problem... I keep getting an error when I use the pagex variable to select from... For some reason even though the value of pagex is the equivilant of a number I seem to still have to type that number in myself... So instead of going

Select from table1 where number = pagex
i have to type
select from table1 where number = 5

or something like that...
Its pissing the **** *** * *** * *** * *** *** out of my **** * **** ** mind and I cant **** *** handle it.

Kalina · 02-16-2006, 01:21 PM

Wow, I'm lost. What's pagex?

Yep, I know the feeling. I will try to figure something out for hours or it needles my brain...