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

NameCompanyPhone
Maria AndersAlfreds Futterkiste030-00743210Ana TrujilloAna Trujillo Emparedados y helados(5) 555-47290Antonio MorenoAntonio Moreno Taquería(5) 555-39320Thomas HardyAround the Horn(171) 555-77880Christina BerglundBerglunds snabbköp0921-12 34 650Hanna MoosBlauer See Delikatessen0621-084600Frédérique CiteauxBlondel père et fils88.60.15.310Martín SommerBólido Comidas preparadas(91) 555 22 820Laurence LebihanBon app'91.24.45.400Elizabeth LincolnBottom-Dollar Markets(604) 555-47290Victoria AshworthB's Beverages(171) 555-12120Patricio SimpsonCactus Comidas para llevar(1) 135-55550Francisco ChangCentro comercial Moctezuma(5) 555-33920Yang WangChop-suey Chinese0452-0765450Pedro AfonsoComércio Mineiro(11) 555-76470Elizabeth BrownConsolidated Holdings(171) 555-22820Sven OttliebDrachenblut Delikatessen0241-0391230Janine LabruneDu monde entier40.67.88.880Ann DevonEastern Connection(171) 555-02970Roland MendelErnst Handel7675-34250Aria CruzFamilia Arquibaldo(11) 555-98570Diego RoelFISSA Fabrica Inter. Salchichas S.A.(91) 555 94 440Martine RancéFolies gourmandes20.16.10.160Maria LarssonFolk och fä HB0695-34 67 210Peter FrankenFrankenversand089-08773100Carine SchmittFrance restauration40.32.21.210Paolo AccortiFranchi S.p.A.011-49882600Lino Rodriguez Furia Bacalhau e Frutos do Mar(1) 354-25340Eduardo SaavedraGalería del gastrónomo(93) 203 45600José Pedro FreyreGodos Cocina Típica(95) 555 82 820André FonsecaGourmet Lanchonetes(11) 555-94820Howard SnyderGreat Lakes Food Market(503) 555-75550Manuel PereiraGROSELLA-Restaurante(2) 283-29510Mario PontesHanari Carnes(21) 555-00910Carlos HernándezHILARIÓN-Abastos(5) 555-13400Yoshi LatimerHungry Coyote Import Store(503) 555-68740Patricia McKennaHungry Owl All-Night Grocers2967 5420Helen BennettIsland Trading(198) 555-88880Philip CramerKöniglich Essen0555-098760Daniel ToniniLa corne d'abondance30.59.84.100Annette RouletLa maison d'Asie61.77.61.100Yoshi TannamuriLaughing Bacchus Wine Cellars(604) 555-33920John SteelLazy K Kountry Store(509) 555-79690Renate MessnerLehmanns Marktstand069-02459840Jaime YorresLet's Stop N Shop(415) 555-59380Carlos GonzálezLILA-Supermercado(9) 331-69540Felipe IzquierdoLINO-Delicateses(8) 34-56-120Fran WilsonLonesome Pine Restaurant(503) 555-95730Giovanni RovelliMagazzini Alimentari Riuniti035-6402300Catherine DeweyMaison Dewey(02) 201 24 670Jean FresnièreMère Paillarde(514) 555-80540Alexander FeuerMorgenstern Gesundkost0342-0231760Simon CrowtherNorth/South(171) 555-77330Yvonne MoncadaOcéano Atlántico Ltda.(1) 135-53330Rene PhillipsOld World Delicatessen(907) 555-75840Henriette PfalzheimOttilies Käseladen0221-06443270Marie BertrandParis spécialités(1) 42.34.22.660Guillermo FernándezPericles Comidas clásicas(5) 552-37450Georg PippsPiccolo und mehr6562-97220Isabel de CastroPrincesa Isabel Vinhos(1) 356-56340Bernardo BatistaQue Delícia(21) 555-42520Lúcia CarvalhoQueen Cozinha(11) 555-11890Horst KlossQUICK-Stop0372-0351880Sergio GutiérrezRancho grande(1) 123-55550Paula WilsonRattlesnake Canyon Grocery(505) 555-59390Maurizio MoroniReggiani Caseifici0522-5567210Janete LimeiraRicardo Adocicados(21) 555-34120Michael HolzRichter Supermarkt0897-0342140Alejandra CaminoRomero y tomillo(91) 745 62000Jonas BergulfsenSanté Gourmet07-98 92 350Jose PavarottiSave-a-lot Markets(208) 555-80970Hari KumarSeven Seas Imports(171) 555-17170Jytte PetersenSimons bistro31 12 34 560Dominique PerrierSpécialités du monde(1) 47.55.60.100Art BraunschweigerSplit Rail Beer & Ale(307) 555-46800Pascale CartrainSuprêmes délices(071) 23 67 22 200Liz NixonThe Big Cheese(503) 555-36120Liu WongThe Cracker Box(406) 555-58340Karin JosephsToms Spezialitäten0251-0312590Miguel Angel PaolinoTortuga Restaurante(5) 555-29330Anabela DominguesTradição Hipermercados(11) 555-21670Helvetius NagyTrail's Head Gourmet Provisioners(206) 555-82570Palle IbsenVaffeljernet86 21 32 430Mary SaveleyVictuailles en stock78.32.54.860Paul HenriotVins et alcools Chevalier26.47.15.100Rita MüllerDie Wandernde Kuh0711-0203610Pirkko KoskitaloWartian Herkku981-4436550Paula ParenteWellington Importadora(14) 555-81220Karl JablonskiWhite Clover Markets(206) 555-41120Matti KarttunenWilman Kala90-224 88580Zbyszek PiestrzeniewiczWolski Zajazd(26) 642-70120 
<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>