Ferran, Yes you can do any SQL statement using the transformer. An insert may look like this:
<?xml version="1.0"?> <page xmlns:sql="http://apache.org/cocoon/SQL/2.0";> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0";> <query name="insert_query" isstoredprocedure="false" > insert into tablex ( username, password, activeFlag ) values ('<substitute-value sql:name="username"/>', '<substitute-value sql:name="password"/>', 'Y') </query> </execute-query> </page> Then process this throught the SQLTransformer and you should see your data in the DB (assuming you have access to insert to this table of course!). HTH, Aaron -----Original Message----- From: Ferran Urgell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 7:10 AM To: [EMAIL PROTECTED] Subject: MySQL Insert Note: I'm using the sql transformer for the querys.....Can I use the sql transformer for the inserts ? --------------------------------------------------------------------- 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]>
