Re: [flexcoders] Disappearing list items

Douglas Knudsen Mon, 16 Oct 2006 07:07:38 -0700

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]> 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

__,_._,___

Re: [flexcoders] Disappearing list items

Reply via email to