At 03:00 PM 5/26/2004, you wrote: >You can put whatever you want in a query object, but if you want to perform >a QofQ on a query, it needs to hold valid SQL datatypes. However, if yo've >got a uniqueID in you query (likely), then you can use a separate struct to >hold your complex data using that key, and retain the ability to do QofQs on >the query object.
Thanks, that's what I surmised. I actually went with the query to avoid having to do the struct/unique key route. Doing a quick Q of Q allows you to index the CFC by other query columns for fast access (rather than iterate over a struct, extract the an inspect each CFC instance). Thanks for the response. -- Alex Sherwood >Cheers, >barneyb > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Alexander Sherwood >> Sent: Wednesday, May 26, 2004 11:46 AM >> To: [EMAIL PROTECTED] >> Subject: [CFCDev] CFCs and Queries >> >> I was under the impression that CF queries can hold any CF >> datatype (structs, arrays, strings, etc.). I am able to store >> a CFC in a query and CFDUMP the query to confirm the CFC has >> in fact been added to the column correctly. >> >> If I try to perform a query of the above query, however, CF >> throws a Q of Q error, stating an "Unknown java type". >> >> Am I missing something, or does CF allow you to store CF data >> types in a query and dump it, but not perform a select from >> the query?! >> >> Thanks, >> >> ---------------------------------- >> Alex Sherwood >> PHS Collection Agency >> THE COLLECTORS >> P: 813-283-4579 >> F: 301.664.6834 >> W: www.phs-net.com >> >> ---------------------------------------------------------- >> You are subscribed to cfcdev. To unsubscribe, send an email >> to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' >> in the message of the email. >> >> CFCDev is run by CFCZone (www.cfczone.org) and supported >> by Mindtool, Corporation (www.mindtool.com). >> >> An archive of the CFCDev list is available at >> www.mail-archive.com/[EMAIL PROTECTED] >> > >---------------------------------------------------------- >You are subscribed to cfcdev. To unsubscribe, send an email >to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' >in the message of the email. > >CFCDev is run by CFCZone (www.cfczone.org) and supported >by Mindtool, Corporation (www.mindtool.com). > >An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
