COM Test #3

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>