I don't think it has anything to do with the SP. This:
<CFLOOP INDEX="type"
LIST="#termtype#">
tells CF to try to treat the entire query as a list, which is why you get
the error. Try
<CFLOOP INDEX="type"
LIST="#termtype.termtype#">
to pass just that field of the query as the list.
-----Original Message-----
From: Larry Lyons [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 10:34 AM
To: CF-Talk
Subject: Stored Procedures Problem
Greetings,
I'm having a problem with the return values from a stored procedure.
Here's the call to the SP:
<cfstoredproc procedure="sp_getrelationships"
datasource="EFGprograms"
returncode="Yes"
debug="Yes">
<!--- Input to stored procedure --->
<cfprocparam cfsqltype="CF_SQL_DECIMAL" value="#form.progid#"
dbvarname="@progid" type="In">
<!--- Output from stored proceedure --->
<cfprocresult name="termtype" resultset="5">
</cfstoredproc>
When we do a simple CF output, as in:
<cfoutput query="termtype">#termtype#<BR></cfoutput>
We get what appears to be a simple list:
30/15 Balloon,15 Year Fixed
Now when we want to loop through the list, as in
<CFLOOP INDEX="type"
LIST="#termtype#">
<cfoutput>#type#<BR></cfoutput>
</cfloop>
We get the following error message:
LIST
The value cannot be converted to a string because it is not a simple value.
Simple values are booleans, numbers, strings, and date-time values.
Any help in figuring out this error and how to correct it would be
appreciated.
Thanks,
larry
--
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 204
Manassas, Virginia 20109-3795
tel: (703) 393-7930
fax: (703) 393-2659
Web: http://www.pacel.com
http://www.ebstor.com
email: [EMAIL PROTECTED]
Chaos, panic, and disorder - my work here is done.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
