Stored Procedures CLI Cold Fusion

I am trying execute a stored procedures from Cold Fusion templates using the Intersolv ODBC driver. I cannot see how I can get any values returned, as CF does not provide any mechanism to retrieve the returned value from the stored procedure. If I was using MSQL I could get the results of a straight select statement back. e.g. select customer_name from customers where customer_number = input_param However this will not work in my stored procedure. What WILL work is select customer_name into xxxfrom customers where customer_number = input_param But then there is no way of retrieving this in CF. Is there anyone out there who has successfully and meaningfully used stored procedures in INFORMIX and exectuted them from CF? Kate Juliff