|
query a MYSQL-database
{mpf:db=test||name=neue||sql=SELECT id,name FROM users;||driver=mysql||host=localhost:3306}
{mpf:test/id}
... {mpf:test/name/{mpf:var/key}} ...
{/mpf:test/id}
query an ODBC-database
{mpf:db=test||sql=SELECT id,name FROM users;||driver=odbc||host=test}
{mpf:test/id}
... {mpf:test/name/{mpf:var/key}} ...
{/mpf:test/id}
JDBC: query an ODBC-source
{mpf:db=test||sql=SELECT id,name FROM users;||driver=jdbc
||host=jdbc:odbc:test
||class=sun.jdbc.odbc.JdbcOdbcDriver}
{mpf:test/id}
... {mpf:test/name/{mpf:var/key}} ...
{/mpf:test/id}
JDBC: query a cloudscape-database
{mpf:db=test||sql=SELECT id,name FROM users;||driver=jdbc
||host=jdbc:rmi://127.0.0.1:1099/jdbc:cloudscape:d:/docs/_work/mydb
||class=COM.cloudscape.core.JDBCDriver}
{mpf:test/id}
... {mpf:test/name/{mpf:var/key}} ...
{/mpf:test/id}
JDBC: query a MySQL-database table
 | the following java package must be available: "mm.mysql.jar" |
{mpf:db=test||sql=SELECT id,name FROM users;||driver=jdbc
||host=jdbc:mysql://localhost:3306/mydb
||class=org.gjt.mm.mysql.Driver
||classes=E:/mm.mysql.jar}
{mpf:test/id}
... {mpf:test/name/{mpf:var/key}} ...
{/mpf:test/id}
ADODB: accessing text-files
| to access a file with ADODB-Textdriver - column names must be included to access attributes in resultset/recordset. |
| do not forget that SQL-statements must include file- and NOT table-name (e.g. SELECT * FROM myfile.csv) in this case. |
| host-parameter must contain at least the following information:
DefaultDir=C:\myFilePath;
Extensions=txt,csv,tab,asc;Driver={Microsoft Text Driver (*.txt; *.csv)_};
|
| DSN (data source name) is not required |
| do not forget to escape curly-brackets '{}' (as shown above)! |
ADODB: accessing MS Excel-files
| to access an Microsoft Excel file via ADODB you must define an range/area as table (see manual of Excel) |
| the column values of first row in this range/area become column names. |
| host-parameter must contain at least the following information:
DRIVER={Microsoft Excel Driver (*.xls)_};
DBQ=C:\myPath\myFile.xls;
|
| DSN (data source name) is not required |
| do not forget to escape curly-brackets '{}' (as shown above)! |
ADODB: accessing MS Access databases
| host-parameter must contain at least the following information:
DRIVER={Microsoft Access Driver (*.mdb)_};
DBQ=C:\myPath\myDatabase.mdb;
|
| you may also try OLEDB-driver (COM-based API):
Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=F:\myPath\myDatabase.mdb;
|
| DSN (data source name) is not required |
| do not forget to escape curly-brackets '{}' (as shown above)! |
| Known restriction: Microsoft.Jet.OLEDB.4.0 does not support attributes named "password" (Access-Driver does) |
{mpf:db=test||sql=SELECT id,name FROM users;||driver=ado
||host=PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=E:\\test.mdb;}
{mpf:test/id}
... {mpf:test/name/{mpf:var/key}} ...
{/mpf:test/id}
ADODB: accessing any databases using ODBC/DSN
| access to Microsoft SQL-server:
SERVER=127.0.0.1;DATABASE=MyDb;
DRIVER={SQL Server_};
DATABASE=MyDb;
UID=MyUserID;
PWD=MyPW;
|
| access to ORACLE (Microsoft Driver Version 1.0):
ConnectString=OracleServer.work;
DRIVER={Microsoft ODBC Driver for Oracle_};
UID=MyUserID;
PWD=MyPW;
|
| access to ORACLE (Microsoft Driver Version > 1.0):
SERVER=OracleServer.work;
DRIVER={Microsoft ODBC Driver for Oracle_};
UID=MyUserID;
PWD=MyPW;
|
| access to OLEDB-compliant database (COM-based API):
PROVIDER=SQLOLEDB;
DATA SOURCE=MyDSN;
DATABASE=MyDb;
UID=MyUserID;
PWD=MyPW;
|
| access any other ODBC-compliant database (C-based API):
DSN=MyDSNName;
UID=MyUserID;
PWD=MyPW;
|
| do not use curly brackets {} for driver names (DRIVER=) - use []-brackets instead (as shown above)! |
{mpf:db=test||sql=SELECT id,name FROM users;||driver=ado||host=DSN=myDSN;UID=myID;}
{mpf:test/id}
... {mpf:test/name/{mpf:var/key}} ...
{/mpf:test/id}
Hyperlink to scroll to previous page
{mpf:db=test...||page={mpf:param/get/pg}||...}
{mpf:MyDB/page_no||++1}
<a href="{mpf:url={mpf:link/url}||pg={mpf:eval={mpf:MyDB/page_no}-1}}">prev</a>
{/mpf:MyDB/page_no||++1}
Hyperlink to scroll to next page
{mpf:db=test...||page={mpf:param/get/pg}||...}
{mpf:MyDB/page_no||--{mpf:MyDB/page_count}}
<a href="{mpf:url={mpf:link/url}||pg={mpf:eval={mpf:MyDB/page_no}+1}}">next</a>
{/mpf:MyDB/page_no||--{mpf:MyDB/page_count}}
list available pages as Hyperlinks
| do not forget to handle first/last item in list (this is especially important if you work with tables to format items) |
{mpf:db=test...||page={mpf:param/get/pg}||...}
{mpf:set=cnt||data={mpf:MyDB/page_count}}
{mpf:loop={mpf:cnt}}
<a href="{mpf:url={mpf:link/url}||pg={mpf:loop/key}}">{mpf:loop/key}</a>
{mpf:loop/key||--{mpf:cnt}}, {/mpf:loop/key||--{mpf:cnt}}
{/mpf:loop={mpf:cnt}}
| 
