Click here to Skip to main content
16,020,518 members

Comments by David_Pollard (Top 9 by date)

David_Pollard 23-Jun-16 23:27pm View    
OK, I had assumed it was PHP. It now appears to me to be some system of tag replacement used by thy web servers CMS.
FIY I have been programming for more than 25 years. In a language that I don't know I find it very useful to start with a working example and modify it to do what I need. It is hardly useful to learn something back to front when I'm only one line short of a working solution. My problem is I asked the question in the wrong place. I'll remove it.

Thanks
David
David_Pollard 6-Jun-16 4:19am View    
It is hard to know what is wrong with so little information coming back from your program. I usually include debugging information to a log file so I can tell where a program is up to when it stops. I also include a setting in the config file so I can turn logging down or off when you don't need it. At a minimum every method outputs its name and any variables passed in and the current date time. Years down the track this extra work can still pay off when a program in the field suddenly stops working.
David_Pollard 3-Jun-16 0:04am View    
Sorry, I haven't explained that part very well. I'm using an application named Policy Patrol that creates a backup in SQL Server of every email coming and going in the organisation. There is an option within that software that compresses the data in one column only, named RFC822_msg. If I turn the compression off it would be a breeze but it would also reduce the amount of history I can store by around half.
David_Pollard 1-Jun-16 20:45pm View    
I also sniffed the SQL when reading the data back from the database into the application and no sign of any decompression there either. Just two normal looking select statements.
David_Pollard 1-Jun-16 20:39pm View    
Hi OriginalGriff, That link points to SQL 2016 and I'm using 2008 R2. It is only one column in my table that is compressed. Not the whole table or Index. Let me know if I'm missing something.
I have sniffed the SQL using a profiler when the application writes to the database and it is a straight SQL Insert command with nothing special about any column. This is why I assumed that the application is doing the compression. Good idea but. :)