I got my original form to output the way I wanted it to. Now, I'm trying to
actually process and validate that form and I'm running into more errors. I
sort of know what I'm doing wrong, but unclear how to fix it.
Here is my error: Invalid tag nesting configuration. A query driven CFOUTPUT
You can put a CFLoop query=foo inside of a cfoutput query=moo tag.
-Original Message-
From: Steven Sprouse [mailto:sspro...@ccboe.com]
Sent: Tuesday, March 16, 2010 10:39 AM
To: cf-talk
Subject: Re: Repeating Data - Unsure of my use of cfquery
I got my original form to output the way
cfoutput query=aQuery
cfoutput query=bQuery
/cfoutput
/cfoutput
That is illegal because ColdFusion does some automatic variable scoping
that would just not work in such a situation. To do this you have to
use the cfloop query... form.
I.E.
cfoutput
cfloop query=aQuery
cfloop
Just so I'm clear, are you saying that I need to change my
#aQuery.aColumn[aQuery.currentRow]# formatting within the form? For example, I
need to change this:
cfoutput query=getSchools
option
On 3/16/2010 8:22 AM, Steven Sprouse wrote:
If so, what is the currentRow value? Just a little confused there.
currentRow is one of the values provided by ColdFusion about its query
objects, just like columnList and recordCount. It is simple the current
row of the record set that is being
My Code: (link to live page -
http://www2.ccboe.com/summeracademy/app/emp/index.cfm)
cfquery name=getSchools datasource=filemaker_schools
SELECT SchNum, SchoolBrief
FROM SCHOOLS
ORDER BY SchoolBrief
/cfquery
cfquery name=getSrastaff datasource=filemaker_srmastaff
SELECT ApplySubject,
Your second query is the problem, both the repeating data and the
slowness. You have a full outer join of five tables, which is not
what you want. You need inner joins. Here is a simple reference that
might help you on your way:
http://www.sql-tutorial.net/SQL-JOIN.asp
Has a million
Looking at the way the data are used, the OP probably needs five queries.
The queries are just building options in select inputs.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
On 15 March 2010 22:36, Barney Boisvert bboisv...@gmail.com wrote:
Your second
Barney, would that require that the different tables have a linking
relationship? I think that's my problem. There is no common field shared among
these tables.
~|
Want to reach the ColdFusion community with something they
Just separate each table into its own query. Use the data from the right
table in the right place and the problem is solved.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
On 15 March 2010 22:39, Steven Sprouse sspro...@ccboe.com wrote:
Barney, would that
You guys are awesome. Sometimes it's the easiest things...
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
11 matches
Mail list logo