Looks like you have a ton of QUERY tags and it's timing out because of it.
Can you clean those up or consolidate them so there aren't so many going on?
On a live server, my apps usually run slower since my dev server is only
running what I ask it to and the live server runs them and everything else
form other accounts. It's probably hitting a max allowance and timing out.
You could also allow more connections in the CF admin.
Joby Bednar
Director of Internet Design
iNEOgroup.com
http://www.ineogroup.com <http://www.ineogroup.com>
Fusing your Dreams and the Web, Together as One
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Cell: 949-283-5138
Personal Fax: 208-485-1170
-----Original Message-----
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 4:10 PM
To: CF-Talk
Subject: page error
Can someone maybe tell me why i get this error on the web but not on my
local machine? its only when this page is run. (both local and web are SQL
7) here is my code:(followed by the error)
<!-- Start Code -->
<!-- Get Name According to Url.ContestantID -->
<cfquery name="GetName"
datasource="#datasource#"
dbtype="ODBC"
username="#username#"
password="#password#">
SELECT *
FROM ContestantManager
WHERE ContestantID = #url.ContestantID#
</cfquery>
<!-- Get Events -->
<cfquery name="GetEvents"
datasource="#datasource#"
dbtype="ODBC"
username="#username#"
password="#password#">
SELECT *
FROM EventManager
</cfquery>
<!-- Get Results -->
<cfquery name="GetResults"
datasource="#datasource#"
dbtype="ODBC">
SELECT RodeoID, EventID, SUM (AdjPoints) as AdjPoints, SUM (Points) as
Points, SUM (MoneyEarned) as TotalMoneyAll, NotAllAround
FROM ResultsManager
WHERE ContestantID = #url.ContestantID#
GROUP BY RodeoID, EventID, NotAllAround
ORDER BY '#GetEvents.EventName#'
</cfquery>
<cfoutput>
<html>
<head>
<title>NSPRA - Contestant Results for #GetName.LastName#,
#GetName.FirstName# (#GetName.Age#)</title>
</head>
<body bgcolor="##FFFFFF">
<table width="590" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="146"><font face="Verdana, Arial, Helvetica, sans-serif"
size="2">Individual Results For:</font></td>
<td width="430"><font face="Verdana, Arial, Helvetica, sans-serif"
size="2">#GetName.LastName#, #GetName.FirstName# (#GetName.Age#)
#GetName.BirthDate# #GetName.CardNumber#</font></td>
</tr>
</table>
<br>
<table width="937" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="137"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Rodeo</font></b></td>
<td width="226"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Event</font></b></td>
<td width="105"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Points</font></b></td>
<td width="122"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Adj. Points</font></b></td>
<td width="118"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Money Won</font></b></td>
<td width="83"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Total Points</font></b></td>
<td width="102"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Include in AllAround (Y/N)</font></b></td>
</tr>
<cfloop query="GetResults">
<tr bgcolor="#IIf(GetResults.CurrentRow Mod 2, DE('FFFFE7'),
DE('99CC99'))#">
<td width="137"><font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><cfquery name="RodeoName" datasource="#datasource#"
username="#username#" password="#password#" dbtype="ODBC">SELECT * FROM
RodeoManager WHERE RodeoID =
'#GetResults.RodeoID#'</cfquery>#RodeoName.RodeoName#</font></td>
<td width="226"><font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><cfquery name="EventName" datasource="rodeo" dbtype="ODBC">SELECT *
FROM EventManager WHERE EventID =
'#GetResults.EventID#'</cfquery>#EventName.EventName#</font></td>
<td width="105"><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">#GetResults.Points#</font></td>
<td width="122"><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">#GetResults.AdjPoints#</font></td>
<td width="118"><font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><cfquery name="EventMoney" datasource="rodeo" dbtype="ODBC"
username="#username#" password="#password#">SELECT MoneyEarned FROM
ResultsManager WHERE EventID =
'#GetResults.EventID#'</cfquery>#NumberFormat(EventMoney.MoneyEarned,"$____.
__")#</font></td>
<td width="83"><font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><!--- #GetResults.TotalPoints# ---></font></td>
<td width="102"><font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><cfif GetResults.NotAllAround EQ "0">Y<cfelseif
GetResults.NotAllAround EQ "1"><b>N</b></cfif></font></td>
</tr>
</cfloop>
<tr>
<td width="137"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Rodeo</font></b></td>
<td width="226"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Event</font></b></td>
<td width="105"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Points</font></b></td>
<td width="122"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Adj. Points</font></b></td>
<td width="118"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Money Won</font></b></td>
<td width="83"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Total Points</font></b></td>
<td width="102"><b><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Include in AllAround (Y/N)</font></b></td>
</tr>
</table>
<br>
<table width="590" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="201"><font face="Verdana, Arial, Helvetica, sans-serif"
size="1">Total Money Won (All Events):</font></td>
<td width="375"><font face="Verdana, Arial, Helvetica, sans-serif"
size="1"><cfquery name="TotalMoney" datasource="#datasource#"
username="#username#" password="#password#" dbtype="ODBC">SELECT SUM
(MoneyEarned) as TotalMoneyAll FROM ResultsManager WHERE ContestantID =
'#url.ContestantID#'</cfquery>#NumberFormat(TotalMoney.TotalMoneyAll,"$____.
__")#</font></td>
</tr>
</table>
</cfoutput>
</body>
</html>
<!-- End Code -->
<!-- Start Error -->
ODBC Error Code = ()
Timed-out trying to get a connection to RODEO. The connection limit has been
reached.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (23:1) to (25:23).
<!-- End Error -->
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
