Search 2 tables

[Donna French]

Okay, I must warn you all that when I first built this web app I was a TOTAL newbie and had no idea what I was doing with CF or database design.

With that said, I am attempting to patch the search feature so that it can pull results from 2 tables while I redesign the app and database.

The current code is:

<cfquery name="search">
  SELECT *
  FROM dolls
  WHERE name LIKE '%#Form.search#%'
</cfquery>

<!-- Display results -->
<cfoutput query="search">
<a href=""> </cfoutput>

The problem is that I need to search 2 tables and display results accordingly.

Table 2 info-

products(table)
productid(pk)
lanesid(text)
productname(text)

If results are found in this table, the link will need to be: detailsProduct.cfm?productid=#productid#

I think I've given enough information, and I won't bother to send all the different methods I've tried to get this to work.

If you have ANY ideas please send!

Greatly appreciate all of your help and patience.

TIA,
Donna

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---