One option would be to define a dummy table with one field, and create 7 records in that table, with values 1 through 7. You can then do an outer join (optional linkage) from the dummy table to your data, matching on the value 1 through 7. If you data record is missing, the outer join will still return a record.
Another option is to load the records into a list or array, and then manipulate from there. Cheers, Phil. ----- Original Message ----- From: "Phil Rasmussen" <[EMAIL PROTECTED]> Newsgroups: cfaussie To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 1:01 PM Subject: [cfaussie] Adding a new row to a query at a certain pointer? > 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 > > > > --- > 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/ > --- 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/
