RE: [ACFUG Discuss] Noob help

2010-12-07 Thread Charlie Arehart
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

Re: [ACFUG Discuss] Noob help

2010-12-07 Thread John Youngman
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

Re: [ACFUG Discuss] Noob help

2010-12-07 Thread Charlie Stell
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

RE: [ACFUG Discuss] Noob help

2010-12-07 Thread axunderwood
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

Re: [ACFUG Discuss] Noob help

2010-12-07 Thread mike barnes
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

Re: [ACFUG Discuss] Noob help

2010-12-06 Thread John Youngman
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

Re: [ACFUG Discuss] Noob help

2010-12-06 Thread Teddy R. Payne
*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

Re: [ACFUG Discuss] Noob help

2010-12-06 Thread Tom McNeer
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

Re: [ACFUG Discuss] Noob help

2010-12-06 Thread Ken Auenson, II
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

Re: [ACFUG Discuss] Noob help

2010-12-06 Thread John Youngman
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

Re: [ACFUG Discuss] Noob help

2010-12-06 Thread Teddy R. Payne
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

[ACFUG Discuss] Noob help

2010-12-06 Thread mike barnes
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: -