I have a problem, that I can't seem to solve.<br>Basically I have two tables, Company and CompanyOwns.<br>What I am trying to do is pass a CompanyID into the database and it returns the Company. What also I want is to search for that CompanyID for companies it owns. <br>For example if the CompanyID was 2 and owns companyID 4,5.<br>Then the records I would like to return would be <br>2,4 and 5.<br><br>I have tried loops, arrays, lists but nothing seems to work it only returns the the last CompanyOwns record, e.g. 5 from the above example.<br><br>Can someone please help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Multiple Search
- Thread starter tempoman
- Start date
Try this:<br><br><FONT FACE=monospace><b><br><cfquery name="company" datasource="mydb"><br> Select * from Company <br> Where CompanyID=#CompanyID#<br></cfquery><br><br><cfquery name="companyowns" datasource="mydb"><br> Select * from CompanyOwns<br> Where OwnerID=#CompanyID#<br></cfquery><br><br><table><br><br> <cfoutput query="company"><br> <tr><br> <td>#CompanyID#</td><br> <td>#Name#</td><br> </tr><br> </cfoutput><br><br> <cfif companyowns.recordcount><br><br> <tr><td colspan=2 bgcolor="ffffcc">OWNS</td></tr><br><br> <cfoutput query="companyowns"><br> <tr><br> <td>#CompanyID#</td><br> <td>#Name#</td><br> </tr><br> </cfoutput><br><br> </cfif><br><br></table><br></b></font><br>Hope this helps..<br><br>DM
- Status
Similar threads
