TopXML Microsoft ASP library : Include an ASP-file in XSL (JITIC Solution)

Home Page

Add/Edit your code items

Search the code library

Browse for the code library

Microsoft ASP
Microsoft ASP
Microsoft ASP Contents
Read/write data with VB using ASP pages

By	Robert Kviby
First Posted	06/11/2002
Times viewed	1189

Include an ASP-file in XSL (JITIC Solution)

Summary When we created JITIC we built an "online status" function which returns data about all users in XML. We get the XML-data from our indexing server. However, we also needed to check if the user was logged in, so we needed to execute some ASP-code within the XSL-file while we parsed the XML... Hmmm, how to do that? See our solution below...

The solution we came up with that we had to check if the user was logged in using ASP and we had to do this for every single user. Hence, we had to, from the XL-file, call an ASP-file and send a querystring to this file with the id for the user.

So, in the XSL-file we parse the XML to HTML. And when doing this we create a script-tag that will (in the HTML) include a javascript-file using like this:
<script language=javascript src=jsfile.js></script>

However, instead of including a file with the extension .js we included a file with the .asp extension and hence we could execute whatever asp-code we wanted and return it as ContentType = application/x-javascript

Check out the XSL and ASP-code below.

Thanks for your time!
Robert Kviby
robert@ngcode.com
Check out JITIC at www.jitic.net

Additional information
<xsl:template match="record"> <tr> <td valign="middle" width="70"> <center> <script><xsl:attribute name="language">JavaScript</xsl:attribute><xsl:attribute name="src">/scripts/checkonlinestatus.asp?userid=<xsl:value-of select="field[@name='ID'~"/></xsl:attribute></script> </center> </td> <td valign="top" width="174"> <a target="content"> <xsl:attribute name="href"> /scripts/writemessage.asp?method=external<![CDATA[&~~>email=<xsl:value-of select="field[@name='email'~"/><![CDATA[&~~>un<![CDATA[=~~><xsl:value-of select="field[@name='username'~"/> </xsl:attribute> <xsl:value-of select="field[@name='username'~"/> </a> </td> <td valign="top" width="170"> <xsl:value-of select="field[@name='groupkey'~"/> </td> <td valign="top" width="105"> <a target="content"> <xsl:attribute name="href"> /scripts/writemessage.asp?touserkey<![CDATA[=~~><xsl:value-of select="field[@name='userkey'~"/><![CDATA[&~~>un<![CDATA[=~~><xsl:value-of select="field[@name='username'~"/> </xsl:attribute> <img src="/images/message.gif" border="0"/> </a> </td> </tr> <tr height="10"><td></td></tr> </xsl:template>

Further additional information
<% Response.Buffer = True ' get the users online status ' --------------------------- ' Get the userid from the xsl file here ' -------------------------------------- struserid = Request.QueryString("userid") ' connect the database and check online ' status in tblsessions and return an ' image to the xsl file ' -------------------------------------- set objconn = server.CreateObject("ADODB.Connection") set objrs = server.CreateObject("ADODB.Recordset") objconn.Open "Provider=SQLOLEDB;Data Source=111.111.111.11;Initial Catalog=sample;User ID=id;Password=pw." strsql = "select * from tblsession where userid = '" & struserid & "' order by ID desc" set objrs = objconn.Execute(strsql) if objrs.EOF = false then ' user active if int(objrs.fields("online").Value) = 1 then ' user online strstatus = "active_user.gif" else ' user offline strstatus = "offline_user.gif" end if else ' user inactive strstatus = "notactive_user.gif" end if objrs.Close set objrs = nothing objconn.Close set objconn = nothing ' Send the output as javascript Response.ContentType = "application/x-javascript" strimage = "<img src='/images/" & strstatus & "' border='0'>" Response.Write "document.write(""" & strimage & """)" & vbnewline %>

Rate this article on a scale of 1 to 10 (2 votes, average 7)

Your vote :

<< LAMP


Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown:



	Recent Jobs Integration Specialist Needed - Work Fro Virtualization Server Infrastructure Arc A great opportunity to Digital Video Eng here is a greate opportunity as a SMS En A great opportunity as a Network Enginee View all Jobs (Add yours) View all CV (Add yours)

	Chicago Web Site Design service internet fax conference call Bvlgari sunglasses air freshener odor remover

	Partners Dream.In.Code dotNet Slackers dotNet Spider Your HTML Source VisualBuilder.com DevGuru Planet Source Code ZVON.ORG Web Design ASPAlliance XML Pitstop Scripts The Spot 4 SAP Bitshop Web Hosting

Email TopXML