there are bugs in the tag lib of jrun 3.0.2
if u used JDBC-ODBC driver to connect the database, there are 2 problem
1. the Text field in MSSQL will be trunate!
<jrun:sql datasrc="ds" id="dd">
stored_proc_name
</jrun:sql>
if u used native driver (I used Native driver of MSSQL)
<jrun:sql datasrc="ds" id="dd">
{ call stored_proc_name }
</jrun:sql>
2. if the stored procedure consist of statement other than select, don't
work probably!
but the way to call it is different!
There is a new tag for stored procedure in beta version of jrun 3.1
the problems seem to be solved,
but I didn't test it through!
download the beta version to have a test yourself!
beta.allaire.com
Cheers,
King
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001 5:55 PM
Subject: JRUN Tag Lib with stored procedure
>
> We are trying to use the JRUN Tag Lib against a Sybase SQL server.
>
> If we do a straight "select ...from ...", it works fine. However, if we
> call a stored procedure it fails.
>
> Is the JRUN Tag Lib supporting calls to the stored procedures ?
>
> brgds Christophe
>
>
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
