Re: CF (8.0.0) performance vs PHP (5)

2010-10-20 Thread Arsalan Tariq Keen
Well, I agree with David... giving PHP a try after using CF for around 8 years, I have found PHP to be much faster on an average setup hardware. Having said that, Wil, I do realise your point, can you please guide us to some resource where we can learn performance tuning of CF specially on the

Re: CF (8.0.0) performance vs PHP (5)

2010-10-20 Thread Jochem van Dieten
On Tue, Oct 19, 2010 at 10:51 PM, Bryan Stevenson wrote: Respectfully Ketanyour tests have nothing to do with the string concatenation performance issue that was the crux of this thread ;-) I very much doubt the performance issue discussed here has anything to do with string concatenation.

Re: CF (8.0.0) performance vs PHP (5)

2010-10-20 Thread Wil Genovese
Each server setup is unique and needs to be tuned for it's purpose, applications running and hardware. I have a couple of JVM Tuning posts on my blog that serve as a guide but not meant as an exact this is how you do it. http://www.trunkful.com/index.cfm/JVM-Tuning The Adobe website has

Find duplicated contacts (and typos)

2010-10-20 Thread Mack
Hi! I have a contact application where I need to display possible duplicates within the existing contacts. Possible duplicates means different contact entries that refer to the same person and might have the same or slightly different information (typos). What I currently do is search for

Re: cant access cf administrator

2010-10-20 Thread Mack
On Tue, Oct 19, 2010 at 6:32 PM, Jay Birdsell john_birds...@hotmail.com wrote:  HI I have just installed CF9 on a Solaris 10 box with weblogic 11g, when i try to log into cf administrator, I get a 500 error, cf itself is running as I can pull the log in pages for all my apps, of course

Re: Find duplicated contacts (and typos)

