I am trying to use an auto complete cfc however when I run the code generates
the following error message
Security: The requested template has been denied access to
D:\ColdFusion8\wwwroot\WEB-INF\cfclasses\cfautosuggest2ecfc702696839.class.
The following is the internal exception message: access denied
(java.io.FilePermission
D:\ColdFusion8\wwwroot\WEB-INF\cfclasses\cfautosuggest2ecfc702696839.class
read)
The code I am using is
CFC page
<cfcomponent output="false">
<!--- Lookup used for auto suggest --->
<cffunction name="findapartment" returntype="string">
<cfargument name="search" type="any"
required="false" default="">
<!--- Define variables --->
<cfset var local = {} />
<!--- Query Location Table --->
<CFQUERY datasource="#ds#" username="#un#" password="#pw#" NAME="local.query">
SELECT unit_number
FROM SAMARIS_apartments
where building_nameid like '#session.Department#'
and Active_Unit like 'y'
and unit_number not like <cfqueryparam cfsqltype="cf_sql_varchar"
value="#ucase(arguments.search)#%" />
order by unit_number
</cfquery>
<!--- And return it as a List --->
<cfreturn valueList(local.query.unit_number)>
</cffunction>
</cfcomponent>
form page
<cfform action="autosuggest.cfm" method="post">
Park Name:<br />
n <cfinput type="text" name="apartmentnumber" size="50"
autosuggest="cfc:autosuggest. findapartment ({cfautosuggestvalue})"
autosuggestminlength="1" maxresultsdisplayed="10" /><br /><br />
</cfform>
Regards
Claude Raiola
B.Econ (Acc), B.Hot.Mngt.
Websites:
www.AustralianAccommodation.com
www.SAMARIS.NET
www.WebSiteSolutions.com.au
Mobile: 0414 228 948
From: [email protected] [mailto:[email protected]] On Behalf Of
Duncan
Sent: Monday, 29 December 2008 2:17 AM
To: [email protected]
Subject: [cfaussie] Re: regex issue - windows chard
Thanks Stephen - I will look into it.
On Thu, Dec 18, 2008 at 7:47 AM, Stephen M <[email protected]> wrote:
Coincidence, I was just doing some work on our RSS service today when
I noticed that IE doesn't handle weird caharcters pasted from WORD
(like single left quotes).
Firefox handles it gracefully, just putting a black diamond question
mark character in its place. But IE carks it.
Anyway, after searching the web I found this link to clean up the
XML. I haven't tried it yet but it look slike it will do the job
http://www.bennadel.com/index.cfm?dax=blog:1155.view
regards,
Stephen
On Dec 16, 12:00 pm, Duncan <[email protected]> wrote:
> Hi
>
> We have a small xml import and the client is putting in ALT+0160 characters,
> windows non breaking spaces. These come out as capital A's with a squiggle
> on top when displayed on an HTML page.
>
> I need to find and replace them on the import script, but I cant work out
> what to search for. can anyone help?
>
> Thanks
>
> --
> Duncan I Loxton
> [email protected]
--
Duncan I Loxton
[email protected]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---