I have received some great feedback. Right now I'm going to try to redesign the queries and output from scratch. I took over this project that was half way complete so with all the questionable results I will try a redesign. I'm half way through already and it is looking much better. I'll keep...
I am pulling information from three tables that I need to display all the columns from. The Cats.CatID is a list that I need to show all the values in the list but have the selected value, selected. Please let me know if you need more detail. Thanks.
I am running a query,
<cfquery name="getRecords" datasource="******">
SELECT Prods.*, ProdMatrix.*, Categories.*
FROM Prods, ProdMatrix, Cats
WHERE (Prods.ProdID = ProdMatrix.ProdID) AND (Prods.CatID = Cats.CatID)
</cfquery>
All information is displaying properly. What I would like to do is show...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.