Quick overview, I have a page that lets a user type in a record number and get the record info exported into an Excel spreadsheet. Right now it only works with one number at a time, but I want to allow them to type multiple record numbers separated with commas.

The relevant code is below:

	OpenTable(goWCServer.oConfig.oTask.cBTSPath+[key\A]+m.bn,[AppExp])
			

			
			*Select columns from table above, name them for Excel headers
			SELECT 	bn as [BatchNum],;
					pk as [RecNo],;
					"" as [Approved],;
					shdt as [ShipDate],;
					canm as [Carrier],;
					prno as [Pro],;
					blno as [BOL],;
					shnm as [Shipper],;
					ozp as [OZip],;
					conm as [Consignee],;
					dzp as [DZip],;
					wtttl as [Weight],;
					"" as [ReWeigh],;
					"" as [Notes],;
					accd1 as [Acc1],;
					acamt1 as [Amt1],;
					accd2 as [Acc2],;
					acamt2 as [Amt2],;
					accd3 as [Acc3],;
					acamt3 as [Amt3];
			FROM AppExp; 
			into cursor ApprovalA
			
			
			SELECT ApprovalA
*Copy data from cursor to Excel file
COPY TO ("C:\test\"+[bn]+m.bn+[T2.xls])

The "OpenTable" bit at the beginning is where it grabs the record number from the textbox on the HTML page (m.bn). Would I need a loop or something in order to get multiple record numbers recognized?