Results 1 to 3 of 3

Thread: beginner

  1. #1
    Join Date
    Dec 1969

    Default beginner

    hi list .<BR><BR>i&#039m a beginner, please help me<BR><BR>howdo i use xml in asp<BR><BR>like i retrieve records using ado then i want to display data using XML.Please guide me in right direction

  2. #2
    Michal M Guest

    Default RE: beginner (xml)

    Hi mary,<BR>I you are using IIS5 it is very easy. You can use this syntax to output xml directly from an asp page:<BR>&#060;%@ codepage=“65001” %&#062;<BR>&#060;object id=“rstCustomers” progid=“ADODB.Recordset” <BR> runat=“Server”&#062;&#060;/object&#062;<BR>&#060;!--metadata name=“Microsoft ActiveX Data Objects 2.5 Library” <BR>type=“TypeLib” uuid=“{00000205-0000-0010-8000-00AA006D2EA4}”--&#062;<BR>&#060;%<BR> Option Explicit<BR> Dim strSQL, strConnection<BR> Response.ContentType = “text/xml”<BR> strSQL = “SELECT CustomerID, CompanyName, ContactName FROM Customers ORDER By CompanyName”<BR> strConnection = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=“ & Server.MapPath(“NWind.mdb”)<BR>rstCustomers.Cu rsorLocation = adUseClient <BR>rstCustomers.Open strSQL, strConnection, adOpenStatic, adLockOptimistic<BR> Response.Write “&#060;?xml version=“1.0” encoding=“ISO-8859-1”?&#062;“ & vbCRLF<BR> response, adPersistXML<BR> rstCustomers.Close<BR>%&#062;<BR><BR>for more information see and<BR><BR>Hope this helps somewhat,<BR>Michal M<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default Michal please help me

    when i ran your asp code i got this error<BR>Active Server Pages error &#039ASP 0203&#039 <BR><BR>Invalid Code Page <BR><BR>/a/abc.asp, line 1 <BR><BR>The specified code page attribute is invalid. <BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts