Ok thanks for this insight, so as i understand it, there is not really
a method to create such code as above that will always work an each
version of mysql and ms sql, bit like design in different browsers so
to speak?
On Nov 25, 4:00 am, "Blair McKenzie" <[EMAIL PROTECTED]> wrote:
> Not really. In fact one of the issues that MySQL dbs can have is with
> subqueries like you're using (mostly older versions).
>
> But for the DBs that FarCry officially supports, the kinds of queries most
> people write won't be an issue.
>
> On Tue, Nov 25, 2008 at 1:53 PM, Marco van den Oever <
>
> [EMAIL PROTECTED]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
