portal entry

select a category, or use search below
(searches all categories and all time range)

ColdFusion Query of Queries (Streamline your Processes)

| View in Portal
June 19, 2019 06:41:09 PM GMT
1 Comment
<p>Finding detailed information in a large database can sometimes be a daunting task. Fortunately, with ColdFusion, you make your searches and data pull a breeze with Query of Queries! Utilizing this awesome function is sure to make any CIO or Project Leader’s job easier. In this article, you will learn: What is a Query of Queries? What are the benefits of using a Query of Queries? How to conduct a Query of Queries. What are some functionalities of ColdFusion Query […]</p>
<p>The post <a rel="nofollow" href="https://coldfusion.adobe.com/2019/06/coldfusion-query-queries-streamline-processes/">ColdFusion Query of Queries (Streamline your Processes)</a> appeared first on <a rel="nofollow" href="https://coldfusion.adobe.com">ColdFusion</a>.</p>
Labels: CF2018 Updates, ColdFusion 2018, Question, Advanced, cf2018 updates, coldfusion 2018, question


When manipulating values within a QofQ, it's important to use Javacast() to retain the original datatype.  If not, querying the QofQ may throw an error. When querying for a text string, the comparison is case-sensitive. Use lower() or upper() or query columnnames in SQL to perform case-insensitive queries. Many more tips are available here: <a href="https://helpx.adobe.com/coldfusion/developing-applications/accessing-and-using-data/using-query-of-queries/query-of-queries-user-guide.html" rel="nofollow">https://helpx.adobe.com/coldfusion/developing-applications/accessing-and-using-data/using-query-of-queries/query-of-queries-user-guide.html</a>
Comment by James Moberg
2131 | June 20, 2019 03:16:29 PM GMT