Microsoft Access

Table of Contents

Description

This extension contains functions for displaying data from Microsoft Access databases.

See also How to add an extension, Using the Extension Dialog, Learn about DekiScript, Extensions Directory.

Configuration:

Before the Microsoft Access extension can be used, it must be configured with the access information to the database.

If you need to configure multiple databases for the same wiki, register this extension once for each database.  Use the following preference to specify a unique namespace value for each registration.  Invoke the service using this value instead of access.  For example, if you set namespace=mydb1, you would invoke the service with mydb1.table("...") instead of access.table("...").

NOTE: The folder in which the Microsoft Access database resides must have appropriate rights granted, otherwise you will receive a "Could not create lock file" error.

Access.Table(query : str) : xml

Show results of a SELECT query in a sortable table.

Parameters:

Name	Type	Description
query	str	SELECT query.

Samples:

	Output
To embed a SELECT query that displays a list of all users in the users table: {{ access.table("SELECT user_name as Name, user_email as Email FROM users") }}

---