Quick Links
This module was created with XMod
We're happy to show our support for the DotNetNuke platform and community by contributing back to the project at the highest "Platinum" level.
|
DNNDev.com Forums
| Author |
Messages |
|
MartinvanBalkom482
XMod Newcomer
Posts: 4
 |
| 8/17/2008 6:28 PM |
|
I just bought XMod5.1. Last time I worked with XMod it was the 3.0 version. Wow, so many improvements! But I have one nagging problem.
I am aware of the dbo.KB_XMod_ExtractFieldValue function to extract a single field from the InstanceData column; very useful. But is there a similar way to also update a field? I tried (this is just an example):
UPDATE
KB_XMod_Modules
SET
dbo.KB_XMod_ExtractFieldValue(InstanceData,'Node') = 'value'
WHERE
XModID=1
...but it throws an error.
I remember that back then when I was working with XMod 3, I was using xurlp to save Xmod data to a separate table, which I was then able to UPDATE using regular SQL commands, and I was retrieving the data with XMRD. But it's a crutch at best, and I was hoping that perhaps by now there is an easier way to modify the native InstanceData?
Another thing I tried, by the way - since InstanceData is saved out as XML - was to use some of the new XQuery functions available in MSSQL 2005. Alas, InstanceData is saved as ntext, and these functions only work on xml formatted data. Could I simply change the format to xml in the database, or will that likely break everything?
As you might have noticed I am not particularly savvy in SQL, XML and what not... any hints are greatly appreciated! |
|
|
|
|
MartinvanBalkom482
XMod Newcomer
Posts: 4
|
| 8/18/2008 4:40 AM |
|
More thorough search through the forums dug out this:
http://dnndev.com/Forums/tabid/215/forumid/18/postid/7730/view/topic/Default.aspx
Have yet to try it but it sounds promising. |
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|
|