2010-10-20 Thread Russ Michaels
Sadly I don;t think soundex is going to help you as this finds words that sound like other words (there, their, they're), which isn't going to pickup typos. I think comparing each contact field on an OR basis is a sufficient way to find dupes, if none of those fields are the same then it is not

Re: Find duplicated contacts (and typos)

2010-10-20 Thread Mack
On Wed, Oct 20, 2010 at 4:22 PM, Russ Michaels r...@michaels.me.uk wrote: Sadly I don;t think soundex is going to help you as this finds words that sound like other words (there, their, they're), which isn't going to pickup typos. In my testing soundex works reasonable well if I allow the 2

Re: cant access cf administrator

2010-10-20 Thread Jay Birdsell
What do the CF and web server logs say ? -- Mack here is the output from the exception log Error,[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)',10/20/10,09:36:24,cfadmin,Could not initialize class com.verity.security.k2.K2Encrypt The specific sequence

Re: cant access cf administrator

2010-10-20 Thread Mack
Jay, From the log file it seems for some reason CF cannot find the K2Encrypt class. On a standard install the class should be in #cf_home#/wwwroot/web-inf/lib/verity.jar. Do you have that file ? Is this the only error message that you get or do you get some other error messages early in the

using cfdocument to generate PDF

2010-10-20 Thread Monte Chan
Hi all, The actual table is a lot larger than the mock-up one that I am going to show you but this mock-up one does explain the problem. Please go to http://www.monteandjanicechan.com/test_table.cfm The thickness of the grid lines in the table are coming up the way I want in the HTML

Memory Upgrade - Revisited

2010-10-20 Thread Steve LaBadie
We purchase 12 GB of memory for our web server and come to find out that we need Windows 2003 Enterprise or upgrade to Windows 2008 in order for the memory to be recognized. We currently have MX 7 standard installed. I am going to upgrade to CF 9, Standard. I understand that CF 9 Standard comes

Re: Memory Upgrade - Revisited

2010-10-20 Thread David McGraw
There is something wrong with the idea of using such a beastly web-server with an Access DB backend, upgrade your DB while you are at it. Regards, David McGraw Oyova Software, LLC http://www.oyova.com On Wed, Oct 20, 2010 at 11:48 AM, Steve LaBadie slaba...@po-box.esu.eduwrote: We

RE: Memory Upgrade - Revisited

2010-10-20 Thread Steve LaBadie
I have a couple of Access DB's (which were done sometime ago) along with MySQL and MS SQL. I guess I am too lazy to switch them over. Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu slaba...@po-box.esu.edu

CFPDF=merge to create 1 page with merged documents

2010-10-20 Thread Brook Davies
Does anyone know if you can use CFPDF=merge to merge to small PDF segments into a 1 page document. Whenever I run merge, it creates a new page. I want to build a single page from multiple source documents (which have a height of 2 inches each and should combine into a single page okay...

RE: Find duplicated contacts (and typos)

2010-10-20 Thread Russ Michaels
Crikey, you must just have a really shagged contacts list LOL. Have you tried Plaxo, this does a very good job of removing duplicates. Or does it need to be an in-house app ? Russ -Original Message- From: Mack [mailto:mrsmith.w...@gmail.com] Sent: 20 October 2010 14:43 To: cf-talk

Re: Memory Upgrade - Revisited

2010-10-20 Thread Maureen
If you are only using the data tables in Access and not any of the reports or forms, you can upsize the tables to MSSQL in just a few minutes with the upsize tool. On Wed, Oct 20, 2010 at 8:59 AM, Steve LaBadie slaba...@po-box.esu.edu wrote: I have a couple of Access DB's (which were done

Re: CFPDF=merge to create 1 page with merged documents

2010-10-20 Thread Jochem van Dieten
On Wed, Oct 20, 2010 at 6:31 PM, Brook Davies wrote: Does anyone know if you can use CFPDF=merge to merge to small PDF segments into a 1 page document. Whenever I run merge, it creates a new page. I want to build a single page from multiple source documents (which have a height of 2 inches

Re: cant access cf administrator

2010-10-20 Thread Jay Birdsell
Jay, From the log file it seems for some reason CF cannot find the K2Encrypt class. On a standard install the class should be in #cf_home#/wwwroot/web-inf/lib/verity.jar. Do you have that file ? Is this the only error message that you get or do you get some other error messages early in the

Re: CF (8.0.0) performance vs PHP (5)

2010-10-20 Thread Bryan Stevenson
Whatever Jochemyou get the pointa simple page load test with some queries etc. has nothing to do with the threadit was a SPECIFIC performance issue. I bow down to your superior knowledge and use of semantics ;-) Cheers On Wed, 2010-10-20 at 09:56 +0200, Jochem van Dieten wrote:

Re: cant access cf administrator

2010-10-20 Thread Jay Birdsell
Jay, Mack I do have that file, but in a different directory web-inf/cfusion/lib. I might have to add it to the class path. the only other error message shows up as a single line entry in the application log Could not initialize class com.verity.security.k2.K2Encrypt The specific sequence of

Apache Axis Does Not Generate All Classes of Web Service

2010-10-20 Thread Donnie Carvajal
I am having a problem with the NetSuite wsdl. There are stub class files that are missing. I've seen some posts in some other forums indicating that when the web service is setup through Coldfusion, there are class files missing, but when wsdl2java is run from the command line, it works just

RE: CFPDF=merge to create 1 page with merged documents

2010-10-20 Thread Brook Davies
OK, good idea Jochem - thank you! -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: October-20-10 10:09 AM To: cf-talk Subject: Re: CFPDF=merge to create 1 page with merged documents On Wed, Oct 20, 2010 at 6:31 PM, Brook Davies wrote: Does anyone know if

Re: Apache Axis Upgrade

2010-10-20 Thread Donnie Carvajal
Are there any special intructions for upgrading Axis in ColdFusion? It seems the webservices.jar file also has a wsdl2java class that maybe being called over the class in the upgrades Axis jar files. Thanks, Donnie ~|

Re: Apache Axis Does Not Generate All Classes of Web Service

2010-10-20 Thread Russ Michaels
you should only need to generate the class files once, it is not likley that the web service is changing very often, so if wsdl2java generates them all properly then you should be able to call the web service after doing so. Russ On Wed, Oct 20, 2010 at 7:37 PM, Donnie Carvajal

Re: Apache Axis Upgrade

2010-10-20 Thread Russ Michaels
u can just open the jar file in winzip or any other archive program and check that. It was a very long time ago i did an axis upgrade so I don't remember if I did anything special, but I don;t think so. On Wed, Oct 20, 2010 at 8:18 PM, Donnie Carvajal donnie.carva...@transformyx.com wrote:

Re: Apache Axis Upgrade

2010-10-20 Thread Donnie Carvajal
Which jar file are you talking about opening and what am I looking for? If this determines that the webservices.jar has the wsdl2java class, how do I get ColdFusion to use the upgraded Axis jar? Thanks. ~| Order the Adobe

Re: Apache Axis Upgrade

2010-10-20 Thread Russ Michaels
In your previous reply you said axis.jar, so this is what i am referring to. if you can determine which one is being used, you can copy the updates class into the jar and see if that helps. On Wed, Oct 20, 2010 at 8:37 PM, Donnie Carvajal donnie.carva...@transformyx.com wrote: Which jar file

Catching Invalid CFML construct found in OnError

2010-10-20 Thread Tony Bentley
I am trying to catch this error type but it is not passing through onError in the Application Class. It simply is evaluated and thrown as is. How do I catch it without a try/catch? ~| Order the Adobe Coldfusion Anthology now!

Importing from CSV to a database

2010-10-20 Thread Claude Schnéegans
Hi, I have to create a new database from a CSV text file. I have an ODBC datasource defined for the CSV file and I can read the file with a query like: CFQUERY NAME=getMembers DATASOURCE=Import SELECT * FROM membersImport.csv /CFQUERY The problem is that column names have blanks and special

Re: Catching Invalid CFML construct found in OnError

2010-10-20 Thread Claude Schnéegans
I am trying to catch this error type but it is not passing through onError in the Application Class. It simply is evaluated and thrown as is. How do I catch it without a try/catch? I don't think you can. onError will only catch execution errors. Invalid CFML construct is a compilation

Re: Catching Invalid CFML construct found in OnError

2010-10-20 Thread Tony Bentley
So basically if there is a typo in the syntax and the code does not compile it will throw an error and I cannot catch it? Hmmm... I guess I need to figure out something else. ~| Order the Adobe Coldfusion Anthology now!

Re: Catching Invalid CFML construct found in OnError

2010-10-20 Thread Claude Schnéegans
So basically if there is a typo in the syntax and the code does not compile it will throw an error and I cannot catch it? More precisely: if there is a typo, the code does get compiled, but is not executed. Since it is not executed, you cannot catch it at execution.

Re: Apache Axis Does Not Generate All Classes of Web Service

2010-10-20 Thread Donnie Carvajal
The problem is that there are class files missing from the intitial generation. I'm trying to figure out how to get either ColdFusion or Apache Axis to generate all of the files. ~| Order the Adobe Coldfusion Anthology now!

Re: Apache Axis Does Not Generate All Classes of Web Service

2010-10-20 Thread Russ Michaels
you said it worked fine when doing it via wsdl2java ? On Wed, Oct 20, 2010 at 9:24 PM, Donnie Carvajal donnie.carva...@transformyx.com wrote: The problem is that there are class files missing from the intitial generation. I'm trying to figure out how to get either ColdFusion or Apache

Re: Apache Axis Does Not Generate All Classes of Web Service

2010-10-20 Thread Donnie Carvajal
No. I never got it to work. When I run wsdl2java from the command line, it times out trying to access the wsdl. ~| Order the Adobe Coldfusion Anthology now!

Re: totaling items in a recordset

2010-10-20 Thread Joel Black
You can query the database to extract the records you want, then query the query for a total. This example actually gets the total if there are multiple quantity for each item !--- get the totals --- cfquery dbtype=query name=total SELECT SUM(PriceSold*Quantity) AS TheTotal FROM cart /cfquery

Re: Importing from CSV to a database

2010-10-20 Thread Leigh
I've tried getMembers['Région administrative'] but it causes an error. Did you forget the row number or is that typo? ie queryName[column name][ rowNumber ] ~| Order the Adobe Coldfusion Anthology now!

Re: Catching Invalid CFML construct found in OnError

2010-10-20 Thread Russ Michaels
you can probably catch it using the default error template. On Wed, Oct 20, 2010 at 9:30 PM, wrote: So basically if there is a typo in the syntax and the code does not compile it will throw an error and I cannot catch it? More precisely: if there is a typo, the code does get compiled,

Re: Find duplicated contacts (and typos)

2010-10-20 Thread Mack
On Wed, Oct 20, 2010 at 7:35 PM, Russ Michaels r...@michaels.me.uk wrote: Crikey, you must just have a really shagged contacts list LOL. Have you tried Plaxo, this does a very good job of removing duplicates. Or does it need to be an in-house app ? Russ, This is part of a larger app and the

Re: Catching Invalid CFML construct found in OnError

2010-10-20 Thread Dave Watts
More precisely: if there is a typo, the code does get compiled, but is not executed. Since it is not executed, you cannot catch it at execution. Well, not exactly - if there is a typo in CFML syntax (rather than within attribute values, etc), the code will not be compiled at all. CF will

Re: cant access cf administrator

2010-10-20 Thread Mack
On Wed, Oct 20, 2010 at 9:25 PM, Jay Birdsell john_birds...@hotmail.com wrote: Jay, Mack I do have that file, but in a different directory web-inf/cfusion/lib. I might have to add it to the class path. the only other error message shows up as a single line entry in the application log Jay,

Re: Catching Invalid CFML construct found in OnError

2010-10-20 Thread Dave Watts
So basically if there is a typo in the syntax and the code does not compile it will throw an error and I cannot catch it?  Hmmm... I guess I need to figure out something else. The site-wide error handler will catch compile-time errors. But really, you should catch them yourself - if you get

ColdFusion Administration 9:: Debugging IP Addresses

2010-10-20 Thread Matthew Lowrey
I have a question about the Debugging IP Addresses (DIPA) section of the CFIDE. We have our developing team IP addresses set in the DIPA section with the understanding that, IF debugging is turned on for our site(s), those of us who are included on this DIPA listing will see the debugging

Re: ColdFusion Administration 9:: Debugging IP Addresses

2010-10-20 Thread Dave Watts
With that said, does debugging run 100% of the time when  turned on, only displaying the information for the DIPA members?  Or, does it know to only run/process information for DIPA members. It runs 100% of the time, whether anyone sees it or not. For this reason, it should never be enabled

Re: ColdFusion Administration 9:: Debugging IP Addresses

2010-10-20 Thread Matthew Lowrey
I had a feeling that was the case, thanks Dave for the clarification. And, my response to that is BOO. Ha ha... It would be great to have it the other way. ~| Order the Adobe Coldfusion Anthology now!

fckEditor and Coldfusion tags

2010-10-20 Thread Torrent Girl
Hello all. I built a Content Management system that uses the fckEditor. The problem is that when a user adds CF tags, they aren't read correct when the content is retrieved from the database. I did a bit of research which lead me to the following url which instructed me to edit the

Re: Catching Invalid CFML construct found in OnError

2010-10-20 Thread Tony Bentley
Dave, You are correct but stuff slips through the cracks. It's how well you can track back the error to the source when it occurs that will dictate if the code will be fixed when or if it happens. I can show a pretty nice user friendly error, but the question remains the same. How will I track

Re: Catching Invalid CFML construct found in OnError

2010-10-20 Thread Dave Watts
You are correct but stuff slips through the cracks. It's how well you can track back the error to the source when it occurs that will dictate if the code will be fixed when or if it happens. I can show a pretty nice user friendly error, but the question remains the same. How will I track

Re: fckEditor and Coldfusion tags

2010-10-20 Thread Matt Robertson
Are you trying to retrieve coldFusion code from a database and then execute it? -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Order the Adobe Coldfusion Anthology now!

Re: Catching Invalid CFML construct found in OnError

2010-10-20 Thread Tony Bentley
How do you catch compile time errors when they occur? Regardless if a template was tested or not. I understand best practices and that your code should be tested but it doesn't mean it will never happen. So when it does, how do you deal with it? If I get a server error from my applications, I get

Re: Catching Invalid CFML construct found in OnError

2010-10-20 Thread Dave Watts
How do you catch compile time errors when they occur? Regardless if a template was tested or not. I understand best practices and that your code should be tested but it doesn't mean it will never happen. So when it does, how do you deal with it? If I get a server error from my applications, I

Re: Catching Invalid CFML construct found in OnError

2010-10-20 Thread Tony Bentley
Okay so running the code is gonna have to be the answer. The original reason for asking was because in my Ajax app I was not able to pass a custom header if I got a compile time error so catching it was a bit more difficult. It makes sense on a page request but an ajax request could be messy.

Re: Importing from CSV to a database

2010-10-20 Thread Claude Schnéegans
Did you forget the row number or is that typo? Actually, I'm in a loop on the query, I thought the row number would be implicit as usual. But you're right, queryName[column name][queryName.currentRow] does work. This is kind of weird since queryName.columnName works, bur not

Re: fckEditor and Coldfusion tags

2010-10-20 Thread Torrent Girl
yep. Are you trying to retrieve coldFusion code from a database and then execute it? -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Order the Adobe Coldfusion Anthology now!

Re: fckEditor and Coldfusion tags

2010-10-20 Thread Torrent Girl
Please tell me this can be done :0 Are you trying to retrieve coldFusion code from a database and then execute it? -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Order the Adobe Coldfusion Anthology

Re: totaling items in a recordset

2010-10-20 Thread Michael Grant
You should read the rest of this thread Joel. On Wed, Oct 20, 2010 at 4:46 PM, Joel Black j...@blackbeardesign.comwrote: You can query the database to extract the records you want, then query the query for a total. This example actually gets the total if there are multiple quantity for

CFExchange Connection Problems

2010-10-20 Thread raiola
Hi all This is my first post to this group. I have started working with the Microsoft exchange integration with CF9 however I receive the following error message Exchange service is not available on 192.168.0.1. cfexchangeConnection action=open username=myusername

Re: fckEditor and Coldfusion tags

2010-10-20 Thread Kym Kovan
On 21/10/2010 11:26, Torrent Girl wrote: Please tell me this can be done :0 yes, indirectly. The editor will by default change any or to their equivalents lt: and gt; One has to ask who is going to write this code? It is the world's second biggest security issue letting code be created

Re: Importing from CSV to a database

2010-10-20 Thread Leigh
This is kind of weird since queryName.columnName works, bur not queryName[columnName] I guess the difference is queryName[columnName] gives you access to the column array. I thought it was strange at first too. But realized it is a good thing, since it allows you to access values in any row

Re: fckEditor and Coldfusion tags

2010-10-20 Thread Torrent Girl
Developers will write it. Its in a protected CMS. Just forms and cfoutput tags are really going to be the only code in the CMS. We just want to have a completely dynamic site. I found this snippet: cffunction name=CleanUpCode access=public returntype=string output=true cfargument

Re: fckEditor and Coldfusion tags

2010-10-20 Thread Claude Schnéegans
Just forms and cfoutput tags are really going to be the only code in the CMS. Even so, you cannot have a CFML template create CFML code and expect it to be executed. The only way to do it would be to write the code into a file, then CFINCLUDE it, kind of cumbersome, especially in a multiuser

RE: fckEditor and Coldfusion tags

2010-10-20 Thread andy matthews
ColdFusion has a function called Evaluate. One way to run this code would be to pass the contents of your dbField into the function. The problem is that if it contained anything OTHER than CF code it would probably die. Another option might be for the user to input their code, then you save it

Re: fckEditor and Coldfusion tags

2010-10-20 Thread Torrent Girl
This function is working for me. cffunction name=CleanUpCode access=public returntype=string output=true cfargument name=string type=string required=true/ cfset string = #Replace(string, ’, ', all)# cfset string = #Replace(string, , , all)# cfset string =

Re: fckEditor and Coldfusion tags

2010-10-20 Thread Torrent Girl
hmmm...maybe I'll add the function before i enter the text into the DB This function is working for me. cffunction name=CleanUpCode access=public returntype=string output=true cfargument name=string type=string required=true/ cfset string = #Replace(string, ’, ',

Re: fckEditor and Coldfusion tags

2010-10-20 Thread Torrent Girl
I spoke too soonit's not working hmmm...maybe I'll add the function before i enter the text into the DB ~| Order the Adobe Coldfusion Anthology now!

Re: fckEditor and Coldfusion tags

2010-10-20 Thread Mike Kear
I get round this issue in my CMS by having a fileName field. For security reasons, this field only appears in forms offered to validated users who have permission to upload such files. (not many!).They can upload the file, using the uploader on the 'content' page, then instead of putting

Re: Fckeditor html vs xhtml

2010-10-20 Thread Mike Kear
Yes. Upgrade to the latest version of FCKEditor, or even to the new CKEditor. IF you are using the built-in editor in CF8, you will find there's a FCKEditor folder in the forms files (in CF9 it's at \CFIDE\scripts\ajax\FCKeditor and from memory I think that's where it is in CF8 too). You

Re: fckEditor and Coldfusion tags

2010-10-20 Thread Matt Robertson
The only way to do it would be to write the code into a file, then CFINCLUDE it, kind of cumbersome, Not quite the only way. 1. Write the code in the editor ... as if it were a code editor :-| 2. Store the form field data using the gymnastics described earlier. 3. Publish the data as a