CFHTTP charset issue

2014-05-09 Thread Edward Chanter

We're using CFHTTP to query a java service. The system basically takes a
piece of text and posts it via CFHTTP to a custom service written in Java.
The problem is occuring because CF doesn't seem to be setting the character
encoding correctly. Consequently special characters like smart quotes are
becoming garbled.

My cfhttp code is very simple:

cfhttp method=post url=
http://localhost/?userid=#session.user.id#type=ExtractClean;
port=#application.SemxPort# charset=utf-8
cfhttpparam type=body value=#params.cleantext#
cfhttpparam type=header name=content-type value=text/html
/cfhttp

On the java side, our dev is using getCharacterEncoding() to return the
character encoding of the request, but it's coming back with null which
according to the docs means: the request does not specify a character
encoding

But I'm specifically setting the charset as utf-8 :(

What am I missing here?

Has anyone seen similar behaviour with CFHTTP and if so how did you resolve
it? Or it's possible that I'm doing something wrong with my CFHTTP tag but
the code is so simple it seems unlikely.

If anyone has any ideas I would be most grateful for your insight :)


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358593
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFHTTP charset issue

2014-05-09 Thread Edward Chanter

Paul, thank you so much, your suggestion sorted my problem out. You just
saved a bunch of people a load of time :)


On 9 May 2014 14:52, Paul Hastings p...@sustainablegis.com wrote:


 On 5/9/2014 4:13 PM, Edward Chanter wrote:
  What am I missing here?

 if that java bit is relying on getCharacterEncoding(), i think it gets the
 charset from Content-Type (not exactly sure why cfhttp charset param's
 not
 setting that). so maybe try setting it via Content-Type too.

 cfhttpparam type=header name=content-type
 value=text/html;charset=utf-8




 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358599
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Frustrated and on a deadline please assist

2013-11-19 Thread Edward Chanter

Maybe a dumb question but are you sure your autoSuggest is handling the //
CF puts at the start of a JSON string correctly? I've encountered this
problem when using the jQuery autoSuggest plugin.


On 19 November 2013 13:12, Will Swain w...@hothorse.com wrote:


 Total shot in the dark, but do you have cf debugging switched on? I've
 found that it interferes with Ajax calls in the past.


 On 19 November 2013 13:09, Steve 'Cutter' Blades 
 cold.fus...@cutterscrossing.com wrote:

 
  Can you post some sample code for the autosuggest config and the cfc
  method?
 
  Steve 'Cutter' Blades
  Adobe Community Professional
  Adobe Certified Expert
  Advanced Macromedia ColdFusion MX 7 Developer
  
  http://cutterscrossing.com
 
 
  Co-Author Learning Ext JS 3.2 Packt Publishing 2010
 
 
 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book
 
  The best way to predict the future is to help create it
 
  On 11/19/2013 7:05 AM, Torrent Girl wrote:
   Are you specifying the return type in your function call or are you
   pulling it out of the default WDDX Packet?
  
   Your output looks like it’s being returned as javascript escaped JSON.
   For example, the following using returntype=json,  yields the correct
   raw JSON array:
  
   URL: http://localhost/tests/jsonTest.
   cfc?method=giveMeJsonreturnformat=json
  
   Component:
  
   component displayname=JSONTest output=false{
  
   remote array function giveMeJson(){
   var a = arrayNew(1);
   arrayAppend(a,Miami Area Geriatric Education Center);
   arrayAppend(a,Miami Children's Hospital);
   arrayAppend(a,Miami Research Associates);
   arrayAppend(a,Miami University (Oxford, Ohio));
   arrayAppend(a,Miami Valley Hospital);
   arrayAppend(a,Miami, FL-546);
   arrayAppend(a,University of MiamiJackson Health System);
  
   return a;
  
   }
  
   }
  
   Result (which is exactly what should be returned by the request):
   [Miami Area Geriatric Education Center,Miami Children's Hospital,
   Miami Research Associates,Miami University (Oxford, Ohio),Miami
   Valley Hospital,Miami, FL-546,University of MiamiJackson Health
   System]
  
   Is the string your provided the response from Firebug, an echo of the
   var in javascript or what you see as the browser source when you
   navigate directly to it?  If so, are you using JQuery’s native .
   getJSON() method? That should give you an immediately workable JS
   array.
  
   HTH,
   Jon
  
  
   On Nov 19, 2013, at 12:36 AM, Torrent Girl moniqueb...@gmail.com
   wrote:
  
   This is what my response looks like:
  
   //\/\/[\Miami Area Geriatric Education Center\,\Miami Children's
   Hospital\,\Miami Research Associates\,\Miami University (Oxford,
   Ohio)\,\Miami Valley Hospital\,\Miami, FL-546\,\University of
   Miami\\\/Jackson Health System\]
  
  
   Ok I read about this on one of my many 1,000 google searches for this
  subject and someone mentioned using returnformat=plain. I tried that and
 I
  get the data back in the correct format:
  
  
 
 /contentfiles/ajaxlookup.cfc?method=getInstitutionsreturnformat=plainterm=Miami
  
  
   //[Miami Area Geriatric Education Center,Miami Children's
  Hospital,Miami Research Associates,Miami University (Oxford,
  Ohio),Miami Valley Hospital,Miami, FL-546,University of
  Miami\/Jackson Health System]
  
  
   BUT I still don't get the autosuggest drop down on the form.
  
  
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357115
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Issue with CFFeed

2013-08-07 Thread Edward Chanter

Small update to this thread, for the benefit of anyone in the future who
might have issues with it and finds this  in a google search.

My users noticed this morning that £ symbols were being converted to �

I'm not entirely sure what caused it but guessed correctly that it was
something to do with the encoding, probably on my Windows 2008 server
and/or IIS 7. The solution was to update the code I used to read and write
the feeds thusly:

cfhttp url=#getFeeds.feedurl# charset=utf-8
cfset xml = cfhttp.fileContent
cfset xml = rereplace(xml, !-- .*? --, )
cfset fileWrite(ram://feed#feedID#.xml, xml, utf-8)

with the utf-8 hardcoded in the cfhttp and fileWrite() code I'm now
seeing my £ symbols again.

I haven't tested this exhaustively but so far it seems to work nicely.


On 6 August 2013 13:11, Edward Chanter firew...@cc.uk.com wrote:

 As I said, your solution seems to work perfectly for all the feeds that
 were causing problems. Some have comments at the top, some at the bottom.
 In one case I couldn't see any comments at all but it seems to work anyway.

 I will post a bug report about this as suggested, it seems to me like
 CFFeed could just strip out any comments before parsing the feed.

 Thanks again for your help with this.


 On 6 August 2013 13:05, Raymond Camden raymondcam...@gmail.com wrote:


 What's fascinating is that as far as I can see, the second URL doesn't
 have
 a comment. Just saving it locally works. I bet the same works for the
 first
 URL too. To be clear, I was able to parse the XML just fine with cfhttp,
 so
 it is valid XML. If you want to work with that and not the cffeed result,
 you can skip the file save.


 On Tue, Aug 6, 2013 at 7:02 AM, Raymond Camden raymondcam...@gmail.com
 wrote:

  You may want to file a bug report for this too. Although the first feed
  URL fails to validate here http://validator.w3.org/feed/.
 
 
  On Tue, Aug 6, 2013 at 6:59 AM, Raymond Camden raymondcam...@gmail.com
 wrote:
 
  Another option is to remove the comment from the source XML.
  Unfortunately, cffeed doesn't let you source via a string, so you have
 to
  save it still.
 
  cfset u = 
  http://www.computerweekly.com/rss/All-Computer-Weekly-content.xml;
 
 


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356415
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Issue with CFFeed

2013-08-06 Thread Edward Chanter

We recently upgraded to CF10 and a small app we use for importing RSS feeds
seems to be rejecting certain feeds that worked perfectly fine in CF8. I've
put details of the feeds and errors below.

I've googled the problem and saw a blog from Ben Nadel about this issue
when using xmlParse() relating to the byte-order-mark. But it doesn't
really help me when using cffeed. I don't control the RSS feeds so have no
way to change their syntax to make them work with CF.

I'm just wondering if anyone else has encountered this problem with cffeed
in CF10 and knows of a solution?

The RSS feeds causing problems:
http://www.computerweekly.com/rss/All-Computer-Weekly-content.xml
http://www.nojitter.com/rss
http://www.zdnet.com/news/rss.xml

They all return the exact same error:
structDetailError: Invalid XML: Error on line 1: Content is not allowed in
prolog.MessageUnable to parse the feed: Either source specified is invalid
or feed is 
malformed.StackTracecoldfusion.syndication.FeedReader$FeedParseSourceException:
Unable to parse the feed: Either source specified is invalid or feed is
malformed. at
coldfusion.syndication.FeedReader.readFeed(FeedReader.java:173) at
coldfusion.syndication.FeedReader.init(FeedReader.java:100) at
coldfusion.tagext.io.FeedTag.doStartTag(FeedTag.java:92) at
coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799) at
cfimporter2ecfm1618229109._factor1(E:\domains\demo\cc\wwwroot\Simba\news_rss\importer.cfm:182)
at
cfimporter2ecfm1618229109._factor2(E:\domains\demo\cc\wwwroot\Simba\news_rss\importer.cfm:166)
at
cfimporter2ecfm1618229109.runPage(E:\domains\demo\cc\wwwroot\Simba\news_rss\importer.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444) at
coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at
coldfusion.filter.IpFilter.invoke(IpFilter.java:64) at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:428) at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at
coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at
coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at
coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151)
at coldfusion.CfmServlet.service(CfmServlet.java:219) at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:204) at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356386
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm

Re: Issue with CFFeed

2013-08-06 Thread Edward Chanter

Thanks for your response Ray, I tried the second of your two ideas because
it meant I didn't have to change any other code or start handling the XML
myself.

It works perfectly now, thank you so much for your help (again) :)




On 6 August 2013 12:59, Raymond Camden raymondcam...@gmail.com wrote:


 Another option is to remove the comment from the source XML. Unfortunately,
 cffeed doesn't let you source via a string, so you have to save it still.

 cfset u = 
 http://www.computerweekly.com/rss/All-Computer-Weekly-content.xml;

 cfhttp url=#u#
 cfset xml = cfhttp.fileContent
 cfset xml = rereplace(xml, !-- .*? --, )
 cfset fileWrite(ram://feed.xml, xml)
 cffeed source=ram://feed.xml query=entries
 cfdump var=#entries#



 On Tue, Aug 6, 2013 at 6:56 AM, Raymond Camden raymondcam...@gmail.com
 wrote:

  Just dump cffeed and switch to cfhttp.
 
  cfset u = 
  http://www.computerweekly.com/rss/All-Computer-Weekly-content.xml;
  cfhttp url=#u#
  cfset xml = cfhttp.fileContent
  cfdump var=#xmlParse(xml)#
 
  You'll have to work with the XML by hand of course.
 
 
  On Tue, Aug 6, 2013 at 5:35 AM, Edward Chanter firew...@cc.uk.com
 wrote:
 
 
  We recently upgraded to CF10 and a small app we use for importing RSS
  feeds
  seems to be rejecting certain feeds that worked perfectly fine in CF8.
  I've
  put details of the feeds and errors below.
 
  I've googled the problem and saw a blog from Ben Nadel about this issue
  when using xmlParse() relating to the byte-order-mark. But it doesn't
  really help me when using cffeed. I don't control the RSS feeds so have
 no
  way to change their syntax to make them work with CF.
 
  I'm just wondering if anyone else has encountered this problem with
 cffeed
  in CF10 and knows of a solution?
 
  The RSS feeds causing problems:
  http://www.computerweekly.com/rss/All-Computer-Weekly-content.xml
  http://www.nojitter.com/rss
  http://www.zdnet.com/news/rss.xml
 
  They all return the exact same error:
  structDetailError: Invalid XML: Error on line 1: Content is not allowed
 in
  prolog.MessageUnable to parse the feed: Either source specified is
 invalid
  or feed is
 
 malformed.StackTracecoldfusion.syndication.FeedReader$FeedParseSourceException:
  Unable to parse the feed: Either source specified is invalid or feed is
  malformed. at
  coldfusion.syndication.FeedReader.readFeed(FeedReader.java:173) at
  coldfusion.syndication.FeedReader.init(FeedReader.java:100) at
  coldfusion.tagext.io.FeedTag.doStartTag(FeedTag.java:92) at
  coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799) at
 
 
 cfimporter2ecfm1618229109._factor1(E:\domains\demo\cc\wwwroot\Simba\news_rss\importer.cfm:182)
  at
 
 
 cfimporter2ecfm1618229109._factor2(E:\domains\demo\cc\wwwroot\Simba\news_rss\importer.cfm:166)
  at
 
 
 cfimporter2ecfm1618229109.runPage(E:\domains\demo\cc\wwwroot\Simba\news_rss\importer.cfm:1)
  at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at
  coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444) at
  coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at
  coldfusion.filter.IpFilter.invoke(IpFilter.java:64) at
  coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:428)
 at
 
 
 coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
  at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
 at
  coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at
  coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at
  coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
 at
 
 
 coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
  at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at
  coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at
  coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at
  coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at
  coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at
 
 
 coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151)
  at coldfusion.CfmServlet.service(CfmServlet.java:219) at
  coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
 at
 
 
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
  at
 
 
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  at
 
 
 coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
  at
 coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
  at
 
 
 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  at
 
 
 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  at
 
 
 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224

Re: Issue with CFFeed

2013-08-06 Thread Edward Chanter

As I said, your solution seems to work perfectly for all the feeds that
were causing problems. Some have comments at the top, some at the bottom.
In one case I couldn't see any comments at all but it seems to work anyway.

I will post a bug report about this as suggested, it seems to me like
CFFeed could just strip out any comments before parsing the feed.

Thanks again for your help with this.


