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?

 

[phreakgrrrl]

im not sure....


i tried what you suggested tho and it gave me only the first artist for A.

then it listed all the other letters but no artists...






~:judy:~

http://www.phreakgrrrl.com

 

[BDC2]

Try this for your loop,

<%
rsLetter.MoveFirst()
rsMenuNames.MoveFirst()
rsPre.MoveFirst()
While (NOT rsLetter(&quot;letter&quot.EOF)
rsLetterVAR = rsLetter(&quot;letter&quot
response.write(&quot;<p><span class='letter'>&quot; & rsLetterVAR & &quot;</span><br>&quot
while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=rsLetterVAR and rsPre(&quot;letter&quot=rsLetterVAR
if rsMenuNames(&quot;author&quot=rsPre(&quot;author&quot then
response.write(&quot;<a href='

http://www.paceprints.com/artistportfolio/artistportfolio.asp?author=&quot;

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

If this doesn't work, your code should be significantly shorter so you might have to paste the whole page for us to work this one out.

BDC.

 

[phreakgrrrl]

hey there.....so i tried your suggestion BDC,

it gave me this error:
Microsoft VBScript runtime error '800a01b6'

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

/artistsTEST.asp, line 97


the line reads...
<%While (NOT rsLetter(&quot;letter&quot.EOF)%>

....

if your willing to help me out ill post the whole code...

any help would be great :-(

~:judy:~

http://www.phreakgrrrl.com

 

[GaryC123]

Aye go on post the whole code, maybe give a link to a sample db so can test it for real

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

 

[phreakgrrrl]

okiday...
here is goes....

*mental coffee cup sent to all who read the whole thing*

<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<!--#include file=&quot;Connections/connPace.asp&quot; -->
<title>Pace Prints | Artists</title>
<% Server.ScriptTimeout=90 %>
<%
set rsMenuNames = Server.CreateObject(&quot;ADODB.Recordset&quot
rsMenuNames.ActiveConnection = MM_connPace_STRING
rsMenuNames.Source = &quot;SELECT DISTINCT author, RIGHT(author, LEN(author) - CHARINDEX(' ', author)) AS lastname, LEFT(RIGHT(author, LEN(author) - CHARINDEX(' ', author)),1) as letter FROM paceprints.stocklist WHERE contemp=1 and canpurchase = 1 and author IN (SELECT DISTINCT author FROM biography) ORDER BY letter, lastname&quot;
rsMenuNames.CursorType = 0
rsMenuNames.CursorLocation = 2
rsMenuNames.LockType = 3
rsMenuNames.Open()
rsMenuNames_numRows = 0
%>

<%
set rsLetter = Server.CreateObject(&quot;ADODB.Recordset&quot
rsLetter.ActiveConnection = MM_connPace_STRING
rsLetter.Source = &quot;SELECT DISTINCT LEFT(RIGHT(author, LEN(author) - CHARINDEX(' ', author)),1) as letter FROM paceprints.stocklist WHERE contemp=1 and canpurchase = 1 and author IN (SELECT DISTINCT author FROM biography) ORDER BY letter&quot;
rsLetter.CursorType = 0
rsLetter.CursorLocation = 2
rsLetter.LockType = 3
rsLetter.Open()
rsLetter_numRows = 0
%>

<%
set rsPre = Server.CreateObject(&quot;ADODB.Recordset&quot
rsPre.ActiveConnection = MM_connPace_STRING
rsPre.Source = &quot;SELECT author, RIGHT(author, LEN(author) - CHARINDEX(' ', author)) AS lastname, LEFT(RIGHT(author, LEN(author) - CHARINDEX(' ', author)),1) as letter FROM paceprints.stocklist WHERE contemp=1 and canpurchase = 1 and author IN (SELECT DISTINCT author FROM paceprints.stocklist) and author IN (SELECT DISTINCT author FROM biography) ORDER BY letter, lastname&quot;
rsPre.CursorType = 0
rsPre.CursorLocation = 2
rsPre.LockType = 3
rsPre.Open()
rsPre_numRows = 0
%>

<!--#include file=&quot;menu/header.inc&quot; -->

<!-- page content -->

<table width=&quot;760&quot; bgcolor=&quot;#ffffff&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; border=&quot;0&quot;>
<tr>
<td rowspan=&quot;2&quot; width=&quot;22&quot;><img src=&quot;images/t.gif&quot; width=&quot;22&quot; height=&quot;1&quot; border=&quot;0&quot;></td>
<td height=&quot;33&quot; colspan=&quot;8&quot;> <img src=&quot;images/titles/artistsonsite.gif&quot; width=&quot;261&quot; height=&quot;33&quot; border=&quot;0&quot;>
</td>

<!-- space -->
<td width=&quot;12&quot; rowspan=&quot;2&quot;><img src=&quot;images/t.gif&quot; width=&quot;12&quot; height=&quot;1&quot;></td>
<!-- /space -->

<!-- divider -->
<td width=&quot;1&quot; bgcolor=&quot;#12477C&quot; valign=&quot;top&quot; rowspan=&quot;2&quot;><img src=&quot;images/whitedot.gif&quot; width=&quot;1&quot; height=&quot;6&quot;></td>
<!-- /divider -->

<!-- space -->
<td width=&quot;4&quot; rowspan=&quot;2&quot;><img src=&quot;images/t.gif&quot; width=&quot;4&quot; height=&quot;1&quot;></td>
<!-- /space -->

<!-- right col -->
<td width=&quot;181&quot; valign=&quot;top&quot; rowspan=&quot;2&quot;>
<!-- ************************************** -->
<center>
<img src=&quot;images/artists-abouttheartists.gif&quot; width=&quot;136&quot; height=&quot;40&quot; border=&quot;0&quot;>
</center>

<p> Click on any artist’s name to view an online portfolio of that artist's
work as available from Pace Prints and PacePrints.com. </p>
<!-- ************************************** -->
<p>&nbsp;</p><table width=&quot;100%&quot; height=&quot;67&quot; border=&quot;0&quot;>
<tr>
<td> <P>To view selected works from our collection <a href=&quot;selectimages.asp&quot; class=&quot;newed&quot;>Click
here</a>.</P></td>
</tr>
</table></td>
<!-- /right col -->

<!-- space -->
<td width=&quot;1&quot; rowspan=&quot;2&quot;><img src=&quot;images/t.gif&quot; width=&quot;1&quot; height=&quot;1&quot;></td>
<!-- /space -->


<!-- border -->
<td rowspan=&quot;2&quot; width=&quot;1&quot; bgcolor=&quot;#12477C&quot;><img src=&quot;images/t.gif&quot; width=&quot;1&quot; height=&quot;1&quot;></td>
<!-- /border -->
</tr>


<tr>


<!-- ********** col one ********** -->
<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 %>

<% if rsLetter(&quot;letter&quot=&quot;C&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>C</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;C&quot; and rsPre(&quot;letter&quot=&quot;C&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;C&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;D&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>D</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;D&quot; and rsPre(&quot;letter&quot=&quot;D&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;D&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;E&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>E</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;E&quot; and rsPre(&quot;letter&quot=&quot;E&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;E&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;F&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>F</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;F&quot; and rsPre(&quot;letter&quot=&quot;F&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;F&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;G&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>G</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;G&quot; and rsPre(&quot;letter&quot=&quot;G&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;G&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>
<img src=&quot;images/t.gif&quot; width=&quot;215&quot; height=&quot;50&quot;> </td>
<!-- ********** /col one ********** -->

<!-- ********** col two ********** -->
<td valign=&quot;top&quot; width=&quot;174&quot;>
<% if rsLetter(&quot;letter&quot=&quot;H&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>H</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;H&quot; and rsPre(&quot;letter&quot=&quot;H&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;H&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;I&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>I</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;I&quot; and rsPre(&quot;letter&quot=&quot;I&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;I&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;J&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>J</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;J&quot; and rsPre(&quot;letter&quot=&quot;J&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;J&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;K&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>K</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;K&quot; and rsPre(&quot;letter&quot=&quot;K&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;K&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;L&quot; then %><% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>L</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;L&quot; and rsPre(&quot;letter&quot=&quot;L&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;L&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;M&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>M</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;M&quot; and rsPre(&quot;letter&quot=&quot;M&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;M&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;N&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>N</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;N&quot; and rsPre(&quot;letter&quot=&quot;N&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;N&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;O&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>O</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;O&quot; and rsPre(&quot;letter&quot=&quot;O&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;O&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;P&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>P</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;P&quot; and rsPre(&quot;letter&quot=&quot;P&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;P&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;Q&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>Q</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;Q&quot; and rsPre(&quot;letter&quot=&quot;Q&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;Q&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;R&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>R</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;R&quot; and rsPre(&quot;letter&quot=&quot;R&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;R&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>
<img src=&quot;images/t.gif&quot; width=&quot;174&quot; height=&quot;50&quot;> </td>
<!-- ********** /col two ********** -->

<!-- ********** col three ********** -->
<td valign=&quot;top&quot; width=&quot;143&quot;>
<% if rsLetter(&quot;letter&quot=&quot;S&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>S</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;S&quot; and rsPre(&quot;letter&quot=&quot;S&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;S&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;T&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>T</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;T&quot; and rsPre(&quot;letter&quot=&quot;T&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;T&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;U&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>U</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;U&quot; and rsPre(&quot;letter&quot=&quot;U&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;U&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;V&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>V</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;V&quot; and rsPre(&quot;letter&quot=&quot;V&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;V&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;W&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>W</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;W&quot; and rsPre(&quot;letter&quot=&quot;W&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;W&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;X&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>X</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;X&quot; and rsPre(&quot;letter&quot=&quot;X&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;X&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>


<% if rsLetter(&quot;letter&quot=&quot;Y&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>Y</span><br>
<% while NOT rsMenuNames.EOF and rsMenuNames(&quot;letter&quot=&quot;Y&quot; and rsPre(&quot;letter&quot=&quot;Y&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;Y&quot; %>
<% rsPre.MoveNext %>
<% wend %>
<% end if %>

<% if rsLetter(&quot;letter&quot=&quot;Z&quot; then %>
<% rsLetter.MoveNext() %>
<p>
<span class=&quot;letter&quot;>Z</span><br>
<% while NOT rsMenuNames.EOF and rsPre(&quot;letter&quot=&quot;Z&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>
<% end if %>
<img src=&quot;images/t.gif&quot; width=&quot;174&quot; height=&quot;50&quot;> </td>
<!-- ********** /col three ********** -->


</tr>

</table>

<!-- /page content -->

<!--#include file=&quot;menu/footer.inc&quot; -->




~:judy:~

http://www.phreakgrrrl.com

 

[GaryC123]

*mental note to self - never invite someone to post all their code*

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

 

[phreakgrrrl]

LOL...
thats why i was hesitating...




~:judy:~

http://www.phreakgrrrl.com

 

[BDC2]

Hey, it's working

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

BDC.

 

[phreakgrrrl]

nah...well yes and no...
i made the page static...
all the links are in but if we add artists or anything i have to go in and change it...

but its something....for now anyway

~:judy:~

http://www.phreakgrrrl.com

 

[BDC2]

Any chance of a sample database in access?

BDC.

 

[phreakgrrrl]

...
no....



~:judy:~

http://www.phreakgrrrl.com

 

[BDC2]

I can't see much wrong with the logic here.

You mentioned an error which came up in your original post. What was the error?

BDC.

 

[phreakgrrrl]

it was a timeout error....
from there it all went to hell

butits not a timeout problem...
at least i dont think it is being as we reset it and all...

i ... i dunno...

i be stumped...



~:judy:~

http://www.phreakgrrrl.com

 

[phreakgrrrl]

ok....so just thought i'd let y'all know...

this little head-ache is over...

turns out there wasnt anything wrong with the code it was something from our database...an item was entered in wrong and screwed the whole thing up....

*scratches head*
i still dont understand it...

thanks for all your help guys!!!

*sends good wishes and tons of caffeine*

~:judy:~

~:judy:~

http://www.phreakgrrrl.com

 

[guineamation]

phreakgrrrl, can you specify what was wrong w/t the DB?
What was the thing that screwed everything up?

I'm having a problem with my DB as well, same page is using 7 different DBs in different languages, and only the Chinese DB is giving me the old "Script timed out" error...

any suggestions?