Output for the Query: SELECT customerid,companyname,contactname,city,phone,fax FROM Customers;


customerid companyname contactname city phone fax
ALFKI Alfreds Futterkiste Maria Anders Berlin 030-0074321 030-0076545 
ANATR Ana Trujillo Emparedados y helados Ana Trujillo México D.F. (5) 555-4729 (5) 555-3745 
ANTON Antonio Moreno Taquería Antonio Moreno México D.F. (5) 555-3932  
AROUT Around the Horn Thomas Hardy London (171) 555-7788 (171) 555-6750 
BERGS Berglunds snabbköp Christina Berglund Luleå 0921-12 34 65 0921-12 34 67 
BLAUS Blauer See Delikatessen Hanna Moos Mannheim 0621-08460 0621-08924 
BLONP Blondel père et fils Frédérique Citeaux Strasbourg 88.60.15.31 88.60.15.32 
BOLID Bólido Comidas preparadas Martín Sommer Madrid (91) 555 22 82 (91) 555 91 99 
BONAP Bon app' Laurence Lebihan Marseille 91.24.45.40 91.24.45.41 
BOTTM Bottom-Dollar Markets Elizabeth Lincoln Tsawassen (604) 555-4729 (604) 555-3745 
BSBEV B's Beverages Victoria Ashworth London (171) 555-1212  
CACTU Cactus Comidas para llevar Patricio Simpson Buenos Aires (1) 135-5555 (1) 135-4892 
CENTC Centro comercial Moctezuma Francisco Chang México D.F. (5) 555-3392 (5) 555-7293 
CHOPS Chop-suey Chinese Yang Wang Bern 0452-076545  
COMMI Comércio Mineiro Pedro Afonso São Paulo (11) 555-7647  
CONSH Consolidated Holdings Elizabeth Brown London (171) 555-2282 (171) 555-9199 
DRACD Drachenblut Delikatessen Sven Ottlieb Aachen 0241-039123 0241-059428 
DUMON Du monde entier Janine Labrune Nantes 40.67.88.88 40.67.89.89 
EASTC Eastern Connection Ann Devon London (171) 555-0297 (171) 555-3373 
ERNSH Ernst Handel Roland Mendel Graz 7675-3425 7675-3426 
FAMIA Familia Arquibaldo Aria Cruz São Paulo (11) 555-9857  
FISSA FISSA Fabrica Inter. Salchichas S.A. Diego Roel Madrid (91) 555 94 44 (91) 555 55 93 
FOLIG Folies gourmandes Martine Rancé Lille 20.16.10.16 20.16.10.17 
FOLKO Folk och fä HB Maria Larsson Bräcke 0695-34 67 21  
FRANK Frankenversand Peter Franken München 089-0877310 089-0877451 
FRANR France restauration Carine Schmitt Nantes 40.32.21.21 40.32.21.20 
FRANS Franchi S.p.A. Paolo Accorti Torino 011-4988260 011-4988261 
FURIB Furia Bacalhau e Frutos do Mar Lino Rodriguez Lisboa (1) 354-2534 (1) 354-2535 
GALED Galería del gastrónomo Eduardo Saavedra Barcelona (93) 203 4560 (93) 203 4561 
GODOS Godos Cocina Típica José Pedro Freyre Sevilla (95) 555 82 82  
GOURL Gourmet Lanchonetes André Fonseca Campinas (11) 555-9482  
GREAL Great Lakes Food Market Howard Snyder Eugene (503) 555-7555  
GROSR GROSELLA-Restaurante Manuel Pereira Caracas (2) 283-2951 (2) 283-3397 
HANAR Hanari Carnes Mario Pontes Rio de Janeiro (21) 555-0091 (21) 555-8765 
HILAA HILARIÓN-Abastos Carlos Hernández San Cristóbal (5) 555-1340 (5) 555-1948 
HUNGC Hungry Coyote Import Store Yoshi Latimer Elgin (503) 555-6874 (503) 555-2376 
HUNGO Hungry Owl All-Night Grocers Patricia McKenna Cork 2967 542 2967 3333 
ISLAT Island Trading Helen Bennett Cowes (198) 555-8888  
KOENE Königlich Essen Philip Cramer Brandenburg 0555-09876  
LACOR La corne d'abondance Daniel Tonini Versailles 30.59.84.10 30.59.85.11 
LAMAI La maison d'Asie Annette Roulet Toulouse 61.77.61.10 61.77.61.11 
LAUGB Laughing Bacchus Wine Cellars Yoshi Tannamuri Vancouver (604) 555-3392 (604) 555-7293 
LAZYK Lazy K Kountry Store John Steel Walla Walla (509) 555-7969 (509) 555-6221 
LEHMS Lehmanns Marktstand Renate Messner Frankfurt a.M. 069-0245984 069-0245874 
LETSS Let's Stop N Shop Jaime Yorres San Francisco (415) 555-5938  
LILAS LILA-Supermercado Carlos González Barquisimeto (9) 331-6954 (9) 331-7256 
LINOD LINO-Delicateses Felipe Izquierdo I. de Margarita (8) 34-56-12 (8) 34-93-93 
LONEP Lonesome Pine Restaurant Fran Wilson Portland (503) 555-9573 (503) 555-9646 
MAGAA Magazzini Alimentari Riuniti Giovanni Rovelli Bergamo 035-640230 035-640231 
MAISD Maison Dewey Catherine Dewey Bruxelles (02) 201 24 67 (02) 201 24 68 
MEREP Mère Paillarde Jean Fresnière Montréal (514) 555-8054 (514) 555-8055 
MORGK Morgenstern Gesundkost Alexander Feuer Leipzig 0342-023176  
NORTS North/South Simon Crowther London (171) 555-7733 (171) 555-2530 
OCEAN Océano Atlántico Ltda. Yvonne Moncada Buenos Aires (1) 135-5333 (1) 135-5535 
OLDWO Old World Delicatessen Rene Phillips Anchorage (907) 555-7584 (907) 555-2880 
OTTIK Ottilies Käseladen Henriette Pfalzheim Köln 0221-0644327 0221-0765721 
PARIS Paris spécialités Marie Bertrand Paris (1) 42.34.22.66 (1) 42.34.22.77 
PERIC Pericles Comidas clásicas Guillermo Fernández México D.F. (5) 552-3745 (5) 545-3745 
PICCO Piccolo und mehr Georg Pipps Salzburg 6562-9722 6562-9723 
PRINI Princesa Isabel Vinhos Isabel de Castro Lisboa (1) 356-5634  
QUEDE Que Delícia Bernardo Batista Rio de Janeiro (21) 555-4252 (21) 555-4545 
QUEEN Queen Cozinha Lúcia Carvalho São Paulo (11) 555-1189  
QUICK QUICK-Stop Horst Kloss Cunewalde 0372-035188  
RANCH Rancho grande Sergio Gutiérrez Buenos Aires (1) 123-5555 (1) 123-5556 
RATTC Rattlesnake Canyon Grocery Paula Wilson Albuquerque (505) 555-5939 (505) 555-3620 
REGGC Reggiani Caseifici Maurizio Moroni Reggio Emilia 0522-556721 0522-556722 
RICAR Ricardo Adocicados Janete Limeira Rio de Janeiro (21) 555-3412  
RICSU Richter Supermarkt Michael Holz Genève 0897-034214  
ROMEY Romero y tomillo Alejandra Camino Madrid (91) 745 6200 (91) 745 6210 
SANTG Santé Gourmet Jonas Bergulfsen Stavern 07-98 92 35 07-98 92 47 
SAVEA Save-a-lot Markets Jose Pavarotti Boise (208) 555-8097  
SEVES Seven Seas Imports Hari Kumar London (171) 555-1717 (171) 555-5646 
SIMOB Simons bistro Jytte Petersen København 31 12 34 56 31 13 35 57 
SPECD Spécialités du monde Dominique Perrier Paris (1) 47.55.60.10 (1) 47.55.60.20 
SPLIR Split Rail Beer & Ale Art Braunschweiger Lander (307) 555-4680 (307) 555-6525 
SUPRD Suprêmes délices Pascale Cartrain Charleroi (071) 23 67 22 20 (071) 23 67 22 21 
THEBI The Big Cheese Liz Nixon Portland (503) 555-3612  
THECR The Cracker Box Liu Wong Butte (406) 555-5834 (406) 555-8083 
TOMSP Toms Spezialitäten Karin Josephs Münster 0251-031259 0251-035695 
TORTU Tortuga Restaurante Miguel Angel Paolino México D.F. (5) 555-2933  
TRADH Tradição Hipermercados Anabela Domingues São Paulo (11) 555-2167 (11) 555-2168 
TRAIH Trail's Head Gourmet Provisioners Helvetius Nagy Kirkland (206) 555-8257 (206) 555-2174 
VAFFE Vaffeljernet Palle Ibsen Århus 86 21 32 43 86 22 33 44 
VICTE Victuailles en stock Mary Saveley Lyon 78.32.54.86 78.32.54.87 
VINET Vins et alcools Chevalier Paul Henriot Reims 26.47.15.10 26.47.15.11 
WANDK Die Wandernde Kuh Rita Müller Stuttgart 0711-020361 0711-035428 
WARTH Wartian Herkku Pirkko Koskitalo Oulu 981-443655 981-443655 
WELLI Wellington Importadora Paula Parente Resende (14) 555-8122  
WHITC White Clover Markets Karl Jablonski Seattle (206) 555-4112 (206) 555-4115 
WILMK Wilman Kala Matti Karttunen Helsinki 90-224 8858 90-224 8858 
WOLZA Wolski Zajazd Zbyszek Piestrzeniewicz Warszawa (26) 642-7012 (26) 642-7012 

