cfgrid

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig77 - 31 Jan 2006 03:14 GMT

hi i am usiong cfgrid to show one of tables,

this works locally, but when on the web i get this error

The request has exceeded the allowable time limit Tag: CFLOOP <br>The error
occurred on line 2153.
any ideas

Reply to this Message

zoeski80 - 31 Jan 2006 04:19 GMT

Craig

The error is pretty self explanatory - the page took too long

* Check that it isn't an infinite loop or infinite cfinclude's
* check how much data it is displayed - use CFDUMP to outupt the query
* are you able to locate link 2153 to see what code is on/around that line
* turn on debugging to output the time taken for queries and for the files to
be run etc to make sure they are all acceptable times
* check what the timeout value actually is to make sure it is large enough:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19438
(this page also includes suggestions on what you can do to find out which bit
of code is taking too long eg. gettickcount() )

HTH

Reply to this Message

Craig77 - 31 Jan 2006 04:26 GMT

Hi Zoe

many thanks for that

is there a way of changing the sort btn in cfgrid, so it sorts lowercase and uppercase together?

Reply to this Message

zoeski80 - 31 Jan 2006 06:03 GMT

Craig

There is a TYPE attribute in the CFGRIDCOLUMN tag with which you can specify
noCase.
So you'll have to define each field using CFGRIDCOLUMN rather than it just
displaying the whole query result.

HTH

<cfgridcolumn name="Last_Name"
        header="Last Name"
        display="yes"
        type="string_noCase"
    >

Reply to this Message

Webmaster Forum / ColdFusion / Advanced Techniques / January 2006

cfgrid