On 6 August 2013 13:05, Raymond Camden raymondcam...@gmail.com wrote:


 What's fascinating is that as far as I can see, the second URL doesn't have
 a comment. Just saving it locally works. I bet the same works for the first
 URL too. To be clear, I was able to parse the XML just fine with cfhttp, so
 it is valid XML. If you want to work with that and not the cffeed result,
 you can skip the file save.


 On Tue, Aug 6, 2013 at 7:02 AM, Raymond Camden raymondcam...@gmail.com
 wrote:

  You may want to file a bug report for this too. Although the first feed
  URL fails to validate here http://validator.w3.org/feed/.
 
 
  On Tue, Aug 6, 2013 at 6:59 AM, Raymond Camden raymondcam...@gmail.com
 wrote:
 
  Another option is to remove the comment from the source XML.
  Unfortunately, cffeed doesn't let you source via a string, so you have
 to
  save it still.
 
  cfset u = 
  http://www.computerweekly.com/rss/All-Computer-Weekly-content.xml;
 
 


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356392
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Weird directoryList problem after migration from CF8 to CF10

2013-05-10 Thread Edward Chanter

I'm using the CFM filemanager, it's an old piece of code but has worked
great until now. It's not supported any more and I've encountered a weird
problem after migrating from CF8 to CF10

I'm getting an error after a directoryList()

The code in question is: cfset thisDir = directoryList(directory,false)

the error is:

Attribute validation error for tag cfloop.
The value of the attribute query, which is currently thisDir, is invalid.

But when I do a cfdump of the  thisDir variable

cfset thisDir = directoryList(directory,false)
cfdump var=#thisDir#
cfabort

I get this:

array
1 ** correct path to file**\080909 - 2009 and the decisions you should take
part 2.doc
2  ** correct path to file**\1.jpg
3  ** correct path to file**\10 Challenges to Delivering a Unified Customer
Experience.pdf
4  ** correct path to file**\10 Challenges to Delivering a Unified Customer
Experience1.pdf
5  ** correct path to file**\10 Challenges to Delivering a Unified Customer
Experience2.pdf
...
3531  ** correct path to file**\~$mbership Summary - Padraig Drennan Sept
2011.docx

So it lists out the folder no problemo.

What am I missing here? I've been staring at it so long I can't see the
wood from the trees. Is there an undocumented change or bug in CF10 that
relates to directoryList()? I tried googling the problem but couldn't find
anything.

Any help would be most appreciated, I could find another file manager but
the CF-junkie in me is completely perplexed with this error and would
*love* to figure out what's happening.

Thanks in advance :)


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355704
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Weird directoryList problem after migration from CF8 to CF10

2013-05-10 Thread Edward Chanter

Hi Ray,

Just tried it:

cfset thisDir = directoryList(directory,false,query)

Now I get an error:
Complex object types cannot be converted to simple values.
The expression has requested a variable or an intermediate expression
result as a simple value. However, the result cannot be converted to a
simple value. Simple values are strings, numbers, boolean values, and
date/time values. Queries, arrays, and COM objects are examples of complex
values.
The most likely cause of the error is that you tried to use a complex value
as a simple one. For example, you tried to use a query variable in a cfif
tag.
The error occurred in
E:/domains/live/ce/wwwroot/admin/fileManager/cffm.cfc: line 419
Called from E:/domains/live/ce/wwwroot/admin/fileManager/cffm.cfm: line 597
Called from E:/domains/live/ce/wwwroot/admin/fileManager/cffm.cfm: line 1
417 : cfif type is dir
418 : !--- go deep! ---
419 : cfset directoryList(directory  path  name,true,dirInfo)
420 : /cfif
421 : /cfloop

The whole function that's causing the error is here:

cffunction access=public name=directoryList output=true
returnType=query HINT=List the contents of a directory, optionally
recursing into subdirectories.  This was implemented due to inconsistencies
between Coldfusion and Bluedragon.
cfargument name=directory type=string required=true
cfargument name=recurse type=boolean required=false default=false
!--- temp vars ---
!--- example:  list = DirectoryList(dir,,,true); ---
 cfargument name=dirInfo type=query required=false
cfargument name=thisDir type=query required=false
cfset var path=
cfset var temp=

cfif not recurse
cfdirectory name=temp directory=#directory#
cfreturn temp
cfelse
!--- We loop through until done recursing drive ---
cfif not isDefined(dirInfo)
cfset dirInfo =
queryNew(attributes,datelastmodified,mode,name,size,type,directory,fullPath)
/cfif
cfset thisDir = directoryList(directory,false,query)
!---cfdump var=#thisDir#
cfabort---
cfif server.os.name contains Windows
cfset path = \
cfelse
cfset path = /
/cfif
cfloop query=thisDir
cfset queryAddRow(dirInfo)
cfset querySetCell(dirInfo,attributes,attributes)
cfset querySetCell(dirInfo,datelastmodified,datelastmodified)
cfset querySetCell(dirInfo,mode,mode)
cfset querySetCell(dirInfo,name,name)
cfset querySetCell(dirInfo,size,size)
cfset querySetCell(dirInfo,type,type)
cfset querySetCell(dirInfo,directory,directory)
Cfset querySetCell(dirInfo,fullPath,directory  path  name)
cfif type is dir
!--- go deep! ---
cfset directoryList(directory  path  name,true,dirInfo)
/cfif
/cfloop
cfreturn dirInfo
/cfif
/cffunction

So I commented out:

cfif type is dir
!--- go deep! ---
cfset directoryList(directory  path  name,true,dirInfo)
/cfif

Now it loads a few lines in the filemanager and then throws another error.
Won't bore you with that one too.

I think I will have to find a more up to date file manager for this client
:)




On 10 May 2013 12:18, Raymond Camden raymondcam...@gmail.com wrote:


 In your cfdump, did you notice it said array? That's why you couldn't use
 the result as a query, it was an array.

 Did you check the docs?


 http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSce19a0e5a003e2edfa09972122fa66a2e8-7ffe.html

 Use the third argument to specify query and you should be fine.



 On Fri, May 10, 2013 at 6:06 AM, Edward Chanter firew...@cc.uk.com
 wrote:

 
  I'm using the CFM filemanager, it's an old piece of code but has worked
  great until now. It's not supported any more and I've encountered a weird
  problem after migrating from CF8 to CF10
 
  I'm getting an error after a directoryList()
 
  The code in question is: cfset thisDir = directoryList(directory,false)
 
  the error is:
 
  Attribute validation error for tag cfloop.
  The value of the attribute query, which is currently thisDir, is invalid.
 
  But when I do a cfdump of the  thisDir variable
 
  cfset thisDir = directoryList(directory,false)
  cfdump var=#thisDir#
  cfabort
 
  I get this:
 
  array
  1 ** correct path to file**\080909 - 2009 and the decisions you should
 take
  part 2.doc
  2  ** correct path to file**\1.jpg
  3  ** correct path to file**\10 Challenges to Delivering a Unified
 Customer
  Experience.pdf
  4  ** correct path to file**\10 Challenges to Delivering a Unified
 Customer
  Experience1.pdf
  5  ** correct path to file**\10 Challenges to Delivering a Unified
 Customer
  Experience2.pdf
  ...
  3531  ** correct path to file**\~$mbership Summary - Padraig Drennan Sept
  2011.docx
 
  So it lists out the folder no problemo.
 
  What am I missing here? I've been staring at it so long I can't see the
  wood from the trees. Is there an undocumented change or bug in CF10 that
  relates to directoryList()? I tried googling the problem but couldn't
 find
  anything.
 
  Any help would be most appreciated, I could find another file manager but
  the CF-junkie in me is completely perplexed with this error and would
  *love* to figure out what's happening.
 
  Thanks in advance

Re: Weird directoryList problem after migration from CF8 to CF10

2013-05-10 Thread Edward Chanter

That would explain it Steve, thanks :)

Turns out that when the client asked for all the functionality they didn't
need it. Now all they want is to upload, view and delete so I can build a
pretty simple page in CF for that. Problem solved.



On 10 May 2013 13:14, DURETTE, STEVEN J sd1...@att.com wrote:


 Ed,

 This is most likely due to the fact that directoryList is now a built in
 function in ColdFusion 10. It doesn't seem to have the same inputs as the
 function that you are using.

 Steve



 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355708
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Issue instantiating java on CF10

2013-04-26 Thread Edward Chanter

Dear Java Gurus,

I'm using some java to do text extraction, it was built on CF8 running on
linux but we recently moved to a new CF10 server running on windows. The
code doesn't work and I can't work out why. It's not using any custom jar
files and I was able to port the same code from one CF8 linux server to
another without a problem. Move it to CF10 windows (64bit) and I start
getting instantiation errors. I realise it's a whole different operating
system and 2 versions of CF so maybe my hope that it would just work was
misguided.

Just wondering if anyone with cf/java expertise had any ideas.

My code looks like this:

this.tweeturl = 
http://thefinanser.co.uk/fsclub/2013/04/why-all-banks-will-change-core-systems.html?utm_source=twitterfeedutm_medium=twitter
;

myExtractor = CreateObject( java, application.TextExtractor).init();

myExtractor.extract( this.tweeturl );
params.description = myExtractor.getExtractedText();

The error:

Object Instantiation Exception.
Class not found: application.TextExtractor

Simple case of a class not found I hear you say! Except I never installed
any classes for it. I just wrote the code on CF8 and it worked.

If anyone has any ideas I'd be most grateful.

-= Ed


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355600
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


cffeed parsing error in CF10 but it works perfectly in CF8

2013-04-25 Thread Edward Chanter

Does anyone know if the cffeed rss parser has changed in CF10? I have a
script that downloads some news headlines via Yahoo's RSS search feature.

On my CF8 server I can parse the feed using cffeed and it all works
perfectly. I ported the script over to the new CF10 server and I get a
parser error.

The feed URL is:
http://news.search.yahoo.com/rss?ei=UTF-8p=Denis Learyfr=news-us-ss

The error I'm seeing on CF10 is:
Unable to parse the feed error: Illegal character in query at index 52:
http://news.search.yahoo.com/rss?ei=UTF-8p=Denis Learyfr=news-us-ss

On CF8 I get the same feed items as I see in my browser when loading the
page manually.

Just wondering if anyone has encountered this before and found a solution?


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355585
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: cffeed parsing error in CF10 but it works perfectly in CF8

2013-04-25 Thread Edward Chanter

Solved my problem, it was the speechmarks.

Duh.

:)


On 25 April 2013 12:30, Edward Chanter firew...@cc.uk.com wrote:

 Does anyone know if the cffeed rss parser has changed in CF10? I have a
 script that downloads some news headlines via Yahoo's RSS search feature.

 On my CF8 server I can parse the feed using cffeed and it all works
 perfectly. I ported the script over to the new CF10 server and I get a
 parser error.

 The feed URL is:
 http://news.search.yahoo.com/rss?ei=UTF-8p=Denis Learyfr=news-us-ss

 The error I'm seeing on CF10 is:
 Unable to parse the feed error: Illegal character in query at index 52:
 http://news.search.yahoo.com/rss?ei=UTF-8p=Denis Learyfr=news-us-ss

 On CF8 I get the same feed items as I see in my browser when loading the
 page manually.

 Just wondering if anyone has encountered this before and found a solution?





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355586
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Weird issue with SOLR and cfindex - it won't index more than 10k rows

2013-02-27 Thread Edward Chanter

Thanks for the insight James, I will definitely try that out.


On 26 February 2013 23:40, James Mc jimmyma...@gmail.com wrote:


 The 10k records entry is only for autocommit which means that as soon as
 your collections reaches 10k uncommitted docs it will commit them and then
 start queuing up more.

 What could be happening is that you have more than 10k but less than 20k
 documents which would leave these documents uncommitted.

 Run the following after indexing.

 cfindex action=commit collection=st_items

 and see if that commits the remaining documents.

 I did more digging into the Solr config XML for my collection, and found
 this in the updateHandler:
 
 autoCommit
   maxDocs1/maxDocs
  !-- maxTime1000/maxTime --
 /autoCommit
 
 That seems to allow me to index more documents.
 
 Solr ended up not being able to do what I needed so I've used SQL
 full-text
 indexing instead.
 
 Just wanted to ask again if there's anyone out there who's had experience
 with this before
 
 
 
 
 
 On 25 February 2013 15:19, Edward Chanter firew...@cc.uk.com wrote:

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354704
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Weird issue with SOLR and cfindex - it won't index more than 10k rows

2013-02-26 Thread Edward Chanter

I did more digging into the Solr config XML for my collection, and found
this in the updateHandler:

autoCommit
  maxDocs1/maxDocs
 !-- maxTime1000/maxTime --
/autoCommit

That seems to allow me to index more documents.

Solr ended up not being able to do what I needed so I've used SQL full-text
indexing instead.

Just wanted to ask again if there's anyone out there who's had experience
with this before





On 25 February 2013 15:19, Edward Chanter firew...@cc.uk.com wrote:

 I'm trying to create a searchable index of database content using SOLR.
 It's a really simple implementation. The problem is that it won't let me
 index more that 10,000 rows of data. I can do 10k no problemo but as soon
 as I try to increase the number I get an HTTP 500 error from IIS, not CF,
 which also makes no sense.

 I'm running CF10/IIS 7.5 and the code lives within a CFWheels 1.1.8
 framework.

 I've included my code below but it's as basic as things get so I don't
 think the code is the problem.

 cftry
 cfcollection
 action = create
  collection = st_items
 engine = solr
 path = PATH_TO_\collections\

 cfcatch type=any
 /cfcatch
 /cftry

 cfquery name=itemList datasource=#application.dsn# maxrows=2
 select * from items where deletedat IS NULL
 /cfquery
  cfindex
  query=itemList
  collection=st_items
  action=refresh
  key=id
 title=title
 body=description,implications,whatchanging,whyimportant,textcapture

 If anyone has any ideas I'd be most grateful for your insight.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354701
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Weird issue with SOLR and cfindex - it won't index more than 10k rows

