Ok that is awesome, thanks both for your time and the insights :)
On Nov 25, 2:51 pm, "Tomek Kott" <[EMAIL PROTECTED]> wrote:
> if you really wanted to do things with farcry and to be cross-db operable, I
> would suggest having two different sql statements:
>
> 1) SELECT data FROM #application.dbowner# rulebanners_abannerclients WHERE
> #application.dbowner#rulebanners_abannerclients.parentid =
> '#stObj.ObjectID#'
> ---- put that into a list form of with single quotes 'data1,data2,data3'
> etc.
> 2) SELECT whatever FROM wherever WHERE (abannerclients) IN
> (#listFromPrevious#) AND ...
>
> So, you would use farcry to do the selects, and put in the WHERE by hand in
> each case.
>
> That's probably how I would do it knowing that old MySQL doesn't like
> SELECTs within SELECTs.
>
> Tomek
>
> On Tue, Nov 25, 2008 at 8:20 AM, Marco van den Oever <
>
> [EMAIL PROTECTED]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
