Sorry to beat a dying horse here, but I'm having issues getting a second
value to return using the custom tag. It works fine if I use a list, but if
I bind it to my cfc that runs a query it returns the first value but stops
after that. I can see it's talking to my CFC if I keep typing, but it never
returns anything.
Here's the CFC I'm using, I'm sure the problem is in here someplace. Other
than the Application.cfc I'm relatively new to CFCs and they way they work.
So I'm sure I missed something here.
<cfcomponent displayname="emailAutoSuggest" hint="Auto Suggests Email
Addresses" output="true">
<cffunction name="lookupEmail" displayname="lookupEmail"
hint="Queries for an email address based on string in form" access="remote"
output="false" returntype="String">
<cfargument name="search" displayName="search" type="Any"
hint="passes the form string to the query" required="false" />
<!--- define vars --->
<cfset var data = "">
<!--- do the searching --->
<cfquery datasource="#application.ds#" name="data">
SELECT leemail
FROM emailview
WHERE ({ fn UCASE(leemail) } LIKE { fn
UCASE('#ARGUMENTS.search#%') })
AND (frn_leuserid = #session.callmeasurement_uid#)
ORDER BY leemail
</cfquery>
<cfreturn data.leemail />
</cffunction>
</cfcomponent>
Thanks again for the help :)
~Steve
http://goodcf.instantspot.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302876
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
