lto:ad...@acfug.org] On Behalf Of mike barnes
Sent: Tuesday, December 07, 2010 7:38 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Noob help
The answer to everyones question is yes, the dbtype is "query". So, how do does
one
debug this query of queries, since it appears t
no, the query returned from the first main query is the "table" the query of a
query is selecting from, hence the term "query of a query". Its querying the
recordset returned from the initial query.
__
John Youngman
j...@jg-technologies.net
http://www.linkedin.com/in/john
Hey Mike,
With query of queries, you only have available to you what was returned from
the main query (both in terms of columns and rows).
To figure out where your loosing records, two cfdump's may be the quickest
way (though a pain if the rowset is really large). For example, if query X
is a no
de and not
the other, etc. CF is MUCH more picky than SQL Server when it comes to joining
it's "tables" to each other.
Hope that helps.
Allen
From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of mike barnes
Sent: Tuesday, December 07, 2010 7
The answer to everyones question is yes, the dbtype is "query". So, how do
does one debug this query of queries, since it appears to not be getting all
of the records. Basically, what I would like to do is see what the
underlying sql statement is; so, that I can map back to the database (or is
this
Good tip,
and dont forget to look in any cfm templates that are used in tags
that may lie above the query in question.
Good luck!! :D
__
John Youngman
j...@jg-technologies.net
http://www.linkedin.com/in/johngyoungman
On Dec 6, 2010, at 5:38 PM, Teddy R. Payne wrote
*chuckle*
As you can see, several people are on the same train of thought here.
Another way in the future to try and figure out context of code is to
do some global searches for keywords like "qryGetVisitRecords". This
could provide some code insight as to where the original query exists
and how
Mike,
You are most likely running into an instance of the previous developer using
ColdFusion's "query of queries" functionality. That's what Teddy, John and
Ken are getting at.
Once you retrieve or create a CF query result - usually by running a normal
CF query to a "real" database table, you ca
Mike,
What you are looking at is probably what in CF world is called a "query of
queries".
Does the CFQUERY tag look like this?
This is a built in feature in CF that allows you to run a query against a
result from another query.
So qryGetVisitRecords is probably the name of another query you have
Mike,
In the cfquery statement, is there a dbtype="query" declaration, or is there a
datasource="" statement?
If its a dbtype="query", the that qry snippet is querying another cfquery
written above the one in question.
If a datasource is defined, then check that datasource in the CFAdmin and
Mike,
In your tag around the code below, is there an attribute
called "dbtype" and the value equal to "query"?
Teddy R. Payne, ACCFD
Google Talk - teddyrpa...@gmail.com
On Mon, Dec 6, 2010 at 5:19 PM, mike barnes wrote:
> Hi everyone,
> I am new to Cold Fusion and have been tasked with main
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:
-
12 matches
Mail list logo
