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
