ODBC, Stored Procedures ,Cold Fusion... 
Author Message
 ODBC, Stored Procedures ,Cold Fusion...

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



Wed, 18 Jun 1902 08:00:00 GMT
 ODBC, Stored Procedures ,Cold Fusion...

Quote:

> 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

Hi Kate,

at the moment I'm a bit confused what you really want. Do you need
the return value of a Stored Procedure in your application ?

SELECT spname() INTO variable FROM systables where tabid=1;

This would execute your Stored Procedure "spname()" and would
store the result into your variable. I think somehow this will work
in your Cold Fusion environment, too. Maybe you will not need
the variable, but the SELECT statement's NAME. Problem: The
Stored Procedure must return a single result and must not
return a result set.

Or do you want to store a select-statement's result into a
Stored Procedure variable ?

create procedure spname()
define var1 int;

         foreach select whatever INTO var1 from yourtable
                -- if you want to return the value ???
                return var1; -- if you have more than one row,
                             -- add "with resume" after the
                             -- return var1
         end foreach;
end procedure;

Bye

Stefan Weideneder



Wed, 18 Jun 1902 08:00:00 GMT
 ODBC, Stored Procedures ,Cold Fusion...
On Tue, 28 Jul 1998 00:06:53 +0100, Stefan Weideneder

Quote:


>> 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

>Hi Kate,

>at the moment I'm a bit confused what you really want. Do you need
>the return value of a Stored Procedure in your application ?

>SELECT spname() INTO variable FROM systables where tabid=1;

>This would execute your Stored Procedure "spname()" and would
>store the result into your variable. I think somehow this will work
>in your Cold Fusion environment, too. Maybe you will not need
>the variable, but the SELECT statement's NAME. Problem: The
>Stored Procedure must return a single result and must not
>return a result set.

>Or do you want to store a select-statement's result into a
>Stored Procedure variable ?

>create procedure spname()
>define var1 int;

>         foreach select whatever INTO var1 from yourtable
>            -- if you want to return the value ???
>            return var1; -- if you have more than one row,
>                             -- add "with resume" after the
>                         -- return var1
>         end foreach;
>end procedure;

Thanks Stefan,

I know how to get a value returned. What I can't work out is how to
receive the value  in a Cold Fusion template.

Kate



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. CA-Orange County-261514--Cold Fusion-Javascript-C-C++-ORACLE-SQLSERVER-Cold Fusion Developer

2. CA-Orange County-261514--Cold Fusion-Javascript-C-C++-ORACLE-SQLSERVER-Cold Fusion Developer

3. VA-Arlington-260457--Cold Fusion-HTML-ORACLE-Javascript-Cold Fusion Programmer

4. VA-Herndon-241647--Cold Fusion-Javascript-DHTML-Mac TCP-ORACLE-Cold Fusion Developer

5. GA-Atlanta-113141--Cold Fusion-HTML-ORACLE-UNIX-C-Intranet-Intranet Developers - Cold Fusion

6. VA-Herndon-241647--Cold Fusion-Javascript-DHTML-Mac TCP-ORACLE-Cold Fusion Developer

7. VA-Herndon-255862--Cold Fusion-Javascript-DHTML-MS ACCESS-ORACLE-Cold Fusion Developer

8. VA-McLean-242990--Cold Fusion-ORACLE-SQLSERVER-SYBASE-Cold Fusion Application Developer

9. VA-McLean-242990--Cold Fusion-ORACLE-SQLSERVER-SYBASE-Cold Fusion Application Developer

10. convert and cold fusion query into a stored procedure

11. Cold Fusion and Stored Procedures


 
Powered by phpBB® Forum Software