Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@cocoon.apache.org
From: <argyn@cox.net>
To: users@cocoon.apache.org
Subject: end-2-end Sybase ESQL stored proc example
Date: Wed, 10 Mar 2004 9:30:22 -0500
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Message-Id: <20040310143019.SSLD11398.lakemtao02.cox.net@smtp.east.cox.net>

Hello

I'm trying to call a stored procedure in Sybase or MS SQL Server. This stored proc accepts parameters and returns me a ResultSet. Basically, it has something like "select * from T where name = @appl_nme", where @appl_nme is the input parameter. I plan to use Sybase's jConnect JDBC library.

Now, I tried to find one end-to-end example with how to setup Sybase or MS SQL Server and Cocoon, and write ESQL expressions in XSP. I couldn't find any samples, but saw a few posts on subj with problems calling stored procs.

Does anyone know of such an example in Cocoon 2.1? 

I don't have to use XSP by the way. Maybe there's a better way in C2.1 to do this sort of things.

thanks,
Argyn


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