Error when removing InfoPath Form Template from MOSS 2007
You may or may not have seen the following error message when trying to remove an InfoPath Form Template in Central Administration-Application Management-InfoPath Forms Services / Manage Form Templates: “The timer job for the operation has been created. However, it cannot be run because the administrative service for this server is not enabled…” In my case, this is due to Network restrictions. Although I’m a site collection admin and a Farm Admin, AND a local admin on the server (and…
Returning the Nth weekday in SQL…and in InfoPath
Ok, after much research I found a forum that had a posting that demonstrated how to get the Nth chosen weekday of a month using T-SQL. Here’s the code: DECLARE @date datetimeDECLARE @weekday intDECLARE @day datetimeDECLARE @number intDECLARE @WhichOne int SELECT @WhichOne = 2 — Set this to the week you want to grabSELECT @number = 1SELECT @weekday = 0SELECT @date = getDate() — Change to dateadd(month, 1, getDate()) for next month, etc. WHILE @weekday 4 — Change this value…
InfoPath data validation using regular expressions
I found it interesting yesterday, while building an InfoPath template for SharePoint 2007, that you can use regular expression code to perform data validation the same way it’s used in an ASP.Net form, and the same way it’s done in C#. Here’s an example: In my form, I wanted to make sure the data entered conformed to a specific email address format. Normally, an email address pattern looks like this: w+([-+.’]w+)*@w+([-.]w+)*.w+([-.]w+)* This won’t work in InfoPath, there are too many…