Return-Path: 
 <cocoon-users-return-34432-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 91883 invoked by uid 500); 3 Jun 2002 17:09:40 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 91872 invoked from network); 3 Jun 2002 17:09:39 -0000
Message-ID: <3CFBA359.C039005F@dnai.com>
Date: Mon, 03 Jun 2002 10:11:53 -0700
From: daniel robinson <drob@dnai.com>
Reply-To: dan@drob.org
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
To: cocoon-users@xml.apache.org
Subject: SQL, Actions, ESQL Help Please!!!
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi,

I've been poking around but I'm clueless (yes, generally as well as
specifically).

What am I trying to do:

1) I have a PostgreSQL table with a field called "StoryText" defined as
a "Text" (virtually unlmited size text data)
2) I wish to update this table with the contents of an XML element ( say

<StoryText>a lot of text with special characters like ' as well as
html code <a href="www.clueless.com/IAM">who is this
noob?</a></StoryText>

3) I've tried ESQL like this:

<esql:connection>
     <esql:pool>VSolano</esql:pool>
     <esql:execute-query>
       <esql:query>


        update "Story" set "Title"= '<xsp-request:get-parameter
name="Title"/>',
                              "Description"= '<xsp-request:get-parameter
name="Description"/>',
                              StoryText"= '<xsp-request:get-parameter
name="StoryText"/>'
                where "ContentID" = '<xsp-request:get-parameter
name="ContentID"/>'

       </esql:query>
     </esql:execute-query>
   </esql:connection>

There have been many attempts :).  I HAVE been able to update the table
when I use literals and short values for the updates themselves (i.e.
...set "Title"='This is for noobs'....).

My questions:

1) should I be using ESQL or Actions?  There has been some discussion on
the listserve that seems to indicate that Actions are the way to go.
2) do the DatabaseActions work?  there seems to have been a lot of
confusion about this.
3) Does someone have examples - hopefully of exactly the sort of thing
I'm trying to do - Store XML in the db - I'm sure I'm not the first.

I am putting together documentation so that when this is all over I can
SHARE IT, because no-one should have to live through this again.  :)

Thanks,

Dan



---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

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