Have any of you run into this error before?
Query Manipulation Error Code = 0
Unable to instantiate environment for 'QUERY'.
Reason: 30 second timeout limit exceeded.
This code was running just fine a few days ago, today it errors
continuously. Here's the code:
=========================================================
<cfquery datasource="#request.dsn#" name="qGetOrders">
SELECT tblStores.*,tblOrders.*
FROM tblStores,tblOrders
WHERE tblStores.storeID=tblOrders.storeID
ORDER BY storename
</cfquery>
<cfparam name="storename" default="All">
<cfparam name="startdate"
default="#dateformat(dateadd('yyyy','-1',Now()),'mm/dd/yyyy')#">
<cfparam name="enddate" default="#dateformat(Now(),'mm/dd/yyyy')#">
<cfparam name="orderby" default="storeid">
<cfparam name="updn" default="ASC">
<cfparam name="grandtotal" default="0">
<cfquery dbtype="query" name="qNew" timeout="90">
SELECT * FROM qGetOrders
WHERE dateordered BETWEEN '#startdate#' AND '#enddate#' <cfif storename
is NOT "All">AND storename='#storename#'</cfif> ORDER BY #orderby#
#updn# </cfquery>
=========================================================
I thought it could be a query error in the QofQ (qNew) so I removed the
WHERE clause and it still fails. I can output the code from the first
query (qGetOrders) with no problems, so I know that it isn't related to
the first query failing. The initial query returns 173 results - is this
a memory issue or what? It's driving me crazy and I can't find any
information about it on MM.com or in the mail archives.
Any help appreciated!
Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
