number of files per folder limitation

nyem — Fri, 23 Nov 2007 12:50:13 +0800

Is there a limit on the number of files that a folder can have in any of the following OS? xp, mac, nokia memory card.

I'm rendering map tiles and on the detail levels the number of files can be very large. If there's such limits I might want to reorganise the output folders.

[mysql] How to get date from a known week number

nyem — Wed, 24 Oct 2007 15:32:51 +0800

I have a table with year, month and week number (1..52). How do I retrieve the date for the first day of the week (monday)?

------------

Sorry guys, wrong information. I thought the week number is the number of week in the year (1..53), but actually it is the number of week for the month (1..5)

Here's my attempt to get the date if the week number is the week number for the year.

CODE

SELECT
� � tahun,minggu,
� � DATE_ADD(
� � � � �CONCAT(tahun,'-01-01'),
� � � � �INTERVAL (minggu-1) * 7 + 1 DAY
� � ) 'tarikh pada hari isnin'
FROM rpt_harga_ph
GROUP BY tahun,minggu
ORDER BY tahun,minggu;

+-------+--------+------------------------+
| tahun | minggu | tarikh pada hari isnin |
+-------+--------+------------------------+
| �2004 | � � �1 | 2003-12-29 � � � � � � |
| �2006 | � � �1 | 2006-01-02 � � � � � � |
| �2006 | � � �2 | 2006-01-09 � � � � � � |
| �2006 | � � �3 | 2006-01-16 � � � � � � |
| �2006 | � � �4 | 2006-01-23 � � � � � � |
| �2006 | � � �5 | 2006-01-30 � � � � � � |
+-------+--------+------------------------+

[addedon]October 25, 2007, 12:41 am[/addedon]Managed to find the solution by getting the week of year first, and then find the first day of the week like the above solution.

CODE

SELECT
� � tahun,bulan,minggu,

� � WEEK(
� � � � �IF (bulan=1,
� � � � � � � DATE_ADD( LAST_DAY( CONCAT(tahun-1,'-',12,'-01') ), INTERVAL 1 DAY ),
� � � � � � � DATE_ADD( LAST_DAY( CONCAT(tahun,'-',bulan-1,'-01') ), INTERVAL 1 DAY )
� � � � �)
� � ) + (minggu) - 1 'week of year',
� �
� � DATE_ADD(
� � � � �CONCAT(tahun,'-','-01-01'),
� � � � �INTERVAL (
� � � � � � � (
� � � � � � � � � �WEEK(
� � � � � � � � � � � � IF (bulan=1,
� � � � � � � � � � � � � � �DATE_ADD( LAST_DAY( CONCAT(tahun-1,'-',12,'-01') ), INTERVAL 1 DAY ),
� � � � � � � � � � � � � � �DATE_ADD( LAST_DAY( CONCAT(tahun,'-',bulan-1,'-01') ), INTERVAL 1 DAY )
� � � � � � � � � � � � )
� � � � � � � � � �) + (minggu - 2)
� � � � � � � ) * 7 + 1
� � � � �) DAY
� � ) 'tarikh pada hari isnin'

FROM rpt_harga_ph
GROUP BY tahun,bulan,minggu
ORDER BY tahun,bulan,minggu;

+-------+-------+--------+--------------+------------------------+
| tahun | bulan | minggu | week of year | tarikh pada hari isnin |
+-------+-------+--------+--------------+------------------------+
| �2004 | � �02 | � � �1 | � � � � � �5 | 2004-01-30 � � � � � � |
| �2006 | � �01 | � � �1 | � � � � � �1 | 2006-01-02 � � � � � � |
| �2006 | � �01 | � � �2 | � � � � � �2 | 2006-01-09 � � � � � � |
| �2006 | � �02 | � � �1 | � � � � � �5 | 2006-01-30 � � � � � � |
| �2006 | � �02 | � � �2 | � � � � � �6 | 2006-02-06 � � � � � � |
| �2006 | � �02 | � � �3 | � � � � � �7 | 2006-02-13 � � � � � � |
| �2006 | � �02 | � � �4 | � � � � � �8 | 2006-02-20 � � � � � � |
| �2006 | � �02 | � � �5 | � � � � � �9 | 2006-02-27 � � � � � � |
| �2006 | � �03 | � � �1 | � � � � � �9 | 2006-02-27 � � � � � � |
| �2006 | � �03 | � � �2 | � � � � � 10 | 2006-03-06 � � � � � � |
| �2006 | � �03 | � � �3 | � � � � � 11 | 2006-03-13 � � � � � � |
| �2006 | � �03 | � � �4 | � � � � � 12 | 2006-03-20 � � � � � � |
| �2006 | � �03 | � � �5 | � � � � � 13 | 2006-03-27 � � � � � � |
| �2006 | � �04 | � � �1 | � � � � � 13 | 2006-03-27 � � � � � � |

I guess it's not a good idea to store data this way as week 5 can also be week 1 of the next month.

setAttribute name doesn't work in IE7

nyem — Thu, 21 Jun 2007 15:03:14 +0800

I have the following html input box

CODE

Which I cloned and assign different name via

CODE

element.setAttribute('name', 'StartDate'+1 );

The above code works in Opera,Safari & FF, but not in IE7. Tried the following but also fails in IE7

CODE

element.name = 'StartDate'+1;

Any workaround?

Opera Widget contest

nyem — Tue, 15 May 2007 14:45:21 +0800

There's a new contest for Opera Widget developers.

Widget Theme: Widget for travelers

Prizes:
1st: Windows Mobile phone that runs Opera
2nd: Nintendo DS Lite
5 runner-ups will get Opera goodie bags with t-shirts, pins, stickers, etc.

Early Bird Prize: Nintendo DS Lite (for most downloaded widget by 28 May)

Deadline: 4 June 2007

Contest details: Calling All Widget Developers: Lend a hand to travelers everywhere

For more info about Opera widget see Opera Widgets and
Opera Widgets Forum

I've won myself Opera goodie bags for my Earthquake Map widget last year. Quite easy and fun programming exercise.

Lowyat.NET: Latest topics by nyem

number of files per folder limitation

[mysql] How to get date from a known week number

setAttribute name doesn't work in IE7

Opera Widget contest