Might be easiest to use QueryNew (create + 1 more than the record count) put in what you want then add the query you were originally adding to...
Alternatively you could use ArrayInsertAt to insert the value in each column. I believe coldfusion treats query columns as array objects, though it may treat the query itself as an array object (for the purpose of the functions), but i am pretty sure Array functions treat query columns as arrays. Good luck :) Chong On May 14, 5:46 pm, "Dale Fraser" <[EMAIL PROTECTED]> wrote: > I need to add a row to a query at position 1. > > queryAddRow takes the number of rows, but they go at the end. > > Anyone have any ideas how to add a row to a query at row 1. > > I want to add a > > None > > Type option to a query that will populate a combo box > > Regards > > Dale Fraser > > http://learncf.com<http://learncf.com/> > > http://flexcf.com<http://flexcf.com/> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---