Mike, In your <cfquery> tag around the code below, is there an attribute called "dbtype" and the value equal to "query"?
Teddy R. Payne, ACCFD Google Talk - [email protected] On Mon, Dec 6, 2010 at 5:19 PM, mike barnes <[email protected]> wrote: > Hi everyone, > I am new to Cold Fusion and have been tasked with maintaining an existing > application and am having a little trouble following the code. > Specifically, I am unable to understand the following cfquery snippet and > how the from clause is figuring out what the table is: > ------------------- Code below --------------------- > SELECT * > FROM qryGetVisitRecords > <cfif form.assigned_month_filter neq "" and not listFind("asc,desc", > form.assigned_month_filter)> > , qryGetAssignedMonths > WHERE qryGetAssignedMonths.sitecompany_id = > qryGetVisitRecords.sitecompany_id > ---------------------------------------------------------- > The issue is that I do not have a qryGetVisitRecords table or view. Also, do > not have a qryGetAssignedMonths table or view. So, the question is where to > I find how the query is calculating the table name. And, is there a way to > trap the sql statement so that I can visually inspect it. > > Thanks > Mike Barnes > ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
