[cfaussie] RE: Error Occurred While Processing Request

[Steve Onnis]

Greg   Thats a pretty big query there, especially is there searchItems are empty.   Maybe try something like this     <cfquery name="Search"  datasource="toolshed" username="" password="">    SELECT  USERID,BILL_FNAME,BILL_LNAME,BILL_COMPANY,BILL_ADDRESS,BILL_CITY,       BILL_STATE,BILL_ZIP,BILL_PHONE,BILL_FAX,BILL_COUNTRY,BILL_EMAIL    FROM  MEMBERS    <cfif Lookup is "Y" AND Len(Trim(searchterms))>     WHERE USERID LIKE '%#searchterms#%' or     BILL_FNAME LIKE '%#searchterms#%' or     BILL_LNAME LIKE '%#searchterms#%' or     BILL_COMPANY LIKE '%#searchterms#%' or     BILL_ADDRESS LIKE '%#searchterms#%' or     BILL_CITY LIKE '%#searchterms#%' or     BILL_STATE LIKE '%#searchterms#%' or     BILL_ZIP LIKE '%#searchterms#%' or     BILL_PHONE LIKE '%#searchterms#%' or     BILL_FAX LIKE '%#searchterms#%' or     BILL_COUNTRY LIKE '%#searchterms#%' or     BILL_EMAIL LIKE '%#searchterms#%'    </cfif>        ORDER BY BILL_LNAME, BILL_FNAME   </cfquery>   I would also be a little weary about using so may OR s in your query.  Lost of load on that   Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9431 4249 http://www.domainconceptdesigns.com [EMAIL PROTECTED] http://www.cfcentral.com.au [EMAIL PROTECTED] ("If you think it can't be done, you haven't asked me!") - Steve Onnis   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 07, 2003 12:13 PM To: CFAussie Mailing List Subject: [cfaussie] Error Occurred While Processing Request Hi hope soemone can shed some light on this one Error issue: I have a site thats been running for a few years and a new error has just poped up that i can seem to tack down.   On just 2 pages in the admin section i get this error. Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) I get no other error message that may help me track this one down. I called the host and they checked the logs and when this page runs  coldfusion server restarts?     The querry on the page looks like this >   <cfparam name="LOOKUP" default="Y">   <cfparam name="SearchTerms" default="">   <cfparam name="TYPE" default="">     <cfquery name="Search"  datasource="toolshed" username="" password="">    SELECT * FROM MEMBERS    <cfif Lookup is "Y">     WHERE USERID LIKE '%#searchterms#%' or     BILL_FNAME LIKE '%#searchterms#%' or     BILL_LNAME LIKE '%#searchterms#%' or     BILL_COMPANY LIKE '%#searchterms#%' or     BILL_ADDRESS LIKE '%#searchterms#%' or     BILL_CITY LIKE '%#searchterms#%' or     BILL_STATE LIKE '%#searchterms#%' or     BILL_ZIP LIKE '%#searchterms#%' or     BILL_PHONE LIKE '%#searchterms#%' or     BILL_FAX LIKE '%#searchterms#%' or     BILL_COUNTRY LIKE '%#searchterms#%' or     BILL_EMAIL LIKE '%#searchterms#%'    </cfif>         ORDER BY BILL_LNAME, BILL_FNAME   </cfquery>   any pointers Thanks in advance regards greg stone --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/