Thanks, I'm still extremely new to VFP though so I'm a bit confused. I tried putting the loop before the OpenTable function and ending it after it put the results into the cursor, but I'm still only getting one record exported. Can you give me a little more detail on where exactly it should go?
>You will need a loop, something like
>For x=1 to getwordcount(bn,',')
> tempbn=getwordnum(bn,x,',')
> **your code here
>Endfor
>
>>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?