2013-02-25 Thread Edward Chanter

I'm trying to create a searchable index of database content using SOLR.
It's a really simple implementation. The problem is that it won't let me
index more that 10,000 rows of data. I can do 10k no problemo but as soon
as I try to increase the number I get an HTTP 500 error from IIS, not CF,
which also makes no sense.

I'm running CF10/IIS 7.5 and the code lives within a CFWheels 1.1.8
framework.

I've included my code below but it's as basic as things get so I don't
think the code is the problem.

cftry
cfcollection
action = create
collection = st_items
engine = solr
path = PATH_TO_\collections\

cfcatch type=any
/cfcatch
/cftry

cfquery name=itemList datasource=#application.dsn# maxrows=2
select * from items where deletedat IS NULL
/cfquery
cfindex
 query=itemList
 collection=st_items
 action=refresh
 key=id
title=title
body=description,implications,whatchanging,whyimportant,textcapture

If anyone has any ideas I'd be most grateful for your insight.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354680
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Need help with inserting non-standard characters into SQL from CF

2013-01-04 Thread Edward Chanter

First off, happy new year all!

I'm sure the answer to this is really simple but I've been banging my head
against a wall for a few hours so thought I'd ask my friendly neighbourhood
gurus.

I have a database table that needs to store currency symbols both as HTML
chars (%pound;), text code (ie. GBP) and the symbol (£)

The database table has the fields as UNICODE (nvarchar) and when I manually
paste the rows in via windows and SMSS I can put in currency symbols and
every other strange character I could find including japanese chars and
other stuff. They are all stored by SQL just fine and I can return the data
in a cfquery without any issues.

However when I try and run an insert query via CF, for example:

insert into currencies
(title,code,symbol,htmlsymbol)
values
('Pounds','GBP','£','pound;')

The £ gets converted to ??

When I insert it as N'£' I still get question marks but these have black
diamond shaped boxes around them.

I thought it was the database collation or something but as I said I can
type these characters into the table in my SMSS console and they are saved
without a problem.

We're running a linux CF server and windows database server, could that be
the problem? If so is there anyway I can get it working? I'm really
struggling to understand this problem so if anyone has encountered it
before and knows a solution or can point me in the right direction for some
reference material then I would be most grateful.

Thanks in advance ;

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353754
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Need help with inserting non-standard characters into SQL from CF

2013-01-04 Thread Edward Chanter

Thanks Russ, I was using the JTDS driver which doesn't have that setting so
I changed it to the MS SQL driver and ticked the relevant box. It's still
not working though. Given that I deleted and recreated the DSN should I
restart the server?


On 4 January 2013 10:41, Russ Michaels r...@michaels.me.uk wrote:


 If memory serves there is a setting in your dsn you need to change to
 enable utf8

 Regards
 Russ Michaels
 www.michaels.me.uk
 www.cfmldeveloper.com - Free CFML hosting for developers
 www.cfsearch.com - CF search engine
 On Jan 4, 2013 10:35 AM, Edward Chanter firew...@cc.uk.com wrote:

 
  First off, happy new year all!
 
  I'm sure the answer to this is really simple but I've been banging my
 head
  against a wall for a few hours so thought I'd ask my friendly
 neighbourhood
  gurus.
 
  I have a database table that needs to store currency symbols both as HTML
  chars (%pound;), text code (ie. GBP) and the symbol (£)
 
  The database table has the fields as UNICODE (nvarchar) and when I
 manually
  paste the rows in via windows and SMSS I can put in currency symbols and
  every other strange character I could find including japanese chars and
  other stuff. They are all stored by SQL just fine and I can return the
 data
  in a cfquery without any issues.
 
  However when I try and run an insert query via CF, for example:
 
  insert into currencies
  (title,code,symbol,htmlsymbol)
  values
  ('Pounds','GBP','£','pound;')
 
  The £ gets converted to ??
 
  When I insert it as N'£' I still get question marks but these have black
  diamond shaped boxes around them.
 
  I thought it was the database collation or something but as I said I can
  type these characters into the table in my SMSS console and they are
 saved
  without a problem.
 
  We're running a linux CF server and windows database server, could that
 be
  the problem? If so is there anyway I can get it working? I'm really
  struggling to understand this problem so if anyone has encountered it
  before and knows a solution or can point me in the right direction for
 some
  reference material then I would be most grateful.
 
  Thanks in advance ;
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353756
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Need help with inserting non-standard characters into SQL from CF

2013-01-04 Thread Edward Chanter

Thanks Paul, the data isn't coming from a form it's being manually entered
in the CFM and will only be run once hence the lack of cfqueryparams, I
suspect that the problem is something to do with the fonts which was why I
was thinking that the linux CF and windows DB might be the problem.
Interestingly your reply to this thread shows on my system with my £
replaced with a �. That suggests fonts somewhere along the line...


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353758
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Need help with inserting non-standard characters into SQL from CF

2013-01-04 Thread Edward Chanter

The short-circuit worked like a dream Paul, problem solved. Thank you very
much for the assistance :)


On 4 January 2013 11:18, Paul Hastings p...@sustainablegis.com wrote:


 On 1/4/2013 6:08 PM, Edward Chanter wrote:
 
  Thanks Paul, the data isn't coming from a form it's being manually
 entered

 you mean from a static cf page? and is that page UTF-8? where's the pound
 symbol
 coming from?

 if you're not using cfqueryparam, make sure to use unicode hinting
 (N'text').

  Interestingly your reply to this thread shows on my system with my £
  replaced with a �. That suggests fonts somewhere along the line...

 that's the way it came thru the mail servers.


 if you want to short circuit this, use the unicode codepoints for those
 symbols

 ie, N'#chr(163)#' for the pound sterling symbol.
 N'#chr(8364)#' for the euro, etc.


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353760
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Is there a better way to do this import

2012-12-12 Thread Edward Chanter

I'm in the process of rebuilding one of our sites and part of that means
rationalising data and correcting mistakes that were made in the original
build. I've got a chunk of data that needs to be extracted and transformed,
then inserted into a new table in a new database. I'm currently using CF to
do the heavy lifting and so my first question is whether CF is best for
this or if I should try to do this with SQL queries. If the answer is 2 can
anyone point me in the right direction as to how I would go about doing
this in native SQL? Or is there a more efficient way to do this in CF?

Here's what the code currently looks like. Bear in mind that the citem
table contains over 90k rows so we're talking about a lot of data here.

!--- gets the old data the modX fields need merging into a new dbase
schema ---
cfquery datasource=#oldDSN# name=gtd
select id, mod, mod2, mod3, mod4
from citem
where active = 1
/cfquery
!--- Start looping through items ---
cfoutput query=gtd
!--- Get the new item ID from the new database ---
cfquery datasource=#newDSN# name=getNewItemID
select id from items where oldid = '#gtd.id#'
/cfquery

!-- Merge the mod fields into a list ---
cfset topicList = ''
cfset topicList = listappend(#topicList#,'#gtd.mod#')
cfset topicList = listappend(#topicList#,'#gtd.mod2#')
cfset topicList = listappend(#topicList#,'#gtd.mod3#')
cfset topicList = listappend(#topicList#,'#gtd.mod4#')
!--- Loop through the list ---
cfloop list=#topicList# index=t

!--- Assuming there's a value in the field do the insert into the new
database ---
cfif trim(t) NEQ '' and trim(t) NEQ '0'
!-- Get the value for the new topicid field ---
cfquery datasource=#newDSN# name=getNewTopicID
select id from topics where oldid = '#t#'
/cfquery
!--- Insert the data into the new topiclinks table that will link topic
IDs and item IDs ---
cfquery datasource=#newDSN#
insert into topiclinks
(topicid,itemid)
values
('#getNewTopicID.id#','#getNewItemID.id#')
/cfquery
!--- Increment a counter so I know how many rows were created ---
cfset numTopics = numTopics + 1
 /cfif
 /cfloop
 /cfoutput


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353439
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Is there a better way to do this import

2012-12-12 Thread Edward Chanter

Thanks for the tip Cameron,  I will definitely research SELECT INTO as
suggested, all I was hoping for was a pointer like that. I have a lot of
tables to transfer but not all require any massaging of the data so I might
be able to use CF for some and SQL for the others.

Cheers :)


On 12 December 2012 16:23, Cameron Childress camer...@gmail.com wrote:


 On Wed, Dec 12, 2012 at 11:16 AM, Edward Chanter firew...@cc.uk.com
 wrote:

  my first question is whether CF is best for
  this or if I should try to do this with SQL queries. If the answer is 2
 can
  anyone point me in the right direction as to how I would go about doing
  this in native SQL? Or is there a more efficient way to do this in CF?
 

 Making all the data do a round trip to CF and then back to the Database is
 always going to be slightly slower. Doing this 90K times in a row may
 magnify this effect. If it's slow in CF, then yes, write it in SQL. Only
 you can answer this question. If it's a one time migration though, who
 cares if it's slow as long as it happens.

 Explaining how to write the SQL to do this is beyond the scope of a simple
 email, but I would start by taking a look into the syntax for SELECT
 INTO, which will allow you to select data from one table directly into
 another. If you need to massage the data first, then it will get more
 complicated.

 -Cameron

 --
 Cameron Childress
 --
 p:   678.637.5072
 im: cameroncf
 facebook http://www.facebook.com/cameroncf |
 twitterhttp://twitter.com/cameronc |
 google+ https://profiles.google.com/u/0/117829379451708140985

 


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353441
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Is there a better way to do this import

2012-12-12 Thread Edward Chanter

Thanks Russ, stored procedures I know something about the others I've never
had to use before but will check them out.


On 12 December 2012 16:36, Russ Michaels r...@michaels.me.uk wrote:


 you may also want to read up on stored procedures,custom functions cursors,
 and bulk inserts which would help in converting cfml to TSQL




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353444
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: HomeSite

2012-10-08 Thread Edward Chanter

I was also supplied with dreamweaver at one point so if you have any old DW
CDs floating around you might find it on there.

On 8 October 2012 01:22, Bobby bo...@acoderslife.com wrote:


 I believe it was in the CFWACK for version 4.5 or 5. Maybe you have that
 book or know someone who does?

 On 10/7/12 10:27 AM, Richard Colman col...@uci.edu wrote:

 
 Hate to bring this up again, but I have used Homesite for many years and
 do like it.
 
 I need to transfer the application to a new computer, and the original
 install disks are long gone.
 
 Does anyone know of a source to obtain or purchase?
 
 TNX,
 
 signed ... the dinosaur ...
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352869
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Localisation - file or database?

2012-10-03 Thread Edward Chanter

Thanks Paul, I'll bear that in mind. Googling icu4j has led to some very
helpful resources, thanks for that too ;-)

On 2 October 2012 18:35, Paul Hastings p...@sustainablegis.com wrote:


 uh, i18n folks like their abbreviations, their standards as well as their
 numeronyms. its LTR (left-to-right writing system)  RTL (right-to-left
 writing
 system). don't go making up your own.

 icu4j is your best friend for serious i18n cf/java work.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352837
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Localisation - file or database?

2012-10-02 Thread Edward Chanter

We're about to embark on a project for which locallisation is a requirement
and it's the first time I've done this. I understand the basic concepts
about having data containing the words and phrases needed on a website
stored with versions for each language but I'm trying to figure something
out: what's the best way to store the data?

I see a lot of sites using flat JSON/XML/Whatever files with the different
translations but is this something that would work well coming from a
database? Is it more efficient to use a flat file or simply have a database
store the words and phrases in columns with a new row for each language?
One advantage I can see with a database option is that it makes adding new
languages a little easier for people with no access to the file system on
the server. It could also be managed with web forms which seems easier than
having a massive flat file with loads of XML or JSON data structures.

The purpose of this question is to see how you all do it and whether there
are any pit-falls I should watch out for?

Thanks ;-)


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352795
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Localisation - file or database?

2012-10-02 Thread Edward Chanter

Thanks guys, Russ especially for taking the time to put all that together,
most appreciated :)

I hadn't thought of the QofQ idea, that is a great suggestion. I think I
will go with that as I like the idea of having everything stored in the
database :)

Thanks again

On 2 October 2012 10:58, Russ Michaels r...@michaels.me.uk wrote:


 If you are talking about the content, then yes this is normally stored in
 the database and is handled by a CMS system. You would then have a separate
 version of the content for each language, and load the appropriate version
 depending on which language the logged in user has chosen.

 If you are are referring to the language of the site, menus, interface etc,
 then this really comes down more to preference, some folks use XML/JSON,
 some store in a database.
 Personally I would store it in the database, because form there you can
 easily generate both XML and JSON anyway plus you have ability to easily
 save revisions whenever something is edited and roll back if required.
 The reason a lot of apps use a flat file is because it allows the community
 to then produce language files for the project.

 What you can then do is create a TERM in English and store the various
 other language equivalents.

 e.g.

 Table: TermRefs
 TermRefID (primary key):
 Reference (varchar)

 Table TERMS
 TermID (primary key):
 TermRefID (foreign key):
 Term (varchar):
 LanguageID (foreign key)

 Table: Languages
 LanguageId (primary key)
 Language (varchar)
 DisplayText (varchar)

 sample data
 ==

 TERMREFS

 1   ContactMenuText
 2   ProductsMenuText
 3   SupportMenuText

 LANGUAGES

 1   English
 2   French
 3   German

 TERMS
 1   1   Contact Us 1
 2   1   contactez-nous 2
 3   1  kontaktieren Sie uns 3

 You would only need to query this lot once and then cache it and use QofQ
 of get your references, so no load on database.

 The TermRefs.reference is a simple understandable reference that you would
 use to contain the text and output it on to the site.

 e.g.
 a href=contactus.cfm#getterm(ContactMenuText)#/a

 You would use the LANGUAGES table on your site in a dropdown list or
 whatever to give the user the language selector. Most people tend to put
 this in English, which must be annoying for the non English visitors, thus
 the DisplayText field, so you can actually display the Language names in
 that language.

 HTH

 On Tue, Oct 2, 2012 at 10:01 AM, Edward Chanter firew...@cc.uk.com
 wrote:

 
  We're about to embark on a project for which locallisation is a
 requirement
  and it's the first time I've done this. I understand the basic concepts
  about having data containing the words and phrases needed on a website
  stored with versions for each language but I'm trying to figure something
  out: what's the best way to store the data?
 
  I see a lot of sites using flat JSON/XML/Whatever files with the
 different
  translations but is this something that would work well coming from a
  database? Is it more efficient to use a flat file or simply have a
 database
  store the words and phrases in columns with a new row for each language?
  One advantage I can see with a database option is that it makes adding
 new
  languages a little easier for people with no access to the file system on
  the server. It could also be managed with web forms which seems easier
 than
  having a massive flat file with loads of XML or JSON data structures.
 
  The purpose of this question is to see how you all do it and whether
 there
  are any pit-falls I should watch out for?
 
  Thanks ;-)
 
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352798
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Localisation - file or database?

