OT:Looking for a good SQL mailing list

2002-10-30 Thread Adams, Stephen
**
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

2002-10-30 Thread Robertson-Ravo, Neil (REC)
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

2002-10-30 Thread Paul Hastings
 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

2002-10-30 Thread Jeffry Houser
  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

2002-10-30 Thread Stephen Moretti
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

2002-10-30 Thread Adrian Lynch
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)

2002-10-30 Thread Adam Reynolds
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

2002-10-30 Thread FlashGuy
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

2002-10-30 Thread Robertson-Ravo, Neil (REC)
-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

2002-10-30 Thread SMR
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

2002-10-30 Thread FlashGuy
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!

2002-10-30 Thread FlashGuy
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!

2002-10-30 Thread Everett, Al
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!

2002-10-30 Thread Robertson-Ravo, Neil (REC)
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!

2002-10-30 Thread FlashGuy
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!

2002-10-30 Thread Everett, Al
 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!

2002-10-30 Thread FlashGuy
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!

2002-10-30 Thread Robertson-Ravo, Neil (REC)
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!

2002-10-30 Thread Jesse Houwing
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!

2002-10-30 Thread Clint Tredway
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

2002-10-30 Thread Jochem van Dieten
 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

2002-10-30 Thread Luis Lebron
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

2002-10-30 Thread Uwe Degenhardt
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

2002-10-30 Thread bajaria aslam
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

2002-10-30 Thread Raymond Camden
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

2002-10-30 Thread Tim Painter
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

2002-10-30 Thread Tony Weeg
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!)

2002-10-30 Thread Robert Everland
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

2002-10-30 Thread Everett, Al
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

2002-10-30 Thread Raymond Camden
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

2002-10-30 Thread Tony Weeg
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

2002-10-30 Thread Mike Townend
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

2002-10-30 Thread Jochem van Dieten
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

2002-10-30 Thread Adrian Lynch
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

2002-10-30 Thread Everett, Al
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

2002-10-30 Thread Everett, Al
 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

2002-10-30 Thread Jeff Beer
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

2002-10-30 Thread Jeff Beer
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

2002-10-30 Thread Everett, Al
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

2002-10-30 Thread Raymond Camden
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

2002-10-30 Thread FlashGuy
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

2002-10-30 Thread Christine Lawson
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

2002-10-30 Thread Robertson-Ravo, Neil (REC)
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

2002-10-30 Thread Govind Bhat
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

2002-10-30 Thread FlashGuy
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

2002-10-30 Thread Jochem van Dieten
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

2002-10-30 Thread Michael Dinowitz
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?

2002-10-30 Thread Troy Simpson
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

2002-10-30 Thread Pete Ruckelshaus
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

2002-10-30 Thread Mike Brunt
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

2002-10-30 Thread Jeff Beer
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

2002-10-30 Thread Eric Dawson
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

2002-10-30 Thread Ben Doom
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

2002-10-30 Thread Uwe Degenhardt
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

2002-10-30 Thread Everett, Al
 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

2002-10-30 Thread brook
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

2002-10-30 Thread Rich Wild
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

2002-10-30 Thread Rob Rohan
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

2002-10-30 Thread Rob Rohan
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

2002-10-30 Thread Rob Rohan
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

2002-10-30 Thread Robert Everland
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)

2002-10-30 Thread FlashGuy
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

2002-10-30 Thread A.Little
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?

2002-10-30 Thread Cary Gordon
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)

2002-10-30 Thread SMR
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

2002-10-30 Thread Rob Rohan
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

2002-10-30 Thread Dan Phillips
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

2002-10-30 Thread brook
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

2002-10-30 Thread John Gedeon
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

2002-10-30 Thread Robertson-Ravo, Neil (REC)
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

2002-10-30 Thread Jochem van Dieten
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

2002-10-30 Thread Rob Rohan
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

2002-10-30 Thread Rob Rohan
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

2002-10-30 Thread Ben Doom
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

2002-10-30 Thread Robertson-Ravo, Neil (REC)
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?

2002-10-30 Thread Tyler Silcox
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

2002-10-30 Thread Robertson-Ravo, Neil (REC)
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

2002-10-30 Thread William Wheatley
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

2002-10-30 Thread Rob Rohan
/* 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

2002-10-30 Thread Jesse Noller
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

2002-10-30 Thread Jochem van Dieten
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

2002-10-30 Thread Costas Piliotis
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

2002-10-30 Thread Scott Brady
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

2002-10-30 Thread S . Isaac Dealey
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

2002-10-30 Thread Rob Rohan
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

2002-10-30 Thread John Gedeon
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

2002-10-30 Thread Ben Doom
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

2002-10-30 Thread Costas Piliotis
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

2002-10-30 Thread Tyler Clendenin
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

2002-10-30 Thread Rob Rohan
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

2002-10-30 Thread Rob Rohan
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

2002-10-30 Thread Paul Giesenhagen
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

2002-10-30 Thread Stephen Moretti
 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

2002-10-30 Thread Critter
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

2002-10-30 Thread SMR
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

2002-10-30 Thread bajaria aslam
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

2002-10-30 Thread Kreig Zimmerman
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

2002-10-30 Thread Jochem van Dieten
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

2002-10-30 Thread Stephen Moretti
 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

2002-10-30 Thread Robert Everland
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.



  1   2   3   >