Hmmm... if it is a query of query, then you are limited to what the parent query (sorry, don't really know what the first query from DB is called...) has. So, even if a row of data does exist in a table, if that row of data is not pulled by the parent query, then there is no way how you can get it through any query of query based on the parent query.
Now, if you look at the query result of the parent query, is the desired row of data in it? On Tue, Jul 8, 2008 at 3:04 PM, Richard White <[EMAIL PROTECTED]> wrote: > hi > > i have a query in cf and want to run another very simple query on it and > for some reason it is not getting the data that i know is in there: > > first i am running this query (i am using query of query for these > queries): > > select qu_80_tb_89_split_0_split_T_Wt from mergedColumnsQuery where > subjectID = 446 and projectID = 36 and testOccasionID = 2 and > qu_80_tb_89_split_0_split_T_Ht is null and qu_82_tb_89_split_0_split_T_Ht = > 147.0; > > and it is returning a value that i know that is in there. > > but then when i run the following statement which is identical to the one > above except a couple of changes in the where clause it doesnt produce any > data although i have checked the data many times and it should definately > return a result: > > select qu_80_tb_89_split_0_split_T_Wt from mergedColumnsQuery where > subjectID = 447 and projectID = 36 and testOccasionID = 2 and > qu_80_tb_89_split_0_split_T_Ht is null and qu_82_tb_89_split_0_split_T_Ht = > 142.2; > > thanks for any suggestions > > richard > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4