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

prepend a row

New Here ,
Jun 26, 2008 Jun 26, 2008

Copy link to clipboard

Copied

How to you prepend a blank row to a binded query before the function returns the query?
TOPICS
Advanced techniques

Views

468

Translate

Translate

Report

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

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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.


Votes

Translate

Translate

Report

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
Documentation