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
