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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>