Snipplr

(SQL) SAP Date Comparison - cori

Wed, 20 May 2009 13:14:30 UTC

this little snippet can be used to compare an SAP Date (which might be empty, or '00000000') to today's date, for instance to query for rows that have been closed in the last x days. Can't CAST the date column (in 'YYYYMMDD' format) to a date for use in where clauses, since '00000000' can't be cast to a datetime

(PHP) list->mysql query iteration for cron job - cori

Mon, 23 Feb 2009 11:27:35 UTC

I needed to have a cron job that did some MySQL work iterating through a long list of items based on the content of a table in MySQL. I wanted each item in the table to be iterated over roughly once every 5 minutes, but building up the in-memory list of items to be processed based on the full contents of the table (~100 rows) was killing server memory and the process was dying. I wanted to find a way to, based on the time, only process a segment of the table's results, and to be reasonable confident that they would all be processed approximately every 5 minutes. Really simple problem, actually, but it took me a while to find the right logic...

(Bash) grep a pattern omitting svn directories - cori

Wed, 27 Aug 2008 00:29:30 UTC

(PHP) another (wp 2.3.3) custom loop query example - cori

Tue, 08 Jul 2008 13:26:51 UTC

(PHP) custom loop query example - cori

Sat, 26 Apr 2008 00:12:35 UTC

the above url has some helpful parameters

(C#) adding CSS to a C# Master page from a child code-behind page - cori

Wed, 03 Oct 2007 12:49:16 UTC

work from content pages or submaster pages