Jay-Z
I.
Will.
Not.
Lose…
Ever.
Put me anywhere on God’s green earth,
I’ll triple my worth.
When working with a DataSet object, I got this error.
“Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.”
Talk about annoying - this took me the better part of an hour and half to figure out where this error was coming from. Quite descriptive if you ask me <rolling eyes>. It’s as useful as this:
As with any bug the more information you can get on it - the better. The code I put together thanks to a tip from Roy Osherove’s Blog gets into the DataSet object to see which column is actually throwing the error.
foreach( DataTable table in dataSet.Tables)
{
if (table.HasErrors)
{
foreach ( var error in table.GetErrors())
{
if (error.HasErrors)
throw (new Exception( error.RowError));
}
}
}
This produced a much more descriptive error that allowed me to track down the problem:
Shendy.
I’m doing the best I ever did.
I’m doing the best that I can.
My food for thought’s so hot, it gives you dudes ulcers.
Since I started using WordPress in January/09, the whole permalinks thing has confused me - mainly because I didn’t spend the time to implement it correctly, but also partly because their documentation is confusing.
I dedicated some time today (ended up taking 10 minutes), to figure this out.
The default for WordPress URLs is http://www.iamshendy.ca?cat=10, or http://www.iamshendy.ca?p=12. This doesn’t fair well for users that want to access your site directly and can’t remember what “cat” is, or which number “p” was supposed to be set to. More importantly - it prevents search engines from better indexing your content. If a link within your site appears as http://www.iamshendy.ca/fitness/ - a user will have a better chance of remembering it, and a search engine can now index the ‘fitness’ keyword for your site.
With the intro out of the way - here’s a few tips to consider while following through WordPress’ documentation
which according to their example - looks like it would work:
![]()
But on fact does not - you actually have to use the tags provided.
Hope this helps you out - email me if you have any questions.
Shendy.
I done forgot more than you ever learned
What you don’t know will make your home a permanent urn
Today, I was determined to run for at least 1/2 an hour worth of interval cardio. I was feeling great when I got the gym, and hopped on the treadmill. I dialled back the intensity from my usual 9mph 2 minute bursts and started off with 7.5mph instead, eventually working my way up to 8.5mph. I wasn’t feeling run down so kept going - and going. Thirty-five minutes later, I got off the treadmill. I ran about 3.8 miles at an average speed of 6.7mph. I felt great!
On to the workout:
Back
I read about a squat stretch from an article I found the other day. It involves sitting at the bottom of your squat (no weight) for 30 seconds, gradually spreading your knees farther apart. This reportedly helps to stretch our your hips (which are a real problem for me). I did 4 of these squat holds for about 15-20 seconds each. I could really feel my form on it, and I hope making these a frequent appearance in my workouts will help improve the weight and form of my squats.
Biceps
"21s" are great for a bicep burner at the end of your workout. They’re simply 3 sets of seven with the first set focusing on the lower half of the curl, the 2nd set focusing on the top half of the curl, and the last being a full curl from the bottom up. Your arms will BURN after trying these, if not - you’re not using enough weight.
Shendy.