Protocols for Hyperlink Display

The following protocols are recognised by Dekho and are automatically displayed as hyperlinks in a table: http://, ftp://, and \\ (UNC paths). Note that trying to use file:// or mailto: will result in a security error in the Flash Player.

The select statement for a URL list may look like this:

SELECT 'http://documentserver/' + docid + '.doc' as url, docname as description FROM mydb.dbo.documents

It is important for the select statement of a URL list to contain a field called url and a field called description. You will probably need to alias these fields as shown in the example above.

The select statement for an image list may look like this:

SELECT 'http://images/' + propertyid + '.jpg' as url,  'http://images/' + propertyid + '.jpg' as description FROM mydb.sde.cadastre

Again, it is important for the select statement of an image list to contain a field called url and a field called description. You will probably need to alias these fields as shown in the example above.


Image Service Black Background Pixels