Assuming you have a query that is ordered by day of week, you can loop over the query and use queryAddRow() to add rows with the appropriate data for an empty day.
Once you have the query in a format that has 7 rows, you can use Query of Query to order it correctly for all 7 days. Spike Stephen Milligan Consultant for hire http://spikefu.blogspot.com > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Phil Rasmussen > Sent: 05 March 2003 13:01 > To: CFAussie Mailing List > 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/
