Re: Cfquery Statements and when are they executed ?????

Hi, as far as I know queries are executed, when they are encountered in the template. so if you put them on the top of the page, first all the queries are executed. You can verify this by looking at the debug output. I would recommend to break the template to small pieces and put each section i

Re: Cfquery Statements and when are they executed ?????

Claude The template is parsed, then executed. The query (and any other) statements are issued as they are encountered. Any queries within a CFIF are only executed if the CFIF is true. You can prove this by constructing a syntactically correct (for CF) query, but one that generates an SQL err

Cfquery Statements and when are they executed ?????

I have a series of cfquery statements at the top of the page as soon as that page is activated does the server take time to search for all those query results or rather does the cf server wait until the query is requested further down the page from that specific cfquery statement before the cfquer