> <cfquery ...>
> SELECT function(argument)
> </cfquery>


Thanks for the reply, i am getting an error running this code saying that it 
cannot be indexed correctly. 

my stored function takes in 2 varchars - an email address and password and 
returns a boolean, so when i call the function i write the following:

<cfquery name="myquery" datasource="db">
  select functionName('[EMAIL PROTECTED]', 'myPassword')
</cfquery>

and it gives the error: cannot be indexed correctly. 
is it something to do with the quotation marks i am using?

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)

Thanks very much for your help

richard 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288540
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to