Running query on generated item

[johnv20]

Hi,
I have a javascript asp which gets the current status of all items from a database and displays the result, code goes something like follows:

sql = "select BarCode, Location, Side from SUTStatus";

and is then displayed like:
out += String(rs.fields.item("BarCode&quot) +
&quot;</td><td>&quot;;


out += String(rs.fields.item(&quot;Location&quot) +
&quot;</td><td>&quot;;

out += String(rs.fields.it(&quot;Side&quot) +
&quot;</td><td>&quot;;


However within table this query is run from there is another field OrderNum where each Barcode in a particular order has the same order num.

Is it possible to count the number of Barcodes with the same order num for each barcode being displayed and then display this value so that the display now gives

OrderQty BarCode etc.
2 AAA
1 BBB
2 CCC

 

[link9]

If I understand your question properly, then modify your sql to look like:

SELECT BarCode, Location, Side, COUNT(*) AS numOfOrders, orderNum FROM SUTStatus GROUP BY orderNum

assuming that barCode, Location, and Side will be the same value for each of the groups, then you can just output your new field name, numOfOrders


paul