2012-10-02 Thread Edward Chanter

Thanks for the tip Andy, I've heard the term mentioned but haven't looked
into it at all. Do you know of any good resources that explain using it in
a CF context? What are the advantages of this method over the database
method that Russ outlined above? I'm new to all of this so please bear with
my noobish questions.

On 2 October 2012 11:31, Andrew Scott andr...@andyscott.id.au wrote:


 I actually prefer to use il8n from Java.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352802
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Localisation - file or database?

2012-10-02 Thread Edward Chanter

Thanks Paul, I'm currently trying to answer all the questions you put in
there. Right now I'm keeping things simple but you're right that it's not
just the globs of text that need translating, I'd already thought of
currency formats etc but the calendar issue you raised is one I hadn't
considered, and the L2R and R2L issue is also something I need to work out.

Fun times!

Thanks again for everyone who responded, you've all given me lots to think
about.

On 2 October 2012 12:31, Paul Hastings p...@sustainablegis.com wrote:

 i think the question should be what's the best way manage all that data?
 typically, this won't be a one off, you'll need to manage translations for
 a
 growing number of locales  the stuff being translated is likely to grow in
 complexity (if its not already).

 who's doing the translations (hint, unless its an app about IT, it really
 shouldn't be your developers)? dealing w/professional translators,
 especially
 for exotic subjects, is often a herding cats exercise. you'll need
 something
 to keep track of what's been translated, when  by whom.

 will the translated resources need to be shared w/other platforms?

 for java, which has had i18n bits since forever, it's normal practice to
 use
 resource bundles (rb)  manage these w/one of the popular rb tools like
 rbManager or Attesoro.

 that's not to say can't mix database supplied text  rb. massive amounts
 of text
 probably should be in some sort of database but you'll need the same kind
 of
 tracking mechanism as regular rb tools.


 and just to make sure its clear, localizing an app isn't the 1st step. its
 internationalization (i18n)--besides the text, your app will need to handle
 date,time,number  currency formatting per locale. maybe calendars (not
 everybody uses gregorian calendars) as well as timezones. layout (LTR vs
 RTL
 locales), colors  even graphics all play a role in localization.



 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352807
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Trying to solve a verity problem

2012-07-03 Thread Edward Chanter

Anyone seen this error when attempting to do verity searches?

The collection you specified does not exists or is not registered with the
ColdFusion Search Service.

The collection is definitely there, 100% sure. It's in CF Admin but I can't
optimise the index as it bombs out with the same error.

I've tried creating the index using CF admin and then updating the index
from my code. It allows me to build the index no problem but when I try to
search it bombs out.

If anyone has any suggestions I would be most grateful because I've been
researching this for 2 days and am getting nowhere :(

Help me Obi Wan Kenobi, you're my only hope :)




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351801
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Trying to solve a verity problem

2012-07-03 Thread Edward Chanter

 -Original Message-
 Your sad devotion to that ancient Jedi religion has not helped you conjure
up
 the missing index, or given you enough clairvoyance to find the Verity
problem.

ROFLMAO, thanks for that, made me smile :)
 
 OK, with that out of the way - I've run into similar problems with Verity
when
 specific documents were indexed. To work through those problems, I had to
 index documents one-by-one to identify the problem document. This is one
 reason why I don't use Verity any more.

I'm not indexing documents, it's a query based index and when I run the part
of the script with the cfindex tag it works without any problem:

cfindex action=UPDATE
 collection=testCollection
 key=id
 type=CUSTOM
 title=title
 query=get
 body=title,descr
 custom1=descr
 language=English

We recently moved the site to a new server at a new hosting company but
they've already reinstalled Verity once and it's still not working right.
Indexing no problem, searching big problem. Didn't have this issue on our
old server...

Do you think maybe indexing smaller sections of data might help with
testing? Like index 10 rows at a time or something?

-= Ed


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351803
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Trying to solve a verity problem

2012-07-03 Thread Edward Chanter

I wasn't seeing this before but I just tried to create a new collection in
CF Admin and got this error:

Unable to create collection testDocs.
Unable to register collection testdocs.
An error occurred while registering the collection with the K2 Search
server: com.verity.api.administration.ConfigurationException: Failed to find
configuration key. (-6005)

But when I look in the list of collections in CFAdmin I see the collection.

Maybe verity just needs to be reinstalled completely again.

 -Original Message-
 From: Dave Watts [mailto:dwa...@figleaf.com]
 Sent: 03 July 2012 14:38
 To: cf-talk
 Subject: Re: Trying to solve a verity problem
 
 
  I'm not indexing documents, it's a query based index and when I run
  the part of the script with the cfindex tag it works without any
problem:
 
  ...
 
  We recently moved the site to a new server at a new hosting company
  but they've already reinstalled Verity once and it's still not working
right.
  Indexing no problem, searching big problem. Didn't have this issue on
  our old server...
 
  Do you think maybe indexing smaller sections of data might help with
  testing? Like index 10 rows at a time or something?
 
 I never had a problem indexing database content with Verity. I suspect you
may
 have something else going on. Try creating a new collection, indexing one
 document into it, then seeing if that collection is searchable. You might
also
 look at using the command-line tools to see if you can query the index
from
 them.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/
 
 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA
Schedule,
 and provides the highest caliber vendor-authorized instruction at our
training
 centers, online, or onsite.
 
 
 ~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:351805
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351806
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Trying to solve a verity problem

2012-07-03 Thread Edward Chanter

Seems to be:

When I run ./cfsearch start it says there is already a k2admin process
running

 -Original Message-
 Check that the k2 server is actually running.
 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351814
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Trying to solve a verity problem

2012-07-03 Thread Edward Chanter

AFAIK it's a fresh install of CF08.01 on a brand new VPS instance, but I can
check with our hosting company tomorrow.


 -Original Message-
 Has this machine beem upgraded from previous version, might explain why
you
 have 2 conflicting processes
 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351817
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Grabbing PHP cookies.

2012-06-21 Thread Edward Chanter

cfoutput#COOKIE.name_of_cookie#/cfoutput

I think that's what you need or maybe I'm oversimplifying it ;-)

 -Original Message-
 From: Cory Fail [mailto:juturnaph...@gmail.com]
 Sent: 21 June 2012 15:40
 To: cf-talk
 Subject: Grabbing PHP cookies.
 
 
 I'm still some what a beginner with CF so take it easy on me. I currently
have a
 web site that uses MyBB as a forum. My homepage/portal is programmed in
 coldfusion. Currently it is gathering post information so it shows latest
posts
 and comments. I want users to be able to login here as well and then it
redirect
 back to the homepage/portal. The login script works flawlessly, however,
once
 someone logs in I want to be able to retrieve the cookies from myBB and
then
 output the current user's username, userid, email, ect.
 
 
 
 How would I retrieve the cookies information and then output the
information
 with coldfusion?
 
 
 
 Thanks!
 
 
 
 ~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:351633
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351634
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Anyone use/used Flinthosts in the UK?

2012-06-15 Thread Edward Chanter

Funny you should say that, we're currently in the process of moving all our
hosting to them.

So far I've found them very good. The support system is responsive and the
staff are friendly and know their stuff.

We're only at the start of our relationship with them but so far the signs
are very good.

We're going with 2 Managed VPS servers not their hosting accounts but the
support you receive will be the same.

Hope that helps.

 -Original Message-
 From: Paul Silver [mailto:paul.sil...@gmail.com]
 Sent: 15 June 2012 11:12
 To: cf-talk
 Subject: Anyone use/used Flinthosts in the UK?
 
 
 Hi,
 
 A friend is considering using Flinthosts in the UK for hosting his
ColdFusion sites.
 He's got 4 and their 'Professional' account looks like it would take all
of them as
 they're not high bandwidth.
 
 Has anyone used Flinthosts and are they / were they any good?
 
 Thanks
 
 Paul
 --
 Paul Silver
 Freelance Web Developer
 Tel: 01273 906020 (UK)
 http://www.paulsilver.co.uk and http://webpositioningcentre.co.uk
 
 
 ~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:351573
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351574
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Date Truncation on CFquery Update

2012-06-13 Thread Edward Chanter

There's a post limit in the CF admin, I think the default is 100Mb but given
that your post is so huge you might want to see if increasing that setting
helps. 

 -Original Message-
 From: Robert Harrison [mailto:rob...@austin-williams.com]
 Sent: 13 June 2012 17:17
 To: cf-talk
 Subject: Date Truncation on CFquery Update
 
 
 I have a client who is essentially entering a document of 50+ pages into a
text
 area field (tiny MCE). The data is being saved to a data base via CFquery
 Update.  The data base is MS SQL server and the field length is set to
 VARCHAR(MAX).  Data is being truncated on update to data base (same place
 every time).
 
 I have checked and the data is not being lost by the text area. If I
display the
 post field after the Update Query, all the data is there. It's definitely
being
 truncated either by CFQuery or by the data base.
 
 I have (temporarily) removed cfqueryparam, so that is not the culprit.
 
 Any ideas what is causing the truncation?
 
 Thanks
 
 
 
 Robert Harrison
 Director of Interactive Services
 
 Austin  Williams
 Advertising I Branding I Digital I Direct
 125 Kennedy Drive,  Suite 100   I  Hauppauge, NY 11788 T 631.231.6600 X
 119   F 631.434.7022 http://www.austin-williams.com
 
 Blog:  http://www.austin-williams.com/blog
 Twitter:  http://www.twitter.com/austin_
 
 
 ~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:351564
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubs

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351565
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CF breaks down with error 500 (GC)

2012-06-11 Thread Edward Chanter

I've seen these errors before and they almost always relate to the JVM
running out of memory. Does the error/cf server log give you any clues about
what template is causing the error?

 -Original Message-
 From: Helwig, Till Helge [mailto:till.hel...@saxsys.de]
 Sent: 11 June 2012 15:44
 To: cf-talk
 Subject: CF breaks down with error 500 (GC)
 
 
 Hi guys,
 
 I got another problem that I can't figure out by myself unfortunately.
 Somewhere inside of the huge CF application I'm in charge of an error
occurs.
 Not the standard error you might expect but instead an error 500 that
tells me
 Java threw an exception with the message GC overhead limit exceeded. And
 afterwards the whole CF server doesn't respond to further requests.
 
 I honestly have no idea where to start with any kind of debugging. When
 watching `top` on the server I can see that the coldfusion process starts
 allocating a lot of memory up to almost 60%. I can't really image what
might
 cause this problem as the template that has been called does little more
than
 retrieve a lot of information from a database. Which is what most parts of
the
 application do and they don't cause any problems...
 
 Would be great if you have any ideas for me regarding where to start
digging
 or what might cause this problem.
 
 Till Helge
 
 
 
 ~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:351534
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351536
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Question for UK List Members

2012-05-23 Thread Edward Chanter

I'm currently investigating a new UK hosting solution and I was hoping to
pick people's brains:

1. Can anyone recommend one or two good, responsive CF hosting companies
based in the UK?
2. Do people have any experiences with running CF hosting on a VM solution,
how does it compare to a standalone server?
3. I tried to convince my boss that cloud is just another of those
meaningless marketing buzz-words but he's insistent I look at cloud-based
CF hosting. Anyone go any recommendations for that in the UK?

Thanks in advance :)

-= Ed




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351301
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Question for UK List Members

2012-05-23 Thread Edward Chanter

 -Original Message-
 Does it *have* to be a CF host? If so, then you've got HostMediaUK and
 BlueThunder Internet.

Not required no, but I'll check those two out anyway.

 If you want a damn good hosting company, then I'd strongly recommend
 Rackspace. They won't help you one jot with ColdFusion, but they are
 untouched for their experience and support when it comes to infrastructure
 and support. We host all our sites and apps on their UK and US Cloud
 platform.

I'll add rackspace to my list of hosts to investigate.

Thanks Andy!


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351303
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: problems with json and google maps

2012-04-20 Thread Edward Chanter

I've had similar problems to this when trying to serialise JSON for a jQuery
plugin. The only solution I found that worked is detailed here:

!--- get the matches ---
cfquery name=q datasource=#request.ds#
select product_id as value, product_title as label
from products
where product_title like cfqueryparam value=%#url.term#% /
/cfquery
 
!--- where we'll hold the data to convert to JSON ---
cfset data = [] /
 
cfoutput query=q
 
!--- create a new structure on each iteration, forcing lowercase
keys ---
cfset obj = {
label = label,
value = value
} /
 
!--- push this match onto the array ---
cfset arrayappend(data, obj) /
/cfoutput
 
!--- serialize the new structure ---
cfoutput#serializeJSON(data)#/cfoutput

http://goo.gl/VGxlA

Credit goes to Eric Hynds not me for this one. 

