rezzie - Developer IT

Unread mail/feed count badges for Gmail/Reader tabs in Google Chrome?

- by Rezzie

As per the title, is there an extension that does this?

System.Data.SQLite parameterized queries with multiple values?

I am trying to do run a bulk deletion using parameterized queries. Currently, I have the following code: pendingDeletions = new SQLiteCommand(@"DELETE FROM [centres] WHERE [name] = $name", conn); foreach (string name in selected) pendingDeletions.Parameters.AddWithValue("$name", centre.Name); pendingDeletions.ExecuteNonQuery(); However, the value of the parameter seems to be overwritten each time and I end up just removing the last centre. What is the correct way to execute a parameterized query with a list of values?

Read the article

C# Path Ellipsis without Win32 API call

- by Rezzie

I have a long path I'd like to shorten for displaying on a form using the ellipsis character(s?). I know there is the PathCompactPathEx Win32 API call, but I know there is a built-in .NET equivalent. I have used it previously, but cannot find it any more. Any hints, please?

Read the article

Thin-border on WPF window?

- by Rezzie

I'd like to create a window, using WPF, that has a thin border all the way around the form - i.e. no space for the title bar with the icon/caption and min/max/close buttons. For example, the "extra" icons form of the new Windows 7 taskbar: How can I do this with WPF (I don't mind resorting to the Win32 API, if not supported natively by WPF)?

Read the article

Conditional SQLite check constraint?

- by Rezzie

I have a table defined by the following SQL: CREATE TABLE test ( id integer PRIMARY KEY NOT NULL UNIQUE, status text NOT NULL, enddate date, /* Checks */ CHECK (status IN ("Current", "Complete")) ); I'd like to add a constraint that requires enddate to be non-null if the status is "Complete". Is this possible? I am using SQLite v3.6.16.

Read the article

Parsing an xs:duration datatype into a Python datetime.timedelta object?

- by Rezzie

As per the title, I'm trying to parse an XML file containing an xs:duration data type. I'd like to convert that into a Python timedelta object, which I can then use in further calculations. Is there any built-in way of doing this? If not, what is the best way to achieve this?

Developer IT