RE: [flexcoders] Disappearing list items

[Shannon Hicks]

I see two things I'd do differently...   1. querysetcell takes three arguments... querycetcell(query,column,value,row) 2. you don't need to do the query of a query at the end.... you can just do <cfset retval.COUNTRIES = qry2>   Shan From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Rick Root Sent: Monday, October 16, 2006 8:04 AM To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] Disappearing list items 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 -- 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