> 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/
