Hi Dale, Looking at what you are trying to do, it looks like you want to add a prompt to the combo box.
With in Flex you have the "prompt" attribute on the <mx:ComboBox> tag which can do this, so would mean you don't need to worry about adding the extra row to the Query. EG: <mx:ComboBox prompt="--- Please Select a Value" > </mx:ComboBox> The value will display when nothing is selected, and that option will disappear when a value is selected. My apologies if someone has already told you this, but I hope it helps! Cheers, David On May 14, 8:07 pm, "Dale Fraser" <[EMAIL PROTECTED]> wrote: > I cant really to that unless I use a funky name like (Select an Option) > > As the brackets will then sort first, that works, it's actually kind of what > I am doing now, but through sql im doing this > > select 'null' as data, '(Select Option)' as label > from rsUser > union > select userCode as data, firstName + ' ' +lastName as label > from rsUser > > Still I would prefer not to use the ('s and thought there might be a trick > somehow, like treating the query as an array or stuct and doing an insert > at? > > Regards > Dale Fraserhttp://learncf.comhttp://flexcf.com > > -----Original Message----- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > > Of Zac Spitzer > Sent: Wednesday, 14 May 2008 5:50 PM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Re: queryAddRow > > how about using a QoQ ? with an order column? > > On Wed, May 14, 2008 at 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://flexcf.com > > -- > Zac Spitzer -http://zacster.blogspot.com(My Blog) > +61 405 847 168 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---