April 17th, 2018
Support >16meg uploads with wwHttp
You can now upload files larger than 16mb with wwhttp by using the new
lUseLargePostBufferflag and setting it to
.T.. Internally this class uses a file stream buffer to hold the POST buffer.
Updated wwFileStream Class to create >16mb Strings
The wwFileStream class provides a file based stream that allows creation of large strings that exceed 16mb and can be loaded into FoxPro strings as a whole. FoxPro supports >16mb strings in limited fashion (basically >16mb string can't be mutated), and this class allows you to create those strings.
Added helper method to send emails using the configuration settings made in
<yourApp>.ini. This makes is easier to send confirmation and notification emails from within your code.
messageParameter for Login
Authenticate("Login")method and the stock Login form now support displaying of a message as part of the login form by providing a Query string parameter for example:
wwJsonSerializer::Serialize() llFormat Option
Serialize()method now has an
llFormatparameter that allows specifying that the content should be pretty formatted. This is in addition to the
FormattedOutputflag on the serializer itself.
Fix: File2Var() UTF-8 Detection
Fixed bug in File2Var() that would cause problems with UTF-8 BOM detection in non-Western alphabets.
Fix: wwEncryption with Upper ASCII Characters
Fixed issue with wwEncryption not properly two way decrypting upper ASCII characters as the Code Page mapping was off. Switched to UTF-8 character sets when encoding and decoding which works on all ANSI codepages as long as the same code page is used to encode and decode.
Fix: .NET Module AdminAccount with multiple Accounts
Fix issue where AdminAccount was not properly working when multiple accounts were configured - account wouldn't validate against the list. Fixed.
February 7th, 2018
Security Weblog Post
Security Update: Update Admin.aspx Page to Disallow Unauthenticated Remote Access
Added logic to the Admin page to disallow access to the Admin page when not authenticated. Local machine access only displays an error message just like previous versions, but remote access now shows an error message and does not display the admin page links.
wwRequest::Form support for > 16meg Strings
Added support for reading Form variables when the Form buffer is greater than 16megs. FoxPro supports strings > 16megs as long as the string is not manipulated with any string mutating functions. But most importantly you can write a > 16meg string easily into file. More info.. Thanks to Keith Hackett for providing this solution.
Added an additional wwServer hook method that is fired after the server is initialized. This hook can be subclassed in the wwServer subclass, and is called after the server has been initialized but before the first request and
January 9th, 2018
Release Blog Post
Add back Apache Support and support Apache 2.4.x
Due to a number of requests from customers as well as generous support by way of contract work sponsored by James Heuer, we've added back support for Apache. Apache was dropped in Web Connection 6.15 and is now back with Apache 2.4 support plus a few additional new features.
Improved and simplified Apache Configuration
The New Project Wizard now works more reliably with automatically setting up an Apache server configuration. Configuration also has been simplified a bit with new features added to Apache for configuration of virtuals and scriptmaps. There's also better compatibility with direct support for
APPL_PHYSICAL_PATHsettings available the Apache request pay load which makes Apache more compatible with IIS's ISAPI implementation.
JsonDate() function in wwUtils
JsonDate()function that creates a JSON formatted date string that is properly UTC adjusted. Function lives in wwUtils but requires wwDotnetBridge/.NET to work.
Unload and Reload Individual COM Servers
There's a new
shutdowninstance.wc?pid=1234maintenance request for COM servers that shuts down a running COM instance that will be reloaded on the next hit. This can be used to remotely or internally restart individual instances that may be running with too much memory. Uses the Process ID as identifier.
Fix: Close FoxPro when Web Connection is Running
Fix issue where FoxPro cannot be shut down when Web Connection is running inside of the IDE in file mode with Cannot Quit Visual FoxPro error message. Hooked window events so shutdown works as expected in file mode. There's now also a wwServer::Shutdown method that is called when the server is shutdown - in file mode only.
Fix: wwJsonSerializer UTC Formatting
Fixed problem with the wwJsonSerializer where UTC dates weren't properly showing time zones other then current time zone.
Fix: wwJsonSerializer Deserialization Property Names
FoxPro supports only alpha-numeric plus
_for property names and this filter ensures that deserialized properties are cleaned up to remove all but those characters via a new
- wwJsonSerializer::Serialize() now relies on .NET
The wwJsonSerializer now uses .NET functions to serialize date values with proper UTC conversions that previously weren't handled.
wwJsonSerializer::DeserializeJson()already depended on .NET so not a big change.
October 16th, 2017
Release Blog Post
Better Error information for wwDotnetBridge Load Errors
wwDotnetBridge will now report slightly better error information on load failures, when failing to load the runtime or initial wwdotnetbridge instance.
Browse Button on the Server Form
The server form now has a Browse Site button that can open a browser window with the configured HomeSite url.
JsonSerialize() and JsonDeserialize() Helper Function
Added helper functions that let you use the JSON serializer without having to create a new object instance of wwJsonSerializer for each serialization process operation. The helpers simply wrap the
DeserializeJson()methods for easier usage.
Updated Process Templates
The default wwProcess templates for new process classes have been updated with a few enhancements: The template automatically adds Intellisense references for
THISand the Web Connection top level intrinsic objects (Request, Resonse, Server, Session) via
#if .F.blocks hide the the directives from executing code but allow the editor to find the Intellisense references. Process classes now also default to Scripts for missing controller/process class methods (ie headless scripts).
Buid Script Updates
build.batfile generated into a new project folder to create a packaged application ready for deployment has been updated to create a more complete deployment package. Previously the script only pulled the EXE and all the Web Connection system dlls required to deploy the binary folder. The updated script adds the Web and Data folders by default and creates the same structure as the project with Deploy/Web/Data top level folders.
Improvements in COM Server Load Times
COM Servers now load slightly faster as the COM load sequence has been optimized further after the last releases parallelization of server loading onto pool threads. Servers are now loaded onto MTA threads (rather than STA), which provides faster startup and less overhead in ASP.NET.
COM Server Loading Changes
We've made some changes to the way servers are loaded by separating the
OnLoad()steps to before and after actual server constructor operation. Previously both operations occurred in the confines of the FoxPro
Init()constructor function which meant any error forced an immediate abort without error information. Now
OnLoad()is fired after the server instance has been created and we can trap errors and display them when the first hit comes in. If an error occurred during load all subsequent requests display that load error - the server is effectively disabled, but you get full error information where previously the server would have not loaded with a cryptic COM error. This should also help with server load speed as load behavior is delayed until after the instance has been returned.
Server Count can now be Interactively set on Admin Page
You can now set the server count interactively on the admin page when using the Web Connection module. This means you can immediately change the number of instances that start up in COM or File Mode with Auto Server start.
Exe Servers hotswapped now automatically re-register for COM
When servers are uploaded and hotswapped via the Web Connection module, servers are now automatically re-registered with the
-regserverflag after successful upload. This should avoid problems if properties or methods were added to the COM server.
New Install-IIS-Features Powershell Script
Web Connection now ships with a Powershell script called
Install-IIS-Features.ps1that can be used to install IIS on a Desktop or Server that doesn't have IIS installed. The commands install the Web Service feature/role with all the options required to run Web Connection.
- Web Control Framework no longer loaded by Default
We've disabled the
wconnect.hwhich means by default the Web Control framework libraries will not be loaded any longer by
wconnect.prg. To enable Web Control framework loading you can reenable the
#UNDEFINE WWC_LOAD_WEBCONTROLS #DEFINE WWC_LOAD_WEBCONTROLS .T.
- Re-Register COM Servers
This release makes changes to the COM server interface of the wwServer class which requires for the type libraries to be updated. Make sure you re-register your server with
yourServer.exe -regserveror by using the new hotswapping features which auto-register the server after upload.
May 30th, 2017
An explicit function to initialize the .NET Runtime for the entire application. Although this function doesn't really do anything but create an instance of wwDotnetBridge with a specific version, the function makes it clear that this initializes the .NET version for the entire application.
Added properties to set dynamic properties on the user record. This allows you to add custom values to the user record without having to extend the schema explicitly (although you can do that as well - add a field and loSecurity.oUser.NewField).
Updated GetUniqueId() to be more Random
Changed the algorithm of GetUniqueId() using Guids that are redistributed over printable characters. The result is truly random Ids that are more unique with much smaller character counts - as little as 8 characters can provide safe ids for low impact applications with a max of 16 for near 100% fidelity.
Add content type to wwHttp::AddPostKey() when uploading files
You can now specify an optional content type when uploading files to a server using
.nHttpPostMode=2. The content type is appended to the file data sent to the server.
Fix: HMACSHA Hashing in wwEncryption
Fixed a salt encoding bug in the
ComputHash()function when calling the HMAC specific methods that require a salt value. Previously the salt value were added to the original string and then encoded. Now the salt value is only applied to the HMAC algorithm processor.
Fix: wwSFTP Large File Upload
Fixed an issue due to a buffer size issue with the underlying SSH library used in wwSFTP. Fixed by ignoring the
< %: expr % > for Templates and Scripts
Scripts and templates can now use automatic HTML encoding by using
< %: expr % >instead of
< %= EncodeHtml(expr) % >(spacing added for rendering). This makes it much easier to create XSS safe string output without more verbose syntax.
Visual Studio 2017 Addin Support and Visual Studio Gallery
The Web Connection Visual Studio Addin now supports Visual Studio 2017 and is also published to the Visual Studio Extension Gallery. This means you can install and update the addin directly from Visual Studio and once installed, the extension can automatically update itself.
New wwSFTP Class for SSH based FTP
There's a new wwSFTP class that provides secure FTP (SFTP only, not FTPS) to connect to SSH based SFTP servers. The class inherits from wwFTP so can be interchangeably with wwFtp based FTP code.
wwUserSecurity Password Encryption via cPasswordEncryptionKey
You can now encrypt your UserSercurity table's passwords by setting the
cPasswordEncryptionKeywhen you create your wwUserSecurity instance. When set passwords are automatically hashed before getting saved to the database.
wwEncryption::ComputeHash() adds HMAC Hash Algorithms
wwEncryption::ComputeHash() adds HMACSHA1, HMACSHA256, HMACSHA384 and HMACSHA512 algorithms. HMAC algorithms use complex salting cycles to add complexity and delay to generated hashes using an industry standard and repeatable algorithm.
wwRequest::GetLogicalPath() can return Proxied Urls
GetLogicalPath() now gets a parameter that when true will return the original URL specified before a proxy redirected the URL to your application. Useful when using extensionless URLs redirected via Rewrite rules in IIS.
Switch to Markdig Markdown Parser
Switch markdown parser to use the MarkDig .NET Markdown parser which natively supports Github flavored markdown and many Markdown extensions, including support for auto-links, extra emphasis (strikeout, sub/superscript etc.)
Allows generation of unique IDs based off a full or partial GUID value. Allows specification of a size that determines the size of the generated string between 15 and 32 characters where 32 is a full GUID.
String utility like ALINES() to return a collection of strings that allows you to specify a length to break lines at. Uses ALINES to capture lines and splits lines longer than specified via MEMLINES(). Useful for any code parsing that needs to ensure string literals don't exceed 255 characters in length.
wwDotnetBridge now supports TLS 1.2
wwDotnetBridge now sets the default HTTPS protocols settings to allow for SSL3, TLS1, TLS11 and TLS12. The default previously only allowed for SSL3 and TLS1. Overrides
ServicePointManager.SecurityProtocolon initial load of the .NET runtime. This affects any .NET API called that uses HTTP including Web service calls.
Explicit function that can be used to compile a single ASP Script page using the same mechanism used to run the page.
WCSCompile for pre-compiling Scripts on the Server Fixed the pre-compilation link on the Admin page that allows recompilation of Scripts (wcs style FoxPro script pages) on the the entire site. This feature now works recursively and can reliably compile scripts assuming all referenced dependencies used in scripts are loaded by the application before compilation occurs.
You can now create a new instance of wwHttp to be used in the wwJsonSerializer implementation when making service calls. You can create a new instance of wwHttp that is pre-configured with Authentication, headers etc. and pass it to this method before a service call.
wwUserSecurity Table Changes
The structure of the Usersecurity table has changed and the table structure has to be updated in order to work. Various fields have been expanded for supporting better security and encryption and field types have been changed to var chars instead of fixed width fields for simpler code and more efficient storage. Make sure you check the structure of the table in wwUserSecurity::CreateTable().
Add Markdig.dll to your Distribution
The new Markdig Markdown parser requires a new DLL to be used. If you're using hte
MarkdownParserclass or the
Markdown()function, make sure to update to this DLL. You can remove
September 16th, 2016
Angular 2.0 Project Template
Added a pre-configured Angular 2.0 template that is post-installed into a newly created project. A new walk through describes how to set up a new Angular 2.0 project.
wwUtils GetWords() Function
Added a new function that parses a string of multi-word text into a collection of words.
Updated Project Templates
Updated the project templates and Console Project Wizard to generate more comments and notifications when a new project is created, so it's easier to known what to do after the wizard finishes.
June 10th, 2016
no breaking changes
View Fox Code from Visual Studio Addin for Scripts/Templates
You can now see the FoxPro Code option on the Visual Studio context menu for scripts and templates and even static HTML pages if the page contains
SourceFile="<filename>". The file name can contain a
~virtual path like:
SourceFile="~/../Deploy/MyProcess.prg"which points back to the source code folder from the Web folder.
Web Connection Handler File Upload
In addition to being able to upload a server EXE file, the handler now supports uploading of arbitrary files to the application's
deploy\tempfolder from the Handler admin page. This makes it easier to push files to the server without having to install an FTP server. Make sure you set the application's request limits to allow larger uploads.
wwDotnetBridge::InvokeMethodAsync() and wwDotnetBridge::InvokeStaticMethodAysnc()
New method that allows invoking .NET methods on an instance asynchronously. You pass in callback object that receives
OnError()callbacks to get notified of completion of the async operation.
Function that returns a human readable string date or time (English only) such as just now, 10 minutes ago, 3 hours ago, yesterday. Anything over a year is turned into a short date: May 1, 2015.
wwUtils::FormatValue and wwUtils::FormatString
Two methods that use .NET string formatting to allow you to use sophisticated string formatting in FoxPro. Easily create nicely formatted date strings, MIME or ISO date formats, non-padded number strings formatted to decimal places with automatic localized formatting.
cursor_legacy:cursorNameto wwJsonSerialize table serialization
You can now serialize cursors in the 'old' default format which included
Countproperties for the actual data array and record count. Provided for backwards compatibility.
Fix wwMaint Server File Editor
Fix bug to properly write the correct file out to disk.
New Project Wizard
Created an updated New Project Wizard that creates a self contained directory structure that holds code, data and Web content. The Wizard also auto configures all paths and related links in such a way that the application should be xcopy deployable if you take the entire folder structure to the server. The new structure links back to Web Connection source files in the original Web Connection install folder, and separates logic for your own projects away from the Web Connection core files.
New Project Wizard can now generate a REST Service
The new project and new process Wizards now include an option to select the process class type to create. You can either create a standard Web Connection wwProcess class or a wwRestProject. The Rest project creates a service method sample.
New Projects generate a Server Configuration Script
The New Project Wizard now also generates a
<YourApp>_ServerSetup.prgfile that is FoxPro PRG based script that can configure your Web application. The script is linked from
<YourApp>Main.prgand can be run it
<YourApp>.exe configfrom the command line in a deployed application.
Partial Pages Script and Templates
There is now support for partial page references that allow you to render child pages from your Scripts and Templates. You can simply reference child pages with Web relative paths using
< %= RenderPartial("~/PartialPage") % >where the ~/ points to the root of the Web site. You can also hard reference a file with a full path.
Scripts and Templates now support multi-line expressions
Script and template pages now can use
< %= expr() % >tags that span multiple lines with line breaks. This especially simplifies use cases where you use complex Html Helpers that include style information. All line breaks are converted to spaces. NOTE: This can cause a problem if you have literal strings that include CHR(13) or CHR(10) values.
Native Markdown Support in Scripts and Templates
Script and template pages can embed
< markdown >and
< \markdown >tags to embed Markdown text into the markup. The Markdown is parsed inline as the Script or Template page is parsed.
Improved handling of Extensionless Urls
Extensionless URLs are common on the Web and this version of Web Connection adds improved support for them by providing a clean re-write rule (needs to be uncommented) and some additional logic in
Layout Pages and Sections for Script and Templates
You can now also create Layout or "Master" pages for scripts and templates that serve as 'common content' containers for content pages. Layout pages typically contain HTML header and common page chrome data - page headers, menus, sidebars that are common to many pages. Layout pages are called from Content pages via
< % Layout="~/_layout.wc" % >which renders the layout page, which in turn renders the content page into a
< %= RenderContent() % >area. Layout pages can also contain section directives to let the content page provide content to embed into the Layout page.
Completely Rewritten Message Board
The message board sample application has been re-written from scratch as an MVC style application using the scripting features in Web Connection 6.0. This application serves as a full featured example for doing MVC style development with Web Connection.
New Markdown Parser
MarkdownParserExtendedclasses that allow parsing of Markdown text to HTML. Markdown is a popular text editing format for developer Web sites and CMS systems that simplifies text input via the simple markup formatting of the Markdown Syntax.
Added a small function that allows 'debouncing' events to a specified number of milliseconds. Allows throttling high volume events like
window.resize()or drag events to be held and fire only at specified intervals to avoid overloading and hanging the browser.
New Visual Studio 2015 VSIX Add-in
The Web Connection add-in has been updated to a full VSIX add-in that can be installed from Explorer by double-clicking. Functionality has also been updated to support View In Browser functionality for any type of HTML file including Web Connection Script files to make it easier to launch in the browser. If no configuration is provided the View in Browser feature still works with the default project configured URL.
Resolves a virtual path (~) to a physical path on disk by replacing the virtual path specifier with the application path.
Allow Console.exe to run out of folders other than Wconnect Install Folder
Console.exe can now run from any location. When the console run it'll now explicitly change path to the /wconnect install folder and change back to the original folder when complete.
.NET Handler Faster COM Server Loading
Initial loading of COM servers when the servers are loaded has been improved significantly by removing a redundant load/unload cycle. Servers should now load twice as fast as previously.
.NET Handler now allows Hotswapping of File Based Servers
You can now use File based messaging with the .NET Module and hotswap EXE servers. Like the COM Server feature, hotswapping allows dynamic updates of the server EXE file without shutting down IIS/Application Pools.
.NET Handler StatusPage Updates
The .NET module now supports ~\ virtual paths for TempPath and ExeFile paths, and the status page now displays the fully resolved OS path.
Method that allows wwDotnetBridge to set a value from the .NET
System.Convertstatic class in a simpler way. Allows access to all
ComValue::SetUInt64 and SetUInt32 Methods
Added additional type conversions for UInt64 and UInt32 values.
New method adds the ability to retrieve an indexed value from an IList based object like arrays and generic lists.
New Html helper that renders the BootStrap DateTimePicker or optionally a native UI on mobile devices.
wwHtmlHelpers HtmlDataGrid OnAfterRowsRendered Event
Added an event that is fired when all rows in the grid have rendered. You can attach an expression that can then render HTML to inject additional HTML like a footer.
Updated HtmlErrorDisplay to use BootStrap alert themes and use font-awesome icons. Also added HtmlErrorDisplayConfig class that can be used to configure this method, as well as work as standard Web Connection form validation object.
Added a new method UnbindFormVars() that's very similar to Request.FormVarsToObject() but differs in that it returns an collection of ValidationErrors message if there are binding errors.
These new methods return value settings that can be embedded in script expressions into Web controls for
checkedvalues effectively. These methods basically use a model value on GET requests or Request.Form() values on post backs to write out their values facilitating display of PostBack control state.
This method returns multiple uploaded files as a collection. This function support the
MULTIPLEattribute on the File Upload input control by accessing multiple files from a single form variable.
GetFormMultiple()but returns a collection instead of an array, to simplify working with the data more easily.
Request.aFormVars()but returns a collection of objects with
Response.ExpandScript() and Response.ExpandTemplate() Path Improvements
These two functions now allow using ~ in the path to specify the virtual root. Example:
Response.ExpandScript("~\views\login.wcs"). You can also call either function without a parameter and it will use the template that references the Physical path of the request.
wwProcessOnAuthenticated() and wwProcessOnShowAuthenticationForm()
Added additional features around authentication to make it easier to override the default authentication functionality. OnAuthenticated() is called when a user is authenticated either after logging in or after retrieving previous login information.OnShowAuthenticationForm() allows overriding the logic for displaying the authentication form so it's easy to hook in a custom form UI. The default form display now uses a customizable template so you might not have to modify code at all.
Hook methods that allow you to hook into the REST process call pipeline before and after a REST method is called. Allows modifying global parameters (like JsonServer.IsDebugMode) or examine and modify individual requests.
Flattens a multi-line SQL into a single line that FoxPro can execute at runtime using Macro expressions. Useful to allow you to write SQL with TEXT/ENDTEXT. Used internally in wwBusinessExecute and wwBusinessQuery.
wwUtils.IsNumber Returns .T. if the provided value is a number, or a string that contains only digists and decimal/seperators (. and ,). Useful in many data binding scenarios to determine validity of number input.
This function can be used to display binding errors for input controls. By providing a control id and ValidationError collection errors can be displayed explicitly in relation to the related parent control.
New HtmlPager() function that can be used to place a pager on the stage by specifying a page number, total pages and a base navigation URL.
New wwJsonServiceClient Wrapper Class for Calling API Services
This class provides an abstract
CallService()method that automatically handles JSON serialization of parameters, making the HTTP call, and deserializing the JSON result back into a FoxPro class. The method makes the HTTP calls and handles all errors.
Added a flag to automatically format all output from Serialize() to be pretty formatted. This is a post-processing operation, so it adds some additional overhead, but can provide a nicer development experience.
Web Connection .NET Module compiled in .NET 4.0
We've changed the compilation mode of the .NET Module to .NET 4.0 which means that if you are running with .NET 2.0 on your server you need to switch (and possibly install) .NET 4.0. .NET 4.x is the default installed version on most servers and desktops today and 4.0 is forward compatible with 4.5 and later versions which improves stability and performance.
Legacy wwPageResponse Methods Removed
The default response class used in new projects is the wwPageResponse class. This class has been trimmed down, and has removed all legacy functions that modified headers, generated cursors and others. It removes the
HtmlHeader()the various form control functions and more. If you are using an old application that uses these function you can switch to use the wwPageResponse40 class instead which is a subclass that includes all the legacy function. Override
wwProcess::cResponseClassand specify wwPageResponse40 and make sure you set the
#define INCLUDE_LEGACY_RESPONSEMETHODS .T.in wconnect_override.h.
wwProcess::nPageScriptMode Default Change
The default setting of
nPageScriptModewhich determines how non-method loose script files with a mapped extension are processed has changed. The new default value is 3 - Scripts which uses
Response.ExpandScript(). Other Values: 2 - Web Control Framework Pages, 1 - Templates (
wwProcess::ErrorMsg() requires an extra lcIcon Parameter
The ErrorMsg() function now receives an extra parameter to receive an Icon that is used from FontAwesome. If you are overriding the ErrorMsg() function in your own applications, make sure to add the extra parameter signature.
wwJsonSerializer::Serialize "cursor:TCursor" now returns a raw Array
wwJsonSerializer now serializes cursors that are created with
cursor:CursorNamesyntax to a straight array. Previously this generated an object with a
cursor_rawarray:CursorNamegenerated a raw array. The
cursor:CursorNamesyntax now has the same behavior as the
cursor_rawarray:CursorNamesyntax, which still works, but it is deprecated in favor of the shorter and more logic syntax.
wwSession Table Length changed to VarChar(17)
We've added a new wwSession unique ID generation algorithm that generates longer and random ids which requires a wider field. Also changed the Fox and SQL types to VarChar so the data is no longer returned with trailing spaces. To update delete wwSession.dbf and let it recreate. For SQL either change the ID field to varchar(17) and update the Sql Scripts to reflect the new width or re-run the SQL Server configuration script from the Console.
wwDotnetBridge default .NET Version changed to .NET 4
Changed the default version that wwDotnetBridge uses if no version is specified to Version 4.0 (which includes all 4.x versions including 4.5 and 4.6). If you want to use .NET 2.0 explicitly pass
CREATEOBJECT("wwDotnetBridge","V2"). We recommend you always specify your version explicitly anyway and remember only the first load determines the runtime loaded.
Comment or report problem with topic