RE: [Junk E-Mail - LOW] Re: [flexcoders] Disappearing list items

[Shannon Hicks]

You don't need to convert a cfquery into an array of objects if you're using CFMX 7.0.2 and flex 2.... it does that for you auto-magically.   Shan From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen Sent: Monday, October 16, 2006 8:55 AM To: flexcoders@yahoogroups.com Subject: [Junk E-Mail - LOW] Re: [flexcoders] Disappearing list items 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. <cfquery name="qry2" dbtype="query">                SELECT                        TABLKEY, TABLFLD                FROM application.udf.getalldropdowns                WHERE                        TABLID = '010'                 UNION                 SELECT '' AS TABLKEY, '' AS TABLFLD                 FROM dual                             ORDER BY TABLFLD        </cfquery> DK On 10/16/06, Rick Root <[EMAIL PROTECTED]lc.com> wrote: so, I solved this problem. My data provider was a query returned by a remoting call created like this:         <cfquery name="qry2" dbtype="query">                 SELECT                         TABLKEY, TABLFLD                 FROM application.udf.getalldropdowns                 WHERE                         TABLID = '010'                 ORDER BY TABLFLD         </cfquery>         <cfset queryaddrow(qry2,1)>         <cfset querysetcell(qry2,"TABLKEY","")>         <cfset querysetcell(qry2,"TABLFLD","")>         <cfquery name="qry" dbtype="query">                 SELECT * FROM qry2 ORDER BY TABLFLD         </cfquery>         <cfset retval.COUNTRIES = qry> I did it this way so I could always have a "blank" item in the dropdown.... The solution was to change the second querysetcell line to be the following:         <cfset querysetcell(qry2,"TABLFLD","- not selected -")> For some reason, the blank item caused every 5th label to disappear for no apparent reason. This seems like a bug.  What's the address to report flex bugs to? 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:flexcoders-digest@yahoogroups.com     mailto:flexcoders-fullfeat[EMAIL PROTECTED].com <*> To unsubscribe from this group, send an email to:      flexcoders-unsubscr[EMAIL PROTECTED]com <*> Your use of Yahoo! Groups is subject to:     http://docs.yahoo.com/info/terms/ -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.408 / Virus Database: 268.13.4/476 - Release Date: 10/14/2006 __._,_.___ -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com SPONSORED LINKS Software development tool Software development Software development services Home design software Software development company Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.408 / Virus Database: 268.13.4/476 - Release Date: 10/14/2006