The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

xAPdb - launched


  • Subject: xAPdb - launched
  • From: mark_harrison_uk2
  • Date: Fri, 21 May 2004 14:38:00 +0000

xAPdb is now available from www.ascentium.co.uk\xap

xAPdb performs queries on a database in response to certain xAP
messages, returning the database results as xAP messages themselves.
xAPlogger is database independant, and uses any ODBC data source as
the message store.

xAPdb listens for messages in the database.query schema, and responds
in the database.result schema. xAPdb sends one xAP message per row
returned from the database.

The database.query schema defines a single body part, also called
database.query, as follows:
database.query
{
sql=SQL query to be run
datasource=name of ODBC data source against which the SQL should
be run
}

The database.result schema defines a two body part, called
database.query and database.result, as follows:
database.query
{
sql=SQL query to which this is part of the response
datasource=ODBC data source for the xAP message to which this is
part of the response
totalrows=Number of rows the query has returned
row=Row number for which this message contains the data
}
database.result
{
One keyword/value pair is returned for every SQL entity returned in
the query.
The name of the keyword is the field name of the SQL entity being
returned.
}






xAP_Automation Main Index | xAP_Automation Thread Index | xAP_Automation Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.