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
