241 reputation
112
bio website tehone.com
location United States
age 36
visits member for 4 years, 2 months
seen Aug 14 at 7:22

A dedicated and highly motivated developer with over 15 years’ experience in internet technologies and solutions.


Jul
2
awarded  Curious
Aug
8
awarded  Popular Question
Sep
24
awarded  Popular Question
Aug
27
revised SQQuery, Dates and Regional Settings
added 24 characters in body
Aug
27
comment SQQuery, Dates and Regional Settings
Ok, I may have spoken too soon. Even with this option the query is still sent to the DB with an automatic adjustment based on my regional settings... Oh SharePoint, how I hate thee sometimes.
Aug
27
answered SQQuery, Dates and Regional Settings
Aug
27
comment SQQuery, Dates and Regional Settings
Thanks for the reply and information. My biggest problem isn't getting things into or out of UTC. The problem is when I provide a UTC date to an SPQuery, it sends that date to the DB as the users local time instead of keeping it as UTC. Since I'm doing stuff that depends highly on date/time, this is causing results to be left off that should be included.
Aug
25
asked SQQuery, Dates and Regional Settings
Aug
18
awarded  Yearling
Aug
18
comment Changing PublishingPage.Layout doesn't change the content type?
Just thought I'd come back an post an update on this. Just changing the page layout wasn't enough for me, I had to also set the ContentTypeId as @GavinB suggested. Here is a code snippet: page.Layout = newPageLayout; page.ListItem[SPBuiltInFieldId.ContentTypeId] = newPageLayout.AssociatedContentType.Id; page.Update();
Aug
18
accepted Changing PublishingPage.Layout doesn't change the content type?
Jun
22
awarded  Popular Question
Jun
14
awarded  Autobiographer
Jun
14
comment SharePoint list query efficiency
Thanks for the reply. The point about security trimming is a good point. There will be security placed on some individual items. A lot of the data won't have security, but some will. I will be using the modification date to only pull new items for "partial updates". But when I need to pull the full view again I need to pull the most recent 20 (or more or less) items in. Some of those items will already be in cache, so I don't need to fetch the full dataset for them from the db, I just need their ids to check against cache. Then for items not in cache, I need to go back for the full dataset.
Jun
13
asked SharePoint list query efficiency
Jun
9
awarded  Excavator
Jun
9
awarded  Editor
Jun
9
revised Dynamic Master Pages
Changed link from sharepointoverflow.com to sharepoint.stackexchange.com
Jun
9
suggested suggested edit on Dynamic Master Pages
Mar
13
accepted Sharepoint 2010 publishing page personalization - Error “Add and Customize Pages permissions”