<HTML>
<HEAD>
   <TITLE>COM Test #3</TITLE>
<STYLE>
BODY{font-family:arial;font-size:10pt;}
TD{font-family:arial;}
TH{font-family:arial;}
</STYLE>
</HEAD>
<BODY>

<!--- Yet another way to do database access
      Create the Connection object and open the datasource
  --->
<SASET NAME=connNW  VALUE=createobject("ADODB.Connection")>
<SASET VALUE=connNW.open( "northwind" )>

<!--- Create a Connection object and set its property --->
<SASET NAME=cmdDC  VALUE=CreateObject("ADODB.Command")>
<SASET NAME=cmdDC.ActiveConnection VALUE=connNW>

<!--- Create the SQL command text that we will send through --->
<SASET NAME=cmdDC.CommandText VALUE="SELECT customerid,companyname,contactname,city,phone,fax FROM Customers;">
<SASET NAME=cmdDC.CommandType VALUE=1>

<!--- Execute the passed SQL string --->
<SASET NAME=rsDC VALUE=cmdDC.Execute()>

<!--- Sanity check; retrieve the property "CommandText" --->
<SAOUTPUT>
<BR><p>Output for the Query: <code><B>#cmdDC.CommandText#</B></code></p><BR>

<!--- Output the data --->
<table border=1>
  <TR>
     <TH>customerid</TH>
     <TH>companyname</TH>
     <TH>contactname</TH>
     <TH>city</TH>
     <TH>phone</TH>
     <TH>fax</TH>
  </TR>
  <!--- Use the COM methods for data population --->
  <SAWHILE COND=!rsDC.eof()>
     <tr>
     <td>#rsDC.Fields("customerid")#</td>
     <td>#rsDC.Fields(1)#</td>
     <td>#rsDC.Fields(2)#</td>
     <td>#rsDC.Fields(3)#</td>
     <td>#rsDC.Fields(4)#</td>
     <td>#rsDC.Fields(5)#&nbsp;</td>
     </tr>
     <SASET VALUE=rsDC.movenext()>
  </SAWHILE>
  </SAOUTPUT>
</table>

<!--- Not necessary to do this, but we may as well to show we
      support fully the ASP functionality --->
<SASET VALUE=rsDC.Close()>
<SASET VALUE=connNW.close()>

</body>
</html>

<SAIMPORT FILE="viewExample.aro">
   <SAPARAM NAME="item" VALUE="comTest3.aro">
</SAIMPORT>