|
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
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/ |
