Saturday, June 30, 2007
Friday, June 29, 2007
Error when creating a SQL function
I have started using functions in SQL 2005 and I really do like them...But (there is always a but) I got this problem....
Msg 443, Level 16, State 1, Procedure UpdateTenders, Line 71
Invalid use of side-effecting or time-dependent operator in 'newid' within a function.
Msg 443, Level 16, State 15, Procedure UpdateTenders, Line 71
Invalid use of side-effecting or time-dependent operator in 'INSERT' within a function.
I got it on a rather natty (if that's how you spell natty) function, if I have to say so myself, but I wasn't doing anything strange with Guids, just an insert.
So after a quick google search found nothing, I changed it to be a stored procedure and it worked!! Hurray for simple solutions...
If it doesn't work as a sql function; do it as a stored procedure.
Thursday, June 28, 2007
Tracy and James visit
On Tuesday Tracy and Jim came down for a visit. Although it was a short visit, we had a fun morning. But we shall be seeing them very soon!!!!
Tags: Tabby, Tracy and Jim
Google Search with Images
Okay, so not a catchy title, but a fairly descriptive one...
I've been toying around with some ideas on how to improve search engine results. I really like the way the image search on search.live.com brings back results. If this idea could be shared with the way web pages are displayed, then it would be a really cool web search...
So I spent a while looking at all the components needed...
1) a web spider (to index all the pages)
2) imaging software to screen shot the web pages
3) a cool web interface to view the results.
4) somewhere to host the software.
I wrote a very basic (but working) c# demo, but (free) hosting is the problem.
So I started from scratch; is it possible to do all the above, but only write a few lines of code and have it hosted???....
The answer is yes, but just like every compromise, there are limitations...
Lets start again, but pick up free or existing software...
1) use google's search API , its free and I wont say easy, but not impossible to use.
2) websnapr offer a free service of imaging web pages..
3) hmmmm this is an area of limitation...
4) erm, lets see if we can use blogger...
The result is this.... Google Search with Images
Sunday, June 24, 2007
Sleep suits you.....
I thought this would make an interesting comparison.
The white new born sleep suit is laid on top of a 6 to 9 month sleep suit (one from Tabby's current rotation).
They do get big quick!
Friday, June 22, 2007
Live Writer and profile...
I'm testing out Window Live Writer, it looks and feels good. I'm impressed....apart from the uploading of images issue (which isn't a Live Writer problem). I will update with any issues I find..
On-line profile updating...:-)
I've updated fiend reunited, Messenger , myspace and now I've created a Facebook profile
Here goes nothing...time to post....
Thursday, June 21, 2007
Online Profile...
I've been reading Bill Thompson's Bill Board on the BBC news web site.
Apart from feeling old, I thought; I want one of those..an on-line profile.. what ever those is..
There are quite a few social networking sites out there, but which is the best? I was talking with some friends at the weekend and they said dont use facebook.... I would have argeed if I knew what facebook was.
So what are the 'cool' sites?
Is myspace still cool? What about friends reunited? and twitter? what the hell is twitter..
Are blogs still cool??
Sometimes my head hurts too much....
Visual Studio Team Edition for Database Professionals 'The selected database is not supported' Error
I tried to 'Import Database Schema..' from a SQL 2005 project, I added a new connection.
When I clicked on OK, I got the following error. 'The selected database is not supported.'
(I was connecting to a standard SQL 2005 database...nothing special about it)
I asked our Microsoft contact; James Snape.
He suggested trying to manually add a new database connection from the Server Explorer. This didn't work!! But I did get a different error, 'Key not valid for use in specified state.'.
The solution was: deleted all the Data Connections I had, then add a new one.
Tags: Bug, Database Professional, James Snape, Microsoft
Thursday, June 14, 2007
Programmer Personality Type
Try this small quiz to work out your programmer personality type.
Mine is....
DHTB
You're a Doer.
You are very quick at getting tasks done. You believe the outcome is the most important part of a task and the faster you can reach that outcome the better. After all, time is money.
You like coding at a High level.
The world is made up of objects and components, you should create your programs in the same way.
You work best in a Team.
A good group is better than the sum of it's parts. The only thing better than a genius programmer is a cohesive group of genius programmers.
You are a liBeral programmer.
Programming is a complex task and you should use white space and comments as freely as possible to help simplify the task. We're not writing on paper anymore so we can take up as much room as we need.
Tags: Fun
Monday, June 11, 2007
Your space, my space, myspace?
It feels as if everyone on the planet has a myspace site, so I have finally got around to creating one...but of course I'm still using blogger for my blog. The myspace site is here at http://www.myspace.com/markprycemaher
Tags: myspace
Sunday, June 10, 2007
And relax...
Pete and Claire having a sit down after getting back from Springwatch (and having our pick's nicked) on Southampton common.
PeteandClare
Originally uploaded by Me
Friday, June 08, 2007
Hello Dave!!!
Meet Dave.
He is one of the members of our co-op family....not matter how much he denies it, he is one of us now.........
Tags: Co-op
Friday, June 01, 2007
Tabitha sleeping
I've been meaning to upload loads of pictures of Tabby, but there are so many, that I've no idea where to start...
So here is one of my favourate...
Tags: Tabby
Simple Web Service using WCF (Windows Communication Framework) - The Code Project - Windows Communication Foundation
Hurray!! My first article (third one written) for CodeProject has been moved from an Unedited Reader Contributions to a proper article...
I've been meaning to write more, but I've just not been able to find the time.
Hopefully, this will spur me on.. (or not)
Its been published here:
Simple Web Service using WCF (Windows Communication Framework) - The Code Project - Windows Communication Foundation
Oh go on, rate it!!
Tags: C#, CodeProject, WCF, Web Service