Click here to Skip to main content

Articles by alex turner (Articles: 31, Technical Blogs: 11)

Articles: 31, Technical Blogs: 11

RSS Feed

Average article rating: 4.04

Client side scripting
General
Posted: 24 Jan 2007   Updated: 24 Jan 2007   Views: 34,924   Rating: 3.22/5    Votes: 3   Popularity: 1.54
Licence: Not specified      Bookmarked: 12   Downloaded: 0
An article on feeding data into Excel from web services and formating it into management reports
Posted: 28 Jan 2007   Updated: 28 Jan 2007   Views: 27,884   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 0
The object of this post is to embed an image into a script which can then load it into MS Excel!
Posted: 2 Feb 2007   Updated: 2 Feb 2007   Views: 37,663   Rating: 4.17/5    Votes: 3   Popularity: 2.29
Licence: The Code Project Open License (CPOL)      Bookmarked: 16   Downloaded: 460
How to read an XML data source from file or AJAX and then represent it in Internet Explorer as a GUI
Posted: 22 Feb 2007   Updated: 22 Feb 2007   Views: 46,424   Rating: 4.09/5    Votes: 3   Popularity: 1.95
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   Downloaded: 377
How to send emails using JScript and Netcat. This technique can be used for mailouts or load testing.
Posted: 19 Feb 2007   Updated: 1 Mar 2007   Views: 31,203   Rating: 2.89/5    Votes: 7   Popularity: 2.45
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   Downloaded: 219
If you have a PHP, ASP, Ruby, or whatever based website, it is usually a pain to get simple but good looking Excel spreadsheets out of the site. This solution is too simple to be true (but it is).
Posted: 1 Mar 2007   Updated: 1 Mar 2007   Views: 52,665   Rating: 2.87/5    Votes: 7   Popularity: 2.43
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 0
An easy to use class that gives some binary file abilities to JScript.
Posted: 1 Mar 2007   Updated: 1 Mar 2007   Views: 17,987   Rating: 3.50/5    Votes: 2   Popularity: 1.05
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 0
To futher my previous post on sending emails using Netcat and JScript, here is how to also send attachments.
Posted: 19 Jan 2010   Updated: 19 Jan 2010   Views: 20,530   Rating: 4.00/5    Votes: 7   Popularity: 3.38
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 7   Downloaded: 0
VBScript may be old and ugly, but there are some quick and dirty tricks for which it is still really handy.
Office Development
Microsoft Excel
Posted: 16 Feb 2007   Updated: 16 Feb 2007   Views: 19,121   Rating: 3.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 61
A JScript that is really used in business for cleaning up named ranges in Excel.
Posted: 16 Mar 2007   Updated: 16 Mar 2007   Views: 16,548   Rating: 3.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 0
How to make a simple Excel database reporting engine with XML configuration.
Posted: 17 Dec 2007   Updated: 17 Dec 2007   Views: 46,538   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 29   Downloaded: 0
Excel 2007 does not seem to support DBF files, here is a VBScript workaround.
Database
SQL Server
Posted: 7 May 2008   Updated: 7 May 2008   Views: 39,185   Rating: 4.85/5    Votes: 8   Popularity: 4.38
Licence: The BSD License      Bookmarked: 22   Downloaded: 191
A VBScript which creates Delete and Insert statements to backup data from SQL Server.
Posted: 14 Jan 2010   Updated: 14 Jan 2010   Views: 38,445   Rating: 4.95/5    Votes: 13   Popularity: 5.51
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 17   Downloaded: 0
They might seem like just another not entirely required feature, but actually table variables are a very handy extension to SQL Server
C#
General
Posted: 18 Jan 2010   Updated: 18 Jan 2010   Views: 13,455   Rating: 4.71/5    Votes: 7   Popularity: 3.98
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 7   Downloaded: 0
The introductions of Tuples (originally to support F#) into .NET shows a possible way to use polyadic returns in C#, COBOL etc., without syntax enhancement.
Java
General
Posted: 29 Mar 2011   Updated: 29 Mar 2011   Views: 26,253   Rating: 4.64/5    Votes: 8   Popularity: 4.24
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 8   Downloaded: 0
JVM code can be just as fast as the equivalent native code: Why and How.
Other .NET Languages
General
Posted: 15 Dec 2009   Updated: 17 Dec 2009   Views: 36,820   Rating: 4.61/5    Votes: 17   Popularity: 5.65
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 22   Downloaded: 0
A simple table showing the syntactic conversion from between each of these languages.
Posted: 23 Dec 2009   Updated: 23 Dec 2009   Views: 6,964   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 2   Downloaded: 41
This simple project shows just how advanced MS COBOL for .NET is for modern development.
Posted: 9 Jan 2010   Updated: 9 Jan 2010   Views: 9,368   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 3   Downloaded: 0
Showing how Micro Focus Managed COBOL can call F#, and some tips on mixing imperative and functional languages the easy way.
Posted: 14 Jan 2010   Updated: 14 Jan 2010   Views: 9,291   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 1   Downloaded: 0
Working with modern technologies like WPF is made a whole lot easier if you have nice features like anonymous deletegates, here is how use them in COBOL.
Posted: 19 Jan 2010   Updated: 19 Jan 2010   Views: 6,685   Rating: 3.67/5    Votes: 2   Popularity: 1.10
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 1   Downloaded: 0
How to and the benefits of tightly integrating scripting with native Micro Focus COBOL to produce more customisable and flexible applications.
Posted: 19 Jan 2010   Updated: 19 Jan 2010   Views: 13,369   Rating: 3.00/5    Votes: 1   Popularity: 0.00
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 2   Downloaded: 0
How about a .NET COBOL program which uses ADO.NET to connect to either MySQL or SQL Server?
Posted: 3 Feb 2010   Updated: 3 Feb 2010   Views: 5,732   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 2   Downloaded: 0
Using the latest versions of COBOL, this venerable language becomes completely type safe via generics - shown by example.
Posted: 25 May 2010   Updated: 25 May 2010   Views: 8,798   Rating: 4.50/5    Votes: 4   Popularity: 2.67
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 1   Downloaded: 0
A 101 on writing a compiler - a Managed COBOL compiler which compiles Brainf**k (a very simple language) to Managed COBOL
Posted: 28 May 2010   Updated: 28 May 2010   Views: 5,223   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 1   Downloaded: 0
Modernizing procedural COBOL can be done in little steps, each one making a bit difference
VBScript
General
Posted: 6 Feb 2007   Updated: 16 Feb 2007   Views: 42,142   Rating: 3.75/5    Votes: 4   Popularity: 2.26
Licence: The Code Project Open License (CPOL)      Bookmarked: 34   Downloaded: 411
Exsead Service Manager is an Open Source (BSD Style License) Windows Service which launches anything via the use of scripts, it is just being released as Open Source, here is more about it.
Posted: 7 Mar 2007   Updated: 7 Mar 2007   Views: 42,054   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 3
To complement my earlier post on sending emails using JScript and Netcat, here is the same but using VBScript and showing the translation from JScript to VBScript.
Posted: 13 Apr 2007   Updated: 13 Apr 2007   Views: 16,929   Rating: 2.82/5    Votes: 5   Popularity: 1.97
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
It has been said that large scale creation of long strings from small strings is not practical in VBScript - NOT SO
Posted: 12 Jan 2010   Updated: 12 Jan 2010   Views: 9,130   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 5   Downloaded: 0
Sometimes we only have VBScript, but it would still be nice to have database like features or persistence and transactions.
Algorithms & Recipes
Algorithms
Posted: 18 Jun 2010   Updated: 18 Jun 2010   Views: 8,655   Rating: 4.83/5    Votes: 3   Popularity: 2.31
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 6   Downloaded: 0
COBOL already has SEARCH ALL, but what if you want to find table values which bracket a searched value - here is the solution.
Programming Tips
General
Posted: 29 Mar 2011   Updated: 29 Mar 2011   Views: 7,826   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 4   Downloaded: 0
Having spent far too much time benchmarking different code recently, here are some lessons learned!
String handling
General
Posted: 25 Mar 2007   Updated: 25 Mar 2007   Views: 26,753   Rating: 4.04/5    Votes: 8   Popularity: 3.65
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   Downloaded: 0
Concatenating strings is critical in many dynamic content situations. Here is how to make it scale and then be fast and scale.

Average blogs rating: 5.00

C / C++ Language
General
Posted: 23 Nov 2012   Updated: 23 Nov 2012   Views: 3,885   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Life can be more fun in tuples!
Posted: 26 Nov 2012   Updated: 26 Nov 2012   Views: 2,598   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
C takes far too long to code up when complex data marshalling or logic gets involved. Also, the very act of writing it is so slow because of its challenges to the IDE.
Java
Beginners
Posted: 23 Nov 2012   Updated: 23 Nov 2012   Views: 3,731   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 0
Blue Sky Thinking In JavaJava does not allow strong interactions with the memory manager other than via extensions (like JVMTI). However, for some JVMs (the Oracle/Sun JVM for example) all is not lost.The challenge I faced was to move over to swapping out very large data structures to disk when the
Posted: 3 Dec 2012   Updated: 3 Dec 2012   Views: 4,062   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
A very fast Sin function for Java.
Exception Handling
General
Posted: 19 May 2010   Updated: 19 May 2010   Views: 6,037   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 0   Downloaded: 0
 Sometimes things don't work out the waywe expect!Micro Focus Managed COBOL has a powerful and flexible exception handling system evolved from similar systems in Java, VB and C#. Here is a quick introduction.The 2002 standard for COBOL did introduce an exception handling mechanism. However, this mec
String handling
Text Conversion
Posted: 23 Dec 2009   Updated: 23 Dec 2009   Views: 7,402   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
A little known but shockingly useful feature of Excel is that you can stick strings together using the & operator in formulaeMy wife asked me how to make a column which has only the month and year from a date column in it.
Uncategorised Technical Blogs
General
Posted: 23 Dec 2009   Updated: 23 Dec 2009   Views: 5,646   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 2   Downloaded: 0
Recently there has been some discussions of COBOL for .net which have been very ill informed. Here I hope to indicate how far COBOL has evolved and how its continues to be an excellent language for conveying programmer intent - especially for business paradigm programs.It is very easy to pick a nast
Posted: 23 Dec 2009   Updated: 23 Dec 2009   Views: 4,887   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 2   Downloaded: 0
Introduction - Why? this project sprang from a real need. Whilst it is possible to browse subversion from a web browser, the handling of non html files is a pain. We wanted a program which would show html files as web pages and all other files as text. This approach alows people to just click aroun
Posted: 13 Jan 2010   Updated: 13 Jan 2010   Views: 6,273   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 0   Downloaded: 0
Inthe highly complex and interconnected contemporary world, computersand humans interact continuously. We need a modelling approach whichcan shed light on the similarities between different players of thisinteraction rather than sub-divide this interconnected world intoartificially specialist domain
Posted: 19 May 2010   Updated: 19 May 2010   Views: 4,310   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 0   Downloaded: 0
Rolling Out The Big Guns - Micro Focus Managed COBOL Does Generic Delegates.Delegates are a managed code way of implementing methods by reference. In C these things are called function pointers. However, function pointers are just plane dangerous (they cause things to crash and lack much in the way
Posted: 19 May 2010   Updated: 19 May 2010   Views: 4,196   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Creative Commons Attribution-ShareAlike 2.5 License      Bookmarked: 0   Downloaded: 0
 Do you know the difference betweena value type and a class? Don't get yourself into deep water!Manage COBOL from Micro Focus not only support classes but also another, very interesting data type called a "Value Type". Here is what you need to know about them:Value Types are a lot like classes, but
No tips have been posted.
No reference articles have been posted.

alex turner
Web Developer
United Kingdom United Kingdom
I am now a Software Systems Developer - Senior Principal at Micro Focus Plc. I am honoured to work in a team developing new compiler and runtime technology for Micro Focus.
 
My past includes a Ph.D. in computational quantum mechanics, software consultancy and several/various software development and architecture positions.
 
For more - see
 
blog: http://nerds-central.blogspot.com
 
twitter: http://twitter.com/alexturner


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 20 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid