Calendar - Parse xml at server

Print Page | Close Window

Parse xml at server

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=22219
Printed Date: 23 April 2024 at 6:17pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Parse xml at server

Posted By: graham@efmail.co.uk
Subject: Parse xml at server
Date Posted: 25 February 2014 at 2:29pm

<Calendar CompactMode="1" Locale="1049">
<CustomProperties>
<CustomProperty Name="clientfk" Value="2" VariantType="2" />
<CustomProperty Name="reporttext" Value="rrrrrrrrrr" VariantType="16396" />
</CustomProperties>
</Calendar>

this is the result of the custom properties field in sql server but I am unable to get the info out of it any ideas for TSQL

Replies:

Posted By: graham@efmail.co.uk
Date Posted: 26 February 2014 at 12:34pm

Don't worry I cracked it