HTH

 -Original Message-
 From: Seamus Campbell [mailto:coldfus...@boldacious.com]
 Sent: 20 April 2012 09:25
 To: cf-talk
 Subject: problems with json and google maps
 
 
 Hi
 I'm trying to populate a google map from a cfquery.
 I serializeJSON the query then try and use that json object to populate
the
 map.
 
 I'm using code from Gabriel Svennerberg's Google Maps books (see code
 below), but my json object from the query looks very different (in format)
 from the example json object that Svennerberg shows.
 His is in this format:
 var json = [
   {
 title: Stockholm,
 lat: 59.3,
 lng: 18.1,
 description: Stockholm is the capital and the largest city of
Sweden and
 constitutes the most populated urban area in Scandinavia with a population
 of 2.1 million in the metropolitan area (2010)
   },
   {
 title: Oslo,
 lat: 59.9,
 lng: 10.8,
 description: Oslo is a municipality, and the capital and most
populous
 city of Norway with a metropolitan population of 1,442,318 (as of 2010).
   }
 ]
 
 and mine is like this:
 {COLUMNS:[BUSINESS_NAME,LATITUDE,LONGITUDE],DATA:[[sdfd
 sf Books,-36.890408,121.154751],[dsdsdsd Booksellers,-
 14.921735,18.602189],[fff ints,-17.8451823,195.0541819]]}
 
 Is there a way I can convert my query to a json object with the same
format
 as Svennerberg's?
 any halp gratefully received
 
 cfsilent
 cfquery name=get_map_details datasource=#application.main_dsn#
 SELECT business_name, latitude, longitude FROM tbl_premises WHERE
 latitude  0 /cfquery /cfsilent cfset json_query =
 serializeJSON(get_map_details,false)
 
 !DOCTYPE HTML
 html
 head
 meta charset=utf-8
 titleUntitled Document/title
 script type=text/javascript
 src=http://maps.google.com/maps/api/js?sensor=false;/scriptscript
 type=text/javascript
 (function() {
   window.onload = function() {
   // Creating a new map
   var map = new
 google.maps.Map(document.getElementById(map), {
   center: new google.maps.LatLng(-24.327, 140.273),
   zoom: 5,
   mapTypeId: google.maps.MapTypeId.ROADMAP
 });
   // Creating a global infoWindow object that will be reused by all
 markers
   var infoWindow = new google.maps.InfoWindow();
   // Looping through the JSON data
   for (var i = 0, length = json_query.length; i  length; i++)
{
   var data = json_query[i],
   latLng = new google.maps.LatLng(data.latitude,
 data.longitude);
 
   // Creating a marker and putting it on the map
   var marker = new google.maps.Marker({
   position: latLng,
   map: map,
   title: data.business_name
   });
   }
   }
 })();
 
 /script
 /head
 body
 div id = map style=width: 800px; height: 500px; border: 1px solid
 #000;/div /body /html
 
 ~~~
 ~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:350808
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350809
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Having a problem with cfpop - UTF-7

2012-04-18 Thread Edward Chanter

Thanks for your help Paul, I tested your script and utf-7 doesn't appear in
the list so I'm assuming that the new charset isn't being picked up. It's
strange though because there is another file in the same folder called
charsets.jar which is native to CF so the folder must be correct. I've
restarted the server twice already with no luck. I tried but failed to
locate the other folder you mentioned so I'm a bit stuck on this one. I
guess I will have to figure out a manual way to remove the offending
messages. 

Does anyone know if this utf-7 thing is still an issue in CF10? If it is
then imo CFPOP should come with a big warning in the Adobe docs:
THIS TAG IS NOT FIT FOR PURPOSE

 -Original Message-
 From: Paul Hastings [mailto:p...@sustainablegis.com]
 Sent: 16 April 2012 13:42
 To: cf-talk
 Subject: Re: Having a problem with cfpop - UTF-7
 
 
 On 4/16/2012 5:18 PM, Edward Chanter wrote:
  1. jcharset
  http://cfg11n.blogspot.co.uk/2005/06/utf-7.html
 
  The jcharset file is stored in /cfroot/runtime/jre/lib and I checked
  the
 
 should work anywhere on cf's classpath (after a server service restart)
but
 vaguely recall some classpath issues with later JVM versions. might also
try
 jrun4/jre/lib
 
 and to test if cf is picking up that JAR:
 
 cfscript
 charSetObj=createObject(java,java.nio.charset.Charset);
 availableCharsets=charSetObj.availableCharsets();
 charsetInfo=structNew();
 for (charset in availableCharsets) {
   thisCharSet=charSetObj.forname(charset);
   t=structNew();
   t.displayName=thisCharset.displayname();

t.aliases=reReplace(thischarSet.aliases().toString(),\[|\],,ALL);
   t.isIANA=thisCharSet.isRegistered();
   t.canEncode=thischarSet.canEncode();
   structInsert(charsetInfo,thisCharset.displayname(),t);
 }
 /cfscript
 
 cfdump var=#charsetInfo#
 
 
 ~~~
 ~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:350709
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350773
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Having a problem with cfpop - UTF-7

2012-04-16 Thread Edward Chanter

This is kind of a re-post as I'm seeing other cf-talk messages in the
archive relating to this issue but I'm a bit stuck so thought I'd ask
anyway.

I've built a bounce manager using the standard catch-all email domain method
and it works great. Except that one of the mail servers returning a message
has done so in UTF-7 format which is, of course, generating a CF error when
I run CFPOP against the bounce mail account.

Having googled the problem and seen 2 solutions:

1. jcharset 
http://cfg11n.blogspot.co.uk/2005/06/utf-7.html

2. cfx_pop3
http://store.newmediadevelopment.net/cfx_tag.cfm?ProductID=3

I've tried both and neither has worked.

I'm running CF 8.01 on linux which is why I think the cfx_pop3 tag failed,
that's a DLL which is windows specific afaik. When I try to run the CFX_pop
tag the server is unable to load the library.

The jcharset file is stored in /cfroot/runtime/jre/lib and I checked the
permissions but upon restarting the server it doesn't seem to make any
difference at all and the bounce manager script still bombs out.

I was just wondering if anyone has come up with any other workarounds for
this problem? 

Thanks in advance for any assistance ;-)

best wishes,

  -= Ed


Edward Chanter
Technical Innovations Manager
Collaborative Connections Ltd.

http://www.cc.uk.com/
e...@cc.uk.com
Landline: 01273 832221
Mobile: 07866 365282
YIM!: jumperb
MSN: e...@cc.uk.com
You can find me on FaceBook too!
 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350708
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Convert php to cfm

2012-01-10 Thread Edward Chanter

This seems like a pretty straightforward conversion. Create the datasource
in the CF admin to point to MySQL and then simply write a cfquery with the
same basic syntax as is used in the PHP. Specify maxrows=200 and then
cfoutput it via json to your datastore.

I might be missing something but it seems that simple.

 -Original Message-
 From: Tom Small [mailto:t...@re-base.net]
 Sent: 10 January 2012 15:47
 To: cf-talk
 Subject: Convert php to cfm
 
 
 Hi, I need to convert php to coldfusion. Would appreciate some help,
 thanks
 
 ?php
 #First we include our credentials file
 # FileName=connect.php
 $hostname = localhost;
 $database = nimsoftslmdev;
 $username = root;
 $password = xxx;
 
 #And now we connect to the database
 //connection String
 
 //connection String
 $con = mysql_connect($hostname, $username, $password) or die('Could not
 connect: ' . mysql_error()); //select database mysql_select_db($database,
 $con); //Select The database $bool = mysql_select_db($database, $con); if
 ($bool === False){
 print can't find $database;
 }
 
 
 $start = ($_REQUEST[start] == null)? 0 : $_REQUEST[start];
 $limit = ($_REQUEST[limit] == null)? 200 : $_REQUEST[limit];
 
 // Gather all pending requests
 $query = SELECT
 nimid,
 level,
 message,
 source
 FROM nas_alarms ;
 
 $query .=  ORDER BY level ASC ;
 $query .=  LIMIT .$start.,.$limit;
 
 $result = mysql_query($query, $con);
 
 // Here we do the count
 $query_c = SELECT
 nimid,
 level,
 message,
 source
 FROM nas_alarms ;
 
 //get total
 $count_result = mysql_query($query_c, $con); $total =
 mysql_num_rows($count_result);
 
 if (mysql_num_rows($result)  0){
 while($obj = mysql_fetch_object($result))
 {
 $arr[] = $obj;
 }
 
 // Now create the json array to be sent to our datastore
 
 $myData = array('myInventory' = $arr, 'totalCount' = $total); echo
 json_encode($myData); return; exit();
 
 }
 
 else { // If no requests found, we return nothing
 
 $myData = array('myInventory' = '', 'totalCount' = '0'); echo
 json_encode($myData); return; exit();
 
 }
 
 ?
 
 ~~
 ~~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:349374
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349375
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Convert php to cfm

2012-01-10 Thread Edward Chanter

 -Original Message-
 Wow, and I wonder at times why PHP is so popular...

My thought too, this is a great example of why I love CF over PHP :)


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349378
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Changing the Mail/Spool folder

2011-11-24 Thread Edward Chanter

Hey guys,

One of our clients has started sending a lot of email and I'm finding the
server running out of space on the CF partition (it's a linux machine). I
have a lot of free space on my /usr/ partition and was thinking of creating
a folder on that for CF to use.

I know the current folder: /opt/coldfusion8/Mail/Spool/

But is there any way to change it? I've been looking through the CF
Administrator and can't see anything obvious so I thought I'd ask my
friendly neighbourhood gurus :)

Thanks in advance,

-= Ed


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348852
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Changing the Mail/Spool folder

2011-11-24 Thread Edward Chanter

Yeah I cleaned up a load of free space but the partition isn't that large
and I wanted to investigate moving the folder so give myself a little more
leeway. Yes in answer to your question it's a large number of emails (50k+).
For the time being I'll just keep a closer eye on the overall free space. 

Thanks for the response :)

 -Original Message-
 it is not a setting in the cfadmin, it will probably be in one of the
config files
 somewhere.
 Are you sure it is the mail causing all the space usage, it would have to
be a
 huge amount of mail, unless you have a  very small partition with not much
 space left.
 Have you tried doing some cleanup of temp files, log files etc to fre eup
some
 space.
 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348856
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Changing the Mail/Spool folder

2011-11-24 Thread Edward Chanter

That's awesome, thanks Russ :)

 -Original Message-
 ok I found it for you.
 
 look in neo-mail.xml
 
 for these 2 values
 
 var
 name='undeliverdir'string{neo.rootdir}/Mail/Undelivr/string/var
 var name='spooldir'string{neo.rootdir}/Mail/Spool/string/var




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348858
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Adobe Abandons Flex

2011-11-18 Thread Edward Chanter

I'm new to this thread but has anyone having issues with IE tried this:
http://code.google.com/p/html5shiv/

We started using it recently and it rocks

Sorry if this is a repeat or if I'm stating the bleeding obvious :)




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348805
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Adobe drops Flsh for mobile devices

2011-11-11 Thread Edward Chanter

Hear! Hear!

This topic was boring 10 years ago and it's just as boring today.


 -Original Message-
 Someone is wrong on the Internet!
 Let's move on and let this thread die (until next year.)


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348638
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Wysiwyg editor

2011-10-25 Thread Edward Chanter

I've tried most of the WYSIWYG editors and CKEditor is definitely the best
in terms of features and customisation.

The problem I found is users. You can put notes in you can warn them, you
can call them email them and practically burn the Do not paste directly
into the editor from ANYWHERE without using the paste from word function
mantra onto their eyelids but there will always be one who doesn't do it and
calls you to complain that the website is all messed up. I've never found
a way around this other than to help the user and remind them from the
50'000th time that they need to use the paste from word function.

On the bright side it's easier than telling them to paste things into
notepad before copying into the editor.

:)

 -Original Message-
 The user copys the text from the word document, then instead of pasting it
 straight into the editor,  click the paste from word
 button and paste the content into the little window that pops up.
 When you click the button, it puts plain text into the editor.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348325
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Wysiwyg editor

2011-10-25 Thread Edward Chanter

 -Original Message-
 you can capture the paste event and put it through the word paste by
 default.
 

Now there's a totally brilliant idea! This is something I really need to
figure out how to do. Do you mayhaps have a piece of javascript which does
this that you'd be willing to share? I'm still getting my head around JS and
coding this one from scratch is a little out of my league.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348327
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Wysiwyg editor

2011-10-25 Thread Edward Chanter

I'll investigate, thanks Russ :)

 -Original Message-
 no sorry, but I know from looking atthe code that it allows you to capture
any
 event and perform an action.
 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348329
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Week Weirdness

2011-10-04 Thread Edward Chanter

Hey all,

Has anyone ever had a CF server's week number get out of sync with the
server?

When I run #week(now())# in Cf I get 41 but when I run the comman in linux
date +%W I get 40

It's causing all sorts of problems when pulling week based data from the
dbase.

Does anyone know how I get them to sync up again? This is really weird.

Thanks in advance

-= Ed




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347885
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Week Weirdness

2011-10-04 Thread Edward Chanter

According to the docs it's 0

The weird thing is that I have 2 servers running the same version of linux
and on one they both say 40 and on the other I get the discrepancy between
linux and CF. 

 -Original Message-
 From: Michael Grant [mailto:mgr...@modus.bz]
 Sent: 04 October 2011 16:51
 To: cf-talk
 Subject: Re: Week Weirdness
 
 
 Does linux use zero (0) as week one?
 
 
 On Tue, Oct 4, 2011 at 11:47 AM, Edward Chanter firew...@cc.uk.com
 wrote:
 
 
  Hey all,
 
  Has anyone ever had a CF server's week number get out of sync with the
  server?
 
  When I run #week(now())# in Cf I get 41 but when I run the comman in
  linux date +%W I get 40
 
  It's causing all sorts of problems when pulling week based data from
  the dbase.
 
  Does anyone know how I get them to sync up again? This is really weird.
 
  Thanks in advance
 
  -= Ed
 
 
 
 
 
 
 ~~
 ~~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:347887
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347888
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Week Weirdness

