Output for the Query: SELECT contactname AS NAME, companyname, Phone FROM Customers

NameCompanyPhone
Maria AndersAlfreds Futterkiste030-0074321
 Ana TrujilloAna Trujillo Emparedados y helados(5) 555-4729
 Antonio MorenoAntonio Moreno Taquería(5) 555-3932
 Thomas HardyAround the Horn(171) 555-7788
 Christina BerglundBerglunds snabbköp0921-12 34 65
 Hanna MoosBlauer See Delikatessen0621-08460
 Frédérique CiteauxBlondel père et fils88.60.15.31
 Martín SommerBólido Comidas preparadas(91) 555 22 82
 Laurence LebihanBon app'91.24.45.40
 Elizabeth LincolnBottom-Dollar Markets(604) 555-4729
 Victoria AshworthB's Beverages(171) 555-1212
 Patricio SimpsonCactus Comidas para llevar(1) 135-5555
 Francisco ChangCentro comercial Moctezuma(5) 555-3392
 Yang WangChop-suey Chinese0452-076545
 Pedro AfonsoComércio Mineiro(11) 555-7647
 Elizabeth BrownConsolidated Holdings(171) 555-2282
 Sven OttliebDrachenblut Delikatessen0241-039123
 Janine LabruneDu monde entier40.67.88.88
 Ann DevonEastern Connection(171) 555-0297
 Roland MendelErnst Handel7675-3425
 Aria CruzFamilia Arquibaldo(11) 555-9857
 Diego RoelFISSA Fabrica Inter. Salchichas S.A.(91) 555 94 44
 Martine RancéFolies gourmandes20.16.10.16
 Maria LarssonFolk och fä HB0695-34 67 21
 Peter FrankenFrankenversand089-0877310
 Carine SchmittFrance restauration40.32.21.21
 Paolo AccortiFranchi S.p.A.011-4988260
 Lino Rodriguez Furia Bacalhau e Frutos do Mar(1) 354-2534
 Eduardo SaavedraGalería del gastrónomo(93) 203 4560
 José Pedro FreyreGodos Cocina Típica(95) 555 82 82
 André FonsecaGourmet Lanchonetes(11) 555-9482
 Howard SnyderGreat Lakes Food Market(503) 555-7555
 Manuel PereiraGROSELLA-Restaurante(2) 283-2951
 Mario PontesHanari Carnes(21) 555-0091
 Carlos HernándezHILARIÓN-Abastos(5) 555-1340
 Yoshi LatimerHungry Coyote Import Store(503) 555-6874
 Patricia McKennaHungry Owl All-Night Grocers2967 542
 Helen BennettIsland Trading(198) 555-8888
 Philip CramerKöniglich Essen0555-09876
 Daniel ToniniLa corne d'abondance30.59.84.10
 Annette RouletLa maison d'Asie61.77.61.10
 Yoshi TannamuriLaughing Bacchus Wine Cellars(604) 555-3392
 John SteelLazy K Kountry Store(509) 555-7969
 Renate MessnerLehmanns Marktstand069-0245984
 Jaime YorresLet's Stop N Shop(415) 555-5938
 Carlos GonzálezLILA-Supermercado(9) 331-6954
 Felipe IzquierdoLINO-Delicateses(8) 34-56-12
 Fran WilsonLonesome Pine Restaurant(503) 555-9573
 Giovanni RovelliMagazzini Alimentari Riuniti035-640230
 Catherine DeweyMaison Dewey(02) 201 24 67
 Jean FresnièreMère Paillarde(514) 555-8054
 Alexander FeuerMorgenstern Gesundkost0342-023176
 Simon CrowtherNorth/South(171) 555-7733
 Yvonne MoncadaOcéano Atlántico Ltda.(1) 135-5333
 Rene PhillipsOld World Delicatessen(907) 555-7584
 Henriette PfalzheimOttilies Käseladen0221-0644327
 Marie BertrandParis spécialités(1) 42.34.22.66
 Guillermo FernándezPericles Comidas clásicas(5) 552-3745
 Georg PippsPiccolo und mehr6562-9722
 Isabel de CastroPrincesa Isabel Vinhos(1) 356-5634
 Bernardo BatistaQue Delícia(21) 555-4252
 Lúcia CarvalhoQueen Cozinha(11) 555-1189
 Horst KlossQUICK-Stop0372-035188
 Sergio GutiérrezRancho grande(1) 123-5555
 Paula WilsonRattlesnake Canyon Grocery(505) 555-5939
 Maurizio MoroniReggiani Caseifici0522-556721
 Janete LimeiraRicardo Adocicados(21) 555-3412
 Michael HolzRichter Supermarkt0897-034214
 Alejandra CaminoRomero y tomillo(91) 745 6200
 Jonas BergulfsenSanté Gourmet07-98 92 35
 Jose PavarottiSave-a-lot Markets(208) 555-8097
 Hari KumarSeven Seas Imports(171) 555-1717
 Jytte PetersenSimons bistro31 12 34 56
 Dominique PerrierSpécialités du monde(1) 47.55.60.10
 Art BraunschweigerSplit Rail Beer & Ale(307) 555-4680
 Pascale CartrainSuprêmes délices(071) 23 67 22 20
 Liz NixonThe Big Cheese(503) 555-3612
 Liu WongThe Cracker Box(406) 555-5834
 Karin JosephsToms Spezialitäten0251-031259
 Miguel Angel PaolinoTortuga Restaurante(5) 555-2933
 Anabela DominguesTradição Hipermercados(11) 555-2167
 Helvetius NagyTrail's Head Gourmet Provisioners(206) 555-8257
 Palle IbsenVaffeljernet86 21 32 43
 Mary SaveleyVictuailles en stock78.32.54.86
 Paul HenriotVins et alcools Chevalier26.47.15.10
 Rita MüllerDie Wandernde Kuh0711-020361
 Pirkko KoskitaloWartian Herkku981-443655
 Paula ParenteWellington Importadora(14) 555-8122
 Karl JablonskiWhite Clover Markets(206) 555-4112
 Matti KarttunenWilman Kala90-224 8858
 Zbyszek PiestrzeniewiczWolski Zajazd(26) 642-7012
  
