On Error Resume next
'This statement makes the program resume the next statement
'instead of throwing an error
if numerror <> 0 Then
....snip snip ....
'and at the end of the script
On Error GoTo 0
'This means On Error, report it - the syntax is crazy.
Thursday, April 16, 2009
Added error handling to asp file which adds content disposition attachment headers to files on stream.radiosai.org - used ideas from this msdn blog post and this devguru article to write something like:
Wednesday, April 08, 2009
The schedule update was consistently timing out every time the csv update was done. Checked with Plesk DBWebadmin (phpmyadmin) and found records from 2008 onwards. Blundering about the interface, found a "Search" - tried 2008, it gave
Search results for "2008" (at least one of the words):Blundering, because I chose delete, and it did
336232 match(es) inside table radiosai_stream_daily Browse Delete
SQL-query:At least now I know what to give as the proper SQL statement - something like
DELETE FROM `radiosai`.`radiosai_stream_daily` WHERE `streamId` LIKE '%2008%'
OR `fileId` LIKE '%2008%' OR `groupId` LIKE '%2008%'
OR `gmtDatetime` LIKE '%2008%' OR `newflag` LIKE '%2008%'
DELETE FROM `radiosai`.`radiosai_stream_daily` WHERE `gmtDatetime` LIKE '%2009-01%'