I posted a few days ago about having multiple cfquery statements in the same
document. After some troubleshooting, I finally figured out how to do this. I
began building my test form, which is populated from fields in a database, I'm
running into a problem where the data is just being repeated,
My Code: (link to live page -
http://www2.ccboe.com/summeracademy/app/emp/index.cfm)
SELECT SchNum, SchoolBrief
FROM SCHOOLS
ORDER BY SchoolBrief
SELECT ApplySubject, ApplySchool, School, ApplyPosition, YrsPartic, TshirtSize
FROM ApplySchoolList, SRAStaff, ApplySubjectGrList, YrsPartic
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 reference
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 wrote:
>
> Your second query is the problem
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 wan
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 wrote:
>
> Barney, would that require that the di
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:
http://www.houseoffusion.com/groups/cf-
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
tag
You can put a inside of a 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 I wanted it to. Now, I'm t
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 form.
I.E.
Just realize with this from CF is not going to automatically scope the
query column names for you an
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:
#getSchools.SchoolBrief#
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 pr
12 matches
Mail list logo