A great idea.
If you add the parameter “Application Name” to your SQL connection string then you can use Application Name to filter the SQL profiler results.
Much easier than having to find the dbid etc.…
Author: Iain 'Cutty' Carlin
Getting List Items from SharePoint list
Today I am trying to populate an ASP.Net drop down list from the contents of a SharePoint list using the Lists web service.
I found this Microsoft page that was most useful in helping me to do that: http://msdn.microsoft.com/en-us/library/lists.lists.getlistitems.aspx
A couple of issues I struck that are mentioned in the article:
- I was getting a SOAP error saying “Guid should contain 32 digits with 4 dashes”. As mentioned in the above article this is due to Visual Studio putting a web reference in Web.config to the top level site rather than the sub-site in which the list exists.
- Once the above was fixed, I got a second error: “InvalidOperationException: Client found response content type of ‘text/html; charset=utf-8’, but expected ‘text/xml’”.
Who would have thought InfoPath was so picky…
My relationship with InfoPath is love hate. On the one hand it’s so easy to create web forms on the other some of the simplest tasks are incredibly difficult.
Take today’s task – putting a simple URL on a form to open a Nintex workflow page for the form. InfoPath lets you put a URL on a form, but you can only have a static URL or populate it from a data source. The data source must have the full URL.
Easy, make the full URL a calculated field…except that calculated fields can’t user ID as one of the fields. In the end I put a button on the form.…
SharePoint filters evaluate criteria in order
Users requested that I filter a list of announcements so that the logic would work like:
(Show All Users Notices OR Staff Notices) AND (Posted before today AND expire after today).
The default filtering doesn’t let you put the brackets into the filter query. Turns out that SharePoint runs the query in order and ‘virtually’ puts brackets around things.
So my eventual logic was(((Show all Users Notices Or Staff Notices) AND StartDate before Today) AND Expires After Today).…
Learning one new thing a day for a year
I thought this was an original idea, but googling it found that there are plenty of others doing the same thing. However, I will press on.
I often marvel at how much I have to look at Google every day in my job as a programmer. When I stop and thing about it, that equates to a lot of stuff that I learn without really knowing it.
S, I thought I would create this blog and keep a record for the next year of everything I learn that is new each day.
If nobody else gets anything out of it, at least I will.…
InfoPath – “Schema validation found non-datatype errors.”
I have a multi-view form that loads different views depending on the status and user. I can’t test it using preview unless some data is loaded.
I have to upload the new form and try it out on live data. I made a change, uploaded then got the error: “Schema validation found non-datatype errors.”
In mucking about with my form, I changed the order of some fields in the Submit data source. InfoPath doesn’t like this and gives you the cryptic message above.…