It sounds like you're trying to use FarCry functions to retrieve sets of
records. We don't usually bother, and just use cfquery.
On Tue, Nov 25, 2008 at 11:13 AM, Marco van den Oever <
[EMAIL PROTECTED]> wrote:
>
> "Generally we wouldn't use a "select" function, we would do a direct
> query to
> the database."
>
> So does that mean that stating the different parameters is named a
> "select function" and props.whereclause is a direct query to the
> database?
>
> I am very new to this so not understanding every term you use yet :)
>
> Thanks
>
> On Nov 25, 1:01 am, "Blair McKenzie" <[EMAIL PROTECTED]> wrote:
> > Generally we wouldn't use a "select" function, we would do a direct query
> to
> > the database. If this is for a view, the returned items would be
> displayed
> > via a webskin.
> >
> > On Tue, Nov 25, 2008 at 10:25 AM, Marco van den Oever <
> >
> > [EMAIL PROTECTED]> wrote:
> >
> > > Well there is no problem anymore, but i would like the opinion of
> > > someone with more experience about the difference between using
> > > structure keys to define each parameter or just one props.whereclause
> > > and put it all in there.
> >
> > > When using props.whereclause i can put it all in there, when not using
> > > i have to state them all separately.
> >
> > > Is there difference in speed etc?
> >
> > > On Nov 24, 11:09 pm, "Blair McKenzie" <[EMAIL PROTECTED]> wrote:
> > > > What exactly are you trying to do? I can't tell what kind of problem
> > > you're
> > > > trying to solve.
> >
> > > > On Tue, Nov 25, 2008 at 3:02 AM, Marco van den Oever <
> >
> > > > [EMAIL PROTECTED]> wrote:
> >
> > > > > So it really doesn't matter if i do it with setting structure keys
> for
> > > > > the sql statement or just like:
> >
> > > > > <cfset props.whereclause="(abannerclients) IN (SELECT data FROM
> > > > > #application.dbowner#rulebanners_abannerclients WHERE
> > > > > #application.dbowner#rulebanners_abannerclients.parentid =
> > > > > '#stObj.ObjectID#') AND showstatus = 'onviews' AND viewsleft > 0"
> />
> >
> > > > > It uses the same function so speed etc is the same ?
> >
> > > > > Thanks
> >
> > > > > On Nov 24, 3:28 pm, Marco van den Oever <
> [EMAIL PROTECTED]>
> > > > > wrote:
> > > > > > Ok that is important to know, will change the code to structures.
> >
> > > > > > thanks
> >
> > > > > > On Nov 24, 1:39 am, "Blair McKenzie" <[EMAIL PROTECTED]> wrote:
> >
> > > > > > > formtools.cfc is intended to be used by the internals of
> > > objectadmin.
> > > > > I'd
> > > > > > > recommend against using it since it will probably be changed
> when
> > > we
> > > > > decide
> > > > > > > to rewrite objectadmin.
> >
> > > > > > > On Mon, Nov 24, 2008 at 11:21 AM, Marco van den Oever <
> >
> > > > > > > [EMAIL PROTECTED]> wrote:
> >
> > > > > > > > So what's your opinion about get the data with structures, or
> > > with
> > > > > > > > oFormtoolUtil?
> >
> > > > > > > > On Nov 24, 1:19 am, Marco van den Oever <
> > > [EMAIL PROTECTED]>
> > > > > > > > wrote:
> > > > > > > > > ahhhhww application.stCOAPI.xyz.packagepath, how simple can
> it
> > > be
> > > > > > > > > huh ? :)
> > > > > > > > > that for me was the missing link.
> >
> > > > > > > > > Thanks!
> >
> > > > > > > > > On Nov 23, 11:23 pm, "Blair McKenzie" <[EMAIL PROTECTED]>
> > > wrote:
> >
> > > > > > > > > > I'm not sure what you mean by structures. You aren't
> using
> > > any in
> > > > > the
> > > > > > > > > > examples you gave.
> >
> > > > > > > > > > When instantiating a content type or rule you should use
> > > > > > > > > > application.stCOAPI.xyz.packagepath. This will work for
> all
> > > rules
> > > > > and
> > > > > > > > all
> > > > > > > > > > types.
> >
> > > > > > > > > > Regarding formtools, you should never have to reference
> > > > > > > > > > farcry.core.packages.farcry.formtools. Everything you
> need is
> > > > > exposed
> > > > > > > > via
> > > > > > > > > > ft:object. To see how core uses it for edit forms you can
> > > have a
> > > > > look
> > > > > > > > in the
> > > > > > > > > > edit function on the types component.
> >
> > > > > > > > > > Blair
> >
> > > > > > > > > > On Mon, Nov 24, 2008 at 4:43 AM, Marco van den Oever <
> >
> > > > > > > > > > [EMAIL PROTECTED]> wrote:
> >
> > > > > > > > > > > In my attempt to use as much structures as possible i
> am
> > > > > rechecking
> > > > > > > > > > > code that is build with formtools, is it correct that
> using
> > > > > > > > structures
> > > > > > > > > > > is faster?
> >
> > > > > > > > > > > Trying now to use structures instead of query's with:
> >
> > > > > > > > > > > <cfset oFormtoolUtil = createObject("component",
> > > > > > > > > > > "farcry.core.packages.farcry.formtools") />
> >
> > > > > > > > > > > Is it correct that for rule table data you can't
> address
> > > > > without
> > > > > > > > using
> > > > > > > > > > > oFormtoolUtil?
> >
> > > > > > > > > > > You can't connect with:
> >
> > > > > > > > > > > <cfset obj = createObject
> > > > > > > > > > > ('component',application.stcoapi.blablabla.typePath) />
> >
> > > > > > > > > > > as it is not an type.
> >
> > > > > > > > > > > You can't connect directly with:
> >
> > > > > > > > > > > obj.getData(stobj.objectid) (or with additional
> properties)
> >
> > > > > > > > > > > as the stobj.objectid refer to the rule table, so not
> > > directly
> > > > > to the
> > > > > > > > > > > data i need.
> >
> > > > > > > > > > > Even when it works out eventually then you might end up
> > > with a
> > > > > couple
> > > > > > > > > > > of structures to do the same you can do with one
> > > oFormtoolUtil
> > > > > setup.
> >
> > > > > > > > > > > What's your vision on this?
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
