EOF problem

mcwilliams132 · - Joined: 27 Jul 2003 Posts: 167 Location: Oshkosh, WI

Since I won't get any support from Active HTML, I suppose I'll post here for assistance.

I'm familiar with ASP and have programed a number of sites.

I'm having problem with looping through a recordset with this bit of code. It seems as if ActiveHTML is chocking on it.

<%
While NOT myRS.EOF
Response.Write myRS("xxx") & myRS("yyy")
myRS.MoveNext
Wend
%>

Pretty standard fare for looping through recordsets. Yes I have a connection to my database (MySQL).

I actually get output if I just have it output one record without the looping statement.

If I can't get this going ... I may try PowerServer at http://www.html-helper.com/

Ideas?
_________________
::::::::::::::::::::::::::::::::::::::::::::::::::
:: Jon-Paul LeClair
:: http://mcwilliamsworld.com
:: "Lobster sticks to magnet!"

mcwilliams132 · - Joined: 27 Jul 2003 Posts: 167 Location: Oshkosh, WI

I may have fixed my own problem...I haven't tested it yet but it seems as if AHTML needs an alias or process scripts from it's root directory.

I'm at work so i can't test it out but I'm viewing the sample scripts from the ahtml dir on my site and they're all functioning as you'd expect.

oh boy oh boy!
_________________
::::::::::::::::::::::::::::::::::::::::::::::::::
:: Jon-Paul LeClair
:: http://mcwilliamsworld.com
:: "Lobster sticks to magnet!"

mcwilliams132 · - Joined: 27 Jul 2003 Posts: 167 Location: Oshkosh, WI

no luck...

I tried running my page from the ahtml dir and got the same stupid message.
----------------------------
Microsoft VBScript runtime error- Error '800a01b6'

Object doesn't support this property or method: 'EOF'
---------------------------

I don't understand it. All the ahtml sample files run fine and checking the source on them show them doing the same dang "while not myRS.EOF" loop.

I'm about ready to pull my hair out (whatever's left of it).

I'm sick of Linux/Apache/PHP. I'm used to ASP.

I may as well switch to IIS 5.0 under Win2kPro and try the metadatabase hack to increase the connections. this is rediculous!
_________________
::::::::::::::::::::::::::::::::::::::::::::::::::
:: Jon-Paul LeClair
:: http://mcwilliamsworld.com
:: "Lobster sticks to magnet!"

aprelium · - Joined: 22 Mar 2002 Posts: 6800

mcwilliams132,

Can you please send us your script (and any useful information) to support@aprelium.com . ASP and activehtml are out of the scope of our tech support but we'll try to see what wrong (since the issue seems to be strange).
_________________
Support Team
Aprelium - http://www.aprelium.com

mcwilliams132 · - Joined: 27 Jul 2003 Posts: 167 Location: Oshkosh, WI

Thanks...

I now think it's my problem with the script.

I've been using this line of code to set the SQL Select and the execute the select as such:

mySQL = "SELECT * FROM myBlog"
myRS = myConn.Execute(mySQL)

While NOT myRS.EOF
Response.Write myRS("Date") & myRS("Blog")
myRS.MoveNext
Wend

Now going back over some of my other sites that use the same procedure, I noticed I have to change the EXECUTE LINE to :
SET myRS = myConn.Execute(mySQL)

That's probably what's giving me the "object does not support EOF" error.

After I posted last night, I installed IIS and tried the same script...and got the same error.

I'm sure that if I change that line of code...everything should be fine.

Too much to remember!

Other than that...Abyss is rock solid and all my ASP stuff runs fine from the HTDOCS folder after following your install instructions for AHTML!

I'll post again tonight if all goes well!

Thanks again!
_________________
::::::::::::::::::::::::::::::::::::::::::::::::::
:: Jon-Paul LeClair
:: http://mcwilliamsworld.com
:: "Lobster sticks to magnet!"

mcwilliams132 · - Joined: 27 Jul 2003 Posts: 167 Location: Oshkosh, WI

My problem is solved. And it was a coding probelm on my end.

Everything's working great.
_________________
::::::::::::::::::::::::::::::::::::::::::::::::::
:: Jon-Paul LeClair
:: http://mcwilliamsworld.com
:: "Lobster sticks to magnet!"