2011-10-04 Thread Edward Chanter

Yes indeed :(

 -Original Message-
 Do both servers have the same version of CF?


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347890
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Week Weirdness

2011-10-04 Thread Edward Chanter

1. Yes, exact same date and time
2. Yes both are set to timezone London and both report BST next to the
time when I do a date command in linux
3. Yes in both cases I used #week(now())# to get the CF date and date
+%W to get the linux date

I've setup and configured quite a few CF linux servers and have only ever
seen this happen on one machine.

Welcome to Weirdsville, population: me :(

 -Original Message-
 Very odd indeed. It makes sense that linux and cf would differ by 1, as cf
is
 1-53. However it doesn't make any sense to me why cf would return 40 on
 one and 41 on the other. Can you verify:
 
 1) they are both the same server date?
 2) they are both the same timezone offset?
 3) they are both using CF's week() function to return the integer?


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347900
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Week Weirdness

2011-10-04 Thread Edward Chanter

Thinking about this on a more technical level, does anyone know where CF
ultimately derives the week number? When I enter #now()# I assume that's the
system time but when I do #week(now())# is that the CF server taking #now()#
and deriving the week or does it get that from jrun or linux or does it work
things out on its own? What could make a CF 8.0.1 server on one linux
machine say that the exact same date/time/timezone is week 41 and every
other CF server that I know of say it's week 40?

Why do I feel like an evil little [enter name of favourite nasty] has
decided to inhabit one of my servers?

The explanation must be so simple that I will call myself an idiot for not
thinking about it when I do find out what it is

 -Original Message-
 1. Yes, exact same date and time
 2. Yes both are set to timezone London and both report BST next to the
 time when I do a date command in linux 3. Yes in both cases I used
 #week(now())# to get the CF date and date
 +%W to get the linux date
 
 I've setup and configured quite a few CF linux servers and have only ever
 seen this happen on one machine.
 
 Welcome to Weirdsville, population: me :(
 
  -Original Message-
  Very odd indeed. It makes sense that linux and cf would differ by 1,
  as cf
 is
  1-53. However it doesn't make any sense to me why cf would return 40
  on one and 41 on the other. Can you verify:
 
  1) they are both the same server date?
  2) they are both the same timezone offset?
  3) they are both using CF's week() function to return the integer?
 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347913
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Week Weirdness

2011-10-04 Thread Edward Chanter

They both use jrun, I didn't change it so they should both be exactly the
same. The servers are not 10 years old (fortunately) one is about 2 years
old and the other 4  :)

 -Original Message-
 From: Jason Fisher [mailto:ja...@wanax.com]
 Sent: 04 October 2011 23:50
 To: cf-talk
 Subject: Re: Week Weirdness
 
 
 I know the various JVM versions have had issues with DST settings in the
 past (like 10 years ago); do your 2 servers have the same JRE configured
for
 CF?
 
 
 
 On 10/4/2011 6:13 PM, Edward Chanter wrote:
  Thinking about this on a more technical level, does anyone know where
  CF ultimately derives the week number? When I enter #now()# I assume
  that's the system time but when I do #week(now())# is that the CF
  server taking #now()# and deriving the week or does it get that from
  jrun or linux or does it work things out on its own? What could make a
  CF 8.0.1 server on one linux machine say that the exact same
  date/time/timezone is week 41 and every other CF server that I know of
 say it's week 40?
 
  Why do I feel like an evil little [enter name of favourite nasty] has
  decided to inhabit one of my servers?
 
  The explanation must be so simple that I will call myself an idiot for
  not thinking about it when I do find out what it is
 
  -Original Message-
  1. Yes, exact same date and time
  2. Yes both are set to timezone London and both report BST next to
  the time when I do a date command in linux 3. Yes in both cases I
  used #week(now())# to get the CF date and date
  +%W to get the linux date
 
  I've setup and configured quite a few CF linux servers and have only
  ever seen this happen on one machine.
 
  Welcome to Weirdsville, population: me :(
 
  -Original Message-
  Very odd indeed. It makes sense that linux and cf would differ by 1,
  as cf
  is
  1-53. However it doesn't make any sense to me why cf would return 40
  on one and 41 on the other. Can you verify:
 
  1) they are both the same server date?
  2) they are both the same timezone offset?
  3) they are both using CF's week() function to return the integer?
 
 
 
 ~~~
 ~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:347917
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347920
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Week Weirdness

2011-10-04 Thread Edward Chanter

I suspect that one might be a throw-back to the Jurassic period but the lack
of stone suggests Dell might have simply managed to construct a freak that
doesn't happen to be shaped like a lemon :)

Me thinks running a magnet over the case and starting again would be a good
idea... lol

 -Original Message-
 From: Michael Grant [mailto:mgr...@modus.bz]
 Sent: 05 October 2011 00:09
 To: cf-talk
 Subject: Re: Week Weirdness
 
 
 Is the epoch of both servers identical?
 
 On Tue, Oct 4, 2011 at 7:05 PM, Edward Chanter firew...@cc.uk.com
 wrote:
 
 
  They both use jrun, I didn't change it so they should both be exactly
  the same. The servers are not 10 years old (fortunately) one is about
  2 years old and the other 4  :)
 
   -Original Message-
   From: Jason Fisher [mailto:ja...@wanax.com]
   Sent: 04 October 2011 23:50
   To: cf-talk
   Subject: Re: Week Weirdness
  
  
   I know the various JVM versions have had issues with DST settings in
   the past (like 10 years ago); do your 2 servers have the same JRE
   configured
  for
   CF?
  
  
  
   On 10/4/2011 6:13 PM, Edward Chanter wrote:
Thinking about this on a more technical level, does anyone know
where CF ultimately derives the week number? When I enter #now()#
I assume that's the system time but when I do #week(now())# is
that the CF server taking #now()# and deriving the week or does it
get that from jrun or linux or does it work things out on its own?
What could make a CF 8.0.1 server on one linux machine say that
the exact same date/time/timezone is week 41 and every other CF
server that I know of
   say it's week 40?
   
Why do I feel like an evil little [enter name of favourite nasty]
has decided to inhabit one of my servers?
   
The explanation must be so simple that I will call myself an idiot
for not thinking about it when I do find out what it is
   
-Original Message-
1. Yes, exact same date and time
2. Yes both are set to timezone London and both report BST next
to the time when I do a date command in linux 3. Yes in both
cases I used #week(now())# to get the CF date and date
+%W to get the linux date
   
I've setup and configured quite a few CF linux servers and have
only ever seen this happen on one machine.
   
Welcome to Weirdsville, population: me :(
   
-Original Message-
Very odd indeed. It makes sense that linux and cf would differ
by 1, as cf
is
1-53. However it doesn't make any sense to me why cf would
return 40 on one and 41 on the other. Can you verify:
   
1) they are both the same server date?
2) they are both the same timezone offset?
3) they are both using CF's week() function to return the integer?
   
   
  
  
 ~~~
   ~~|
   Order the Adobe Coldfusion Anthology now!
   http://www.amazon.com/Adobe-Coldfusion-
   Anthology/dp/1430272155/?tag=houseoffusion
   Archive: http://www.houseoffusion.com/groups/cf-
   talk/message.cfm/messageid:347917
   Subscription:
   http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
   Unsubscribe: http://www.houseoffusion.com/groups/cf-
   talk/unsubscribe.cfm
 
 
 
 
 ~~~
 ~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:347922
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347923
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Iphone app

2011-06-29 Thread Edward Chanter

I would persevere with jQuery, the docs are a work in progress but it's
possible to do a lot using their actual documentation website as a template.

I'm a complete noob at all this mobile malarkey and I'm totally loving both
jQuery and jQuery mobile. There are limitations but I expect those will be
resolved in time.

HTH

-= Ed


 -Original Message-
   I need to write either an app for the iphone or at least a website that
looks
 like a app.. I have been looking around for toolkits and there are an
 overwhelming number of choices that I don't know where to start.
 I need:
 1. easy coldfusion integration (so based on html not coco) 2. Preferably
 usable on a pc..  I have access to a mac but not easily.  I can use it to
compile
 and upload the end result if needed.
 3. easy:)
 4. Cheap or free. (It is for a nonprofit)
 
 I have been playing around with jquery mobile. I love jquery but the
jquery
 mobile docs suck..
 
 Any ideas?
 Al


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345889
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Iphone app

2011-06-29 Thread Edward Chanter

YES PLEASE!! O wise and mighty Jedi Master :)

Anything to make the lives of us poor little padawans a little easier would
be very cool.

 -Original Message-
 Yeah - um. Well, they did get better. I have a Quick Start guide I wrote
for
 them that is - unfortunately - still waiting to be officially released. I
may ask
 if I can just release it as


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345891
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Iphone app

2011-06-29 Thread Edward Chanter

That's the trouble with new things, but I'm sure it would be really useful
anyway. As Al said, the docs are somewhat lacking.

 -Original Message-
 I'll check with them today. Unfortunately it was written for Alpha3 so it
is a
 bit out of date (mainly just the appearance of the Back button), but I
think
 the guide is good.
 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345895
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cfinclude on a flash form not working with Chrome

2011-06-22 Thread Edward Chanter

I've had problems with it too but found no solutions I'm afraid, Chrome uses
its own flash plugin though you can disable it and use the adobe one. That's
not a great solution for other chrome users though. Given that you're
reading a text file you might try using cffile to put the contents into a
variable and then insert the variable into your flash form. I'm not 100%
sure it will work but it's worth a try.

 -Original Message-
 From: Dave Hatz [mailto:daveh...@hatzventures.org]
 Sent: 22 June 2011 01:15
 To: cf-talk
 Subject: cfinclude on a flash form not working with Chrome
 
 
 Having difficulties trying to get this to work with Chrome.  This is
inside a
 Flash Form on CF8.  Works great on IE, FF and Safari, but won't come up on
 Chrome.  Seems there are a lot of Flash Form issues with Chrome when I
 Googled the problem, but nothing specific on the CFINCLUDE.  Can anyone
 help me out here on how to solve this problem?
 
 cfformitem type=text width=720cfinclude
 template=../uploads/agreement_section1.txt/cfformitem
 
 ~~~
 ~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:345514
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345516
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


LinkedIn - Importing contact details

2011-06-15 Thread Edward Chanter

One of my clients has just asked me if it's possible for us to have people
connect their accounts on the client site with their LinkedIn accounts and
have some sort of import process that grabs their profile information so
they don't have to fill it in again. I know there must be a way because I
see other sites doing it but this is all new to me.

Before I delve into their documentation I thought I'd ask if anyone has had
any experience doing anything like this? Any tips, tricks or suggestions
would be most welcome :-) 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345320
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: LinkedIn - Importing contact details

2011-06-15 Thread Edward Chanter

Note to self: Google properly next time before asking dumb-a** questions :)

Thanks Steve, that's look exactly what I need.


 -Original Message-
 Have you looked in RIAForge?
 
 http://linkedin.riaforge.org/
 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345322
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CDN and Coldfusion

2011-06-15 Thread Edward Chanter

I've experimented with Railo on Amazon's Elastic Beanstalk, connect that to
an Amazon DB instance and you've got your distributed CF. Host images and
other media in an Amazon EC3 bucket and you've got your CDN. Don't run one
of their SQL Server Windows instances or you might as well just give Amazon
your credit card, the rest you can probably get as part of the free tier so
it shouldn't cost too much :)

There's an excellent how-to blog here if you want to get railo running on
elastic beanstalk
http://blog.getrailo.com/post.cfm/railo-on-aws-elastic-beanstalk


 -Original Message-
 From: Paul Alkema [mailto:paulalkemadesi...@gmail.com]
 Sent: 15 June 2011 16:00
 To: cf-talk
 Subject: Re: CDN and Coldfusion
 
 
 I think what your describing is more of mirrored servers than a Content
 Delivery Network. Mirrored servers are a completely different story, he
 could use mirrored servers if he doesn't mind spending that kind of money.
 
 I prefer CDN's. Cheaper, almost as effective and easier to maintain.
 
 On Wed, Jun 15, 2011 at 10:52 AM, Dave Watts dwa...@figleaf.com wrote:
 
 
   From what it sounds like, your asking if you can have a CDN run and
   distribute ColdFusion applications? As far as I know, this isn't a
   capability of a CDN, that would be more for something like a
   mirrored server.
 
  CDNs can be used with dynamic content, but it gets ... complicated.
  You can, for example, distribute edge servers, use in-memory database
  replication, etc, etc.
 
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
  http://training.figleaf.com/
 
  Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA
  Schedule, and provides the highest caliber vendor-authorized
  instruction at our training centers, online, or onsite.
 
 
 
 ~~~
 ~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:345328
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345332
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CFPDF Performance Issues

2011-06-14 Thread Edward Chanter

I'm having a bit of a weird issue with the creation of PDFs. The issue is
quite simple, we have two servers and one is generating PDFs much faster
than the other. The weird thing is that the server which is slow is our
64bit production server running CF 8.0.1 Enterprise and the faster server is
the old 32bit CF 8.0.1 standard box. One would logically expect the big fast
production server to process the PDF much faster. I'm using the exact same
CFML page to generate the PDF including the same data, images, etc.

The problem I'm having is trying to get to the bottom of what is causing the
difference in speed. To that end does anyone know what might cause the CFPDF
service to take a long time to create the PDF? I'm seeing nothing in my logs
and the performance monitor only tells me that the page is slow.

Any ideas are most welcome because this one has me completely stumped.

:)


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345249
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFPDF Performance Issues

2011-06-14 Thread Edward Chanter

On the dev server generating a simple page takes about 7 seconds, on the
fast production server it takes about 15 seconds. That's including images
and stuff.

