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]
