ASP error 0113 time out error...

[phreakgrrrl]

hey all...

so out of nowhere this error came up on one of my pages...

then when we reloaded the page...it started to load correctly but since we're pulling items up from a database what it looks like now is that its incomplete...

to be more specific...

its an artists list page...

http://www.paceprints.com/artists.asp

it reloaded with only the a's..

ive been searching online and they say that it might be a loop...
???
at first we though it was a timeout error but when we extended the time and reloaded the page it didnt help..

so now i'm lost cause im not sure after looking at the page ...where the error could be...

can anyone shed some light?

 

[BDC2]

Is this being pulled from a database? - I would check your database first to make sure it contains more than just the A's which are displayed.

What error did you get on your page, and was it writing to the database at the time?

You will need to post some code, preferable your connection setting up your recordset and the loop to display the items.

BDC.

 

[BDC2]

I've done a search on the site and it looks like the db contains all the artists, it must be the loop to display the items. Please post code.

BDC.

 

[phreakgrrrl]

im not sure where the loop could be....

heres a bit of the code...

thanks for any help...




<td valign=&quot;top&quot; width=&quot;215&quot;>
<% if rsLetter(&quot;letter&quot=&quot;A&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>A</span><br>
<% rsMenuNames.MoveFirst() %>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;A&quot; and rsPre(&quot;letter&quot=&quot;A&quot; %>
<% if rsMenuNames(&quot;author&quot=rsPre(&quot;author&quot then %>
<a href=&quot;

http://www.paceprints.com/artistportfolio/artistportfolio.asp?author=<%=

Server.urlEncode( rsMenuNames(&quot;author&quot ) %>&quot; class=&quot;newed&quot;><%= rsMenuNames(&quot;author&quot %></a><br>
<% rsMenuNames.MoveNext %>
<% rsPre.MoveNext %>
<% else %>
<% rsPre.MoveNext %>
<% end if %>
<% wend %>
</p>
<% while rsPre(&quot;letter&quot=&quot;A&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;B&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>B</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;B&quot; and rsPre(&quot;letter&quot=&quot;B&quot; %>
<% if rsMenuNames(&quot;author&quot=rsPre(&quot;author&quot then %>
<a href=&quot;

http://www.paceprints.com/artistportfolio/artistportfolio.asp?author=<%=

Server.urlEncode( rsMenuNames(&quot;author&quot ) %>&quot; class=&quot;newed&quot; ><%= rsMenuNames(&quot;author&quot %></a><br>
<% rsMenuNames.MoveNext %>
<% rsPre.MoveNext %>
<% else %>
<% rsPre.MoveNext %>
<% end if %>
<% wend %>
</p>
<% while rsPre(&quot;letter&quot=&quot;B&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

 

[BDC2]

That's going to be one big piece of code!!

A quick fix for this would be to add this line...

<% rsMenuNames.MoveFirst %>

...before this line...

<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;B&quot; and rsPre(&quot;letter&quot=&quot;B&quot; %>

You will have to do this for every letter.

If you just want to get it to work, this should do it, but there is a better way of doing this using loops, you may have to to some research.

Let me know if this helps,

BDC.

 

[BDC2]

eek sorry, I missed the brackets, the lines of code to add should be:

<% rsMenuNames.MoveFirst() %>

BDC.

 

[phreakgrrrl]

lol

yeah i guess it was alot to post up...

(((giggle)))

ill try that and let ya know how it goes...

 

[GaryC123]

I would definitely say do a loop using CHR(), prob make it easier to debug just one block of code

http://www.intouch-media.co.uk

 

[phreakgrrrl]

doh!

ok..well...the quick fix didnt seem to do it.....

*pout*

 

[GaryC123]

Should it be listing all artists, running thru from A to Z?
Your code is a little confusing.

http://www.intouch-media.co.uk

 

[phreakgrrrl]

any ideas?


or can anyone maybe quickly shed some light on what the loops will entail...i um....i dont know a thing about them and if thats whats needed ill need any shove in the right direction...

thanx!!!

 

[phreakgrrrl]

yes...

A-Z...


and it was up until a few days ago...

*scratches head*

 

[GaryC123]

Cant really test this properly but try replacing all your A-Z code with just this

<%
for count=65 to 90 %>
<p><span class=&quot;letter&quot;><%=chr(count)%></span><br><%
rsMenuNames.MoveFirst()
while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=chr(count)
if rsMenuNames(&quot;author&quot=rsPre(&quot;author&quot then %>
<a href=&quot;..blah blah...&quot;></a><br><%
end if
rsMenuNames.MoveNext
wend %>
</p><%
next %>

http://www.intouch-media.co.uk

 

[phreakgrrrl]

i shall give it a try....

 

[GaryC123]

No forget that. What does rsMenuNames and rsPRe contain ?
Trying to follow the logic of your statement

Runs thru rsMenuNames checking at start letter A then B...
If rsMenuNames(&quot;author&quot=rsPre(&quot;author&quot
or in other words
If Authorname=Authorname
mmm.

http://www.intouch-media.co.uk

 

[BDC2]

There are 3 recordsets in there
rsMenuNames, rsPre and rsLetter and I'm not sure what they are all doing!

BDC.

 

[GaryC123]

Ok unless I'm missing something blatanly obvious here...

' your select statement
sql=&quot;Select author from yourauthortable order by letter&quot;
<%
for count=65 to 90
while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=chr(count) %>
<p><span class=&quot;letter&quot;><%=chr(count)%></span><br>
<a href=&quot;

http://www.paceprints.com/artistpor...<%=rsMenuNames(&quot;author&quot;)%>&quot;><%

rsMenuNames.MoveNext
wend %>
</p><%
next %>

http://www.intouch-media.co.uk

 

[GaryC123]

Change this bit

<a href = '

http://www.paceprints.com/artistpor...author=<%=rsMenuNames(&quot;author&quot;)%>'>

http://www.intouch-media.co.uk

 

[phreakgrrrl]

oi!...

having problems here guys...

this isnt my code im dealing with...

and being as said person is not available...i kind of have to make a miracle happen here...


in other words...any further advice would be GREAT!!!

thanks

~:judy:~

 

[GaryC123]

That code should be
for count=65 to 90
while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=chr(count) %>
<p><span class=&quot;letter&quot;><%=chr(count)%></span><br>
<a href = '

http://www.paceprints.com/artistpor...author=<%=rsMenuNames(&quot;author&quot;)%>'>

><%= rsMenuNames(&quot;author&quot %></a><br>
<%
rsMenuNames.MoveNext
wend %>
</p><%
next %>

Your rsMenuNames recordset is pulled from a table that contains all the Artists names and there is also a field called 'letter' which I assume is the first letter of the artists band.
Correct ?
From what I see above all you are doing is listing them alphabetically with an hyperlink assigned to their name
Correct ?

What is your SQL statement?

http://www.intouch-media.co.uk