I created simple HTML page with the word test on it and that comes through
very quickly so it does feel like the issue is related to images or CSS or
something. I've seen a lot of posts online (and in cf-talk) about calling
the images using file:// instead of the http. I tried that in my code but it
didn't seem to make any difference. I'm using a CFHTTP request to grab a
page URL and then taking the #fileContent# and embedding that into the
cfdocument tags.

It's weird though because both servers talk to the same code and database so
if there was an issue with images then one might expect it to happen on both
servers.


 -Original Message-
 From: Mike Chabot [mailto:mcha...@gmail.com]
 Sent: 14 June 2011 14:03
 To: cf-talk
 Subject: Re: CFPDF Performance Issues
 
 
 What type of speed differences are you seeing? Milliseconds or seconds? Is
 it consistently slower at creating any PDF, or is it only a particular PDF
that is
 slow? Is the more powerful server also handling a lot more
traffic/processing
 activity, outside of the PDF creation event? If you remove all the images
from
 the PDF, is there still a noticeable speed difference?
 
 -Mike Chabot
 
 
 On Tue, Jun 14, 2011 at 4:48 AM, Edward Chanter firew...@cc.uk.com
 wrote:
 
 
  I'm having a bit of a weird issue with the creation of PDFs. The issue
  is quite simple, we have two servers and one is generating PDFs much
  faster than the other. The weird thing is that the server which is
  slow is our 64bit production server running CF 8.0.1 Enterprise and
  the faster server is the old 32bit CF 8.0.1 standard box. One would
  logically expect the big fast production server to process the PDF
  much faster. I'm using the exact same CFML page to generate the PDF
  including the same data, images, etc.
 
  The problem I'm having is trying to get to the bottom of what is
  causing the difference in speed. To that end does anyone know what
  might cause the CFPDF service to take a long time to create the PDF?
  I'm seeing nothing in my logs and the performance monitor only tells
  me that the page is slow.
 
  Any ideas are most welcome because this one has me completely
 stumped.
 
  :)
 
 
 
 
 ~~
 ~~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:345252
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345253
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFPDF Performance Issues

2011-06-14 Thread Edward Chanter

I will try that, thanks :) It'll take me a while because the pages are
relative complex but I will let you know how it goes.

 -Original Message-
 From: Patrick Kerley [mailto:kerl...@yahoo.com]
 Sent: 14 June 2011 14:14
 To: cf-talk
 Subject: Re: CFPDF Performance Issues
 
 
 We've seen that when we have CFPDF's with Images that as ridiculous as
this
 sounds sometimes we need to move the images to different domains (multi
 domain system on same CF server) or sometimes just different
 folders.  Comment out images (if you have any) and see if that speeds it
up?
 
 -
 Patrick Kerley
 kerl...@yahoo.com
 -
 
 
 
 From: Edward Chanter firew...@cc.uk.com
 To: cf-talk cf-talk@houseoffusion.com
 Sent: Tuesday, June 14, 2011 4:48 AM
 Subject: CFPDF Performance Issues
 
 
 I'm having a bit of a weird issue with the creation of PDFs. The issue is
quite
 simple, we have two servers and one is generating PDFs much faster than
 the other. The weird thing is that the server which is slow is our 64bit
 production server running CF 8.0.1 Enterprise and the faster server is the
old
 32bit CF 8.0.1 standard box. One would logically expect the big fast
 production server to process the PDF much faster. I'm using the exact same
 CFML page to generate the PDF including the same data, images, etc.
 
 The problem I'm having is trying to get to the bottom of what is causing
the
 difference in speed. To that end does anyone know what might cause the
 CFPDF service to take a long time to create the PDF? I'm seeing nothing in
my
 logs and the performance monitor only tells me that the page is slow.
 
 Any ideas are most welcome because this one has me completely stumped.
 
 :)
 
 
 
 
 ~~
 ~~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:345254
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cf

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345255
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFPDF Performance Issues

2011-06-14 Thread Edward Chanter

I tried a very simple test of using replace() to edit the URL of the images
to our dev box so the image come from a different domain. The loading time
of one 4 page PDF went from 2+ minutes to about 6 seconds so it seems like
this is the problem. I don't understand why it's just started happening;
this code has been live for over a year without anyone complaining.
Regardless, I think I have a fix for it so thanks to everyone for the
assistance :)

 -Original Message-
 From: Mike Chabot [mailto:mcha...@gmail.com]
 Sent: 14 June 2011 15:19
 To: cf-talk
 Subject: Re: CFPDF Performance Issues
 
 
 Image handling is the most likely cause of the slowness. The first test I
would
 do is to temporarily take out every image, or knock out all HTML tags if
you
 are pulling content from CFHTTP, to see how many seconds those tags
 contribute to the creation time.
 
 -Mike Chabot
 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345258
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFPDF Performance Issues

2011-06-14 Thread Edward Chanter

Using an IP won't work because the IP resolves to multiple virtual hosts :)

Yeah I agree it is bizarre. Then again I'm still on CF8 so maybe this has
been solved in CF9

 -Original Message-
 From: Brook Davies [mailto:cft...@logiforms.com]
 Sent: 14 June 2011 16:11
 To: cf-talk
 Subject: RE: CFPDF Performance Issues
 
 
 That's bizarre. What happens if you use an IP address instead of a domain?
 Is this a bug?
 
 Brook
 
 -Original Message-
 From: Edward Chanter [mailto:firew...@cc.uk.com]
 Sent: June-14-11 7:45 AM
 To: cf-talk
 Subject: RE: CFPDF Performance Issues
 
 
 I tried a very simple test of using replace() to edit the URL of the
images
 to our dev box so the image come from a different domain. The loading time
 of one 4 page PDF went from 2+ minutes to about 6 seconds so it seems like
 this is the problem. I don't understand why it's just started happening;
 this code has been live for over a year without anyone complaining.
 Regardless, I think I have a fix for it so thanks to everyone for the
 assistance :)
 
  -Original Message-
  From: Mike Chabot [mailto:mcha...@gmail.com]
  Sent: 14 June 2011 15:19
  To: cf-talk
  Subject: Re: CFPDF Performance Issues
 
 
  Image handling is the most likely cause of the slowness. The first
  test I
 would
  do is to temporarily take out every image, or knock out all HTML tags
  if
 you
  are pulling content from CFHTTP, to see how many seconds those tags
  contribute to the creation time.
 
  -Mike Chabot
 
 
 
 
 
 ~~
 ~~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:345262
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345266
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: So to flog the preverbial undead horse

2011-06-14 Thread Edward Chanter

I've been hearing the CF is dying thing for at least the last 10 years and
the old girl is still here and going strong :)

 -Original Message-
 From: John M Bliss [mailto:bliss.j...@gmail.com]
 Sent: 14 June 2011 16:27
 To: cf-talk
 Subject: Re: So to flog the preverbial undead horse
 
 
 My assumption is that most/all of the people who think the CF is dying
out
 are no longer monitoring this list.  So I suspect you won't get their
opinion.
 
 Bottom line: if you're currently gainfully employed and actively improving
 and/or diversifying, you should be fine.
 
 I've been (mostly) a pro CF dev for 15 years with no complaints.*
 
 *past performance is not necessarily indicative of future results
 
 On Tue, Jun 14, 2011 at 10:14 AM, Integration Developer
 tyrsbl...@gmail.com
  wrote:
 
 
  Well the CF community has been great for me and I have made some good
  friends in it. I was just looking for some clarity and to see if
  anyone has thought about this and to see if they decided CF is going
  for the long run or dying out. All PR and Flame War BS aside.
 
   can you convince me that CF will continue to pay my bills, clothe
   my
  children and put bacon in the beans?
  
  You're posting on a list made up mostly (I'd assume) of people who
  get most/all of their bills/clothing/bacon money from CF so I'd call
  this a yes.
  
   If not, suggest some alternative pathways (honestly with a
   CIS/Business
  minor degree I've thought about IT management.).
  
  Alternative pathways are always/usually a good idea.  In no
  particular
  order:
  
  - sysadmin
  - DBA
  - UI/UX
  - IT/Project management
  - new CF framework
  - new application development language
  - new RDBMS
  - etc
  
  On Tue, Jun 14, 2011 at 10:05 AM, Integration Developer 
  tyrsbl...@gmail.com
   wrote:
  
  
 
 
 
 ~~
 ~~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:345267
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe.cfm


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345268
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Ning and CF

2011-05-27 Thread Edward Chanter

I was wondering if any of you lovely people has had any experience
integrating a CF based website with a Ning social network. I have a client
who has a CF website we host and a ning network he setup separately. He has
asked if it's possible for people to register on his site and have the CF
server automatically sign them up for ning as well. Or the reverse where
someone signs up for the ning network and is then signed up to his CF
website. He basically wants to try and get social networking capabilities
without having the whole thing built from scratch into his website. There's
also the issue of user generated content that he wants to keep on his
network.

I know ning has an API and I'm reading through the docs at the moment but I
was wondering if any of you have any experience with it that you might be
willing to share?

-= Ed





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344951
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: vCAL formatting

2011-05-26 Thread Edward Chanter

I had all kinds of problems with this, are you experiencing problems with
all versions of outlook or just one? I found outlook to be hypersensitive to
html and special characters in the description so that might be a place to
start.

 -Original Message-
 Anyone know where to get info on formatting the Description field when
 using Coldfusion to write an vCAL .ICS file to import into Outlook
Calendar.
 
 I am getting:
 
 PERSONS NAME
 PERSONS ADDRESS
 CITY, STATE ZIPCODE
 PHONE NUMBER
 
 I am using:
 cfset aDescription = #name##chr(10)##address##chr(10)##city#, #state#
 #zipcode##chr(10)##phone# Which gives me the results above.
 
 Terry


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344908
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFThread Memory Issues sending emails

2011-05-23 Thread Edward Chanter
   /cfmail
 
   cfcatch type=any
   div style=color:red;
   Failed send: #gu.email# -
 #cfcatch.message#br /
   /div
   /cfcatch
 
   /cftry
 
 
   /cfoutput
   /cfloop
 
 cfset endingTime = '#timeformat(now(), HH:MM:SS)#'
 
 cfmail to=#getauthuser()# bcc=e...@cc.uk.com from=Ed
 e...@cc.uk.com
 subject=I finished sending your newsletter#gn.msgSubj# sent to
 #listlen(Form.sendToList)# people
 
 Started: #startingTime#
 Finished: #endingTime#
 /cfmail
 
 /cfthread
 
 
 best wishes,
 
   -= Ed
 
 
 Edward Chanter
 Technical Innovations Manager
 Collaborative Connections Ltd.
 
 http://www.cc.uk.com/
 
 
 
 
 
 ~~
 ~~~|
 Order the Adobe Coldfusion Anthology now!
 http://www.amazon.com/Adobe-Coldfusion-
 Anthology/dp/1430272155/?tag=houseoffusion
 Archive: http://www.houseoffusion.com/groups/cf-
 talk/message.cfm/messageid:344803
 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe: http://www.houseoffusion.com/groups/cf-
 talk/unsubscribe

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344834
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFThread Memory Issues sending emails

2011-05-20 Thread Edward Chanter

Sounds about right, I'm currently working on a way to have things split into
chunks of 10k :)

Thanks anyway!

 -Original Message-
 I've found that all sends of email to large lists has to be done in
batches.
 CFMail doesn't really handle massive lists very well.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344741
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFThread Memory Issues sending emails

2011-05-20 Thread Edward Chanter

Here's a question for the gurus; if I split a 50k mass email into chunks of
10k could I thread each chunk and have 5 threads running simultaneously
sending 10k emails each?

Has anyone tried this?

 -Original Message-
 From: Edward Chanter [mailto:firew...@cc.uk.com]
 Sent: 20 May 2011 09:10
 To: cf-talk
 Subject: RE: CFThread Memory Issues sending emails
 
 
 Sounds about right, I'm currently working on a way to have things split
into
 chunks of 10k :)
 
 Thanks anyway!
 
  -Original Message-
  I've found that all sends of email to large lists has to be done in
 batches.
  CFMail doesn't really handle massive lists very well.
 
 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344742
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CFX_IMG install problems

2007-03-22 Thread Edward Chanter
Dear All,

I just tried to install CFX_IMG I must have done something wrong because now 
the CF server won't come back up and I'm seeing loads of the following message 
in cfserver.log. The problem is I can't now get into the CF server admin to 
remove the changes I made. Is there any way to do this manually or should I try 
reinstalling the cf server.

Any help greatly appreciated,

- Ed

22/03 10:11:21 user failed to load: coldfusion.CfmServlet
22/03 10:11:21 error 
[1]java.lang.ClassNotFoundException
at 
coldfusion.bootstrap.BootstrapClassLoader.loadClass(BootstrapClassLoader.java:229)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at 
coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java:93)
at coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:48)
at 
jrun.servlet.WebApplicationService.loadServlet(WebApplicationService.java:1242)
at 
jrun.servlet.JRunRequestDispatcher.init(JRunRequestDispatcher.java:748)
at 
jrun.servlet.JRunRequestDispatcher.init(JRunRequestDispatcher.java:98)
at 
jrun.servlet.WebApplicationService.getDispatcher(WebApplicationService.java:865)
at 
jrun.servlet.ServletEngineService$1.fetch(ServletEngineService.java:511)
at jrunx.util.Cache.get(Cache.java:116)
at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:537)
at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
[0]javax.servlet.ServletException
at 
coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java:102)
at coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:48)
at 
jrun.servlet.WebApplicationService.loadServlet(WebApplicationService.java:1242)
at 
jrun.servlet.JRunRequestDispatcher.init(JRunRequestDispatcher.java:748)
at 
jrun.servlet.JRunRequestDispatcher.init(JRunRequestDispatcher.java:98)
at 
jrun.servlet.WebApplicationService.getDispatcher(WebApplicationService.java:865)
at 
jrun.servlet.ServletEngineService$1.fetch(ServletEngineService.java:511)
at jrunx.util.Cache.get(Cache.java:116)
at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:537)
at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


