> Thanks for the explanation, Isaac!
Also just FYI, although referential integrity is desired in most
cases, there are some exceptions in which you may not want to enforce
referential integrity. Typically the only place you would want to
allow orphaned records would be in a logging tool or in a re
> Thanks for the explanation, Isaac!
Glad to help. :)
s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm
~~
Thanks for the explanation, Isaac!
According to your explanation, I actually did
have a problem with referential integrity.
I had been manipulating the data in the database
manually over several weeks working on the
queries for output and had not built in the safeguards
to prevent destroyed refer
> The first...bad data...I had previously entered data
> for another test run of this application and, I guess,
> somewhere along the way I deleted some of the data
> from some of the tables, so the data lacked
> referential integrity. (I think that's the right term...)
That depends on the state
Ah, of course.
On 4/2/06, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> > CFERROR templates work for compile errors too. I tried it
> > before posting (of course), on CF 6.1, and this sent me
> > an error via my cferror-specified exception handling template:
>
> That's true. The point I was making
> CFERROR templates work for compile errors too. I tried it
> before posting (of course), on CF 6.1, and this sent me
> an error via my cferror-specified exception handling template:
That's true. The point I was making is that the cferror tag must
compile and execute before it can trap a compile e
CFERROR templates work for compile errors too. I tried it before
posting (of course), on CF 6.1, and this sent me an error via my
cferror-specified exception handling template:
Notice the missing > after
Well, Doug, et al...
The problem with the queries I was running
and the data the was being returned turned out
to be the result of two problems...
The first...bad data...I had previously entered data
for another test run of this application and, I guess,
somewhere along the way I deleted some of
Hello,
I ran into a java.net.connectexception when trying to start
a flex-message gateway (for the session tracker example).
I tried to fix it using this technote, but I did something wrong.
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19185
Can someone please do a search on "
Thanks, Doug...
Sounds like a good plan. I have started breaking down the
original join query to its indiviual queries and testing them.
I'm getting some good results with that testing, so it may
have something to do with the original queries (although that
worked in a different template) and co
nevermind.
ColdFusion was displaying the wrong template name and line numbers for
the error because the error occurred at compile time while compiling
the CFC, but because the erroneous line numbers it showed included a
cfinvoke tag that definitely had a method attribute I didn't catch on
immediat
Has anybody ever seen ColdFusion 7 claim that a method attribute isn't
provided to cfinvoke and then simultaneously prove to you that it is
in fact provided?
--
Attribute validation error for tag CFINVOKE.
The tag requires the attribute(s): METHOD .
The error occurred in
C:\Inetp
> S. Isaac Dealey wrote:
>> I guess this does means I should start figuring out a way
>> to provide support
>> for both UTF-8 and ASCII resource bundles in the
>> framework to
> i wouldn't bother unless your apps will be that complex &
> you forsee the need to
> use external tools to mange the rb.
Hi Rick. Just read through the entire thread, I see that you've reworked your
query to utilize the suggested joins, and still you are getting query results
that never change. If it were me in that situation, my very next step would be
to grab the actual query out of debugging and start working w
Greg Morphis wrote:
> Make sure you use distinct or in() for those subqueries. If you're
> returning more than 1 employer_id or family_id then that'll cause an
> error too.
Just flatten it into a join.
SELECT
C.*,
FG.*,
E.*
FROM
clients C
INNER JOIN family_
S. Isaac Dealey wrote:
> I guess this does means I should start figuring out a way to provide support
> for both UTF-8 and ASCII resource bundles in the framework to
i wouldn't bother unless your apps will be that complex & you forsee the need to
use external tools to mange the rb. but if you do
16 matches
Mail list logo
