Skip to main content
W
wkuo
Participant
June 26, 2008
Question

prepend a row

  • June 26, 2008
  • 2 replies
  • 523 views
How to you prepend a blank row to a binded query before the function returns the query?
This topic has been closed for replies.

2 replies

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
June 27, 2008
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.


J
JR__Bob__Dobbs-qSBHQ2
Inspiring
June 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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices