To insert dynamic value in Xml

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mukesh <efextra@xxxxxxxxxxxxxxxxx>
Date: Fri, 24 Nov 2006 20:44:56 +0530

sir,
i am developing a database, which will store the users profile both personal and professional
which includes the address, telephone, gender and etc.
in my main table i have created a column of xml data type. i was successful in inserting the static
value inside my table.by following code:---

UPDATE docs
SET xCol.modify ('
insert <publisher>Microsoft Press</publisher>
before (/book/title)[1]')

since the profile of users vary from person to person, i cant insert static value. i need to generate dynamic value.
the value which is inserted by user through text box should get inserted in my main table .

kindly guide me.
.

Follow-Ups:
- Re: To insert dynamic value in Xml
  - From: Han

Prev by Date: Re: App_Code & bin
Next by Date: Creating a simple Windows Service .. can't find it??
Previous by thread: Crystal Reports ActiveX Designer can't connect to Oracle 10g
Next by thread: Re: To insert dynamic value in Xml
Index(es):
- Date
- Thread

Relevant Pages

Re: Mailbox user limits
... Thats what I thought too... ... I changed the users profile to 2Gb (at that point he'd been stopped by a ... Store 1gb limit)... ... store limit. ...
(microsoft.public.windows.server.sbs)
Re: To insert dynamic value in Xml
... You seem to want to use sql variable within your XML DML. ... which will store the users profile both ... successful in inserting the static ...
(microsoft.public.dotnet.framework.aspnet)