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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by shamrock3

  1. shamrock3

    Show Selected Value from Query

    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...
  2. shamrock3

    Show Selected Value from Query

    I have not used the ValueList function and I am doing some reading on it. Any suggestions for the format?
  3. shamrock3

    Show Selected Value from Query

    Unfortunatly that is out of my control. I appreciate the input and will forward your recommendations to the DBA.
  4. shamrock3

    Show Selected Value from Query

    It is the latter.
  5. shamrock3

    Show Selected Value from Query

    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.
  6. shamrock3

    Show Selected Value from Query

    I am using * because I need to display information from all the columns. How do you suggest I proceed?
  7. shamrock3

    Show Selected Value from Query

    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...

Part and Inventory Search

Back
Top