King:
ColdFusion has a tag which allows you to pick from the various resultsets
returned by a stored procedure. But I don't recall ever seeing anything
similar in the JDBC documents I've looked at.
If you haven't done so already, you might try looking at the JDBC 2.0 spec
to see whether this is supported.
Mike Farin
CyFi Services
> -----Original Message-----
> From: King [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 3:15 AM
> To: JRun-Talk
> Subject: JRun tag and stored procedure
>
>
> Dear all,
>
> we are using jrun sql tag to retrieve data from the stored
> procedure (MSSQL)
> and we found that if the stored procedure has only select statement, it
> works fine. However, if the stored procedure contains
> "insert/update/delete"
> statements,
> the tag can't give us output properly! (it returns the resultset of the
> insert statement, how can I call it to return the resultset of select
> statement for me?)
>
> --------------------------------
> CREATE PROCEDURE sp_get_test
> as
> insert into temp1 values ('11')
> select * from temp1
> --------------------------------
>
> Thank you very much!
>
> Regards,
> King
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