Re: CFX_IMG install problems

2007-03-22 Thread Edward Chanter
Thanks Dave, I should have waited for your email. I couldn't get it working so 
I tried uninstalling and reinstalling the ColdFusion server, now I can't get 
the apache connectors working :-( What a nightmare day, and I'm supposed to be 
going on holiday tomorrow. I have a CF server that is taking over 500 seconds 
to restart and the apache connectors fail miserably, even though I've had it 
all working before. Do you know why it might take so long to restart?

 I just tried to install CFX_IMG I must have done something 
 wrong because now the CF server won't come back up and I'm 
 seeing loads of the following message in cfserver.log. The 
 problem is I can't now get into the CF server admin to remove 
 the changes I made. Is there any way to do this manually or 
 should I try reinstalling the cf server.

All of the configuration information is in a set of text files you can edit
directly. On a multiserver install, the directory is
\jrun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib. Off the
top of my head, I think that the file you want to edit is neo-runtime.xml,
but if not, it's almost certainly one of the other neo-*.xml files.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

This email has been processed by SmoothZap - www.smoothwall.net

~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

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


Re: CFX_IMG install problems

2007-03-22 Thread Edward Chanter
Thanks Dave, I should have waited for your email. I couldn't get it working so 
I tried uninstalling and reinstalling the ColdFusion server, now I can't get 
the apache connectors working :-( What a nightmare day, and I'm supposed to be 
going on holiday tomorrow. I have a CF server that is taking over 500 seconds 
to restart and the apache connectors fail miserably, even though I've had it 
all working before. Do you know why it might take so long to restart?

 I just tried to install CFX_IMG I must have done something 
 wrong because now the CF server won't come back up and I'm 
 seeing loads of the following message in cfserver.log. The 
 problem is I can't now get into the CF server admin to remove 
 the changes I made. Is there any way to do this manually or 
 should I try reinstalling the cf server.

All of the configuration information is in a set of text files you can edit
directly. On a multiserver install, the directory is
\jrun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib. Off the
top of my head, I think that the file you want to edit is neo-runtime.xml,
but if not, it's almost certainly one of the other neo-*.xml files.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

This email has been processed by SmoothZap - www.smoothwall.net

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

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


IsUserInRole - question

2006-03-10 Thread Edward Chanter
I can't seem to get the IsUserInRole function to accept dynamic data, eg.

cfset dynData = '15'

cfif IsUserInRole(#dynData#)
User is in this role
/cfif

Am I being dumb here or am I missing something or is this deliberate?

best wishes,

-= Ed


~
Edward Chanter
Technical Innovations Manager
Collaborative Connections Ltd.

http://www.cc.uk.com/
Phone: +44 (0) 1273 832221
Mobile: +44 (0) 7866 365282
~


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235012
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: IE6 caching behaviour... all change

2001-11-22 Thread Edward Chanter

I don't know about caching but I've noticed some really odd behaviour with
IE6, like it just stops being able to access web pages for no apparent
reason Also some strange behaviour with redirects and cflocation
tags...?
On shutdown the process doesn't terminate and I have to use taskmanager to
kill it When it restarts it seems to be ok, at least for a while then
starts acting up again. :-(

MS Gremiln v6 me thinks..

Anyone else noticed anything smillar?

best wishes,

  -= Ed


 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Using characters other than ? in the url query string

2001-11-16 Thread Edward Chanter

Joel that was great, thanks a lot for your help

best wishes,

  -= Ed


 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Using characters other than ? in the url query string

2001-11-15 Thread Edward Chanter

G'day Peoples,

Does any of you Jedi Knights know a way of reconfiguring either IIS or Cold
Fusion so that it takes a / instead of a ? as the control character in a
url cgi query string...?

According to the Spider Food site it is possible, but they don't tell you
how and I can't find anything on the tech support site that talks about
it?

The Spider Food URL is:
http://spider-food.net/dynamic-page-optimization-b.html

Any help would be greatly appreciated..

best wishes,

  -= Ed


 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



cfquery Question

2001-09-07 Thread Edward Chanter

I'm probably being a dunce here but does anyone know a sql query that will
list out all the tables in a particular sql7 database...?

Thanks in advance...

-= Ed
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Weird CF5 server problem

2001-08-10 Thread Edward Chanter

I've set up CF 5 on a development machine running NT4 sp6a and the Latest
version of Apache as opposed to IIS. I've been seeing a lot of errors in the
Event log in NT containing the following:

Unable to gain access to the WEB server thru the Service Manager

Has any of you seen this before? I've checked the service manager and the cf
server should have access to the web server without any problem..

best wishes,

  -= Ed


If you want others to be happy, practice compassion.
If you want to be happy, practice compassion.
~The 14th Dalai Lama
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF5 Advanced Security

2001-08-09 Thread Edward Chanter

Guys n Gals,

Is it possible to use a cf4.5 installation as the security server for a cf5
install.???

Or do they both need to be running cf5?


best wishes,

  -= Ed


If you want others to be happy, practice compassion.
If you want to be happy, practice compassion.
~The 14th Dalai Lama
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFMail Spool Interval

2001-08-08 Thread Edward Chanter

Maybe I'm being thick here, but what does the spool interval _actually_ do
in CF 4.5

Does it control how often the spool restarts ie. It sends all the mail it
can and then wait's an specified interval before starting again, or does it
control something else.

Sorry if this is a dumb question but it is first thing in the morning :-O


best wishes,

  -= Ed


If you want others to be happy, practice compassion.
If you want to be happy, practice compassion.
~The 14th Dalai Lama
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CFMail Spool Interval

2001-08-08 Thread Edward Chanter

Wicked :-)

Cheers mate!


best wishes,

  -= Ed


If you want others to be happy, practice compassion.
If you want to be happy, practice compassion.
~The 14th Dalai Lama
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF Forums - Weirdness

2001-08-07 Thread Edward Chanter

Ok, we've just set up forums on our system and it's behaving in a rather odd
way, perhaps one of you lot has seen this before and knows a workaround.

Ok, the way it's working is this:

1. User goes to conference
2. User is allowed in but with no rights to post or reply
3. User wants to post so they click the login/logout button
4. User Registers
5. User confirms password
6. User waits for approval.

Now, here's the problem, unless the user logs in unsuccessfully straight
after registration their username won't show up in the list of users
requiring approval that the admin sees...

I've tested it and even tried modifying the code but I managed to kill the
server in the process :-/

Can anyone help???

Or possibly recommend another open source threaded discussion app for CF
This is starting to drive me a little potty so if anyone wants to help
rescue my sanity, please feel free!!

best wishes,

  -= Ed


If you want others to be happy, practice compassion.
If you want to be happy, practice compassion.
~The 14th Dalai Lama
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF Forums - Weirdness

2001-08-07 Thread Edward Chanter

 -Original Message-
 Is it the free forum from allaire that you mean by CF Forums

Yes

 If so did you know that there is a forum for it at www.forumspot.org

Yeah I know but I thought I'd post the question here too becuase the support
forum isn't the fastest place in the world to get answers.

 If you dont know about it its opensource.

No, really?

 You can download it from the above address also.

I have, done the download, got the SQL database working, but the forums app
itself just doesn't work properly. Or at least not in any way that makes
sense to your average mortal.

 There are a few errors in the files such as attachments etc.
 Most of the info is on the site above.

Yeah, I know but what's not there is an explanation as to why the app works
in such a dumb way. I mean if someone registers on the site and user
approval is forced then it SHOULD correctly put that user in the list of
those requiring approval WITHOUT forcing that user to login first. As it
is, unless the user registers then unsuccessfully tries to login, the admin
doesn't know that they require approval.

-= Ed


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: default.ida?

2001-08-03 Thread Edward Chanter

 -Original Message-
  I keep seeing on the log files some default.ida request.
  are those hacking attempts? what is this file do?


YOU ARE INFECTED WITH CODE RED

Please shut down your IIS, patch it and then restart!


best wishes,

  -= Ed


If you want others to be happy, practice compassion. 
If you want to be happy, practice compassion. 
~The 14th Dalai Lama
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: default.ida?

2001-08-03 Thread Edward Chanter

I don't actually think it's hysteria mate, do you want to see a copy of my
IDS logs There are a large number of attacks going on as I write this
and anyone running an unpatched/unprotected IIS server needs to do something
about it asap.


best wishes,

  -= Ed


If you want others to be happy, practice compassion.
If you want to be happy, practice compassion.
~The 14th Dalai Lama
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: default.ida?

2001-08-03 Thread Edward Chanter

 -Original Message-
  I don't actually think it's hysteria mate, do you want to see
  a copy of my
  IDS logs

 Not really, no. They tend to be boring and full of kidz getting 404's.

:-) I did say IDS logs though, they filter out all the crap and only show me
the ISAPI Extension Overflow errors.

  There are a large number of attacks going on as
  I write this

 Woo-wee - where have you been ? An ongoing scan of your system is
 a *FACT OF
 LIFE* for a system on the internet.
 My dial-up gateway at home gets scanned !

Tell me about it, then again, my server very rarely blocks anyone, so far
today it's implemented over  300 24 bans on various IP addresses in the last
12 hours. That is unusual.

  and anyone running an unpatched/unprotected IIS server needs
  to do something
  about it asap.

 No, anyone running an unpatched/unprotected IIS server on a public network
 needs to fired, as their not doing their job. The patch was all
 over BugTraq
 et al. well before Code Red was released.

Agreed!

 But, if you look at the domains from which these scans originate,
 most have
 no reverse look-up, or are from ISP's like @home shrug and
 those are just
 the people who wont care, because Code Red version 2 is non destructive to
 the local machine.

Lot's of Chinese, Japanese, Koreans, Mexicans and a few US and EU academic
one's as well.. There are even some coming in as 0.0.0.0

I have had a few responses from some of the ones  I thought would take
action, some very sheepish IISadmins out there :-)

We're averaging a new attempt every minute or so

-= Ed



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: default.ida?

2001-08-03 Thread Edward Chanter

193.122.20.5 - Production
193.122.20.8 - Development

Why?



 -Original Message-
 From: Tangorre, Mike [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, August 02, 2001 3:34 PM
 To: CF-Talk
 Subject: RE: default.ida?


 whats yur ip?  :-)


 Michael T. Tangorre
 
 Web Applications Developer
 Office Phone: 703-558-4746
 Cellular Phone: 607-426-9277
 AIM: CrazyFlash4
 Personal Email: [EMAIL PROTECTED]
 Work Email: [EMAIL PROTECTED]
 School Email: [EMAIL PROTECTED]
 
 This Email contains MillenniuM Information
 Systems, LLC Privileged Information which
 is Customer or Business Sensitive.
 


 -Original Message-
 From: Edward Chanter [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, August 02, 2001 10:32 AM
 To: CF-Talk
 Subject: RE: default.ida?


  -Original Message-
   I don't actually think it's hysteria mate, do you want to see
   a copy of my
   IDS logs
 
  Not really, no. They tend to be boring and full of kidz getting 404's.

 :-) I did say IDS logs though, they filter out all the crap and
 only show me
 the ISAPI Extension Overflow errors.

   There are a large number of attacks going on as
   I write this
 
  Woo-wee - where have you been ? An ongoing scan of your system is
  a *FACT OF
  LIFE* for a system on the internet.
  My dial-up gateway at home gets scanned !

 Tell me about it, then again, my server very rarely blocks anyone, so far
 today it's implemented over  300 24 bans on various IP addresses
 in the last
 12 hours. That is unusual.

   and anyone running an unpatched/unprotected IIS server needs
   to do something
   about it asap.
 
  No, anyone running an unpatched/unprotected IIS server on a
 public network
  needs to fired, as their not doing their job. The patch was all
  over BugTraq
  et al. well before Code Red was released.

 Agreed!

  But, if you look at the domains from which these scans originate,
  most have
  no reverse look-up, or are from ISP's like @home shrug and
  those are just
  the people who wont care, because Code Red version 2 is non
 destructive to
  the local machine.

 Lot's of Chinese, Japanese, Koreans, Mexicans and a few US and EU academic
 one's as well.. There are even some coming in as 0.0.0.0

 I have had a few responses from some of the ones  I thought would take
 action, some very sheepish IISadmins out there :-)

 We're averaging a new attempt every minute or so

   -= Ed

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: default.ida?

2001-08-03 Thread Edward Chanter

Yeah that's the address of one of Aol's many proxies

I think our firewall just blocked a large swathe of Aol users.

 -Original Message-
 From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
 Sent: 2 August 2001 5:03 PM
 To: CF-Talk
 Subject: RE: default.ida?
 
 
  IP: 172.158.23.29
  DNS: AC9E171D.ipt.aol.com
 
 Looks like a dial-up luser.
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: default.ida?

2001-08-03 Thread Edward Chanter

Amen!

 -Original Message-
 his email domain is cc.uk.com. which i can ping and see the IP 
 193.122.20.2.
 so i could do a port scan in that range and see any machine 
 running port 80.
 
 so can you explain to us all what he revealed that wouldn't take 
 more than 1
 or 2 minutes for anyone to figure out?


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: default.ida?

2001-08-03 Thread Edward Chanter

Ok, so who is

IP: 172.158.23.29
DNS: AC9E171D.ipt.aol.com

One of you lot?

best wishes,

  -= Ed


If you want others to be happy, practice compassion.
If you want to be happy, practice compassion.
~The 14th Dalai Lama
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: default.ida?

2001-08-03 Thread Edward Chanter

LOL, like someone on this list couldn't work it out simply by doing a dig on
our DNS info based on my email address domain Anyone serious about it
doesn't need me or anyone else to tell them my (or your) IP address.

Besides, they're public servers and I'd like to see Code Red do anything at
all except get itself banned.

:-)

best wishes,

  -= Ed


If you want others to be happy, practice compassion.
If you want to be happy, practice compassion.
~The 14th Dalai Lama
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



  1   2   >