Having fun being a father and a web geek.
Hello, my name is
Who am Who am I? I am a
geek/programmer/webmaster/manager for the bestest company.
I write applications for Web Services and Windows. I also do on the side
contract programming as my time allows (which is not very much).
|Sunday, November 23, 2014|
Foggy drive on the bridge, Daphne saw it, really cool I think
|Friday, November 07, 2014|
Another fabulous sunrise
|Monday, October 27, 2014|
End Zone. Where it all ends.
I guess that is why the word End is in the phrase?
|Sunday, October 26, 2014|
Daphne in the fog.
same Game. Daphne in the Fog getting ready to play
Just fun to watch.
|Saturday, October 25, 2014|
Football in the Fog
Last night, North Polk got to play football in the fog. At one point the announcer said. "I have no idea. It might be a touchdown it might not. The player juked left then went back right. Then I lost him. I have not clue."
It was a nice warm evening with no breeze and lots of fog. Made for an interesting match. PCM played well. But the Comets ended up with the win.
|Wednesday, October 15, 2014|
Linking from into a List Item for Viewing or Editing the list. Project Server
Sometimes in Project Server (Microsoft Project server that is) you are creating a report that shows the list items from the project site. IE Issues, Risks, Deliverables.
These can all be found in the reporting database and it comes contained in there. Pretty easy stuff to find. I will let you do the research for that.
But once in awhile. You have to link to the list item. Mainly because there is just too much information that is in the item to show on a report and the end users want that drill down ability.
I cannot say that I blame them.
Anyhoo, You need to know SharePoint at this point. The linkage is pretty easy. So lets say that I have a Risk for a Project and I want to be able to put an Edit this Item link into one of my reports. The SQL is fairly easy. If you know the project guid. You just write SQL like
select r.RiskID, p.projectworkspaceinternalhref as purl from msp_wssrisk inner join msp_epmproject_userview p on r.projectuid=p.projectuid where projectuid = @guid
ok now you have the RiskID and the URL for the Project. Want to create that link?
here is your formula
@purl + Lists + Risks + Editform.aspx + ?ID = @RiskID
so it should come out like the following
@purl = "http://projectserver1/projectsite1"
@RiskID = 1
full link should be
There you go. Now you can give people that ability to edit the item
Want them to Just view
Replace Editform with DispForm
Entering a New Item?
drop the ?ID=#
Lots and lots of uses. Issues, and Deliverables work the same way.
I have not tested with Tasks especially not in 2013.
|Wednesday, October 08, 2014|
Just another morning. Just another sunrise.
Just another sighting of God. A friend the other day spoke to me about God and how I have been looking for God in nature. He isn't far off. But I look for God in glimpses. glimpses of things. a glimpse of a smile on a child's face when they see their mom, a glimpse of a butterfly as it weirdly flies around. the glimpse of a dog when its master enters the house. and yes the glimpse of God as I drive across saylorville lake at 7am in the morning. Yes there is a glimpse of God there. He is everywhere though. You just have to look. God is there in your pain. He is there in your frustration. He is there when someone lies to you. He is there when you get a hug. He is there when it rains and when the sun is shining.
God is there.
And yes there is a picture.
pictures are here.
Other stuff of interest to people possibly.
Trip to Tahiti.
is nice as well