Thanks for the feedback guys.....in the end I actually sat down with the guys and decided that creating a template structure with the date as the key for x number of days, and then looping over the query and updating the non-empty structure values worked the best. This way I have a set container for every date regardless of non-existend ones.
Phil "Rod Higgins" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > > I am praying that this is possible.....can you add a new row to an existing > > query an a certain pointer? > > > > Ie I have a query that returns data for a 7 day period for a graph, however > > if there is no data for one of the days, then only 6 records are returned. I > > want to create an empty row if this is the case, so that the graph still > > shows the days in the correct order woth any blank days included as well. So > > what I am really asking is can you do a QueryAddRow(myQuery, 1) at a certain > > position within the query...ie between rows 4 and 5? > > > > Thanks, > > > > Phil > > Quite easy to do with a java cfx tag or more slowly with cf code. > > If you used a java tag you would simply add a row to the resultset, then > working from the last record backwards shift the data one record down, > then write the data to the required row. > > If you used cf code the easiest way would be to write the old query data > to a new query with the missing row added where needed. > > hth > Rod > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
