Richard White wrote:
> <cfquery name="myquery" datasource="db">
> select functionName('[EMAIL PROTECTED]', 'myPassword')
> </cfquery>
>
> and it gives the error: cannot be indexed correctly.
That is because CF tries to create a column from the result with the
name "functionName('[EMAIL PROTECTED]', 'myPassword')" and that is not
a valid column name in CF.
<cfquery name="myquery" datasource="db">
select functionName('[EMAIL PROTECTED]', 'myPassword') AS queryResult
</cfquery>
> also how do i check if it returned a true or false from this (my stored
> function returns a boolean value true or false variable called queryResult)
Just dump the query and you will see what is in it.
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288544
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
