Professional Web Applications Themes

cfquery, timeout attribute and cfserver timeout setting - Coldfusion - Advanced Techniques

On our server, CFMX 6.1, we have an option setting for timeout requests as120 seconds. Then in my query, I tried replacing the timeout setting to 300 seconds, but the query always timeouts at 120 seconds. Is there something I miss? How come my query timeouts at the server setting and not my query setting? I just need to know. There has to be a simple or complicated explanation. Any which way that will satisfy my curiousity. Thanks in advance.....

  1. #1

    Default cfquery, timeout attribute and cfserver timeout setting

    On our server, CFMX 6.1, we have an option setting for timeout requests as120
    seconds. Then in my query, I tried replacing the timeout setting to 300
    seconds, but the query always timeouts at 120 seconds. Is there something I
    miss? How come my query timeouts at the server setting and not my query
    setting?

    I just need to know. There has to be a simple or complicated explanation. Any
    which way that will satisfy my curiousity.

    Thanks in advance..

    Telix Guest

  2. #2

    Default Re: cfquery, timeout attribute and cfserver timeoutsetting

    This from
    [url]http://livedocs.macromedia.com/coldfusion/5.0/CFML_Reference/Tags78.htm#1102316:[/url]

    "Optional. The maximum number of milliseconds for the query to execute before
    returning an error indicating that the query has timed-out. This attribute is
    not supported by most ODBC drivers. timeout is supported by the SQL Server 6.x
    or above driver. The minimum and maximum allowable values vary, depending on
    the driver."


    jdeline Guest

Similar Threads

  1. #40750 [NEW]: fsockopen timeout parameter overwrites timeout for reading
    By andreas dot rieber at 2e-systems dot com in forum PHP Bugs
    Replies: 14
    Last Post: March 14th, 07:22 PM
  2. Timeout setting not working
    By tomp in forum Coldfusion Server Administration
    Replies: 4
    Last Post: August 18th, 03:09 PM
  3. Replies: 3
    Last Post: April 29th, 02:21 AM
  4. Timeout sometimes runs past the timeout length
    By Stuart in forum Macromedia Director Lingo
    Replies: 1
    Last Post: August 20th, 04:28 PM
  5. Replies: 0
    Last Post: August 7th, 12:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139