Hi,
Is there anything like LaTeXDB:
<http://privat.hgesser.com/software/latexdb/>
in ConTeXt?
The short story is that LaTeXDB makes it possible to include SQL queries in a LaTeX document.
I have played with the following code:
% interface=en output=pdftex
\unprotect
\definesystemvariable{sq}
\def\startSQLquery#1#2\stopSQLquery
{\setvalue{\??sq:#1}{#2}}\def\applySQLquery#1% last line is quit without ;
{\bgroup
\def\\{\rawcharacter{`\\}}%
\long\def\next##1;##2%
{\ifx##2\empty
\immediate\write\scratchwrite{##1}%
[EMAIL PROTECTED]@EA\relax
\else
\immediate\write\scratchwrite{##1;}%
[EMAIL PROTECTED]
\fi##2}%
\immediate\openout\scratchwrite=\bufferprefix\jobname-sql.sql
[EMAIL PROTECTED]:#1\endcsname\empty\empty;\empty\relax
\immediate\closeout\scratchwrite
\executeSQLcommand
{\bufferprefix\jobname-sql.sql}%
{\bufferprefix\jobname-sql.log}%
\egroup}\def\executeSQLcommand#1#2%
% {\executesystemcommand{c:/mysql/bin/mysql.exe < #1 > #2}}
{\executesystemcommand{c:/mysql/bin/mysqldump.exe -r #2 < #1}}\protect % \endinput
\starttext
\startSQLquery{test}
connect cod ;
% select leerling into outfile "e:/tmp/test.tmp" from ws_p ;
%select data into outfile "e:/tmp/test.tmp"
select data from ws_p ;
quit
\stopSQLquery\applySQLquery{test}
\typefile{e:/tmp/test.tmp}
\stoptext
t
There have been discussions of extending the (fptex) url input file support with something that could talk to ports (services) ... maybe its time to pick up that thread.
Hans
-------------------------------------------------------------------------
Hans Hagen | PRAGMA ADE | [EMAIL PROTECTED]
Ridderstraat 27 | 8061 GH Hasselt | The Netherlands
tel: +31 (0)38 477 53 69 | fax: +31 (0)38 477 53 74 | www.pragma-ade.com
-------------------------------------------------------------------------
information: http://www.pragma-ade.com/roadmap.pdf
documentation: http://www.pragma-ade.com/showcase.pdf
-------------------------------------------------------------------------_______________________________________________ ntg-context mailing list [EMAIL PROTECTED] http://www.ntg.nl/mailman/listinfo/ntg-context
