SharePoint Integration

Re: Date field not updated using updatelistitems

spr — Thu, 04 May 2006 20:01:39 GMT

Hi all
Will you please tell me how to write CAML to delete listitem.

Re: Date field not updated using updatelistitems

AndersR — Mon, 24 Apr 2006 07:25:13 GMT

Hi,

i havent tried with update, but with Cmd='New' i havent had any problems (as long as its a valid lookup ID ofcourse (in the solution i delete and create new)

string strBatch = "<Method ID='" + number + "' Cmd='New'>" +
"<Field Name='ID'>New</Field>" +
"<Field Name='Title'><![CDATA[" + equipmentText + "]]></Field>" +
"<Field Name='Equipment_x0020_Type'><![CDATA[" + typeText + "]]></Field>" +
"<Field Name='Recommendation'><![CDATA[" + recommendationText + "]]></Field>" +
"<Field Name='Area'>" + areaID + "</Field>" +
"</Method>";

hth

Re: Date field not updated using updatelistitems

Shanthi Reddy — Sun, 23 Apr 2006 09:17:13 GMT

Sharepoint gives an unique ID value for each row. You will have to first call GetListItems to get the ID of the specific row whose value you want to use to update the Look up field. Now that you have the ID field value, use that as input value.

There is some code athttp://weblogs.asp.net/bsimser/archive/2005/05/13/406734.aspx that might help.

Hope this helps!

Re: Date field not updated using updatelistitems

gaurs — Wed, 19 Apr 2006 09:09:51 GMT

I could get the date field to update properly. But I am unble to update a lookup field.
I have a Request ID - text field on the doc library. This will be unique. Then I have another doc library where I have a lookup column which refers to Request ID of the prev lib. How do I update the lookup column value. If I psecify the requedt ID directly, it does not work.
I came across some information that to update lookup column, you have to give the ID of the references list/doc entry. However this is not working for me. Could someone share exact format for this.

This is my code:

string myPlan = string.Format(
"<Method ID='1' Cmd='Update'>" +
"<Field Name='ID'>" + docId +"</Field>" +
"<Field Name='FileRef'>" + myUrl "</Field>" +
//"<Field Name='RequestId'>{0}</Field>" +
"<Field Name='SupportPlanId'>{0}</Field>" +
"</Method>",
---->>>> //requestId,
supportPlanId);

How do I specify the correct ID in the code marked with arrow?

Re: Date field not updated using updatelistitems

gaurs — Mon, 17 Apr 2006 03:59:18 GMT

How can I find that? Or is there a way in which I can query the SQL format and then convert to that format?

Re: Date field not updated using updatelistitems

Patrick Halstead — Sun, 16 Apr 2006 06:53:18 GMT

Hi Gaurs,
Probably has something to do with type of data since SQL datetime is different from the XML data type in InfoPath.

Date field not updated using updatelistitems

gaurs — Fri, 14 Apr 2006 09:07:29 GMT

I am trying to use updatelistitems method of lists webservice to update a custom list. It works great for text/number columns but when I try to update date column, no error is returned but column does not get updated in the custom list. Problem also with lookup columns and person/group columns. Any pointers would be greatly appreciated.