sql server notification services: Stylesheet problem....help -- sql server notification services

Stylesheet problem....help

unc27932 NO[at]SPAM yahoo.com
1/17/2006 8:57:44 AM

sql server notification services: My events are firing and my email alerts are arriving. But all that
arrives in the body of my message is the "<" character. It's like it's
not finding my stylesheet definition. I just used the one from the
template and replaced the field names with my fieldnames from my ADF.
Below is my stylesheet & ADF <notificationclasses> section for
debugging. Can anyone help?

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="notifications">

<html>
<body>
<xsl:apply-templates/>
Thank you for using this Notification System. 
The thing that you have subscribed to has happened! 
</body>
</html>
</xsl:template>

<xsl:template match="notification">
Full Name : <xsl:value-of select="FullName" /> 
New Address Line 1 : <xsl:value-of select="AddressLine1"
/> 
New Address Line 2 : <xsl:value-of select="AddressLine2"
/> 
New City : <xsl:value-of select="City" /> 
New State : <xsl:value-of select="State" /> 
New Zip Code : <xsl:value-of select="Zip" /> 
 
</xsl:template>

</xsl:stylesheet>

---------------------------

<NotificationClasses>

<NotificationClass>
<NotificationClassName>
ChangeofAddressAlert
</NotificationClassName>
<Schema>
<Fields>
<Field>
<FieldName>RegistrationNumber</FieldName>
<FieldType>varchar(10)</FieldType>
</Field>
<Field>
<FieldName>FullName</FieldName>
<FieldType>varchar(30)</FieldType>
</Field>
<Field>
<FieldName>Date</FieldName>
<FieldType>datetime</FieldType>
</Field>
<Field>
<FieldName>AddressLine1</FieldName>
<FieldType>varchar(40)</FieldType>
</Field>
<Field>
<FieldName>AddressLine2</FieldName>
<FieldType>varchar(40)</FieldType>
</Field>
<Field>
<FieldName>City</FieldName>
<FieldType>varchar(24)</FieldType>
</Field>
<Field>
<FieldName>State</FieldName>
<FieldType>char(2)</FieldType>
</Field>
<Field>
<FieldName>Zip</FieldName>
<FieldType>varchar(9)</FieldType>
</Field>
</Fields>
</Schema>
<ContentFormatter>
<ClassName>XsltFormatter</ClassName>
<Arguments>
<Argument>
<Name>XsltBaseDirectoryPath</Name>
<Value>%_AppPath_%\stylesheets</Value>
</Argument>
<Argument>
<Name>XsltFileName</Name>
<Value>stylesheet.xslt</Value>
</Argument>
</Arguments>
</ContentFormatter>
<Protocols>
<Protocol>
<ProtocolName>SMTP</ProtocolName>
<Fields>
<Field>
<FieldName>Subject</FieldName>
<SqlExpression>'Your Notification'</SqlExpression>
</Field>
<Field>
<FieldName>From</FieldName>
<SqlExpression>'Notify@whereever.com'</SqlExpression>
</Field>
<Field>
<FieldName>To</FieldName>
<FieldReference>DeviceAddress</FieldReference>
</Field>
<Field>
<FieldName>Priority</FieldName>
<SqlExpression>'Normal'</SqlExpression>
</Field>
<Field>
<FieldName>BodyFormat</FieldName>
<SqlExpression>'html'</SqlExpression>
</Field>
</Fields>

</Protocol>
</Protocols>
</NotificationClass>

Re: Stylesheet problem....help

unc27932 NO[at]SPAM yahoo.com
1/17/2006 10:15:16 AM

OK - got it figured out. I had my UTF encoding = 16 in my ICF and
changed it to utf-8 & this fixed it.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server notification services group.