<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
TABLID = '010'
UNION
SELECT '' AS TABLKEY, '' AS TABLFLD
FROM dual
ORDER BY TABLFLD
</cfquery>
DK
On 10/16/06, Rick Root <[EMAIL PROTECTED]> 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:[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/
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it? __._,_.___
--
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
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
__,_._,___