You're trying to return propID, but you don't reference it anywhere in
your Stored Procedure. The only time you reference it is with . This is just setting a variable, it's not a query, which
is what your function is expecting as a return type.
Thanks,
Eric
Bruce Sorge wrote:
> I have a CFC
propID is 'foo' which is not a valid query type. Change returntype="query"
to returntype="string" just to make it work as is. You will of course want
to change propID from 'foo' to your new ID and change the returntype to the
correct datatype for propID.
It seems to me from looking at the code that propID is just a string:
"foo". That's not a query, and you have your return type set to
"query". Change your return type to "string" or "any" and the error
will go away.
Chris
On Nov 6, 2007 10:43 AM, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> I have a
In the code you provided, you set propID as "foo", perform the SP call, and
return propID unchanged. You can add an out parameter to the SP call,
something similar to the following:
~|
Create robust enterprise, web RIAs.
Upgra
Well the function indicates to return a "query" structure where you are
returning a single ID. Change the CFFUNCTION to return an integer
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 06, 2007 11:44 AM
To: CF-Talk
Subject: CFC Not act
You set return type to query, but you set propID to foo and returned
it. foo is a string.
On Nov 6, 2007 10:43 AM, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> I have a CFC that both inserts a series of field variables and returns
> the ID number that was just created. I am getting an error that state
I'm not seeing where you are actually assigning the return from your SP
to propID. "foo" is not a query.
--Ben Doom
Bruce Sorge wrote:
> I have a CFC that both inserts a series of field variables and returns
> the ID number that was just created. I am getting an error that states
> "the value
There were a few things wrong with this once I stepped away, had a cup of
coffee and looked at it again. This is what happens when you are knee deep
into your work and then you get called up by your unit and don't look at
code for over two weeks. LOL
So what I did was remove the returntype attribu
You have specified the returnType as query, but you seem to be
returning only the ID. Change one or the other to make it happy.
On Nov 6, 2007 10:43 AM, Bruce Sorge <[EMAIL PROTECTED]> wrote:
> I have a CFC that both inserts a series of field variables and returns
> the ID number that was just cre
I have a CFC that both inserts a series of field variables and returns
the ID number that was just created. I am getting an error that states
"the value returned from the insertProposal function is not of type
query". Here is the function:
10 matches
Mail list logo