Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

prepend a row

New Here ,
Jun 26, 2008 Jun 26, 2008
How to you prepend a blank row to a binded query before the function returns the query?
TOPICS
Advanced techniques
489
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advisor ,
Jun 26, 2008 Jun 26, 2008
You could add the row with the QueryAddRow function, then sort your resultset to get the new row first by using Query of Queries.

QueryAddRow
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_m-r_17.html#134706

Query of Queries
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=using_recordsets_3.html#1157970
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 26, 2008 Jun 26, 2008
LATEST
I think JR "Bob" Dobbs' suggestion does it. However, you should question the need to prepend a blank row. Sounds like an attempt to square the wheel.


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources