I was wondering if the was a Farcry method to do it? Otherwise, yes, I will right my own SQL.
2009/6/3 Blair McKenzie <[email protected]> > 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 >> >> >> > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
