to that trap...
-Cameron
-
Cameron Childress
Sumo Consulting Inc
---
land: 858.509.3098
cell: 678.637.5072
aim: cameroncf
email: [EMAIL PROTECTED]
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 2:55 PM
To: CF-Talk
Subject: RE: Database J
:49
To: CF-Talk
Subject: RE: Database Joins
> So I take it, instead of that query loading
> everytime the application.cfm file does it
> just does it once and caches it?
Yup! Cool huh?
-Cameron
-
Cameron Childress
Sumo Consulting Inc
---
land: 858.509.3098
cell: 678
PROTECTED]
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 2:47 PM
To: CF-Talk
Subject: RE: Database Joins
Thanks for that. I just put the not structkeyExists bit in with the
query into my application.cfm file for the time being. So I take it,
i
[mailto:[EMAIL PROTECTED]
Sent: 08 February 2004 22:18
To: CF-Talk
Subject: RE: Database Joins
> Thanks Cameron, do you mean for me to put that cfif into my
> application.cfm file?
You could put it there if you wanted. You could also put it into it's
own
file and include
ssing power?
>
> I'll look into that cachedwitin. Thanks,
>
> Stuart
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 08 February 2004 21:46
> To: CF-Talk
> Subject: Re: Database Joins
>
> I think you should keep them
idd [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 2:10 PM
To: CF-Talk
Subject: RE: Database Joins
Thanks Cameron, do you mean for me to put that cfif into my
application.cfm file?
What does that structkeyExists mean?
Cheers,
Stuart
-Original Message-
From: Cameron Childress
Thanks Cameron, do you mean for me to put that cfif into my
application.cfm file?
What does that structkeyExists mean?
Cheers,
Stuart
-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]
Sent: 08 February 2004 21:50
To: CF-Talk
Subject: RE: Database Joins
04 21:46
To: CF-Talk
Subject: Re: Database Joins
I think you should keep them separate, and cache the country query,
since
it's likely never to change...(using cfquery's cachedwithin parameter or
even writing that to static html and using that)... That's more
performant than worry
: Sunday, February 08, 2004 1:46 PM
To: CF-Talk
Subject: Re: Database Joins
I think you should keep them separate, and cache the country query, since
it's likely never to change...(using cfquery's cachedwithin parameter or
even writing that to static html and using that)... That's
EMAIL PROTECTED]
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 1:37 PM
To: CF-Talk
Subject: Database Joins
Hi guys,
I'm trying to do one database query (SELECT) without having to do 2
separate ones.
I have two tables. One called Pr
I think you should keep them separate, and cache the country query, since
it's likely never to change...(using cfquery's cachedwithin parameter or
even writing that to static html and using that)... That's more
performant than worrying about condensing 2 queries into one If you
want one query
Hi guys,
I'm trying to do one database query (SELECT) without having to do 2
separate ones.
I have two tables. One called PropertyAgent and then another called
PropertyCountryList.
In PropertyAgent, there is a field called PropertyAgentCountry (numeric)
which was inserted originally using
> Hi, I'm wondering if it's possible to make a join over 2
> different databases
> on 2 different servers. What I'm trying to do is that I have my
> information
> on 1 server, including a customer id and the customer name is
> located on the
> other server. I can easily get all this info in multip
Hi, I'm wondering if it's possible to make a join over 2 different databases
on 2 different servers. What I'm trying to do is that I have my information
on 1 server, including a customer id and the customer name is located on the
other server. I can easily get all this info in multiple queries, th
14 matches
Mail list logo
