Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query within a query
Thanks! When I got my act together it worked just fine, One remark though: It seems that this syntax works ok <CFQUERY name="combined" dbtype="query"> select getApples.weight as output1 , getApples.origin as output2 ... -
Query within a query
OK, I'm sorry for not beeing clear enough about the problem. Joining tables (outer or inner) from ONE datasource isn't much of a problem but what if you want to join data from TWO or more datasources in ONE query? My colleges and I have been reading discriptions of the new features in CF5 and... -
PASSING VARIABLES BETWEEN PAGES
There are of course a number of ways to do this. The method you should choose is dependant of what kind of an application you are trying to build. What you need to do is to read the CF documentation (no, its not that much), and I sugest that you start with: application variables (carefull... -
Query within a query
I would like to know if its possible to join the resultset of two previous querys in one query within a query. It seems to work fine to loop over one query and join with the other one record at a time but sometimes it would bee nice to bee able to do something like this: <cfquery...
