Why not just use a UNION in a QoQ?
Pete
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229095
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:
As a follow up to this post, in case anybody has the same problem I did, I had
to put the word key in brackets...something like...
WHERE dbResults.primaryID = verityResults.[key]
This was in MX7 running on a W2K Server box.
-jim
>And did you try it without table aliases and with the join in th
My God, that actually works!! Swwwet! But what the hell
does that mean is happening with the query translation in the cfquery?
Ah well, I'll use this now.
Thanks Pascal.
George
On 5/3/05, Pascal Peters <[EMAIL PROTECTED]> wrote:
> And did you try it without table aliases and with th
Well,
My workaround for the time being is to use the very excellent
queryMerge UDF from cflib.org. Leads to some overhead, but what the
hey!
George
On 5/3/05, George Abraham <[EMAIL PROTECTED]> wrote:
> Yep, tried that too. Another thing I just noticed is that it does not
> like the dot notation
the past (on CF5)
Pascal
> -Original Message-
> From: George Abraham [mailto:[EMAIL PROTECTED]
> Sent: 03 May 2005 16:46
> To: CF-Talk
> Subject: Re: Combining verity results with database query
>
> Yep, tried that too. Another thing I just noticed is that it do
Yep, tried that too. Another thing I just noticed is that it does not
like the dot notation as in dbr.PrimaryID or whatever. It gives this
error:
Query Manipulation Error Code = 0
Invalid SQL
SQL = "SELECT dbr.* FROM dbResults dbr INNER JOIN verityResults vr ON
vr.key=dbr.PrimaryID"
Data Sour
Did you try
SELECT dbr.PrimaryID AS PrimaryID, vr.Score AS Score ...
Pascal
> -Original Message-
> From: George Abraham [mailto:[EMAIL PROTECTED]
> Sent: 03 May 2005 16:34
> To: CF-Talk
> Subject: Re: Combining verity results with database query
>
> I toyed arou
I toyed around with this code for some time. It is almost as if it
does not see that second table (or resultset) which is being joined.
For example, if this is the code:
SELECT PrimaryID, Score
FROM dbResults dbr
INNER JOIN verityResults vr ON vr.key = dbr.PrimaryID
ORDER BY vr.Score
then i
It's that last combination that is not working for me. I try to refer
to the results from the verity resultset joined on the results from
the database (based on a PrimaryID) and I get an error that the SQL is
bad. Has anybody ever done this? Here is the SQL code:
SELECT dbResults.*, vr.Score
FROM
-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED]
Sent: Monday, May 02, 2005 2:01 PM
To: CF-Talk
Subject: Re: Combining verity results with database query
Anybody?
On 5/2/05, George Abraham <[EMAIL PROTECTED]> wrote:
> Hi all,
> I have a verity search result (say V
Anybody?
On 5/2/05, George Abraham <[EMAIL PROTECTED]> wrote:
> Hi all,
> I have a verity search result (say VerityResults) that has the key as
> the primary id of a database table. I know that I can use this primary
> id as a parameter for retreiving results from the database like so:
>
>
> SEL
Hi all,
I have a verity search result (say VerityResults) that has the key as
the primary id of a database table. I know that I can use this primary
id as a parameter for retreiving results from the database like so:
SELECT *
FROM thisTable
WHERE PrimaryID IN (#ValueList(VerityResults.Key),",")#)
12 matches
Mail list logo
