Douglas Knudsen wrote: > > > odd. Myself, I prefer not to return queries from CF to Flex. Instead > convert to a array of objects or XML. That said, maybe try using the > SQL for it direct, in case the Query functions are flaking somehow. The > below would be for Oracle.
You can't combine a query of queries with a database query in a single query. My datasource is "application.udf.getalldropdowns", not a database table. And unfortunately, coldfusion requires a "from" clause and there is no dual. Or sysibm.sysdummy1. I suppose I could create a single row query to do the union with... That does work. Still doesn't solve the problem if the first items label field is an empty string. I reversed the order with the empty label at the end and everything was fine.. only when the empty label was the first item... crazy. At any rate, I'm perfectly happy with the solution of my labels being "- not selected -" instead of empty. Rick -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/flexcoders/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/