I think you have to structure your own specific needed inner joins or sub queries, then you can use farcry's sqlwhere="" to put those in there.
On Jun 3, 2:20 am, AJ Mercer <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
