Works great.
;-)
Donna
----- Original Message -----
From: Ryan Duckworth
To: CF-Talk
Sent: Monday, August 02, 2004 2:56 PM
Subject: RE: Search 2 tables
There are many ways to do this. Try this code:
Additional Query:
<cfquery name="searchProducts">
SELECT *
FROM products
WHERE productname LIKE '%#Form.search#%'
</cfquery>
Same 1st Search Query:
<cfquery name="search">
SELECT *
FROM dolls
WHERE name LIKE '%#Form.search#%'
</cfquery>
Display Results:
<cfif searchProducts.RecordCount GT 0>
<h2>Products</h2>
<!-- Display Product results -->
<cfoutput query="searchProducts">
<a href="" productname
#</a><br>
</cfoutput>
</cfif>
<cfif search.RecordCount GT 0>
<h2>Dolls</h2>
<!-- Display Product results -->
<cfoutput query="search">
<a href=""> </cfoutput>
</cfif>
Ryan Duckworth
Macromedia ColdFusion Certified Professional
Uhlig Communications
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
