mm ok i thought it was not smart to do so as when you do it with
Farcry functions there will be no problems with differences in mysql
and ms sql etc, so these Farcry functions are not made to do so, i'm
confused now.
for instance i use the below code to get banner id's for the banner
plugin:
<!--- get the banner id's --->
<cfset props = {} />
<cfset props.whereclause="(abannerclients) IN (SELECT data FROM
#application.dbowner#rulebanners_abannerclients WHERE
#application.dbowner#rulebanners_abannerclients.parentid =
'#stObj.ObjectID#') AND showstatus = 'onhits' AND hitsleft > 0" />
<cfset onhits = obj.getMultipleByQuery(argumentCollection=props) />
as i thought this would use the farcry function and therefore also
would process the code right if it was mysql or ms sql.
On Nov 25, 3:38 am, "Blair McKenzie" <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
