On Mon, 09 Aug 2004 17:11:08 -0400, Barry Lloyd <[EMAIL PROTECTED]> wrote:
> Here is the Query. It conditionally builds the sql based on input.
> Probably not the best way , but I am the newbie. I tried raising the
> timout, but this has no effect.
>
> Barry
>
> <cftry>
> <cfquery name="pat_query" datasource="SCDMH1" timeout="300"
> blockfactor="100" debug="1" username=#session.login#
> password=#session.passwd#>
> select patient.cid,
> patient.lname,patient.fname,patient.dob,race.descr
> race_descr,patient.sex , admission.admdat, discharge.dischrgdat
> from patient,race,admission,advoc
> , outer discharge where patient.race = race.code and
> admission.cid = patient.cid
> and admission.admno = (select max(admno) from admission where
> admission.cid
> = patient.cid) and admission.dmhfacil = advoc.dmh and
> advoc.logname=user
> and admission.admno = discharge.admno and
> <cfif url.cid neq ''>
> patient.cid =
> <cfqueryparam value="#url.cid#" cfsqltype="CF_SQL_INTEGER">
> <cfelse>
> <cfif url.lname neq ''>
> patient.lname matches '#ucase(url.lname)#'
> </cfif>
> <cfif url.fname neq ''>
> <cfif url.lname neq ''>
> and patient.fname matches '#ucase(url.fname)#'
> <cfelse>
> patient.fname matches '#ucase(url.fname)#'
> </cfif>
> </cfif>
> </cfif>
> order by lname, fname
> </cfquery>
> <cfcatch type="database">
> <cfoutput>#cfcatch.sql# #cfcatch.detail#</cfoutput>
> </cfcatch>
> </cftry>
>
> >>> [EMAIL PROTECTED] 08/09/04 05:04PM >>>
> Can you show us example code please?
>
> On Mon, 09 Aug 2004 16:51:17 -0400, Barry Lloyd <[EMAIL PROTECTED]>
> wrote:
> > I'm using Coldfusion MX 6.1 on a Redhat ES 3 with Apache/2.0.46.
> > Database is Informix 9.2. I have a query that if the execution time
> > exceeds 30 seconds, I get no result set. I do not receive any
> errors,
> > nothing is logged in the log files. The RecordCount is 0. If the
> query
> > executes in less than 30 seconds, I get the result set. This query
> is a
> > query of patients based on input from a form. If you use the name
> SMITH
> > in the query, it takes 41 seconds to process the query with
> recourdcount
> > = 0. If I copy the sql from the debug info and run it in ISQL
> > (informix-SQL) , 505 records returned. What am I doing wrong??????
> >
> > Barry Lloyd
> > SC. Dept. of Mental Health
> >
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
