Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Reply-To: <terry@rostersetc.com>
From: "Terry Paddy" <terry@rostersetc.com>
To: <cocoon-users@xml.apache.org>
Subject: RE: SQLProcessor - attributes of the query tag? 
Date: Thu, 9 Mar 2000 13:41:59 +1300
Message-ID: <000001bf8969$250020c0$0301a8c0@computer>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Importance: Normal
In-Reply-To: 
 <Pine.LNX.4.10.10003081908280.23953-100000@phoenix.webslingerZ.com>

Thanks for the info Donald

>Weellll.... I have an SQLEditorProcessor that I wrote. It's horrid, nasty,
>ugly code, but it _is_ functional, horrid, nasty, ugly code. It places
>some contraints on how you must name tables and columns, though I think I
>let you circumvent that through use of specially named meta tables. If you
>want to take a look at it, I'll send it your way; I'd be happy to open the
>source but wouldn't want to, uh, impose it upon anyone.

I'd appreciate looking at it if you could send it to me

Thanks... Terry
Christchurch, New Zealand

-----Original Message-----
From: Donald Ball [mailto:balld@webslingerZ.com]
Sent: Thursday, 9 March 2000 13:17
To: cocoon-users@xml.apache.org; terry@rostersetc.com
Subject: RE: SQLProcessor - attributes of the query tag?


On Fri, 3 Mar 2000, Terry Paddy wrote:

>
> Hi Donald, I sort of answered my own question by looking at the source
code
> namely the master_default_query_props, it's just that the SQLProcessor doc
> page says ... "A partial list of attributes is:" so I assumed that there
> were more.
>
> The only extras I found in the source were
> count-attribute
> query-attribute
> update-rows-attribute
> session-variable-left-delimiter
> session-variable-right-delimiter
>
> I haven't worked out what they do yet :-)

Aha, foolish me, I must update these docs. Okay, just for your edification
right now, count-, query-, and update-rows- attributes tell sqlprocessor
to add attributes whose names are the values of these attributes to the
result doc-element, whose values are the number of rows returned, the
actual SQL query performed, and the number of rows updated (by a SQL
UPDATE, DELETE, etc.). So you might get:

<query count-attribute="count" query-attribute="query"...></query>

<rowset count="1" query="select name from foo_table where id = 23">
 <row>
  <name>Foo</name>
 </row>
</rowset>

The first two are to help you do pages where you iterate through a rowset;
the last is for those doing admin SQL stuff through SQLProcessor.

> While I have 'your ear', is there a way of updating a database from a XML
> file? Or do I have to write that functionality myself?

Weellll.... I have an SQLEditorProcessor that I wrote. It's horrid, nasty,
ugly code, but it _is_ functional, horrid, nasty, ugly code. It places
some contraints on how you must name tables and columns, though I think I
let you circumvent that through use of specially named meta tables. If you
want to take a look at it, I'll send it your way; I'd be happy to open the
source but wouldn't want to, uh, impose it upon anyone.

Oh, a couple of people at apachecon were bemoaning the lack of db pooling
in SQLProcessor. After being embarassed in person, I reckon I'll actually
get around to throwing one in. Does anyone have a preference for which
open source database pool we use? It will, of course, be completely
optional.

- donald


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org