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]
