RE: Stored Procedures problem

Thanks Craig I missed using the resultset. I went to school in Surrey many years back. Jack -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 6:49 AM To: CF-Talk Subject: RE: Stored Procedures problem Try this.. -- CREATE

RE: Stored Procedures problem

Try this.. -- CREATE PROCEDURE dbo.Q_CheckItem @Items_id int AS SELECT card FROM Items WHERE Items_id = @Items_id -- #card.card# -- -Original Message- From: Jack Ince [mailto:[EMAIL PROTECTED] Sent: 06 March 2003 14:36

Re: Stored Procedures Problem

Thanks. That was it entirely. D'uh - slapping self on forehead etc. regards, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAI

Re: Stored Procedures Problem

Thanks all it worked. larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here

RE: Stored Procedures Problem

> When we do a simple CF output, as in: > > #termtype# > We get what appears to be a simple list: > > 30/15 Balloon,15 Year Fixed You are probably not getting a list, but rather the first record of a one row query resultset. The queryname being "termtype" and the columnname also being "termtype

RE: Stored Procedures Problem

I don't think it has anything to do with the SP. This: tells CF to try to treat the entire query as a list, which is why you get the error. Try to pass just that field of the query as the list. -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED]] Sent: Thursday, January