Can't get it to work, but that's OK because I've confused myself to the point that I'm not sure what I'm trying to accomplish.
Fuck my head hurts!
error. but I'm stuck on trying to figure out how to approach this.
I have the needed info in the database. So I just need to compare or count and that's where I'm stuck atm.
<CFQUERY NAME="count" DATASOURCE="isiswood"> SELECT COUNT(*) AS WoodType FROM ProductionDetail WHERE rudID='041811BD' AND rudCategory='Produced' AND rudProductID LIKE '%RO%'; </cfquery>
<CFQUERY NAME="count" DATASOURCE="isiswood"> SELECT rudID AS WoodType, COUNT(*) AS WoodCount FROM ProductionDetail WHERE rudCategory='Produced' AND rudProductID LIKE '%RO%' GROUP BY rudID </cfquery>
SELECT SUBSTRING(rudProductID,6,2) AS WoodType, COUNT(*) AS WoodCount FROM ProductionDetail WHERE rudCategory='Produced' GROUP BY SUBSTRING(rudProductID,6,2)
OK Peter I'm stuck again.
I can get it to output the types and count for a query, but how can I tell it the one with the biggest number is the one I want to use?
I'll show you after I eat supper. I can't remember really.
But I rebuilt the whole code and cleaned it all up. It required much less math and variables. So I thank you for that! Plus I formatted it as you suggested and that helps a lot.
<CFQUERY NAME="sluth" DATASOURCE="isiswood"> SELECT ID=rudID, Category=rudCategory, Seq=rudSeq, Type=rudType, Product_ID=rudProductID, Description=rudDescrip, PcsPerPkg=rudPcsPerPkg, Tally=rudTally, UOM=rudBaseUnitID, Pieces=rudPieces, Volume=rudVolume, NetVolume=rudNetVolume, Cost=rudCost, AddedCost= rudAddedCost, MktValue=rudMarketValue, Total=rudTotal, NetThick=rudNetThick, NetWidth=rudNetWidth, NetLength=rudNetLength, NetType=rudVolType, LocationID=rudLocationID,rudFIFOVolume,rudForceCost,rudBoomID,prdLengthID=(SELECT prdLengthID FROM ProductMaster WHERE prdID=rudProductID) FROM ProductionDetail WHERE rudID='#form.batch#' AND rudCategory='Produced' AND rudProductID LIKE '%#WoodType#%' AND rudDescrip NOT LIKE '%boards%' AND rudDescrip NOT LIKE '%blocking%' ORDER BY Seq; </cfquery>
AND rudID = <cfqueryparam value="#form.batch#" />
Run ID = <cfoutput>#HtmlEditFormat(form.batch)#</cfoutput>
Yes just an internal tool so I'm not really concerned about injections, but you're right. Get in the habit!
I have no doubt there are things that need changed. I haven't used CF in about 2 years and even then I wasn't what I would consider much good at it.
WHERE rudID='#form.batch#' AND rudCategory='Produced' AND rudProductID LIKE '%#WoodType#%' AND rudDescrip NOT LIKE '%boards%' AND rudDescrip NOT LIKE '%blocking%'
WHERE rudID='#form.batch#' AND rudCategory='Produced' AND rudProductID LIKE '%#WoodType#%' AND rudDescrip LIKE '%boards%' AND rudDescrip LIKE '%blocking%'