<HTML>
<HEAD>
   <TITLE>COM Test #1</TITLE>
<STYLE>
BODY{font-family:arial;font-size:10pt;}
TD{font-family:arial;}
TH{font-family:arial;}
</STYLE>
</HEAD>
<BODY>

<!--- Create the ADO DB connection object --->
<SASET NAME=conSQL VALUE=CreateObject( "ADODB.Connection" )>

<!--- Connect to the datasource 
        - notice here that the brackets are not required
          SteelArrow supports ASP type coding 
        - brackets could have been added
  --->
<SASET VALUE=conSQL.Open "northwind", "", "", -1 >
 
<!--- Build our query string --->
<SAset NAME=strQuery VALUE="SELECT contactname ">
<SAset NAME=strQuery  VALUE=strQuery & "AS NAME, companyname, Phone ">
<SAset NAME=strQuery  VALUE=strQuery & "FROM Customers">

<!--- Execution returns a resultSet COM object --->
<SAset NAME=rsSQL  VALUE=conSQL.Execute( strQuery )>

<!--- Use one of the resultSet methods to format the data 
      For the heck of it...
  --->
<SAset NAME=strOutput VALUE=rsSQL.getString( 2, 100, (Markup('/td') & Markup('td')), "", (Markup('/td') & (Markup('/tr') & CHAR(10) & Markup('tr') & Markup('td')), "&nbsp;")>

<!--- Sanity message --->
<SAOUTPUT>
<p>Output for the Query: <code><B>#strQuery#</B></code></p>

<!--- Output the data --->
<table border=1>
   <tr><th>Name</th><th><b>Company</th><th>Phone</th></tr>
   <tr>
      <td>#strOutput#</td>
   </tr>
</table>
</SAOUTPUT>

</BODY>
</HTML>

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