ODBC, Stored Procedures ,Cold Fusion...
Posted in 1998
Kate Juliff — — source: Informix-list mailing list archive (1991-1998)
I am hoping to find someone who has used stored procedures in Informix and executed them from Cold Fusion. I know that CF cannot pick up the return value, but had hoped I could somehow get the results of a select statement in an Informix SP from CF. As I understand it, if an MSQL stored procedure is executed from CF, then, if the procedure containd a select statement, the results of the select are passed to CF. However, with Informix, a select (as opposed to a "select into") statement is not available in a SP and so I cannot use a select statement to pass results to CF. If anyone at all has used Informix SPs with CF, I'd really appreciate them getting in touch. Thanks, Kate Juliff