When I have done things like this in the past I do similar to what Benoit
mentioned initially, but I take it one step further.
Instead of putting the Tablename column in with a word like 'Product', etc.
I put the whole piece if possible.
ie.
'this is a product' as Source
UNION
'this is a content' as Source
UNION
'this is a department' as Source
Then the information is in the query data. Fill in around the above
obviously with your query.
Hope this helps.
Mike
-----Original Message-----
From: Benoit Hediard [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 10, 2002 8:51 AM
To: CF-Talk
Subject: RE: Query + Output
For the output, you could do something like this :
<cfoutput query="qSearch">
<cfswitch expression="#qSearch.TableName#">
<cfcase value="Product">
<cfset Description = "this is a product">
</cfcase>
<cfcase value="Content">
<cfset Description = "this is a content">
</cfcase>
<cfcase value="Department">
<cfset Description = "this is a department">
</cfcase>
</cfswitch>
#qSearch.Title#, #Description#<br>
</cfoutput>
Benoit Hediard
http://www.benorama.com
-----Message d'origine-----
De : Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Envoy� : samedi 10 ao�t 2002 15:15
� : CF-Talk
Objet : Re: Query + Output
Wouldn't the output be:
<cfoutput query="querynam">
#queryname.TableName#
</cfoutput>
How would you tell between departments and content?
Paul Giesenhagen
QuillDesign
----- Original Message -----
From: "Benoit Hediard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, August 10, 2002 4:07 AM
Subject: RE: Query + Output
> A simple solution :
>
> <cfquery...>
> SELECT
> 'Product' as TableName,
> Title,
> Keywords
> FROM
> Product
> WHERE
> Keywords LIKE ...
>
> UNION
>
> SELECT
> 'Content' as TableName,
> Title,
> Keywords
> FROM
> Content
> WHERE
> Keywords LIKE ...
>
> UNION
>
> SELECT
> 'Departments' as TableName,
> Title,
> Keywords
> FROM
> Departments
> WHERE
> Keywords LIKE ...
> </cfquery>
>
>
> Ben
> http://www.benorama.com
>
> -----Message d'origine-----
> De : Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Envoy� : samedi 10 ao�t 2002 04:33
> � : CF-Talk
> Objet : Query + Output
>
>
> I have a situation that I am sure someone will be able to answer.
>
> I have three tables: Product, Content, Departments
>
> They are basically the same (except for a few obvious differences).
>
> I am wanting to do a keyword search on all of them and I need to know
where
> my result is coming from.
>
> I want to search on the following fields.
>
> title, keywords, content
>
> I could put together a union, but the tricky part (maybe it's not) ... is
> that I need to know what table the result is from. Is it a department,
> content or product.
>
> Result set would look something like this:
>
> Title, this is a product
> Title1, this is content
> Title2, this is a product
> Title3, this is a department
> Title4, this is content
> ..
>
> Is this possible in SQL, if not, does anyone have suggestions as to the
best
> way to do it in SQL/CF?
>
> I would like to avoid running three different queries, but that is an
> option.
>
> Thanks!
> Paul Giesenhagen
> QuillDesign
>
>
>
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
