by Marcell
21. January 2010 04:26
Recently I've had a problem with firefox. It would take up to 10 seconds for each DNS request making browsing to any site extremely slow.
I tried clearing caches, changing settings in about:config but nothing worked.
The only thing that worked was to create a new default profile for Firefox and copy all the bookmarks, extenstions, etc over to the new one.
by Marcell
8. September 2009 17:06
I ran into an issue recently while comparing a datetime entry from an HTML form to a DateTime field in SQL. When .NET parses the entry into a DateTime object and the Time is omitted, it throws off the comparison when it gets to the SQL.
For instance, a user enters "9/8/2009" instead of "9/8/2009 5:00 PM"
To get around this, I came across this little hack for SQL which strips off the time from the SQL datetime when doing the comparison :
(SELECT CAST(FLOOR(CAST(someDate AS float)) AS datetime)
What this does:
1. Casts someDate to a float which truncates the time on conversion.
2. Casts back to a datetime which leaves you with a date like 9/8/2009 00:00:00
32cb69ba-ee4d-4e78-a563-4e1e5bc78bd5|0|.0
Tags:
SQL
by Marcell
4. July 2009 07:35
25efd73b-b9f0-4588-985c-52b881c29673|0|.0
Tags:
Javascript
by Marcell
3. July 2009 17:25
9202e635-e9a8-487f-b0b8-1eb25277b567|1|5.0
Tags:
Cars