Re: query of query timing out

your right, i wish they would support so much more in QoQ. i have read that it was not meant to be used in the way that so many people are now trying to use it. but i hope they realise that they have started the need for something that can really help people out and they should really satisfy th

RE: query of query timing out

back. This effect grows exponentially. ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 12:13 PM To: CF-Talk Subject: Re: query of query timing out ok thanks brad, i have taken it out of the from list, you learn something new everyday

Re: query of query timing out

ok thanks brad, i have taken it out of the from list, you learn something new everyday i hadnt realised that by putting that in there that it would think that i am joining it, even if i had not specified any columns from that query but would still attempt to join it. to be honest i thought i ne

RE: query of query timing out

better name for that one). You do not need to have the mergedColumnsQuery query in the from list to do the valuelist() stuff. ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:38 AM To: CF-Talk Subject: Re: query of query timing out i

Re: query of query timing out

i am getting the exact same problem with the following query but cannot see why it is taking so long and what is missing - would also appreciate your help with this one: select query.subjectID,query.projectID,query.testOccasionID,query.subjectHeight,query.subjectWeight from query, merge

Re: query of query timing out

thanks Jochem, no wonder is was timing out!!! thanks for spotting that >Richard White wrote: > >> >> select query.subjectID > >> ,mergedColumnsQuery.#currentColumn# >> >> from query, mergedColumnsQuery >> > >This is an unconstrained / cartesian join. Make sure you have a where >c

Re: query of query timing out

Richard White wrote: >> is there any reason why a basic query of query with only if statements >> and no loops would make the jrun processor shoot up and for it to >> eventually time out > > select query.subjectID > ,mergedColumnsQuery.#currentColumn# > > from query, mergedColum

Re: query of query timing out

i have noticed that if i run the query without the line: mergedColumnsQuery.#currentColumn# and if i dont add the mergedColumnsQuery query onto the from line then it works fine but when i add these then it actually doesnt even time it, it just keeps on loading the page and doesnt ever stop and

Re: query of query timing out

> hi > > is there any reason why a basic query of query with only if statements > and no loops would make the jrun processor shoot up and for it to > eventually time out > > thanks this is the code: select query.subjectID ,query.projectID ,query.testOccasionID