ColdFusion

In a previous post, I wrote about watching out for data type mismatches when using the CFSharePoint tag.  While this is all well and good, much of my post was based on  a misconception of how an "inout parameter" works.  While I can't claim great knowledge of this, I think I have a better understanding.

From what I understand, an inout parameter expects a specifically named parameter–let's say "Result"–to be passed in.  When you pass this parameter to the web service, the value, or "out", should be the variable that you want returned.  So if I want the "results" parameter to return its value as "finalResults", you could do something like:results="finalResults"

In the last post, I was under the impression that the initial value of "results" HAD to be a ColdFusion data type, like a structure or array.  This is not correct.  Sure, I can pass in the appropriate data type with the "results" parameter; however, whatever structure I pass in will overwrite the "out".  This is why if you run the example I provided in the last post, copying an "About.doc" file from one folder to another will really just create a new "About.doc" with the value of the binary object More >

In my last post, I showed how simple it is to post a list item to a SharePoint list from Coldfusion 9.  In this post, I want to expand a bit, showing how to add an attachment to a newly created list item.  I also thought it would be a bit more fun to use form data, rather than hardcoding everything…so here goes 🙂

<cfif isDefined('FORM.submit')>
     <cfsavecontent variable="xml">
          <Batch OnError='Return'>
               <cfoutput>
               <Method ID='1' Cmd='New'>
                    <Field Name='ID'>New</Field>
                    <Field Name='Title'>#FORM.title#</Field>
                    <Field Name='Favorite_x0020_Color' #FORM.color#</Field>
               </Method>
               </cfoutput>
          </Batch>
     </cfsavecontent>
     <cfset newItem = xmlParse(xml)>
     <!---Be sure to get the actual field name from the URL, not from the display in SharePoint--->                                    <cfsharepoint action="updatelistitems"
                   domain="domain"
                   userName="username"
                   password="password"
                   name="theresult"
                   params="#{listName="AAC20C17-A87D-4985-BA1D-9DD511EE9B9A",updates="#newItem#"}#"
     />
     <cfset theID = theresult.result[2].ows_ID />
     <cfset attach = filereadbinary(FORM.myfile)>
          <cfsharepoint action="addattachment"
                        domain="domain"
                        userName="username"
                        password="password"
                        params="#{listName="AAC20C17-A87D-4985-BA1D-9DD511EE9B9A",
                                  listItemID="#theID#",
                                  fileName="#filename#",
                                  attachment="#attach#"
                                 }#"
          />
</cfif>
<cfform name="myform" method="post" enctype="multipart/form-data" target="addlistwithattachment.cfm">
Title:    <cfinput type="text" name="title" /><br />
Fav Color:  <cfinput type="text" name="color" /><br />
Filename:  <cfinput type="text" name="filename" /><br />
File:  <cfinput type="file" name="myfile" id="myfile" /><br />
<cfinput type="submit" name="submit" value="Submit" /></cfform>

So really, here we have another easy bit of code.  The insert method (updatelistitems) is unchanged, except that I’ve tied the field values More >