CF to Flex? Also, what do you do instead? You mentioned converting
the query record-set to an Array of Objects or XML. What benefits do you
get on the Flex end for doing this considering its more work for CF?
| Aaron West
| aaron AT trajiklyhip DOT com
| http://www.trajiklyhip.com/blog/
| Certified Advanced Adobe ColdFusion MX 7 Developer
| Certified Macromedia FlashMX Developer
| Adobe Community Expert
On Oct 16, 2006, at 8:55 AM, 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.
<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
<image.tiff>
SPONSORED LINKS
Software development tool
Software development
Software development services
Home design software
Software development company
<x-tad-smaller> Your email settings: Individual Email|Traditional</x-tad-smaller>
<x-tad-smaller>Change settings via the Web</x-tad-smaller><x-tad-smaller> (Yahoo! ID required) </x-tad-smaller>
<x-tad-smaller> Change settings via email: </x-tad-smaller><x-tad-smaller>Switch delivery to Daily Digest</x-tad-smaller><x-tad-smaller> | </x-tad-smaller><x-tad-smaller>Switch to Fully Featured</x-tad-smaller><x-tad-smaller> </x-tad-smaller>
<x-tad-smaller> Visit Your Group </x-tad-smaller><x-tad-smaller> </x-tad-smaller><x-tad-smaller>| </x-tad-smaller><x-tad-smaller>Yahoo! Groups Terms of Use </x-tad-smaller><x-tad-smaller> </x-tad-smaller><x-tad-smaller>| </x-tad-smaller><x-tad-smaller>Unsubscribe </x-tad-smaller>
__,_._,___