Microsoft KB Archive/228761

= Showing the MAPS 2.5 Transaction Database =

Article ID: 228761

Article Last Modified on 9/30/2003

-

APPLIES TO


 * Microsoft Commercial Internet System 2.5

-



This article was previously published under Q228761



SUMMARY
Occasionally it is helpful to view the transaction information stored in the transaction database. The documentation describes the database, and the following Web page uses ADO to do a dump of a particular transaction.

NOTE: This assumes that you are not automatically deleting transactional information.

<%@ Language=VBScript %>









.TableName

{

background-color: lightgrey;

color: black;

font-weight: bold;

font-size: 16pt;

text-align: center;

}









<%

TransactionID = Request.QueryString("TransactionID")

Set DB = Server.CreateObject ("ADODB.Connection")

DB.Open "trandb", "sa", "password"

%>

mapsTrans



<% Set RS = DB.Execute ("SELECT * FROM mapsTrans WHERE id=" & TransactionID) %>

<%

RS.Close

Set RS = Nothing

%>







<DIV CLASS="TableName">mapsTranSubObj</DIV>

<BR>

<BR>

<HR>

<BR>

<DIV CLASS="TableName">mapsTranSubAttribute</DIV>

<BR>

<% Set RS = DB.Execute ("SELECT * FROM mapsTranSubObj WHERE tranid=" & TransactionID) %>

<BR>

<HR>

<BR>

<DIV CLASS="TableName">mapsTranAttribute</DIV>

<BR>

<%

Set RS = DB.Execute ("SELECT * FROM mapsTranAttribute WHERE tranid=" & TransactionID)

%>

</CENTER>

</BODY>

</HTML>

Additional query words: MCIS2.5 MAPS

Keywords: KB228761

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.