OT:Looking for a good SQL mailing list
** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I am having some trouble with an SQL statement I'm trying to write and I want to know if there are any good mailing lists out there for SQL, that are as good as CFTalk is for ColdFusion. Or can I post my question here? Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Looking for a good SQL mailing list
whats your problem? -Original Message- From: Adams, Stephen [mailto:sadams;westminster.gov.uk] Sent: 30 October 2002 09:45 To: CF-Talk Subject: OT:Looking for a good SQL mailing list ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I am having some trouble with an SQL statement I'm trying to write and I want to know if there are any good mailing lists out there for SQL, that are as good as CFTalk is for ColdFusion. Or can I post my question here? Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT:Looking for a good SQL mailing list
want to know if there are any good mailing lists out there for SQL, that are as good as CFTalk is for ColdFusion. by all means post here BUT if you're using sql server get on the list: http://www.SSWUG.org --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.408 / Virus Database: 230 - Release Date: 10/24/2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT:Yahoo moving to PHP
Look at the CreateObject function to create an instance of an object in CFScript. Other than that, I don't see how one syntax could get old while the other version doesn't. At 11:11 PM 10/29/2002 -0500, you wrote: It isn't ugly, but it can be a pain. I would like to see CF be able to be tag based or like everything else. It does get old typing stuff like cfif blah cfelse /cfif I like if (blah) { } else { } while you can use CFscript for this, there are a number of things you can't do with CFScript. Like including a file, running a query, creating an instance of an object. Create Complete CFCs Some of these things can now be done using UDF, but that requires an additional file included, which can end up being pretty big. -- Jeffry Houser | mailto:jeff;farcryfly.com DotComIt, Putting you on the web AIM: Reboog711 | Phone: 1-203-379-0773 -- My CFMX Book: http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Yahoo moving to PHP
Haven't looked at it myself, but my business partner tells me that PHP4 is looking pretty good these days. He thinks that maybe the developers have learnt some lessons about how the various tags and functions look and feel from CF, as its much more friendly and requires less of a propeller head to be able to code. Maybe that's why they went with PHP, but yeah, from that presentation, those are some lame excuses for not using the other languages, especially the CF excuse! Stephen - Original Message - From: Matt Liotta [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 10:20 PM Subject: RE: Yahoo moving to PHP There must be more to their choices then the slides reveal. They say... * They didn't go with CF because its syntax is ugly. * They didn't go with ASP because it requires Windows. * They didn't go with Java because it required threads and FreeBSD doesn't really like threads. All of the above sounds pretty retarded. Matt Liotta President CEO Montara Software, Inc. http://www.montarasoftware.com/ 888-408-0900 x901 -Original Message- From: Ben Densmore [mailto:ben_densmore;esupport.com] Sent: Tuesday, October 29, 2002 5:13 PM To: CF-Talk Subject: OT:Yahoo moving to PHP Check it out, in their presentation for why they chose PHP, they make reference as to why they didn't go with CF or ASP http://public.yahoo.com/~radwin/talks/yahoo-phpcon2002.htm Ben ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cfc error help
I've only starting writing cfcs myself, but I've noticed that I sometimes needed to refresh the WbService in Administrator or restart CF to get it to work. Try that if you feel your code is correct. Ade -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: 30 October 2002 05:08 To: CF-Talk Subject: cfc error help hello list... im having web service issuesplease help if you can thanks! Error Occurred While Processing Request Could not perform web service invocation ScoreWizardCFCWebService because AxisFault faultCode: ns1:Server.userException faultString: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.runtime.UndefinedVariableException : Variable ROOTPATH is undefined.] faultActor: null faultDetail: stackTrace: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.runtime.UndefinedVariableException : Variable ROOTPATH is undefined.] at coldfusion.xml.rpc.CFComponentSkeleton.__createCFCInvocationException(Un known Source) at clients.cx_WebserviceApp.ScoreWizard.webService.ScoreWizard.ScoreWizardC FCWebService(ScoreWizard.java:16) at java.lang.reflect.Method.invoke(Native Method) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java :347) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.ja va:225) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:263 ) at coldfusion.xml.rpc.CFCProcessor.invokeImpl(Unknown Source) at coldfusion.xml.rpc.CFCProcessor.invoke(Unknown Source) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.j ava:71) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:154) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:121) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:288) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:543) at coldfusion.xml.rpc.CFCServlet.doAxisPost(Unknown Source) at coldfusion.filter.AxisFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.xml.rpc.CFCServlet.invoke(Unknown Source) at coldfusion.xml.rpc.CFCServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241 ) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527 ) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: 198) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j ava:348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java :451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav a:294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) null The Error Occurred in D:\www\clients\cx_WebServiceApp\ScoreWizard\webService\invoke.cfm: line 23 21 : !-- We close the cfinvoke tag.-- 22 : 23 : /cfinvoke is the error i am getting when attempting to invoke my webservice cfinvoke method=ScoreWizardCFCWebService webservice=http://localhost/clients/cx_WebserviceApp/ScoreWizard/webSer vice/ScoreWizard.cfc?wsdl returnVariable=SWCFCXML !-- We will define what argument needs to be invoked from the Web service. In this case it is called cfcName, which is the field name of the search field. This is the argument name that is being returned from the Web service as we will see in the next step.-- cfinvokeargument name=username value=tweeg/ cfinvokeargument name=password value=webmaster1 cfinvokeargument name=cracode value=/ cfinvokeargument name=reportid value=645724/ cfinvokeargument name=experianData value=EQUIFAX![CDATA[FULL801ZB00982008FI02 1071519980921200209292002SPROWIS JAYME L 15172365410221979 001010100020001002809000 00 this has been cut so as not to show too much on here... here is the cfc code... cfcomponent displayName=ScoreWizardCFC hint=Generate a ScoreWizard XML Report cffunction name=ScoreWizardCFCWebService access=remote output=0 returntype=struct cfargument name=username type=string required=true/ cfargument name=password type=string required=true/ cfargument name=cracode
Converting HTML to images (JPG/GIF)
Anybody done this? Is there a sexy tag out there that lets me do this? Adam ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
MySQL for Windows and CF
Hi, I was using Acess but have now installed mySQL for Windows. I'm a little confused on how to create a database. With Access its a snap but there are no tools for me to create the databases? I need help! --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: MySQL for Windows and CF
-Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 12:28 To: CF-Talk Subject: MySQL for Windows and CF Hi, I was using Acess but have now installed mySQL for Windows. I'm a little confused on how to create a database. With Access its a snap but there are no tools for me to create the databases? I need help! --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: MySQL for Windows and CF
mysql.com has tons of tools out there... dbtools is what I use and its freeware.. great tool. http://www.dbtools.com.br/ - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 7:27 AM Subject: MySQL for Windows and CF Hi, I was using Acess but have now installed mySQL for Windows. I'm a little confused on how to create a database. With Access its a snap but there are no tools for me to create the databases? I need help! --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: MySQL for Windows and CF
Cool! THanks On Wed, 30 Oct 2002 07:44:05 -0500, SMR wrote: mysql.com has tons of tools out there... dbtools is what I use and its freeware.. great tool. http://www.dbtools.com.br/ - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 7:27 AM Subject: MySQL for Windows and CF Hi, I was using Acess but have now installed mySQL for Windows. I'm a little confused on how to create a database. With Access its a snap but there are no tools for me to create the databases? I need help! --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Run code once and only once at inital login...WTF!
I have this line in my application.cfm file. cfparam name=session.InitialCodeRun default=FALSE Then in my index.cfm (which can get reloaded multiple times during a session) reads from a database and does some stuff based on the session.initialCodeRun. Here is my code: cfif SESSION.InitialCodeRun IS 0 cfset SESSION.InitialCodeRun = 1 cfquery name=GetEnv datasource=profs dbtype=ODBC SELECT strField1 FROM table1 /cfquery cfif isDefined(GetEnv.strField1) IS Yes --- YES --- cfelse --- NO --- /cfif /cfif Even though strField1 in my database has *nothing* entered there the above code returns Yes upon initial login. Even if I enter in no in that field it still returns yes Whats going on? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Run code once and only once at inital login...WTF!
That's because while the field is *empty* it is still *defined* You want something like this: cfif isDefined(GetEnv.strField1) AND Len(Trim(GetEnv.strField1)) GT 0 Or, if it's supposed to be a particular value: cfif isDefined(GetEnv.strField1) AND GetEnv.strField1)) EQ aParticularValue -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Wednesday, October 30, 2002 8:23 AM To: CF-Talk Subject: Run code once and only once at inital login...WTF! I have this line in my application.cfm file. cfparam name=session.InitialCodeRun default=FALSE Then in my index.cfm (which can get reloaded multiple times during a session) reads from a database and does some stuff based on the session.initialCodeRun. Here is my code: cfif SESSION.InitialCodeRun IS 0 cfset SESSION.InitialCodeRun = 1 cfquery name=GetEnv datasource=profs dbtype=ODBC SELECT strField1 FROM table1 /cfquery cfif isDefined(GetEnv.strField1) IS Yes --- YES --- cfelse --- NO --- /cfif /cfif Even though strField1 in my database has *nothing* entered there the above code returns Yes upon initial login. Even if I enter in no in that field it still returns yes Whats going on? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Run code once and only once at inital login...WTF!
a few things : why are you setting it to be FALSE the checking if its 0? pick a boolean method and stick to it :-) You do not need to check the value of a boolean like this cfif X = TRUE but default, cfif X is the same and will always equate to True/False (I personally use 0s 1s) Also, are you running MX? if not, where are your cflocks? Neil -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 13:23 To: CF-Talk Subject: Run code once and only once at inital login...WTF! I have this line in my application.cfm file. cfparam name=session.InitialCodeRun default=FALSE Then in my index.cfm (which can get reloaded multiple times during a session) reads from a database and does some stuff based on the session.initialCodeRun. Here is my code: cfif SESSION.InitialCodeRun IS 0 cfset SESSION.InitialCodeRun = 1 cfquery name=GetEnv datasource=profs dbtype=ODBC SELECT strField1 FROM table1 /cfquery cfif isDefined(GetEnv.strField1) IS Yes --- YES --- cfelse --- NO --- /cfif /cfif Even though strField1 in my database has *nothing* entered there the above code returns Yes upon initial login. Even if I enter in no in that field it still returns yes Whats going on? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: Run code once and only once at inital login...WTF!
On Wed, 30 Oct 2002 13:26:32 -, Robertson-Ravo, Neil (REC) wrote: a few things : why are you setting it to be FALSE the checking if its 0? pick a boolean method and stick to it :-) You do not need to check the value of a boolean like this cfif X = TRUE but default, cfif X is the same and will always equate to True/False (I personally use 0s 1s) OK. Also, are you running MX? Nope. if not, where are your cflocks? Oh no...should I be putting cflocks around *ALL* the cfquery(s) I have in my app? Neil -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 13:23 To: CF-Talk Subject: Run code once and only once at inital login...WTF! I have this line in my application.cfm file. cfparam name=session.InitialCodeRun default=FALSE Then in my index.cfm (which can get reloaded multiple times during a session) reads from a database and does some stuff based on the session.initialCodeRun. Here is my code: cfif SESSION.InitialCodeRun IS 0 cfset SESSION.InitialCodeRun = 1 cfquery name=GetEnv datasource=profs dbtype=ODBC SELECT strField1 FROM table1 /cfquery cfif isDefined(GetEnv.strField1) IS Yes --- YES --- cfelse --- NO --- /cfif /cfif Even though strField1 in my database has *nothing* entered there the above code returns Yes upon initial login. Even if I enter in no in that field it still returns yes Whats going on? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Run code once and only once at inital login...WTF!
Oh no...should I be putting cflocks around *ALL* the cfquery(s) I have in my app? No, only if you're reading/writing to/from SESSION/APPLICATION/SERVER variables. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Run code once and only once at inital login...WTF!
Thanks alot. That did the trick. I appreciate all the help guys! On Wed, 30 Oct 2002 08:26:44 -0500, Everett, Al wrote: That's because while the field is *empty* it is still *defined* You want something like this: cfif isDefined(GetEnv.strField1) AND Len(Trim(GetEnv.strField1)) GT 0 Or, if it's supposed to be a particular value: cfif isDefined(GetEnv.strField1) AND GetEnv.strField1)) EQ aParticularValue -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Wednesday, October 30, 2002 8:23 AM To: CF-Talk Subject: Run code once and only once at inital login...WTF! I have this line in my application.cfm file. cfparam name=session.InitialCodeRun default=FALSE Then in my index.cfm (which can get reloaded multiple times during a session) reads from a database and does some stuff based on the session.initialCodeRun. Here is my code: cfif SESSION.InitialCodeRun IS 0 cfset SESSION.InitialCodeRun = 1 cfquery name=GetEnv datasource=profs dbtype=ODBC SELECT strField1 FROM table1 /cfquery cfif isDefined(GetEnv.strField1) IS Yes --- YES --- cfelse --- NO --- /cfif /cfif Even though strField1 in my database has *nothing* entered there the above code returns Yes upon initial login. Even if I enter in no in that field it still returns yes Whats going on? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Run code once and only once at inital login...WTF!
only around shared scope variables such as session, application and server -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 13:32 To: CF-Talk Subject: RE: Run code once and only once at inital login...WTF! On Wed, 30 Oct 2002 13:26:32 -, Robertson-Ravo, Neil (REC) wrote: a few things : why are you setting it to be FALSE the checking if its 0? pick a boolean method and stick to it :-) You do not need to check the value of a boolean like this cfif X = TRUE but default, cfif X is the same and will always equate to True/False (I personally use 0s 1s) OK. Also, are you running MX? Nope. if not, where are your cflocks? Oh no...should I be putting cflocks around *ALL* the cfquery(s) I have in my app? Neil -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 13:23 To: CF-Talk Subject: Run code once and only once at inital login...WTF! I have this line in my application.cfm file. cfparam name=session.InitialCodeRun default=FALSE Then in my index.cfm (which can get reloaded multiple times during a session) reads from a database and does some stuff based on the session.initialCodeRun. Here is my code: cfif SESSION.InitialCodeRun IS 0 cfset SESSION.InitialCodeRun = 1 cfquery name=GetEnv datasource=profs dbtype=ODBC SELECT strField1 FROM table1 /cfquery cfif isDefined(GetEnv.strField1) IS Yes --- YES --- cfelse --- NO --- /cfif /cfif Even though strField1 in my database has *nothing* entered there the above code returns Yes upon initial login. Even if I enter in no in that field it still returns yes Whats going on? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Run code once and only once at inital login...WTF!
FlashGuy wrote: On Wed, 30 Oct 2002 13:26:32 -, Robertson-Ravo, Neil (REC) wrote: a few things : why are you setting it to be FALSE the checking if its 0? pick a boolean method and stick to it :-) You do not need to check the value of a boolean like this cfif X = TRUE but default, cfif X is the same and will always equate to True/False (I personally use 0s 1s) OK. Also, are you running MX? Nope. if not, where are your cflocks? Oh no...should I be putting cflocks around *ALL* the cfquery(s) I have in my app? No around all things that alter or readfrom the session scope ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Run code once and only once at inital login...WTF!
You need cflocks around your session vars... -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Wednesday, October 30, 2002 7:32 AM To: CF-Talk Subject: RE: Run code once and only once at inital login...WTF! On Wed, 30 Oct 2002 13:26:32 -, Robertson-Ravo, Neil (REC) wrote: a few things : why are you setting it to be FALSE the checking if its 0? pick a boolean method and stick to it :-) You do not need to check the value of a boolean like this cfif X = TRUE but default, cfif X is the same and will always equate to True/False (I personally use 0s 1s) OK. Also, are you running MX? Nope. if not, where are your cflocks? Oh no...should I be putting cflocks around *ALL* the cfquery(s) I have in my app? Neil -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 13:23 To: CF-Talk Subject: Run code once and only once at inital login...WTF! I have this line in my application.cfm file. cfparam name=session.InitialCodeRun default=FALSE Then in my index.cfm (which can get reloaded multiple times during a session) reads from a database and does some stuff based on the session.initialCodeRun. Here is my code: cfif SESSION.InitialCodeRun IS 0 cfset SESSION.InitialCodeRun = 1 cfquery name=GetEnv datasource=profs dbtype=ODBC SELECT strField1 FROM table1 /cfquery cfif isDefined(GetEnv.strField1) IS Yes --- YES --- cfelse --- NO --- /cfif /cfif Even though strField1 in my database has *nothing* entered there the above code returns Yes upon initial login. Even if I enter in no in that field it still returns yes Whats going on? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: MySQL for Windows and CF
I was using Acess but have now installed mySQL for Windows. I'm a little confused on how to create a database. With Access its a snap but there are no tools for me to create the databases? How about: http://www.mysql.com/doc/en/Connecting-disconnecting.html http://www.mysql.com/doc/en/Creating_database.html Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: MySQL for Windows and CF
You may want to try phpmyadmin http://www.phpwizard.net/projects/phpMyAdmin/ for a web based tool or you can download mysql front at http://mysqlfront.venturemedia.de/index.php?s=9503bf12672368f1fd43045383a767 13act=STf=2t=328. Also there are tools listed at www.mysql.org. Look in the downloads section. Luis -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: Wednesday, October 30, 2002 6:28 AM To: CF-Talk Subject: MySQL for Windows and CF Hi, I was using Acess but have now installed mySQL for Windows. I'm a little confused on how to create a database. With Access its a snap but there are no tools for me to create the databases? I need help! --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
problems with cfgraph
Hi list, I have problems with cfgraph. Nothing gets viewed. The page runs forever. On a development engine, everything works fine. I have Win2000,IIS5,CF5 and URLScan installed. Ideas what to do ? Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
capturing a query
Hi List. When you have the debugging on, you can see that it shows the sql generated also. You may have #variableName# in the cfquery template, but finally when all the variables get resolved, you have a query that is sent to the database. That query can be seen when the debugging is on on the webpage. is there a way to capture that final query? i tried #cgi.QueryName# , but did not work. Any ideas? thanks list __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: cfc error help
This is necessary when using the CFC as a web service. In general, I tend to do my dev work using the CFC _just_ as a CFC until I'm(pretty) sure it's ready. -Raymond - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 5:38 AM Subject: RE: cfc error help I've only starting writing cfcs myself, but I've noticed that I sometimes needed to refresh the WbService in Administrator or restart CF to get it to work. Try that if you feel your code is correct. Ade -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: 30 October 2002 05:08 To: CF-Talk Subject: cfc error help hello list... im having web service issuesplease help if you can thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: capturing a query
I've created the query as a variable and use the variable inside the cfquery: cfset sql = Select * from sometable where foo = '#form.bar#' Generated sql: #sql# cfquery name=foo datasource=bar #PreserveSingleQuotes(sql)# /cfquery HTH, Tim P. - Original Message - From: bajaria aslam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 9:01 AM Subject: capturing a query Hi List. When you have the debugging on, you can see that it shows the sql generated also. You may have #variableName# in the cfquery template, but finally when all the variables get resolved, you have a query that is sent to the database. That query can be seen when the debugging is on on the webpage. is there a way to capture that final query? i tried #cgi.QueryName# , but did not work. Any ideas? thanks list __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cfc error help
ray... can you elaborate on this CFC _just_ as a CFC until I'm(pretty) sure it's ready. do you mean, run it as I would a cfm page? test the code/flow/logic? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Raymond Camden [mailto:jedimaster;macromedia.com] Sent: Wednesday, October 30, 2002 9:12 AM To: CF-Talk Subject: Re: cfc error help This is necessary when using the CFC as a web service. In general, I tend to do my dev work using the CFC _just_ as a CFC until I'm(pretty) sure it's ready. -Raymond - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 5:38 AM Subject: RE: cfc error help I've only starting writing cfcs myself, but I've noticed that I sometimes needed to refresh the WbService in Administrator or restart CF to get it to work. Try that if you feel your code is correct. Ade -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: 30 October 2002 05:08 To: CF-Talk Subject: cfc error help hello list... im having web service issuesplease help if you can thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: MX Installation: Client Variables Not Changing (Part 2!)
Well if you're using CFMX, and you're on one server, why not change it to session variables. You don't need any locking now, please correct me if I am wrong. So you could just do a massive search and replace on your code. I have seen far too many people have issues with client variables. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Anthony Wong [mailto:anthony;intracomm.com] Sent: Wednesday, October 30, 2002 2:27 AM To: CF-Talk Subject: RE: MX Installation: Client Variables Not Changing (Part 2!) Cool Site Ben !! I'm a big fan of Gundam .. just love those toys .. Anthony -Original Message- From: Ben Koshy [mailto:benlist;w3media.net] Sent: Saturday, October 19, 2002 5:25 AM To: CF-Talk Subject: RE: MX Installation: Client Variables Not Changing (Part 2!) Thanks Dave, That resolved that issue! Now one last bug is holding me up again: Site: http://www.gundam.com Uses extensive use of client variables. However, after a client variable is set, I can't seem to update it. This is most evident when a user logs in and is unable to log out. My logout file is simply this: CFSET client.LoggedIn=0 CFSET client.MemberID=-1 CFSET client.MemberName= I wrote a litte test program: http://www.gundam.com/test.cfm which uses a new Application Name and simply sets a client variable and then attempts to change its value in the same page: Value of Client Variable is 1 Setting Client Variable to 2. Value of Client Variable is 1 My client variables are set to a database table which I created Client Tables using CFMX, and it has full permissions to the database. Any ideas? -- Ben. -Original Message- From: Dave Watts [mailto:dwatts;figleaf.com] Sent: Friday, October 18, 2002 12:37 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: MX Installation: Wrong site being loaded occasionally I have a site at: http://www.crackedpipe.com Which is on the same site as: http://www.gundam.com Gundam.Com, which was the first site on this newly installed CFMX test box, works fine. Crackedpipe.Com was installed afterwards, and it appears to work most of the time, but on every now and then (quite often!) when I click on a link on the left menu. It'll pull up the HOME page from Gundam.Com which happens to have the same name index.cfm. I'm at a loss here as to why this is happening. I can't reproduce it consistently other than just keep trying it and it'll happen eventually. If you keep hitting reload, it eventually goes back to the crackedpipe homepage. Did you edit the cacheRealPath value in \CFusionMX\runtime\servers\default\SERVER-INF\jrun.xml? http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenote s_mx html#installing Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
CF4.5/5 cfqueryparam differences
I'm working with a mixture CF 4.5.1SP2 and CF5 servers pointint to an Oracle 8i database. I'm currently in the process of migrating completely to CF5, but in the meantime I need to ensure that all my code is the same and works the same in both environments. I'm finding an issue with how 4.5 and 5 treat DATE columns using CFQUERYPARAM. I have the following (snippet) in one of my queries: AND AUTHORIZATION_EMAIL_NEXT_DATE cfqueryparam cfsqltype=CF_SQL_DATE value=#CreateODBCDate(10/31/2002)# In CF4.5 this throws an error: CFQUERYPARAM data conversion error This same error also occurs if I change the CFSQLTYPE to CF_SQL_TIMESTAMP or remove the CreateODBCDate(). However, in CF5, it doesn't throw an error and everything seems fine. In CF4.5 I'm using a third-party (Data Direct) ODBC driver, while in CF5 I'm using the Oracle driver that came with it. Does anybody have any insight? Am I going to have to forget the CFQUERYPARAM in this case and just do AUTHORIZATION_EMAIL_NEXT_DATE #CreateODBCDate(10/31/2002)# , at least until I get everyone up to CF5? -- Al Everett Allied Office Products www.askallied.com mailto:aeverett;askallied.com v: 973-594-3209 f: 973-594-3626 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: cfc error help
When you do something like foo = createObject(component,foo) or use cfinvoke component=, you are using the CFC as a CFC. If you were to use cfinvoke webservice = or cfhttp, you would be calling the CFC as a web service. In that case, the cached version is used. Another option would be to simply keep a browser open to the web services page in the admin and click the refresh button on the WS everytime you edit. ;) -Raymond, live from DevCon - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 9:14 AM Subject: RE: cfc error help ray... can you elaborate on this CFC _just_ as a CFC until I'm(pretty) sure it's ready. do you mean, run it as I would a cfm page? test the code/flow/logic? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Raymond Camden [mailto:jedimaster;macromedia.com] Sent: Wednesday, October 30, 2002 9:12 AM To: CF-Talk Subject: Re: cfc error help This is necessary when using the CFC as a web service. In general, I tend to do my dev work using the CFC _just_ as a CFC until I'm(pretty) sure it's ready. -Raymond - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 5:38 AM Subject: RE: cfc error help I've only starting writing cfcs myself, but I've noticed that I sometimes needed to refresh the WbService in Administrator or restart CF to get it to work. Try that if you feel your code is correct. Ade -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: 30 October 2002 05:08 To: CF-Talk Subject: cfc error help hello list... im having web service issuesplease help if you can thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cfc error help
ok cool...ill try that. ..tony Live from rainy maryland :) have a good one ray! Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Raymond Camden [mailto:jedimaster;macromedia.com] Sent: Wednesday, October 30, 2002 9:35 AM To: CF-Talk Subject: Re: cfc error help When you do something like foo = createObject(component,foo) or use cfinvoke component=, you are using the CFC as a CFC. If you were to use cfinvoke webservice = or cfhttp, you would be calling the CFC as a web service. In that case, the cached version is used. Another option would be to simply keep a browser open to the web services page in the admin and click the refresh button on the WS everytime you edit. ;) -Raymond, live from DevCon - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 9:14 AM Subject: RE: cfc error help ray... can you elaborate on this CFC _just_ as a CFC until I'm(pretty) sure it's ready. do you mean, run it as I would a cfm page? test the code/flow/logic? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Raymond Camden [mailto:jedimaster;macromedia.com] Sent: Wednesday, October 30, 2002 9:12 AM To: CF-Talk Subject: Re: cfc error help This is necessary when using the CFC as a web service. In general, I tend to do my dev work using the CFC _just_ as a CFC until I'm(pretty) sure it's ready. -Raymond - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 5:38 AM Subject: RE: cfc error help I've only starting writing cfcs myself, but I've noticed that I sometimes needed to refresh the WbService in Administrator or restart CF to get it to work. Try that if you feel your code is correct. Ade -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: 30 October 2002 05:08 To: CF-Talk Subject: cfc error help hello list... im having web service issuesplease help if you can thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CF4.5/5 cfqueryparam differences
Try using CF_SQL_TIMESTAMP as the type for dates... That's what I use and have no issues... HTH -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Wednesday, October 30, 2002 14:30 To: CF-Talk Subject: CF4.5/5 cfqueryparam differences I'm working with a mixture CF 4.5.1SP2 and CF5 servers pointint to an Oracle 8i database. I'm currently in the process of migrating completely to CF5, but in the meantime I need to ensure that all my code is the same and works the same in both environments. I'm finding an issue with how 4.5 and 5 treat DATE columns using CFQUERYPARAM. I have the following (snippet) in one of my queries: AND AUTHORIZATION_EMAIL_NEXT_DATE cfqueryparam cfsqltype=CF_SQL_DATE value=#CreateODBCDate(10/31/2002)# In CF4.5 this throws an error: CFQUERYPARAM data conversion error This same error also occurs if I change the CFSQLTYPE to CF_SQL_TIMESTAMP or remove the CreateODBCDate(). However, in CF5, it doesn't throw an error and everything seems fine. In CF4.5 I'm using a third-party (Data Direct) ODBC driver, while in CF5 I'm using the Oracle driver that came with it. Does anybody have any insight? Am I going to have to forget the CFQUERYPARAM in this case and just do AUTHORIZATION_EMAIL_NEXT_DATE #CreateODBCDate(10/31/2002)# , at least until I get everyone up to CF5? -- Al Everett Allied Office Products www.askallied.com mailto:aeverett;askallied.com v: 973-594-3209 f: 973-594-3626 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CF4.5/5 cfqueryparam differences
Quoting Everett, Al [EMAIL PROTECTED]: I'm finding an issue with how 4.5 and 5 treat DATE columns using CFQUERYPARAM. I have the following (snippet) in one of my queries: AND AUTHORIZATION_EMAIL_NEXT_DATE cfqueryparam cfsqltype=CF_SQL_DATE value=#CreateODBCDate(10/31/2002)# In CF4.5 this throws an error: CFQUERYPARAM data conversion error In CF 4.5 I don't have a problem if I use value=-mm-dd But it may be a driver issue, YMMV. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: cfc error help
I sometimes found that refreshing the WebService didn't always work, maybe it was my code, I had to restart to get the thing to work. Ade -Original Message- From: Raymond Camden [mailto:jedimaster;macromedia.com] Sent: 30 October 2002 14:35 To: CF-Talk Subject: Re: cfc error help When you do something like foo = createObject(component,foo) or use cfinvoke component=, you are using the CFC as a CFC. If you were to use cfinvoke webservice = or cfhttp, you would be calling the CFC as a web service. In that case, the cached version is used. Another option would be to simply keep a browser open to the web services page in the admin and click the refresh button on the WS everytime you edit. ;) -Raymond, live from DevCon - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 9:14 AM Subject: RE: cfc error help ray... can you elaborate on this CFC _just_ as a CFC until I'm(pretty) sure it's ready. do you mean, run it as I would a cfm page? test the code/flow/logic? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Raymond Camden [mailto:jedimaster;macromedia.com] Sent: Wednesday, October 30, 2002 9:12 AM To: CF-Talk Subject: Re: cfc error help This is necessary when using the CFC as a web service. In general, I tend to do my dev work using the CFC _just_ as a CFC until I'm(pretty) sure it's ready. -Raymond - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 5:38 AM Subject: RE: cfc error help I've only starting writing cfcs myself, but I've noticed that I sometimes needed to refresh the WbService in Administrator or restart CF to get it to work. Try that if you feel your code is correct. Ade -Original Message- From: Tony Weeg [mailto:tony;navtrak.net] Sent: 30 October 2002 05:08 To: CF-Talk Subject: cfc error help hello list... im having web service issuesplease help if you can thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CF4.5/5 cfqueryparam differences
I tried that. (Re-read my message.) -Original Message- From: Mike Townend [mailto:mike;cfnews.co.uk] Sent: Wednesday, October 30, 2002 9:34 AM To: CF-Talk Subject: RE: CF4.5/5 cfqueryparam differences Try using CF_SQL_TIMESTAMP as the type for dates... That's what I use and have no issues... HTH -Original Message- From: Everett, Al [mailto:AEverett;askallied.com] Sent: Wednesday, October 30, 2002 14:30 To: CF-Talk Subject: CF4.5/5 cfqueryparam differences I'm working with a mixture CF 4.5.1SP2 and CF5 servers pointint to an Oracle 8i database. I'm currently in the process of migrating completely to CF5, but in the meantime I need to ensure that all my code is the same and works the same in both environments. I'm finding an issue with how 4.5 and 5 treat DATE columns using CFQUERYPARAM. I have the following (snippet) in one of my queries: AND AUTHORIZATION_EMAIL_NEXT_DATE cfqueryparam cfsqltype=CF_SQL_DATE value=#CreateODBCDate(10/31/2002)# In CF4.5 this throws an error: CFQUERYPARAM data conversion error This same error also occurs if I change the CFSQLTYPE to CF_SQL_TIMESTAMP or remove the CreateODBCDate(). However, in CF5, it doesn't throw an error and everything seems fine. In CF4.5 I'm using a third-party (Data Direct) ODBC driver, while in CF5 I'm using the Oracle driver that came with it. Does anybody have any insight? Am I going to have to forget the CFQUERYPARAM in this case and just do AUTHORIZATION_EMAIL_NEXT_DATE #CreateODBCDate(10/31/2002)# , at least until I get everyone up to CF5? -- Al Everett Allied Office Products www.askallied.com mailto:aeverett;askallied.com v: 973-594-3209 f: 973-594-3626 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CF4.5/5 cfqueryparam differences
In CF 4.5 I don't have a problem if I use value=-mm-dd But it may be a driver issue, YMMV. I suspect you're right, but I'll try that format just in case. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: problems with cfgraph
There's an issue with CFGRAPH in 5.0 - if you pass values with 0 the java something or other will start looping and spin out of control, sucking up memory and processor until the box blows up. There's a simple hot fix at macromedia.. -Original Message- From: Uwe Degenhardt [mailto:cf-talk;sdsolutions.de] Sent: Wednesday, October 30, 2002 8:58 AM To: CF-Talk Subject: problems with cfgraph Hi list, I have problems with cfgraph. Nothing gets viewed. The page runs forever. On a development engine, everything works fine. I have Win2000,IIS5,CF5 and URLScan installed. Ideas what to do ? Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: problems with cfgraph
There's an issue with CFGRAPH in 5.0 - if you pass values with 0 the java something or other will start looping and spin out of control, sucking up memory and processor until the box blows up. There's a simple hot fix at macromedia.. -Original Message- From: Uwe Degenhardt [mailto:cf-talk;sdsolutions.de] Sent: Wednesday, October 30, 2002 8:58 AM To: CF-Talk Subject: problems with cfgraph Hi list, I have problems with cfgraph. Nothing gets viewed. The page runs forever. On a development engine, everything works fine. I have Win2000,IIS5,CF5 and URLScan installed. Ideas what to do ? Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CF4.5/5 cfqueryparam differences
Well I'll be damned. It looks like that worked. Thanks. Here's the magic code: cfset checkdate = DateFormat(DateAdd(d,1,Now()),'-mm-dd') cfquery ... .. WHERE AUTHORIZATION_EMAIL_NEXT_DATE cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#Variables.checkdate# -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: Wednesday, October 30, 2002 9:36 AM To: CF-Talk Subject: Re: CF4.5/5 cfqueryparam differences Quoting Everett, Al [EMAIL PROTECTED]: I'm finding an issue with how 4.5 and 5 treat DATE columns using CFQUERYPARAM. I have the following (snippet) in one of my queries: AND AUTHORIZATION_EMAIL_NEXT_DATE cfqueryparam cfsqltype=CF_SQL_DATE value=#CreateODBCDate(10/31/2002)# In CF4.5 this throws an error: CFQUERYPARAM data conversion error In CF 4.5 I don't have a problem if I use value=-mm-dd But it may be a driver issue, YMMV. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFMX possible bug, anyone care to verify
I was not able to reproduce this bug. (Using CFMX+Updater.) -Ray - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 7:26 PM Subject: CFMX possible bug, anyone care to verify I might be missing something here, but I seem to be able to generate a null error when performing a regex operation on a sting longer than 12980 chars. Is this a known limitation? Maybe some one could try this could on there CFMX dev box and tell me if they get the same error. Here is some sample code which will generate a string of 12980 characters long and then try a regular expression operation on the string. This generates an error on my CFMX (updater installed) server which is running Win2k / sp3 with IIS5.0. !--- changing the loop to value to anything over 12980 throws an error (try it at 12980 and 12981)--- cfset str= cfloop from=1 to=12981 index=i cfset str=stri /cfloop BR cfoutputThs string is #len(str)# chars long/cfoutput !--- this is the expression which causes the error --- cfset z=REfindnocase((\[)([[:print:][:space:]])*(\]),str,1) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT: Running CF, mySQL
Hi, I'm having a little trouble. I've installed mySQL. I've started the service via WinMySQL admin. I was able to create my databases. I also installed MySQL-Front and DBTools. The problem is when I startup any of the tools and try to create a connection I get a MySQL Error - COnnection failed. 1045 - Access denied for user administratorsevenofnine/ (Using password: YES). What am I doing wrong. The username/password are correct. The mySQL service is running. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFMX possible bug, anyone care to verify
Me neither, also using CFMX+ Updater. Christine -Original Message- From: Raymond Camden [mailto:jedimaster;macromedia.com] Sent: Wednesday, October 30, 2002 9:51 AM To: CF-Talk Subject: Re: CFMX possible bug, anyone care to verify I was not able to reproduce this bug. (Using CFMX+Updater.) -Ray - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 7:26 PM Subject: CFMX possible bug, anyone care to verify I might be missing something here, but I seem to be able to generate a null error when performing a regex operation on a sting longer than 12980 chars. Is this a known limitation? Maybe some one could try this could on there CFMX dev box and tell me if they get the same error. Here is some sample code which will generate a string of 12980 characters long and then try a regular expression operation on the string. This generates an error on my CFMX (updater installed) server which is running Win2k / sp3 with IIS5.0. !--- changing the loop to value to anything over 12980 throws an error (try it at 12980 and 12981)--- cfset str= cfloop from=1 to=12981 index=i cfset str=stri /cfloop BR cfoutputThs string is #len(str)# chars long/cfoutput !--- this is the expression which causes the error --- cfset z=REfindnocase((\[)([[:print:][:space:]])*(\]),str,1) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Running CF, mySQL
try and logon with the 'root' username password (usually blank) -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 14:48 To: CF-Talk Subject: OT: Running CF, mySQL Hi, I'm having a little trouble. I've installed mySQL. I've started the service via WinMySQL admin. I was able to create my databases. I also installed MySQL-Front and DBTools. The problem is when I startup any of the tools and try to create a connection I get a MySQL Error - COnnection failed. 1045 - Access denied for user administratorsevenofnine/ (Using password: YES). What am I doing wrong. The username/password are correct. The mySQL service is running. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: High traffic CF website/application
Hi all, We have been running on CF since 1998 and quite happy with the performance (with caching on!!). For example, yesterday we had 1.3 million hits and 200,000 page views with average download time of 3.4 seconds. (More than 60% of the pages served were dynamic) Regards Govind Bhat Technology Manager www.50plus.com -Original Message- From: [EMAIL PROTECTED] [mailto:CF-Talk-list;houseoffusion.com] Sent: October 30, 2002 6:08 AM To: [EMAIL PROTECTED] Subject: CF-Talk-list V1 #57 CF-Talk-list Wed, 30 Oct 2002 Volume 1 : Number 57 In this issue: Re: Shorter urls? RE: Shorter urls? RE: Yahoo moving to PHP RE: OT:Yahoo moving to PHP Re: Yahoo moving to PHP cfc question RE: cfc question RE: cfc question Re: Shorter urls? cfc error help cfc question RE: cfc question Re: columns of user-editable text: Link to Excel sheet? RE: MX Installation: Client Variables Not Changing (Part 2!) OT:Looking for a good SQL mailing list RE: Looking for a good SQL mailing list Re: OT:Looking for a good SQL mailing list RE: OT:Yahoo moving to PHP Re: Yahoo moving to PHP RE: cfc error help Converting HTML to images (JPG/GIF) -- Date: Tue, 29 Oct 2002 22:08:26 -0500 From: Christian Cantrell [EMAIL PROTECTED] Subject: Re: Shorter urls? Message-ID: [EMAIL PROTECTED] Here's an interesting solution. It's not perfect (just threw the code together), but it works. It has the additional benefit of adding a level of security to your application because it hashes your query string in a way that cannot be reversed (essentially obfuscates it in a non-reversible manner). It also assumes that once you have created a shorter query string, you will eventually want to recover the original query string, probably in the page processing the request that contains the query string. Start by including these two functions: cfscript function getShortString(str) { var key = ; if (false is isDefined(application._strMap)) { application._strMap = structNew(); } key = hash(str); application._strMap[key] = str; return key; } function getLongString(key) { if (false is isDefined(application._strMap)) { return ; } if (false is structKeyExists(application._strMap, key)) { return ; } return application._strMap[key]; } /cfscript Then create your querystrings like this: cfset qs = a=bb=cc=a / a href=someProcessingPage.cfm?q=cfoutput#getShortString(qs)#/cfoutputcl ick here/a In the processing page, retrieve the original querystring like this: cfset qs = #getLongString(url.q)# / The full querystring is cfoutput#qs#/cfoutput. Of course, you could do something a little more clever like creating a function that returns a struct or parses the querystring and puts the values in the URL scope so that you could retrieve them just as though they were literally passed in the URL as opposed to actually getting back a query string, but you get the idea. Your query string has to be over 32 characters before this technique starts to pay for itself in terms of length since the hash() function returns a 32 byte string. As I mentioned earlier, it has the added benefit of completely obscruing the data you pass in your query string, too, since the MD5 hash is not reversable. If you decide to implement something like this, consider variable locking. Hope this helps. Cantrell Ian Lurie wrote: Hi all, I've searched the devcenter, google, etc. but can't seem to find any discussion of how to generate shorter URL strings. I want to take: http://www.site.com?action=blahbrand=1name=blahblah; And convert it to http://www.site.com/asdfwer234123 I've seen it done but just can't remember where. Can someone send me a url? Thanks in advance, Ian -- Christian Cantrell [EMAIL PROTECTED] (571) 220-8659 (mobile) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm -- Date: Tue, 29 Oct 2002 22:16:26 -0500 From: Matt Liotta [EMAIL PROTECTED] Subject: RE: Shorter urls? Message-ID: 000101c27fc2$bb740100$c801a8c0@FREEWILL This technique seems like a waste of processing time when the underlying Java object already provides the same thing. From the documentation... hashCode public int hashCode() Returns the hash code value for this map. The hash code of
RE: Running CF, mySQL
That was it. I thought the username/password had to be the same as the username/password used for WinMySQL Admin. Thanks On Wed, 30 Oct 2002 14:52:16 -, Robertson-Ravo, Neil (REC) wrote: try and logon with the 'root' username password (usually blank) -Original Message- From: FlashGuy [mailto:flashmx;rogers.com] Sent: 30 October 2002 14:48 To: CF-Talk Subject: OT: Running CF, mySQL Hi, I'm having a little trouble. I've installed mySQL. I've started the service via WinMySQL admin. I was able to create my databases. I also installed MySQL-Front and DBTools. The problem is when I startup any of the tools and try to create a connection I get a MySQL Error - COnnection failed. 1045 - Access denied for user administratorsevenofnine/ (Using password: YES). What am I doing wrong. The username/password are correct. The mySQL service is running. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CF4.5/5 cfqueryparam differences
Everett, Al wrote: Well I'll be damned. It looks like that worked. Thanks. Here's the magic code: cfset checkdate = DateFormat(DateAdd(d,1,Now()),'-mm-dd') cfquery ... .. WHERE AUTHORIZATION_EMAIL_NEXT_DATE cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#Variables.checkdate# Well, considering that the SQL standard says that a date is formatted as 10 positions in the format -mm-dd I would not call it is magic. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT: Community Suite Schedule
For those watching on the webcam through HoF and Jochem (thanks again), here's what will be happening today: 10:15 Rey Muradaz Copyright Issues and Software 11:15 Charlie Arehart Getting into Dreamweaver MX for HomeSite/Studio Users 12:20 Final Book Auction 1:00 Michael Smith Client Communication Problems 1:30 Michael Dinowitz Regular Expression Patterns 3:00 Bruce Epstein from O'Reilly and Associates 3:10 John Harmon SQL extension to Dreamweaver 4:00 Room closes ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Where do CFC's go?
Thanks for describing your layout. It has been very helpful in providing me with ideas. How do (would) you outline the directory structure for multiple websites that are hosted on one system. For example: admin.domain.com app1.domain.com app2.domain.com app3.domain.com .. It appears that ColdFusion was design with the aspect of supporting only one website instead of many. This is evident in the ColdFusion Administrator, Server Mappings page. For example, I'm only allowed to provide one root Mapping for / and the mapping must be unique. I do understand why though. Anyone have any ideas how to work around this? Thanks, Troy Sean A Corfield wrote: On Friday, Oct 25, 2002, at 16:30 US/Pacific, Troy Simpson wrote: I'm using Dreamweaver MX to create some CFC's and trying to figure out how to layout the file system on the ColdFusionMX App server. (FYI: I'm new at this CFC stuff and Dreamweaver too.) Where am I suppose to copy the CFC's too? I've read various things. Some put them under the wwwroot. Others put them outside the wwwroot and create a mapping. If you want to invoke them as Web Services or via Flash Remoting, you need to make your CFCs web-accessible. Otherwise, you can put them wherever you want. Here's what my team does (partial credit to Mike Nimer for the seed of this): {cfmx}/ extensions/ components/ {appname}/ {file}.cfc customtags/ {appname}/ {file}.cfm includes/ {appname}/ {file}.cfm wwwroot/ {appname}/ {file}.cfm Where {cfmx} is the install directory, {appname} is an application name (e.g., store, membership) and {file} is any filename. Then we add these to the custom tag / components path in the CF Admin: {cfmx}/extensions/components/ {cfmx}/extensions/customtags/ And we add a mapping for the includes: /cfinclude {cfmx}/extensions/includes/ Typically, each application has an Application.cfm under wwwroot/{appname}/ which also cfinclude's /Application.cfm which contains our 'global' stuff. This is all part of our coding guidelines - but I can't remember whether I left this in the public domain version: http://www.corfield.org/coldfusion/codingStandards.htm I can't answer your RDS question I'm afraid! Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 fax: (415) 865-3113 -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
CFIF and CFSWITCH brain freeze
I'm having a brain freeze on the differences between how CFIF and CFSWITCH statements are handled. How I understand it: CFSWITCH evaluates all expressions independently (i.e. with no regard to other CFCASE values) while CFIF evaluates expressions serially (i.e. from first to last). Is this statement true? Here's the reason I'm asking. First off, I'm doing this logic inside of a CFSCRIPT block, not that it should make any difference. I have this script: cfscript IF (CGI.script_name CONTAINS /default.cfm) { ad.category = 1;} ELSE IF (CGI.script_name CONTAINS /directory/default.cfm) { ad.category = 2;} ELSE IF (CGI.script_name CONTAINS /directory/subdirectory/default.cfm) { ad.category = 3;} ELSE ad.category = 0; /cfscript In this example, If I am on /directory/default.cfm, 2 should be set as the ad.category value and not 1, correct? I just want to make sure that my assumptions are safe before I go too much further on this. Thanks, Pete ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: High traffic CF website/application
Govind, that's nice a testament to ColdFusion and significantly your use of it. You obviously are doing a great job developing and maintaining your apps. Nice performance response times. Mike Brunt - CTO Webapper Services LLC http://www.webapper.com Downey CA Office 562.243.6255 Making the NET Work -Original Message- From: Govind Bhat [mailto:G.Bhat;50plus.com] Sent: Wednesday, October 30, 2002 7:00 AM To: CF-Talk Subject: RE: High traffic CF website/application Hi all, We have been running on CF since 1998 and quite happy with the performance (with caching on!!). For example, yesterday we had 1.3 million hits and 200,000 page views with average download time of 3.4 seconds. (More than 60% of the pages served were dynamic) Regards Govind Bhat Technology Manager www.50plus.com -Original Message- From: [EMAIL PROTECTED] [mailto:CF-Talk-list;houseoffusion.com] Sent: October 30, 2002 6:08 AM To: [EMAIL PROTECTED] Subject: CF-Talk-list V1 #57 CF-Talk-list Wed, 30 Oct 2002 Volume 1 : Number 57 In this issue: Re: Shorter urls? RE: Shorter urls? RE: Yahoo moving to PHP RE: OT:Yahoo moving to PHP Re: Yahoo moving to PHP cfc question RE: cfc question RE: cfc question Re: Shorter urls? cfc error help cfc question RE: cfc question Re: columns of user-editable text: Link to Excel sheet? RE: MX Installation: Client Variables Not Changing (Part 2!) OT:Looking for a good SQL mailing list RE: Looking for a good SQL mailing list Re: OT:Looking for a good SQL mailing list RE: OT:Yahoo moving to PHP Re: Yahoo moving to PHP RE: cfc error help Converting HTML to images (JPG/GIF) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: CFIF and CFSWITCH brain freeze
Reverse the evaluation order. Since CGI.ScriptName DOES contain default.cfm it evaluates as TRUE and never looks at the other conditions. -Original Message- From: Pete Ruckelshaus [mailto:cflist;ruckelshaus.com] Sent: Wednesday, October 30, 2002 10:22 AM To: CF-Talk Subject: CFIF and CFSWITCH brain freeze I'm having a brain freeze on the differences between how CFIF and CFSWITCH statements are handled. How I understand it: CFSWITCH evaluates all expressions independently (i.e. with no regard to other CFCASE values) while CFIF evaluates expressions serially (i.e. from first to last). Is this statement true? Here's the reason I'm asking. First off, I'm doing this logic inside of a CFSCRIPT block, not that it should make any difference. I have this script: cfscript IF (CGI.script_name CONTAINS /default.cfm) { ad.category = 1;} ELSE IF (CGI.script_name CONTAINS /directory/default.cfm) { ad.category = 2;} ELSE IF (CGI.script_name CONTAINS /directory/subdirectory/default.cfm) { ad.category = 3;} ELSE ad.category = 0; /cfscript In this example, If I am on /directory/default.cfm, 2 should be set as the ad.category value and not 1, correct? I just want to make sure that my assumptions are safe before I go too much further on this. Thanks, Pete ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
(Multiple presence IMs) Re: About damn time
I'd say about time. I don't know anyone on AIM, but certainly a PITA to worry all the different IM transports. I currently use trillian http://www.ceruleanstudios.com/trillian/index.html but have been following jabber (search on Source Forge for jabber). promising. http://www.chote.net/projects.php?item=1 e From: William Wheatley [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Community [EMAIL PROTECTED] Subject: About damn time Date: Wed, 30 Oct 2002 09:59:23 -0500 AIM To talk to icq http://news.com.com/2100-1023-963699.html?tag=fd_ots Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFIF and CFSWITCH brain freeze
IIRC, yes, all of the case values in a cfswitch are evaluated independently. So, in this case, you'd run the switch case order the same way you listed your if order (which, as Jeff pointed out, is backwards). The last case to evaluate to true would be the one to set the final value of ad.category, so you want to list them from least specific to most specific. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Jeff Beer [mailto:jbeer;dbactive.com] : Sent: Wednesday, October 30, 2002 10:34 AM : To: CF-Talk : Subject: RE: CFIF and CFSWITCH brain freeze : : : Reverse the evaluation order. : : Since CGI.ScriptName DOES contain default.cfm it evaluates as TRUE and : never looks at the other conditions. : : -Original Message- : From: Pete Ruckelshaus [mailto:cflist;ruckelshaus.com] : Sent: Wednesday, October 30, 2002 10:22 AM : To: CF-Talk : Subject: CFIF and CFSWITCH brain freeze : : : I'm having a brain freeze on the differences between how CFIF and : CFSWITCH statements are handled. : : How I understand it: CFSWITCH evaluates all expressions independently : (i.e. with no regard to other CFCASE values) while CFIF evaluates : expressions serially (i.e. from first to last). Is this statement true? : Here's the reason I'm asking. : : First off, I'm doing this logic inside of a CFSCRIPT block, not that it : should make any difference. : : I have this script: : : cfscript : IF (CGI.script_name CONTAINS /default.cfm) { : ad.category = 1;} : ELSE IF (CGI.script_name CONTAINS /directory/default.cfm) { : ad.category = 2;} : ELSE IF (CGI.script_name CONTAINS : /directory/subdirectory/default.cfm) { : ad.category = 3;} : ELSE : ad.category = 0; : /cfscript : : In this example, If I am on /directory/default.cfm, 2 should be set as : the ad.category value and not 1, correct? I just want to make sure : that my assumptions are safe before I go too much further on this. : : Thanks, : : Pete : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re[2]: problems with cfgraph
Hello Jeff, Wednesday, October 30, 2002, 3:40:46 PM, you wrote: JB There's an issue with CFGRAPH in 5.0 - if you pass values with 0 the JB java something or other will start looping and spin out of control, JB sucking up memory and processor until the box blows up. JB There's a simple hot fix at macromedia.. JB -Original Message- JB From: Uwe Degenhardt [mailto:cf-talk;sdsolutions.de] JB Sent: Wednesday, October 30, 2002 8:58 AM JB To: CF-Talk JB Subject: problems with cfgraph JB Hi list, JB I have problems with cfgraph. JB Nothing gets viewed. The page runs forever. JB On a development engine, everything works fine. JB I have Win2000,IIS5,CF5 and URLScan installed. JB Ideas what to do ? JB Uwe JB ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CF4.5/5 cfqueryparam differences
Well, considering that the SQL standard says that a date is formatted as 10 positions in the format -mm-dd I would not call it is magic. Deep in my misty memory I was taught that when using CF and Oracle, dates needed to be formatted as DD-MMM-. Looking at it now, it's probably the third-party driver that allowed us to send dates in that format as strings and would automagically convert them to dates. With CF5 and the Oracle driver that came with it doesn't do that. At least, that's my theory du jour. I thought, however, that CFQUERYPARAM would take any date object in the value. Formatting shouldn't have anything to do with it. At least that's how it appears to work in CF5. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: High traffic CF website/application
Good Work Govid! I bet your not using CFMX :( Okay, that was a bit of a low blow. Please tell us more about your server specs and software versions. Brook At 07:31 AM 10/30/02 -0800, you wrote: Govind, that's nice a testament to ColdFusion and significantly your use of it. You obviously are doing a great job developing and maintaining your apps. Nice performance response times. Mike Brunt - CTO Webapper Services LLC http://www.webapper.com Downey CA Office 562.243.6255 Making the NET Work -Original Message- From: Govind Bhat [mailto:G.Bhat;50plus.com] Sent: Wednesday, October 30, 2002 7:00 AM To: CF-Talk Subject: RE: High traffic CF website/application Hi all, We have been running on CF since 1998 and quite happy with the performance (with caching on!!). For example, yesterday we had 1.3 million hits and 200,000 page views with average download time of 3.4 seconds. (More than 60% of the pages served were dynamic) Regards Govind Bhat Technology Manager www.50plus.com -Original Message- From: [EMAIL PROTECTED] [mailto:CF-Talk-list;houseoffusion.com] Sent: October 30, 2002 6:08 AM To: [EMAIL PROTECTED] Subject: CF-Talk-list V1 #57 CF-Talk-list Wed, 30 Oct 2002 Volume 1 : Number 57 In this issue: Re: Shorter urls? RE: Shorter urls? RE: Yahoo moving to PHP RE: OT:Yahoo moving to PHP Re: Yahoo moving to PHP cfc question RE: cfc question RE: cfc question Re: Shorter urls? cfc error help cfc question RE: cfc question Re: columns of user-editable text: Link to Excel sheet? RE: MX Installation: Client Variables Not Changing (Part 2!) OT:Looking for a good SQL mailing list RE: Looking for a good SQL mailing list Re: OT:Looking for a good SQL mailing list RE: OT:Yahoo moving to PHP Re: Yahoo moving to PHP RE: cfc error help Converting HTML to images (JPG/GIF) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: capturing a query
if you're using CFMX than you can get at this data by interrogating the Service Factory. This is undocumented, but fun to discover! If you're not using CFMX then you can't access the debugging information, unfortunately. -Original Message- From: bajaria aslam [mailto:aslambajaria;yahoo.com] Sent: 30 October 2002 14:01 To: CF-Talk Subject: capturing a query Hi List. When you have the debugging on, you can see that it shows the sql generated also. You may have #variableName# in the cfquery template, but finally when all the variables get resolved, you have a query that is sent to the database. That query can be seen when the debugging is on on the webpage. is there a way to capture that final query? i tried #cgi.QueryName# , but did not work. Any ideas? thanks list __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CFMX possible bug, anyone care to verify
Hi Brook, I tried your code and for 12981 got Ths string is 53799 chars long (No null pointer exception) for a hoot I bumped it up to 5 I got Ths string is 238894 chars long (No null pointer exception) It is a phat box though. W2k, jdk1.4.0_02, IIS5 -Original Message- From: Brook Davies [mailto:brook;maracasmedia.com] Sent: Tuesday, October 29, 2002 4:26 PM To: CF-Talk Subject: CFMX possible bug, anyone care to verify I might be missing something here, but I seem to be able to generate a null error when performing a regex operation on a sting longer than 12980 chars. Is this a known limitation? Maybe some one could try this could on there CFMX dev box and tell me if they get the same error. Here is some sample code which will generate a string of 12980 characters long and then try a regular expression operation on the string. This generates an error on my CFMX (updater installed) server which is running Win2k / sp3 with IIS5.0. !--- changing the loop to value to anything over 12980 throws an error (try it at 12980 and 12981)--- cfset str= cfloop from=1 to=12981 index=i cfset str=stri /cfloop BR cfoutputThs string is #len(str)# chars long/cfoutput !--- this is the expression which causes the error --- cfset z=REfindnocase((\[)([[:print:][:space:]])*(\]),str,1) Brook Davies ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Yahoo moving to PHP
cfscript if (blah) { }else{ switch () { 1: this; break; 2: that; break; } } /cfscript -Original Message- From: Nick McClure [mailto:cf-lists;king-nacho.com] Sent: Tuesday, October 29, 2002 8:21 PM To: CF-Talk Subject: Re: Yahoo moving to PHP cf, %, etc,\., what's the difference? Here is the difference, to me it seems cleaner. cfif blah cfswitch cfcase /cfcase cfcase /cfcase cfcase /cfcase /cfswitch cfelse /cfif or % if (blah) { }else{ switch () { 1: this; break; 2: that; break; } } % ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: problems with cfgraph
cfgraph used to barf if you passed in 0's (that's a zero) for values. They might have fixed that, but what you describe is what happened when 0's were passed in - you might check that and make sure you have the update installed. -Original Message- From: Uwe Degenhardt [mailto:cf-talk;sdsolutions.de] Sent: Wednesday, October 30, 2002 5:58 AM To: CF-Talk Subject: problems with cfgraph Hi list, I have problems with cfgraph. Nothing gets viewed. The page runs forever. On a development engine, everything works fine. I have Win2000,IIS5,CF5 and URLScan installed. Ideas what to do ? Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Yahoo moving to PHP
But you can't do that if you want to include files. I think yahoo makes a good case for moving to PHP. It's very fast for them, they are on Freebsd and they gave pretty good reasons to move to that language. Some of us don't agree that CF is an ugly language, but it is. It's nice for us because we're used to it, but hard core prgrammers are use to c style syntax. PHP follows c very closely which if you read the article is also very similar to the language they are already using. I doubt CF would be able to come to the speed that PHP can either. They did tests with it before, PHP blew the pants off of ASP and CF. I think Yahoo would do their research before making any rash decisions. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: Wednesday, October 30, 2002 11:10 AM To: CF-Talk Subject: RE: Yahoo moving to PHP cfscript if (blah) { }else{ switch () { 1: this; break; 2: that; break; } } /cfscript -Original Message- From: Nick McClure [mailto:cf-lists;king-nacho.com] Sent: Tuesday, October 29, 2002 8:21 PM To: CF-Talk Subject: Re: Yahoo moving to PHP cf, %, etc,\., what's the difference? Here is the difference, to me it seems cleaner. cfif blah cfswitch cfcase /cfcase cfcase /cfcase cfcase /cfcase /cfswitch cfelse /cfif or % if (blah) { }else{ switch () { 1: this; break; 2: that; break; } } % ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT: CF and mySQL (configuring)
OK...I'm getting there. I have the service running. I've created my database and table with MySQL-Front. I'm in the process of creating the fields but I'm stuck on what type from the Field-Properties, Length/Set and Default Value to select. Also Table-Type? Options are: Automatic (by default) ISAM MyISAM HEAP MERGE InnoDB BDB These are the fields from my access database: ID (automatically generated by Access) Do I include this field when I import the comma-delimited file exported from Access? field1 (text. Could be 5-20 characters long) field2 (text. This field is updated from another database. It will be a comma-delimited string from 5 to possibly 1000+ characters) There are also other boxes to check: [ ] Primary [ ] Index [ ] Unique [ ] Unsigned (This was checked by default) [ ] Zerofil [ ] Not Full [ ] AutoIncrement How do I proceed? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: CFMX possible bug, anyone care to verify
The code you're using to generate a long string will give: For 1-9 it will produce: 123456789 (making len(str)=9) but for 1-10 it will give 12345678910 (making len(str)=11) etc So the string len that you're getting (53799) sounds about right when the loop goes up to 12981. Doesn;t explain why the regex fails though ! Alex -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: 30 October 2002 16:06 To: CF-Talk Subject: RE: CFMX possible bug, anyone care to verify Hi Brook, I tried your code and for 12981 got Ths string is 53799 chars long (No null pointer exception) for a hoot I bumped it up to 5 I got Ths string is 238894 chars long (No null pointer exception) It is a phat box though. W2k, jdk1.4.0_02, IIS5 -Original Message- From: Brook Davies [mailto:brook;maracasmedia.com] Sent: Tuesday, October 29, 2002 4:26 PM To: CF-Talk Subject: CFMX possible bug, anyone care to verify I might be missing something here, but I seem to be able to generate a null error when performing a regex operation on a sting longer than 12980 chars. Is this a known limitation? Maybe some one could try this could on there CFMX dev box and tell me if they get the same error. Here is some sample code which will generate a string of 12980 characters long and then try a regular expression operation on the string. This generates an error on my CFMX (updater installed) server which is running Win2k / sp3 with IIS5.0. !--- changing the loop to value to anything over 12980 throws an error (try it at 12980 and 12981)--- cfset str= cfloop from=1 to=12981 index=i cfset str=stri /cfloop BR cfoutputThs string is #len(str)# chars long/cfoutput !--- this is the expression which causes the error --- cfset z=REfindnocase((\[)([[:print:][:space:]])*(\]),str,1) Brook Davies ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: columns of user-editable text: Link to Excel sheet?
You can configure an Excel file as an ODBC datasource. Then you could display it in a CFGRID, if you like. Cary At 08:23 PM 10/29/2002 -0600, you wrote: Someone wants to have a page that's mainly an Excel spreadsheet... anyone know how to do that? Does it change when they change the spreadsheet? Or, I was thinking the user could export to a text file, which I could cfinclude between PRE /PRE tags... but there are columns of data - how would I get them to line up? This is the user phone list - name, dept, phone, employee no... tabular data. They HAVE an actual cfgrid of data for it now, and I knew they would eventually NOT want to keep it up (in duplicate with whatever the secretary is using to distribute the real phone list!). Suggestions? Sample code? TIA Ed Gordon ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CF and mySQL (configuring)
I usually us MyISAM but you should read the description of each in the mysql manual to determine what is best for you.. same thing about the checkboxes.. - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 11:16 AM Subject: OT: CF and mySQL (configuring) OK...I'm getting there. I have the service running. I've created my database and table with MySQL-Front. I'm in the process of creating the fields but I'm stuck on what type from the Field-Properties, Length/Set and Default Value to select. Also Table-Type? Options are: Automatic (by default) ISAM MyISAM HEAP MERGE InnoDB BDB These are the fields from my access database: ID (automatically generated by Access) Do I include this field when I import the comma-delimited file exported from Access? field1 (text. Could be 5-20 characters long) field2 (text. This field is updated from another database. It will be a comma-delimited string from 5 to possibly 1000+ characters) There are also other boxes to check: [ ] Primary [ ] Index [ ] Unique [ ] Unsigned (This was checked by default) [ ] Zerofil [ ] Not Full [ ] AutoIncrement How do I proceed? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Yahoo moving to PHP
I was just trying to be a smart ass - It looked like you wanted some one to be :) I like php, I use in on one of my open source sites (which happens to run on FreeBSD). As I recall CF isn't supported on FreeBSD anyway. I care not what yahoo does. You make a very intelligent argument for those posting against the php switch however. -Original Message- From: Robert Everland [mailto:REverland;dixonusa.com] Sent: Wednesday, October 30, 2002 8:09 AM To: CF-Talk Subject: RE: Yahoo moving to PHP But you can't do that if you want to include files. I think yahoo makes a good case for moving to PHP. It's very fast for them, they are on Freebsd and they gave pretty good reasons to move to that language. Some of us don't agree that CF is an ugly language, but it is. It's nice for us because we're used to it, but hard core prgrammers are use to c style syntax. PHP follows c very closely which if you read the article is also very similar to the language they are already using. I doubt CF would be able to come to the speed that PHP can either. They did tests with it before, PHP blew the pants off of ASP and CF. I think Yahoo would do their research before making any rash decisions. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: Wednesday, October 30, 2002 11:10 AM To: CF-Talk Subject: RE: Yahoo moving to PHP cfscript if (blah) { }else{ switch () { 1: this; break; 2: that; break; } } /cfscript -Original Message- From: Nick McClure [mailto:cf-lists;king-nacho.com] Sent: Tuesday, October 29, 2002 8:21 PM To: CF-Talk Subject: Re: Yahoo moving to PHP cf, %, etc,\., what's the difference? Here is the difference, to me it seems cleaner. cfif blah cfswitch cfcase /cfcase cfcase /cfcase cfcase /cfcase /cfswitch cfelse /cfif or % if (blah) { }else{ switch () { 1: this; break; 2: that; break; } } % ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
caching
Can someone tell me or point to a site that gives a comparison or server caching vs. client side and use the CFCACHE tag? Thx! Dan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: CFMX possible bug, anyone care to verify
Well, thats odd then. Because it certainly happens on my box. Thats too strange... Thanks for checking y'all... Brook At 09:50 AM 10/30/02 -0500, you wrote: I was not able to reproduce this bug. (Using CFMX+Updater.) -Ray - Original Message - From: Brook Davies [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 7:26 PM Subject: CFMX possible bug, anyone care to verify I might be missing something here, but I seem to be able to generate a null error when performing a regex operation on a sting longer than 12980 chars. Is this a known limitation? Maybe some one could try this could on there CFMX dev box and tell me if they get the same error. Here is some sample code which will generate a string of 12980 characters long and then try a regular expression operation on the string. This generates an error on my CFMX (updater installed) server which is running Win2k / sp3 with IIS5.0. !--- changing the loop to value to anything over 12980 throws an error (try it at 12980 and 12981)--- cfset str= cfloop from=1 to=12981 index=i cfset str=stri /cfloop BR cfoutputThs string is #len(str)# chars long/cfoutput !--- this is the expression which causes the error --- cfset z=REfindnocase((\[)([[:print:][:space:]])*(\]),str,1) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
How secure is encrypt
how good is the encryption that the built in cf function use? good enough for cc's or passwords? John Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: How secure is encrypt
erm... I suppose is all depends on how secure you define secure? -Original Message- From: John Gedeon [mailto:jgedeon;qualcomm.com] Sent: 30 October 2002 16:42 To: CF-Talk Subject: How secure is encrypt how good is the encryption that the built in cf function use? good enough for cc's or passwords? John Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: How secure is encrypt
John Gedeon wrote: how good is the encryption that the built in cf function use? good enough for cc's or passwords? Totally insecure. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: How secure is encrypt
no -Original Message- From: John Gedeon [mailto:jgedeon;qualcomm.com] Sent: Wednesday, October 30, 2002 8:42 AM To: CF-Talk Subject: How secure is encrypt how good is the encryption that the built in cf function use? good enough for cc's or passwords? John Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
RE: How secure is encrypt
http://www.password-crackers.com/crack/cfdecrypt.html -Original Message- From: John Gedeon [mailto:jgedeon;qualcomm.com] Sent: Wednesday, October 30, 2002 8:42 AM To: CF-Talk Subject: How secure is encrypt how good is the encryption that the built in cf function use? good enough for cc's or passwords? John Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: How secure is encrypt
It's like the latch on your gate. It'll keep out things without opposable thumbs. :-) --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: John Gedeon [mailto:jgedeon;qualcomm.com] : Sent: Wednesday, October 30, 2002 11:42 AM : To: CF-Talk : Subject: How secure is encrypt : : : how good is the encryption that the built in cf function use? : good enough for cc's or passwords? : : John : : Proverbs 3:5 Trust in the Lord with all your heart and lean not on : your own understanding; : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: How secure is encrypt
expand/explain? If its so insecure, can you tell me what this string says? 8512J85868A65C9E588CAA7E809E907492541 :-p -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 30 October 2002 16:46 To: CF-Talk Subject: Re: How secure is encrypt John Gedeon wrote: how good is the encryption that the built in cf function use? good enough for cc's or passwords? Totally insecure. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Where do CFC's go?
Here's a side question for you, that I've tried posting before ;-): Is there a way to find the root of the ColdFusion server? The majority of our sites are hosted on someone else's box, so we don't always have access to the CFAdministrator. We can usually request some mappings, but it always made more sense for me to add a resources folder to our website root. We use Fusebox, so we designate all non-Circuit folders as a resource folder and prefix with a _. Usually we have _images, _customtags, _pdfs, etc. It'd be great if I could somehow reference the CF root with a variable, because I could then I could write a UDF to call my cfcs as #cfroot#.mydomin._cfcs.somecfc but I can't quite figure out how to do that. It really would help for portability and reuse, any suggestions Tyler Silcox email | [EMAIL PROTECTED] - Original Message - From: Troy Simpson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 10:24 AM Subject: Re: Where do CFC's go? Thanks for describing your layout. It has been very helpful in providing me with ideas. How do (would) you outline the directory structure for multiple websites that are hosted on one system. For example: admin.domain.com app1.domain.com app2.domain.com app3.domain.com . It appears that ColdFusion was design with the aspect of supporting only one website instead of many. This is evident in the ColdFusion Administrator, Server Mappings page. For example, I'm only allowed to provide one root Mapping for / and the mapping must be unique. I do understand why though. Anyone have any ideas how to work around this? Thanks, Troy Sean A Corfield wrote: On Friday, Oct 25, 2002, at 16:30 US/Pacific, Troy Simpson wrote: I'm using Dreamweaver MX to create some CFC's and trying to figure out how to layout the file system on the ColdFusionMX App server. (FYI: I'm new at this CFC stuff and Dreamweaver too.) Where am I suppose to copy the CFC's too? I've read various things. Some put them under the wwwroot. Others put them outside the wwwroot and create a mapping. If you want to invoke them as Web Services or via Flash Remoting, you need to make your CFCs web-accessible. Otherwise, you can put them wherever you want. Here's what my team does (partial credit to Mike Nimer for the seed of this): {cfmx}/ extensions/ components/ {appname}/ {file}.cfc customtags/ {appname}/ {file}.cfm includes/ {appname}/ {file}.cfm wwwroot/ {appname}/ {file}.cfm Where {cfmx} is the install directory, {appname} is an application name (e.g., store, membership) and {file} is any filename. Then we add these to the custom tag / components path in the CF Admin: {cfmx}/extensions/components/ {cfmx}/extensions/customtags/ And we add a mapping for the includes: /cfinclude {cfmx}/extensions/includes/ Typically, each application has an Application.cfm under wwwroot/{appname}/ which also cfinclude's /Application.cfm which contains our 'global' stuff. This is all part of our coding guidelines - but I can't remember whether I left this in the public domain version: http://www.corfield.org/coldfusion/codingStandards.htm I can't answer your RDS question I'm afraid! Sean A Corfield -- Director, Architecture Web Technology Group -- Macromedia, Inc. tel: (415) 252-2287 -- cell: (415) 717-8473 fax: (415) 865-3113 -- http://www.macromedia.com An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: How secure is encrypt
Erm.. I dont think thats what he was on about, and anyhow you should not be posting things like that to the list. You know as much as anyone that this is a violation of the Agreement (decrypting templates) tut tut, shame on you. :-p -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: 30 October 2002 16:49 To: CF-Talk Subject: RE: How secure is encrypt http://www.password-crackers.com/crack/cfdecrypt.html -Original Message- From: John Gedeon [mailto:jgedeon;qualcomm.com] Sent: Wednesday, October 30, 2002 8:42 AM To: CF-Talk Subject: How secure is encrypt how good is the encryption that the built in cf function use? good enough for cc's or passwords? John Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: How secure is encrypt
Doesnt mean people dont do it :) hes just being realistic lol - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 11:55 AM Subject: RE: How secure is encrypt Erm.. I dont think thats what he was on about, and anyhow you should not be posting things like that to the list. You know as much as anyone that this is a violation of the Agreement (decrypting templates) tut tut, shame on you. :-p -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: 30 October 2002 16:49 To: CF-Talk Subject: RE: How secure is encrypt http://www.password-crackers.com/crack/cfdecrypt.html -Original Message- From: John Gedeon [mailto:jgedeon;qualcomm.com] Sent: Wednesday, October 30, 2002 8:42 AM To: CF-Talk Subject: How secure is encrypt how good is the encryption that the built in cf function use? good enough for cc's or passwords? John Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: How secure is encrypt
/* CFDECRYPT: Decrypt Cold Fusion templates encrypted with CFCRYPT Matt Chapman [EMAIL PROTECTED] Usage: cfdecrypt encrypted.cfm decrypted.cfm Requires a DES encryption library to compile. */ #include stdio.h #include des.h int main(void) { char *header = Allaire Cold Fusion Template\012Header Size: ; char buffer[54]; int headsize, outlen; int skip_header; int len, i; char *keystr = Error: cannot open template file--\%s\. Please, try again!\012\012; des_cblock key; des_cblock input; des_cblock output; des_key_schedule schedule; if ((fread(buffer, 1, 54, stdin) 54) || (memcmp(buffer, header, 42))) { fprintf(stderr, File is not an encrypted template\n); return 1; } if (!memcmp(buffer[42], New Version, 11)) { headsize = 69; skip_header = 1; } else { headsize = atoi(buffer[42]); skip_header = 0; } if ((headsize 54) || (fseek(stdin, headsize, SEEK_SET) 0)) { fprintf(stderr, Error in file format\n); return 1; } des_string_to_key(keystr, key); des_set_key(key, schedule); outlen = 0; while ((len = fread(input, 1, 8, stdin)) == 8) { des_ecb_encrypt(input, output, schedule, 0); outlen += 8; i = 0; if (skip_header) { while (i 8) { if (output[i++] == 0x1A) { skip_header = 0; break; } } } fwrite(output + i, 1, 8 - i, stdout); } for (i = 0; i len; i++) { output[i] = input[i] ^ (outlen + i); } fwrite(output, 1, len, stdout); return 0; } -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Wednesday, October 30, 2002 8:50 AM To: CF-Talk Subject: RE: How secure is encrypt expand/explain? If its so insecure, can you tell me what this string says? 8512J85868A65C9E588CAA7E809E907492541 :-p -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 30 October 2002 16:46 To: CF-Talk Subject: Re: How secure is encrypt John Gedeon wrote: how good is the encryption that the built in cf function use? good enough for cc's or passwords? Totally insecure. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: How secure is encrypt
People are getting template encryption confused with the functions the guy actually asked about. -jesse -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: Wednesday, October 30, 2002 12:04 PM To: CF-Talk Subject: RE: How secure is encrypt /* CFDECRYPT: Decrypt Cold Fusion templates encrypted with CFCRYPT Matt Chapman [EMAIL PROTECTED] Usage: cfdecrypt encrypted.cfm decrypted.cfm Requires a DES encryption library to compile. */ #include stdio.h #include des.h int main(void) { char *header = Allaire Cold Fusion Template\012Header Size: ; char buffer[54]; int headsize, outlen; int skip_header; int len, i; char *keystr = Error: cannot open template file--\%s\. Please, try again!\012\012; des_cblock key; des_cblock input; des_cblock output; des_key_schedule schedule; if ((fread(buffer, 1, 54, stdin) 54) || (memcmp(buffer, header, 42))) { fprintf(stderr, File is not an encrypted template\n); return 1; } if (!memcmp(buffer[42], New Version, 11)) { headsize = 69; skip_header = 1; } else { headsize = atoi(buffer[42]); skip_header = 0; } if ((headsize 54) || (fseek(stdin, headsize, SEEK_SET) 0)) { fprintf(stderr, Error in file format\n); return 1; } des_string_to_key(keystr, key); des_set_key(key, schedule); outlen = 0; while ((len = fread(input, 1, 8, stdin)) == 8) { des_ecb_encrypt(input, output, schedule, 0); outlen += 8; i = 0; if (skip_header) { while (i 8) { if (output[i++] == 0x1A) { skip_header = 0; break; } } } fwrite(output + i, 1, 8 - i, stdout); } for (i = 0; i len; i++) { output[i] = input[i] ^ (outlen + i); } fwrite(output, 1, len, stdout); return 0; } -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Wednesday, October 30, 2002 8:50 AM To: CF-Talk Subject: RE: How secure is encrypt expand/explain? If its so insecure, can you tell me what this string says? 8512J85868A65C9E588CAA7E809E907492541 :-p -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 30 October 2002 16:46 To: CF-Talk Subject: Re: How secure is encrypt John Gedeon wrote: how good is the encryption that the built in cf function use? good enough for cc's or passwords? Totally insecure. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: How secure is encrypt
Robertson-Ravo, Neil (REC) wrote: expand/explain? It is more obfuscated as encrypted. So if a hacker has sufficient data with some common characteristic, like creditcards of which you know they follow the MOD 10 algorithm and have predictable starting numbers, it is hackable. But the deeper problem is that the encryption is two-way symmetric. The most likely way to get a password or a creditcard database is to root a server. That will give that person access to the template doing the encryption as well, and he can simply read the password from it [1]. Then it is easy to reverse the encryption. In the case of passwords, the obvious solution is to use one-way encryption. In the case of creditcards, use asymmetric encryption and store the key to decrypt somewhere else as the encrypted data. Jochem [1] Has anybody checked with CF MX if encrypted .cfm templates produce encrypted .java files? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: How secure is encrypt
Unless I'm mistaken, it looks like you've posted a utility to decrypt encrypted cf templates, not a link decrypt scrings that are encrypted. Something like #encrypt(string, key)# I think was the question... -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: Wednesday, October 30, 2002 8:49 AM To: CF-Talk Subject: RE: How secure is encrypt http://www.password-crackers.com/crack/cfdecrypt.html -Original Message- From: John Gedeon [mailto:jgedeon;qualcomm.com] Sent: Wednesday, October 30, 2002 8:42 AM To: CF-Talk Subject: How secure is encrypt how good is the encryption that the built in cf function use? good enough for cc's or passwords? John Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: How secure is encrypt
http://www.password-crackers.com/crack/cfdecrypt.html I think John is actually asking about the encrypt function withing CFML (to encrypt a string), rather than encrypting cfml files. Of course, neither method is secure . . . . Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Attribute set validation error in tag CFOUTPUT
Here's a unique one: CF 5, Win2K Server This code: - cfoutput div id=headerChange Bond Order for #client.ssmembername#/div /cfoutput - Produces this error: - Attribute set validation error in tag CFOUTPUT The tag has an invalid attribute combination: the most likely attribute combination is Required attributes: 'GROUP,QUERY'. Optional attributes: 'GROUPCASESENSITIVE,MAXROWS,STARTROW'. Other possible combinations are Required attributes: 'GROUP'. Optional attributes: 'GROUPCASESENSITIVE,MAXROWS'. Required attributes: 'QUERY'. Optional attributes: 'MAXROWS,STARTROW'. Required attributes: None. Optional attributes: None. The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (1:1) to (1:10). - Anybody have any ideas why the server would just freak out suddenly like this? I tried commenting out the client variable on the off-chance it might produce a change and it didn't seem to have any affect. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer New Epoch www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: How secure is encrypt
oops thats for the encrpyted files... I can feel the fames... -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: Wednesday, October 30, 2002 9:04 AM To: CF-Talk Subject: RE: How secure is encrypt /* CFDECRYPT: Decrypt Cold Fusion templates encrypted with CFCRYPT Matt Chapman [EMAIL PROTECTED] Usage: cfdecrypt encrypted.cfm decrypted.cfm Requires a DES encryption library to compile. */ #include stdio.h #include des.h int main(void) { char *header = Allaire Cold Fusion Template\012Header Size: ; char buffer[54]; int headsize, outlen; int skip_header; int len, i; char *keystr = Error: cannot open template file--\%s\. Please, try again!\012\012; des_cblock key; des_cblock input; des_cblock output; des_key_schedule schedule; if ((fread(buffer, 1, 54, stdin) 54) || (memcmp(buffer, header, 42))) { fprintf(stderr, File is not an encrypted template\n); return 1; } if (!memcmp(buffer[42], New Version, 11)) { headsize = 69; skip_header = 1; } else { headsize = atoi(buffer[42]); skip_header = 0; } if ((headsize 54) || (fseek(stdin, headsize, SEEK_SET) 0)) { fprintf(stderr, Error in file format\n); return 1; } des_string_to_key(keystr, key); des_set_key(key, schedule); outlen = 0; while ((len = fread(input, 1, 8, stdin)) == 8) { des_ecb_encrypt(input, output, schedule, 0); outlen += 8; i = 0; if (skip_header) { while (i 8) { if (output[i++] == 0x1A) { skip_header = 0; break; } } } fwrite(output + i, 1, 8 - i, stdout); } for (i = 0; i len; i++) { output[i] = input[i] ^ (outlen + i); } fwrite(output, 1, len, stdout); return 0; } -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Wednesday, October 30, 2002 8:50 AM To: CF-Talk Subject: RE: How secure is encrypt expand/explain? If its so insecure, can you tell me what this string says? 8512J85868A65C9E588CAA7E809E907492541 :-p -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 30 October 2002 16:46 To: CF-Talk Subject: Re: How secure is encrypt John Gedeon wrote: how good is the encryption that the built in cf function use? good enough for cc's or passwords? Totally insecure. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: How secure is encrypt
I was talking about the Encrypt function built in to cf not the code hiding external function or are they the same? ex cfset value = Encrypt(string,key) At 08:49 AM 10/30/2002, you wrote: http://www.password-crackers.com/crack/cfdecrypt.html -Original Message- From: John Gedeon [mailto:jgedeon;qualcomm.com] Sent: Wednesday, October 30, 2002 8:42 AM To: CF-Talk Subject: How secure is encrypt how good is the encryption that the built in cf function use? good enough for cc's or passwords? John Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: How secure is encrypt
If I wanted to take an hour to write an app, and let it run in the background for a day or two? Yes, I probably could. cfencrypt is a symetric key algorythm with (iirc) only a 32-bit keyspace. So I need to run through, at most, about 4.2 billion keys, looking for (as an example) anything that contains a dictionary word. I pick the one of that set that seems to make the most sense. If I'm right, I've got your key. For CCs, I find a group of encrypted ones and look for a key that makes all of them a 16-digit number (with or without dashes, spaces, whatever). Now I've got your key. For passwords, I get the login name and the encrypted password and try login after login until I'm in. Now I've got your key, and can decrypt anyone else's login for whom I have a login name and an encrypted password. Will cfencrypt keep out people with no skills who really don't want to hack you site? Yeah, I'd say it would. Will it keep out script kiddies, hackers, or me in a bad mood? I wouldn't count on it. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Robertson-Ravo, Neil (REC) : [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] : Sent: Wednesday, October 30, 2002 11:50 AM : To: CF-Talk : Subject: RE: How secure is encrypt : : : expand/explain? : : If its so insecure, can you tell me what this string says? : : 8512J85868A65C9E588CAA7E809E907492541 : : : :-p : : : : -Original Message- : From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] : Sent: 30 October 2002 16:46 : To: CF-Talk : Subject: Re: How secure is encrypt : : : John Gedeon wrote: : : how good is the encryption that the built in cf function use? : good enough for cc's or passwords? : : Totally insecure. : : Jochem : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: How secure is encrypt
Alright. I've got an ancryption library that offers stronger encryption than the encrypt function. Use a one-way hash for password if you can. Much stronger. Something like Sha256 or something is excellent. You store the encrypted string in your database. When someone tries to log in, you encrypt the attempted password and compare to the string in your database. Best way to encrypt passwords IMHO. I have a copy of some encryption alorithms here that you can download: http://voyager.voyus.com/cflib/ciphers.zip -Original Message- From: Jesse Noller [mailto:jnoller;macromedia.com] Sent: Wednesday, October 30, 2002 9:07 AM To: CF-Talk Subject: RE: How secure is encrypt People are getting template encryption confused with the functions the guy actually asked about. -jesse -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: Wednesday, October 30, 2002 12:04 PM To: CF-Talk Subject: RE: How secure is encrypt /* CFDECRYPT: Decrypt Cold Fusion templates encrypted with CFCRYPT Matt Chapman [EMAIL PROTECTED] Usage: cfdecrypt encrypted.cfm decrypted.cfm Requires a DES encryption library to compile. */ #include stdio.h #include des.h int main(void) { char *header = Allaire Cold Fusion Template\012Header Size: ; char buffer[54]; int headsize, outlen; int skip_header; int len, i; char *keystr = Error: cannot open template file--\%s\. Please, try again!\012\012; des_cblock key; des_cblock input; des_cblock output; des_key_schedule schedule; if ((fread(buffer, 1, 54, stdin) 54) || (memcmp(buffer, header, 42))) { fprintf(stderr, File is not an encrypted template\n); return 1; } if (!memcmp(buffer[42], New Version, 11)) { headsize = 69; skip_header = 1; } else { headsize = atoi(buffer[42]); skip_header = 0; } if ((headsize 54) || (fseek(stdin, headsize, SEEK_SET) 0)) { fprintf(stderr, Error in file format\n); return 1; } des_string_to_key(keystr, key); des_set_key(key, schedule); outlen = 0; while ((len = fread(input, 1, 8, stdin)) == 8) { des_ecb_encrypt(input, output, schedule, 0); outlen += 8; i = 0; if (skip_header) { while (i 8) { if (output[i++] == 0x1A) { skip_header = 0; break; } } } fwrite(output + i, 1, 8 - i, stdout); } for (i = 0; i len; i++) { output[i] = input[i] ^ (outlen + i); } fwrite(output, 1, len, stdout); return 0; } -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: Wednesday, October 30, 2002 8:50 AM To: CF-Talk Subject: RE: How secure is encrypt expand/explain? If its so insecure, can you tell me what this string says? 8512J85868A65C9E588CAA7E809E907492541 :-p -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 30 October 2002 16:46 To: CF-Talk Subject: Re: How secure is encrypt John Gedeon wrote: how good is the encryption that the built in cf function use? good enough for cc's or passwords? Totally insecure. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Times Return Wrong
I am using Cold Fusion MX and connecting to an informix database through an odbc source. The problem is that all times being reutrned from the queries are actually three hours greater then what is in the database. Anyone know what this could be. I am guessing some sort of weird time zone compatiblity attept gone horribly wrong. thanky -tyler clendenin gsl solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: How secure is encrypt
Yes I did, my bad. I'll just have to get out my dictionary and brute force. Sorry. -Original Message- From: Costas Piliotis [mailto:cpiliotis;voyus.com] Sent: Wednesday, October 30, 2002 9:08 AM To: CF-Talk Subject: RE: How secure is encrypt Unless I'm mistaken, it looks like you've posted a utility to decrypt encrypted cf templates, not a link decrypt scrings that are encrypted. Something like #encrypt(string, key)# I think was the question... -Original Message- From: Rob Rohan [mailto:rob;cardinalweb.com] Sent: Wednesday, October 30, 2002 8:49 AM To: CF-Talk Subject: RE: How secure is encrypt http://www.password-crackers.com/crack/cfdecrypt.html -Original Message- From: John Gedeon [mailto:jgedeon;qualcomm.com] Sent: Wednesday, October 30, 2002 8:42 AM To: CF-Talk Subject: How secure is encrypt how good is the encryption that the built in cf function use? good enough for cc's or passwords? John Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: How secure is encrypt
Yeah yeah, I got it. Sorry. -Original Message- From: Scott Brady [mailto:cf_talk;scottbrady.net] Sent: Wednesday, October 30, 2002 9:08 AM To: CF-Talk Subject: RE: How secure is encrypt http://www.password-crackers.com/crack/cfdecrypt.html I think John is actually asking about the encrypt function withing CFML (to encrypt a string), rather than encrypting cfml files. Of course, neither method is secure . . . . Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: Attribute set validation error in tag CFOUTPUT
Interesting, I copied and pasted your code (added a client.ssmembername variable first) ... but it ran just fine for me. CF5/W2k Paul Giesenhagen QuillDesign - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 11:06 AM Subject: Attribute set validation error in tag CFOUTPUT Here's a unique one: CF 5, Win2K Server This code: - cfoutput div id=headerChange Bond Order for #client.ssmembername#/div /cfoutput - Produces this error: - Attribute set validation error in tag CFOUTPUT The tag has an invalid attribute combination: the most likely attribute combination is Required attributes: 'GROUP,QUERY'. Optional attributes: 'GROUPCASESENSITIVE,MAXROWS,STARTROW'. Other possible combinations are Required attributes: 'GROUP'. Optional attributes: 'GROUPCASESENSITIVE,MAXROWS'. Required attributes: 'QUERY'. Optional attributes: 'MAXROWS,STARTROW'. Required attributes: None. Optional attributes: None. The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (1:1) to (1:10). - Anybody have any ideas why the server would just freak out suddenly like this? I tried commenting out the client variable on the off-chance it might produce a change and it didn't seem to have any affect. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer New Epoch www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: How secure is encrypt
how good is the encryption that the built in cf function use? Its alright, but its only as secure as your server as you have to keep the encryption/decryption key on the server. good enough for cc's Definately not... Look at something like pgp for encrypting credit card numbers, where you have a public and private key pair and the key that you need to decrypt the cc numbers is not kept on the server. passwords? ~shrug~ I suppose you could, but probably better to use hash() as its a one way encryption algorithm. Regards Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: How secure is encrypt
oi Rob!! uh. he's talking about the function not the exe. no? best thing to do is hashem or something similiar -- Critz Macromedia Certified Advanced ColdFusion Developer CFX_BotMaster Network=Efnet Channel=ColdFusion Blog=http://blog.ctzc.com; Wednesday, October 30, 2002, 11:49:20 AM, you wrote: RR http://www.password-crackers.com/crack/cfdecrypt.html RR -Original Message- RR From: John Gedeon [mailto:jgedeon;qualcomm.com] RR Sent: Wednesday, October 30, 2002 8:42 AM RR To: CF-Talk RR Subject: How secure is encrypt RR how good is the encryption that the built in cf function use? RR good enough for cc's or passwords? RR John RR Proverbs 3:5 Trust in the Lord with all your heart and lean not on RR your own understanding; RR ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Times Return Wrong
check your time zone settings on the machine running CFMX ? - Original Message - From: Tyler Clendenin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 12:15 PM Subject: Times Return Wrong I am using Cold Fusion MX and connecting to an informix database through an odbc source. The problem is that all times being reutrned from the queries are actually three hours greater then what is in the database. Anyone know what this could be. I am guessing some sort of weird time zone compatiblity attept gone horribly wrong. thanky -tyler clendenin gsl solutions ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: capturing a query
Thanks so much buddy! But, I believe that there is no easy way to capture the information from the debug info. Thanks again. --- Tim Painter [EMAIL PROTECTED] wrote: I've created the query as a variable and use the variable inside the cfquery: cfset sql = Select * from sometable where foo = '#form.bar#' Generated sql: #sql# cfquery name=foo datasource=bar #PreserveSingleQuotes(sql)# /cfquery HTH, Tim P. - Original Message - From: bajaria aslam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 9:01 AM Subject: capturing a query Hi List. When you have the debugging on, you can see that it shows the sql generated also. You may have #variableName# in the cfquery template, but finally when all the variables get resolved, you have a query that is sent to the database. That query can be seen when the debugging is on on the webpage. is there a way to capture that final query? i tried #cgi.QueryName# , but did not work. Any ideas? thanks list __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: OT:Yahoo moving to PHP
That's pretty much what I've done at my company as well. CFSCRIPT is just so much cleaner, and easier to read. CFML tends to be only used when we are annotating HTML. Fregas wrote: I know a development firm that tends not to use CF at all, but instead puts everything in CFSCRIPT that they can. They claim tags are deprecated in CFML. ;) - Original Message - From: Rob Rohan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 4:42 PM Subject: RE: OT:Yahoo moving to PHP CF syntax is not ugly, but i do get tired of typing Thank God for cfscript -Original Message- From: Jeffry Houser [mailto:jeff;farcryfly.com] Sent: Tuesday, October 29, 2002 2:28 PM To: CF-Talk Subject: Re: OT:Yahoo moving to PHP That is interesting... Check out Slide 22 . I wouldn't say that CF has an ugly syntax. ( I doubt many on this list would ). At 05:13 PM 10/29/2002 -0500, you wrote: Check it out, in their presentation for why they chose PHP, they make reference as to why they didn't go with CF or ASP http://public.yahoo.com/~radwin/talks/yahoo-phpcon2002.htm Ben ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Times Return Wrong
Tyler Clendenin wrote: I am using Cold Fusion MX and connecting to an informix database through an odbc source. The problem is that all times being reutrned from the queries are actually three hours greater then what is in the database. Anyone know what this could be. I am guessing some sort of weird time zone compatiblity attept gone horribly wrong. What datatypes? TIMESTAMP WITH TIMEZONE or just TIMESTAMP? What timezone is the server running at? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Attribute set validation error in tag CFOUTPUT
Anybody have any ideas why the server would just freak out suddenly like this? I tried commenting out the client variable on the off-chance it might produce a change and it didn't seem to have any affect. That error is usually indicitive of your CFOUTPUT being nested inside another CFOUTPUT, but if its not, all I can think of is the usual trick of solving any unusual problem with a quick restart of the server (CF or the OS too) Not much help I'm afraid... Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT:Yahoo moving to PHP
I use it as much as I can also, but it is by no means a replacement for many of the cf tags. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Kreig Zimmerman [mailto:kkz;foureyes.com] Sent: Wednesday, October 30, 2002 12:34 PM To: CF-Talk Subject: Re: OT:Yahoo moving to PHP That's pretty much what I've done at my company as well. CFSCRIPT is just so much cleaner, and easier to read. CFML tends to be only used when we are annotating HTML. Fregas wrote: I know a development firm that tends not to use CF at all, but instead puts everything in CFSCRIPT that they can. They claim tags are deprecated in CFML. ;) - Original Message - From: Rob Rohan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 4:42 PM Subject: RE: OT:Yahoo moving to PHP CF syntax is not ugly, but i do get tired of typing Thank God for cfscript -Original Message- From: Jeffry Houser [mailto:jeff;farcryfly.com] Sent: Tuesday, October 29, 2002 2:28 PM To: CF-Talk Subject: Re: OT:Yahoo moving to PHP That is interesting... Check out Slide 22 . I wouldn't say that CF has an ugly syntax. ( I doubt many on this list would ). At 05:13 PM 10/29/2002 -0500, you wrote: Check it out, in their presentation for why they chose PHP, they make reference as to why they didn't go with CF or ASP http://public.yahoo.com/~radwin/talks/yahoo-phpcon2002.htm Ben ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.