Some pseudo-sql: client inner join client_arrayfield on objectid=parentid where data=<your value>
Blair On Tue, Jun 2, 2009 at 6:45 PM, AJ Mercer <[email protected]> wrote: > Hmmm, not too sure where to start looking for how to do this... > > I have created an array property which I now want to use in a query > That is, get all clients (custom type) that have subscribed to (the array > field) a passed in value (publication) > > Any pointers / tips would be greatly appreciated. > > > > 2009/6/2 AJ Mercer <[email protected]> > >> had a dig into array.cfc and saw it has a renderType of checkbox >> so now have what I want with just this >> >> <cfproperty ftSeq="100" >> ftFieldset="Publications" >> ftWizardStep="Subscriptions" >> name="aSubscribedTo" type="array" >> default="" hint="Publications Subscribed to" >> ftLabel="Publications" ftType="array" ftJoin="pslPublicationType" >> ftRenderType="checkbox" /> >> >> Which works in the webtop and formtools on the front end >> >> Me so happy :-) >> >> >> Now to work out how to query the array table ... >> >> >> >> 2009/6/2 AJ Mercer <[email protected]> >> >> note sure why my version is not working - copied from farUser >>> <cfproperty ftSeq="100" >>> ftFieldset="Publications" ftWizardStep="Subscriptions" >>> name="aSubscribedTo" type="array" >>> default="" hint="Publications Subscribed to" >>> ftLabel="Publications" >>> ftType="array" ftJoin="pslPublicationType" /> >>> >>> <cfproperty name="lSubscribedTo" >>> type="longchar" default="" hint="Publications Subscribed to (list >>> generated automatically)" >>> ftLabel="Publications" >>> ftType="arrayList" ftArrayField="aSubscribedTo" >>> ftJoin="pslPublicationType" /> >>> >>> >>> The Select Library works, but I am not seeing the list of check boxes. >>> >>> Do I need to create a webskin somewhere? >>> >>> >>> -- >>> AJ Mercer >>> Web Log: http://webonix.net >>> >> >> >> >> -- >> AJ Mercer >> Web Log: http://webonix.net >> > > > > -- > AJ Mercer > Web Log: http://webonix.net > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry -~----------~----~----~----~------~----~------~--~---
