RE: is cfflush above?

2006-10-04 Thread Ben Nadel
Just wrap it a UDF that returns a boolean


cfif IsFlushInitiated()

.

/cfif 



..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Eduard Tabara [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 04, 2006 4:47 PM
To: CF-Talk
Subject: Re: is cfflush above?

yeah, setting a request variable will help.. i thought about that too.
but the idea was to find out if there was a cfflush in the code above
without to have a need to set any specific variables. i am looking more
into something like getting in a variable all the above code (let's
say so: ANY above code. so no additional requests variable setup or
things like that will work) or let's say the list of tags that was used
previously in the code, etc. it should be more hm something that can be
used for example in onRequestEnd (or in
onRequest) method of application.cfc. So, no matter what code will be
executed, in onRequestEnd to be possible to know if that cfflush tag
has been used or no.

Ed

--- In [EMAIL PROTECTED], [EMAIL PROTECTED] wrote:

  
 Try rockin' in trial and error?
 
 
 cftry
   !--- Try set a status code. ---
   cfheader 
   statuscode=200 
   statustext=OK
   /
   
   cfset REQUEST.FlushInitiated = false /
   
   cfcatch
   
   !--- The CFHeader threw an error. CFFlush has already
been run. 
 ---
   cfset REQUEST.FlushInitiated = true /
   
   /cfcatch
 /cftry
 
 
 ..
 Ben Nadel
 Certified Advanced ColdFusion Developer www.bennadel.com
  
 
 -Original Message-
 From: Ian Skinner [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, October 04, 2006 2:14 PM
 To: CF-Talk
 Subject: RE: is cfflush above?
 
 maybe there is an undocumented way to get the cf code to be compiled? 
 so that it to can be searched for the cfflush tag.
 
 Thx in advance,
 Ed
 
 Well, I don't know why you would want to compile something.  It would 
 be fairly trivial, if not ideal, to build something that will search 
 for the cfflush tag with standard ColdFusion file and string
capabilities.
 
 Why one would want to do this is beyond my comprehension.
 
 
 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA
 
 -
 | 1 |   |
 -  Binary Soduko
 |   |   |
 -
  
 C code. C code run. Run code run. Please!
 - Cynthia Dunning
 
 Confidentiality Notice:  This message including any attachments is for

 the sole use of the intended
 recipient(s) and may contain confidential and privileged information.
 Any unauthorized review, use, disclosure or distribution is
prohibited.
 If you are not the intended recipient, please contact the sender and 
 delete any copies of this message.
 
 
 
 
 
 
 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: is cfflush above?

2006-10-04 Thread Ben Nadel
NO worries dude, does this help:

http://bennadel.com/index.cfm?dax=blog:317.view 


..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Eduard Tabara [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 04, 2006 5:14 PM
To: CF-Talk
Subject: Re: is cfflush above?

sorry, maybe my english is not good enough and i don't get understood
well... the question is: how that IsFlushInitiated() will find out if
there was used the cfflush tag or not? as i said, the above code may
be any code. so, setting a special variable with each cfflush call or
any other operation done each time with cfflush usage is not a solution.
it should be something that can be used just anytime. you know like
creating a cfm file that will consist of 2 parts: 1) doing a cfinlude
(of ANY hypotheticalally existing cfm file); 2) the code that will tell
if the cfflush exited there b4 or not.

it's like if you would want to know if you can in that second part to
use some tags that can't be used with cfflush.. like cfcookie,
cflocation, etc. WITHOUT to have direct access to the code in the first
part.

hope this time i am understood enough.

P.S. i did try to see if there is any class in cfusion.jar that would
return anything that can be used for this purpose, but i was not able to
find anything so far :(


--- In [EMAIL PROTECTED], [EMAIL PROTECTED] wrote:

 Just wrap it a UDF that returns a boolean
 
 
 cfif IsFlushInitiated()
 
 .
 
 /cfif
 
 
 
 ..
 Ben Nadel
 Certified Advanced ColdFusion Developer www.bennadel.com
  
 
 -Original Message-
 From: Eduard Tabara [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, October 04, 2006 4:47 PM
 To: CF-Talk
 Subject: Re: is cfflush above?
 
 yeah, setting a request variable will help.. i thought about that too.
 but the idea was to find out if there was a cfflush in the code above 
 without to have a need to set any specific variables. i am looking 
 more into something like getting in a variable all the above code 
 (let's say so: ANY above code. so no additional requests variable 
 setup or things like that will work) or let's say the list of tags 
 that was used previously in the code, etc. it should be more hm 
 something that can be used for example in onRequestEnd (or in
 onRequest) method of application.cfc. So, no matter what code will be 
 executed, in onRequestEnd to be possible to know if that cfflush tag

 has been used or no.
 
 Ed
 
 --- In [EMAIL PROTECTED], archive@ wrote:
 
   
  Try rockin' in trial and error?
  
  
  cftry
  !--- Try set a status code. ---
  cfheader 
  statuscode=200 
  statustext=OK
  /
  
  cfset REQUEST.FlushInitiated = false /
  
  cfcatch
  
  !--- The CFHeader threw an error. CFFlush has already
 been run. 
  ---
  cfset REQUEST.FlushInitiated = true /
  
  /cfcatch
  /cftry
  
  
  ..
  Ben Nadel
  Certified Advanced ColdFusion Developer www.bennadel.com
   
  
  -Original Message-
  From: Ian Skinner [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, October 04, 2006 2:14 PM
  To: CF-Talk
  Subject: RE: is cfflush above?
  
  maybe there is an undocumented way to get the cf code to be
compiled? 
  so that it to can be searched for the cfflush tag.
  
  Thx in advance,
  Ed
  
  Well, I don't know why you would want to compile something.  It 
  would be fairly trivial, if not ideal, to build something that will 
  search for the cfflush tag with standard ColdFusion file and string
 capabilities.
  
  Why one would want to do this is beyond my comprehension.
  
  
  --
  Ian Skinner
  Web Programmer
  BloodSource
  www.BloodSource.org
  Sacramento, CA
  
  -
  | 1 |   |
  -  Binary Soduko
  |   |   |
  -
   
  C code. C code run. Run code run. Please!
  - Cynthia Dunning
  
  Confidentiality Notice:  This message including any attachments is 
  for
 
  the sole use of the intended
  recipient(s) and may contain confidential and privileged
information.
  Any unauthorized review, use, disclosure or distribution is
 prohibited.
  If you are not the intended recipient, please contact the sender and

  delete any copies of this message.
  
  
  
  
  
  
  
 
 
 
 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: How to get file sizes dynamically?

2006-10-04 Thread Ben Nadel
Gotta run, so need to keep it short, but you can call a CFDirectory on
that file:

cfdirectory
action=LIST
directory=#ExpandPath( './mp3/' )# 
name=qFileSize
filter=my_mp3_file.mp3
/

This will return a cFdirectory query in which qFileSize.size will have
the name of the file (Check for qFileSize.REcordCount first just to be
sure or wrap in Val()). 

The FILTER attribute makes sure it doesn't list all the files in the
directory, JUST the given file. 

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Aaron Roberson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 04, 2006 6:08 PM
To: CF-Talk
Subject: How to get file sizes dynamically?

I have a list of mp3 files that I am making available for download on my
website and would like to indicate what the file size of each mp3 is.

How can I do this programmaticly?

Thanks for the help!
Aaron



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Headers and Footers

2006-10-03 Thread Ben Nadel
A the moment, I have had a lot of good experiences with including
headers and footers via CFInclude. I set some sort of variable prior to
this that is reference in the header / footer to determine output. I the
following example, I set REQEST.Page which is used in the header to
determine navigation and what not:

Example page with headers/ footers:

http://www.bennadel.com/index.cfm?dax=skinspider:0.viewcodefile=462C9E6
E7E5B1C8E6091FB8940BA7D9E49E2AE744A6169B84A729D9AE1A1A841159C8C939E4FA6F
8ABE7EF93999A6EA0AC9898823BAC1FA8CCD7C6E0A6CEC7CBFDEBA788F89288D39842A1
code_module=I1_2006_09_27code_height=700#0587CE131042B73A28FBA15F45B078
29


Example header page:

http://www.bennadel.com/index.cfm?dax=skinspider:0.viewcodefile=462C9E6
E7E5B1C8E6091FB8940BA7D9E49E2AE744A6169B84A729D9AE1A1A841159C8C939E4FA6F
8ABE7EF93999A6EA0AC9898823BAC1FA8CCD7C6E0A6CEC7CBFDEBA799E1819E93884DA39
380418C97509A9A537C686EA8512A5DBDAA3DA22DBFAFA3B2BC8D7B49AC31F3code_mod
ule=I1_2006_09_27code_height=700#911875C4F2759B4537823DD3EDD643A1

Notice that in the header, I referencing the REQUEST.Page...

(SORRY of the HUGE urls).

Not sure how this integrates with Dream Weaver, but since its just
straight up CFIncludes I imagine it would do just fine. And now, you can
manage header footer arbitrarily. 

You can take it one step futher and just include a _header.cfm page
which would then check variables and include a TYPE of header (ex.
Standard, print, email, etc).

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Sent: Tuesday, October 03, 2006 3:06 PM
To: CF-Talk
Subject: Headers and Footers

I've seen developers wrap headers in footer in many different ways.
Some basic ideas just use includes, I've also seen custom tags that take
attributes and effect the way a page is displayed.  

I'm looking for any ideas that would allow me to centrally manage header
and footer content and still be able to use DreamWeaverMX2004 to make
some quick table/css adjustments.

Any throughts or prebuilt solutions successfully used from Adobe
Exchange?

Thanks.

D



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Headers and Footers

2006-10-03 Thread Ben Nadel
Sorry, those URLs were horrible, try this:

http://www.bennadel.com/index.cfm?dax=skinspider:0.viewcodecode_module=
I1_2006_10_03file_request=tags.cfm

And 

http://www.bennadel.com/index.cfm?dax=skinspider:0.viewcodecode_module=
I1_2006_10_03file_request=extensions/includes/_header_standard.cfm

 A bit better. 



..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com


-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 03, 2006 3:57 PM
To: CF-Talk
Subject: RE: Headers and Footers

A the moment, I have had a lot of good experiences with including
headers and footers via CFInclude. I set some sort of variable prior to
this that is reference in the header / footer to determine output. I the
following example, I set REQEST.Page which is used in the header to
determine navigation and what not:

Example page with headers/ footers:

http://www.bennadel.com/index.cfm?dax=skinspider:0.viewcodefile=462C9E6
E7E5B1C8E6091FB8940BA7D9E49E2AE744A6169B84A729D9AE1A1A841159C8C939E4FA6F
8ABE7EF93999A6EA0AC9898823BAC1FA8CCD7C6E0A6CEC7CBFDEBA788F89288D39842A1
code_module=I1_2006_09_27code_height=700#0587CE131042B73A28FBA15F45B078
29


Example header page:

http://www.bennadel.com/index.cfm?dax=skinspider:0.viewcodefile=462C9E6
E7E5B1C8E6091FB8940BA7D9E49E2AE744A6169B84A729D9AE1A1A841159C8C939E4FA6F
8ABE7EF93999A6EA0AC9898823BAC1FA8CCD7C6E0A6CEC7CBFDEBA799E1819E93884DA39
380418C97509A9A537C686EA8512A5DBDAA3DA22DBFAFA3B2BC8D7B49AC31F3code_mod
ule=I1_2006_09_27code_height=700#911875C4F2759B4537823DD3EDD643A1

Notice that in the header, I referencing the REQUEST.Page...

(SORRY of the HUGE urls).

Not sure how this integrates with Dream Weaver, but since its just
straight up CFIncludes I imagine it would do just fine. And now, you can
manage header footer arbitrarily. 

You can take it one step futher and just include a _header.cfm page
which would then check variables and include a TYPE of header (ex.
Standard, print, email, etc).

...
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Sent: Tuesday, October 03, 2006 3:06 PM
To: CF-Talk
Subject: Headers and Footers

I've seen developers wrap headers in footer in many different ways.
Some basic ideas just use includes, I've also seen custom tags that take
attributes and effect the way a page is displayed.  

I'm looking for any ideas that would allow me to centrally manage header
and footer content and still be able to use DreamWeaverMX2004 to make
some quick table/css adjustments.

Any throughts or prebuilt solutions successfully used from Adobe
Exchange?

Thanks.

D





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Headers and Footers

2006-10-03 Thread Ben Nadel
Oh, I need to get me some of that :) Installing right now! 

Thanks!

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Crow T Robot [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 03, 2006 4:12 PM
To: CF-Talk
Subject: RE: Headers and Footers

The TinyURL extension for FF rocks, you know.. :)

http://tinyurl.com/jtpx6

AND 

http://tinyurl.com/fw97g




 -Original Message-
 From: Ben Nadel [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 03, 2006 4:03 PM
 To: CF-Talk
 Subject: RE: Headers and Footers
 
 Sorry, those URLs were horrible, try this:
 
 http://www.bennadel.com/index.cfm?dax=skinspider:0.viewcodecode_modul
 e=
 I1_2006_10_03file_request=tags.cfm
 
 And
 
 http://www.bennadel.com/index.cfm?dax=skinspider:0.viewcodecode_modul
 e= I1_2006_10_03file_request=extensions/includes/_header_standard.cfm
 
  A bit better.
 
 
 
 ..
 Ben Nadel
 Certified Advanced ColdFusion Developer www.bennadel.com
 
 
 -Original Message-
 From: Ben Nadel [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 03, 2006 3:57 PM
 To: CF-Talk
 Subject: RE: Headers and Footers
 
 A the moment, I have had a lot of good experiences with including 
 headers and footers via CFInclude. I set some sort of variable prior 
 to this that is reference in the header / footer to determine output. 
 I the following example, I set REQEST.Page which is used in the header

 to determine navigation and what not:
 
 Example page with headers/ footers:
 
 http://www.bennadel.com/index.cfm?dax=skinspider:0.viewcodefile=462C9
 E6
 E7E5B1C8E6091FB8940BA7D9E49E2AE744A6169B84A729D9AE1A1A841159C8C939E4
 FA6F
 8ABE7EF93999A6EA0AC9898823BAC1FA8CCD7C6E0A6CEC7CBFDEBA788F89288D398
 42A1
 code_module=I1_2006_09_27code_height=700#0587CE131042B73A28FBA15F45B0
 78
 29
 
 
 Example header page:
 
 http://www.bennadel.com/index.cfm?dax=skinspider:0.viewcodefile=462C9
 E6
 E7E5B1C8E6091FB8940BA7D9E49E2AE744A6169B84A729D9AE1A1A841159C8C939E4
 FA6F
 8ABE7EF93999A6EA0AC9898823BAC1FA8CCD7C6E0A6CEC7CBFDEBA799E1819E9388
 4DA39
 380418C97509A9A537C686EA8512A5DBDAA3DA22DBFAFA3B2BC8D7B49AC31F3cod
 e_mod
 ule=I1_2006_09_27code_height=700#911875C4F2759B4537823DD3EDD643A1
 
 Notice that in the header, I referencing the REQUEST.Page...
 
 (SORRY of the HUGE urls).
 
 Not sure how this integrates with Dream Weaver, but since its just 
 straight up CFIncludes I imagine it would do just fine. And now, you 
 can manage header footer arbitrarily.
 
 You can take it one step futher and just include a _header.cfm page 
 which would then check variables and include a TYPE of header (ex.
 Standard, print, email, etc).
 
 ...
 Ben Nadel
 Certified Advanced ColdFusion Developer www.bennadel.com
 
 
 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED]
 
 Sent: Tuesday, October 03, 2006 3:06 PM
 To: CF-Talk
 Subject: Headers and Footers
 
 I've seen developers wrap headers in footer in many different ways.
 Some basic ideas just use includes, I've also seen custom tags that 
 take attributes and effect the way a page is displayed.
 
 I'm looking for any ideas that would allow me to centrally manage 
 header and footer content and still be able to use DreamWeaverMX2004 
 to make some quick table/css adjustments.
 
 Any throughts or prebuilt solutions successfully used from Adobe 
 Exchange?
 
 Thanks.
 
 D
 
 
 
 
 
 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Preventing long strings of one character

2006-10-03 Thread Ben Nadel
 

For (strKey in FORM){

FORM[ strKey ] = REReplaceNoCase(
   FORM[ strKey ],
   ([\w]{1})(\1{2,}),
   \1,
   ALL
);

}


This gets the first group (which is any letter or digit) and checks to
see if that is followed by 2 or more instances of that letter. If so,
then it is replaced with a single version of that letter.

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 03, 2006 4:20 PM
To: CF-Talk
Subject: Preventing long strings of one character

I'm building an email signup form for kids. Sometimes they (or their
adults) type in values with long strings of one letter:

avid for example.

I'd like to loop over the form fields and check for any occurrence of
one character repeated more than 3 times. That should cover any legit
instance.
I'm guessing that this would be a cause for REReplaceNoCase, but I'm not
certain what the regex would be. Anyone have input? For simplicity's
sake, I'll just search for any letters or numbers.

So I want to find any occurrence of 4 or more letters or numbers in a
row. I was thinking that this should work, but it's matching whether
there's 3 or more letters in a row or not:

cfset mystring = waalt

cfif REFindNoCase([0-9a-z]{3},mystring)
hammer time
cfelse
nada
/cfif

I'm using CF 6.1

!//--
andy matthews
web developer
certified advanced coldfusion programmer ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Preventing long strings of one character

2006-10-03 Thread Ben Nadel
It's not a look ahead or a look behind.. I am not sure what the
technical term. I think it's just a back reference. The  \1 in the
regular expression is just a back reference to the first group as
denoted by ( and ).

Maybe someone else here can help with the actual name.

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 03, 2006 4:31 PM
To: CF-Talk
Subject: RE: Preventing long strings of one character

Well now. That was easy enough. So using lookaheads? Thank you Ben.

!//--
andy matthews
web developer
certified advanced coldfusion programmer ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 03, 2006 3:27 PM
To: CF-Talk
Subject: RE: Preventing long strings of one character




For (strKey in FORM){

FORM[ strKey ] = REReplaceNoCase(
   FORM[ strKey ],
   ([\w]{1})(\1{2,}),
   \1,
   ALL
);

}


This gets the first group (which is any letter or digit) and checks to
see if that is followed by 2 or more instances of that letter. If so,
then it is replaced with a single version of that letter.


Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com


-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 03, 2006 4:20 PM
To: CF-Talk
Subject: Preventing long strings of one character

I'm building an email signup form for kids. Sometimes they (or their
adults) type in values with long strings of one letter:

avid for example.

I'd like to loop over the form fields and check for any occurrence of
one character repeated more than 3 times. That should cover any legit
instance.
I'm guessing that this would be a cause for REReplaceNoCase, but I'm not
certain what the regex would be. Anyone have input? For simplicity's
sake, I'll just search for any letters or numbers.

So I want to find any occurrence of 4 or more letters or numbers in a
row. I was thinking that this should work, but it's matching whether
there's 3 or more letters in a row or not:

cfset mystring = waalt

cfif REFindNoCase([0-9a-z]{3},mystring)
hammer time
cfelse
nada
/cfif

I'm using CF 6.1

!//--
andy matthews
web developer
certified advanced coldfusion programmer ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-








~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: CFID CFTOKEN ...MSN and search engine listings..

2006-10-02 Thread Ben Nadel
There is nothing that requires you to pass CFID CFTOKEN in URL unless
you are not using cookies or something. In CFLocation tags they even
have a boolean attribute for this:

cflocation 
url=
addtoken=false
/ 

How are you doing session management?


..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: D F [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 02, 2006 11:37 AM
To: CF-Talk
Subject: CFID  CFTOKEN ...MSN and search engine listings..

Hi there, 

Our SEO guy gave me the following message, wanted to see what the
concensus was in the CF community in regards the CFID and CFTOKEN
variables passed in urls could be causing a problem to the search
engines ( MSN in particular ). 

Is there a way to disable this feature in CF? 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: CFID CFTOKEN ...MSN and search engine listings..

2006-10-02 Thread Ben Nadel
Mary Jo,

I like your approach. Nicely done. 

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 02, 2006 12:48 PM
To: CF-Talk
Subject: Re: CFID  CFTOKEN ...MSN and search engine listings..

There is nothing that requires you to pass CFID CFTOKEN in URL unless 
you are not using cookies or something.

True, but what if you want to support users with cookies either on or
off? 

My approach is to do a cookie check and add the CFID/CFTOKEN if they are
turned off...but to also do a browser check (cgi.http_user_agent) and
exclude any that have a common search engine string in them. That seems
to do the trick 95% of the timeand is also useful for generating
error messages (or not) as well, since some search engines seem
particularly good at coming up with very misformed URLs.


Mary Jo Sminkey
http://www.cfwebstore.com
CFWebstore, ColdFusion E-commerce. 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Handling Marketing URLs

2006-09-29 Thread Ben Nadel
I have a non-database demo that I wrote that is a watered down version
of what I do It a bit much to take in, but I tried to comment it up
wazoo:

http://www.bennadel.com/blog/286-Handling-404-Errors-in-ColdFusion-via-I
IS-Throwing-404-.htm 

 Which is actually ...

http://bennadel.com/index.cfm?dax=blog:286.view


..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 28, 2006 10:37 PM
To: CF-Talk
Subject: Re: Handling Marketing URLs

Here's the 404 redirector code that I developed for a couple of my
sites:

!---
404 Redirector
Query redirects table //for all active values, put in server
scope.
//Uses QoQ to get values,
 - if value is in the database, do an HTTP 301 (Moved
Permanently) redirect.
 - if value is not in the database, do an HTTP 307 (Temporary
Redirect)
 //- if value is not in the database, insert it
 //- if value is in the database but doesn't have a goodurl set,
increment the count
 + Requires datasource redirects
---
cfscript
attemptedURL = http://;  CGI.server_name  CGI.script_name;
generatedURL = getToken(CGI.query_string, 2, ;);
if (len(trim(generatedURL)) EQ 0) {
generatedURL = attemptedURL;
}
if (findNoCase(:80, generatedurl) NEQ 0) {
generatedurl = replacenocase(generatedurl, :80, );
}
/cfscript
cfquery name=qryRedirect datasource=redirects
SELECT  R.goodURL
FROMtblRedirects R
WHERE   R.badURL = '#generatedURL#' AND
((R.goodurl IS NOT NULL) OR
(R.goodurl != ''))
/cfquery
cfif qryRedirect.recordcount GT 0
cfheader name=Location value=#qryRedirect.goodurl#
cfheader statuscode=301 statustext=Moved Permanently
cfabort
cfelse
cfheader name=Location value=/resources/sitemap.cfm
cfheader statuscode=307 statustext=Temporary Redirect
cfabort
/cfif



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Init Explanation

2006-09-28 Thread Ben Nadel
 
D,

Take a look at this page:
http://www.bennadel.com/index.cfm?dax=skinspider:0.it1thecodecode_updat
e=2006-09-27

In the description, click on the Application.cfm link (in the page
content). This will pop up a window with the Application.cfm code. In
it, I use the variable reset... But same idea as init. Read the
comments in the file.

Hope that helps.
-b

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com

 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Sent: Thursday, September 28, 2006 10:33 AM
To: CF-Talk
Subject: Init Explanation

Can someone help me understand what init is what it does and why it's
used?

For example, in a application.cfm

cfif not isDefined(application.init) or isDefined(url.reinit)
cfset application.init = true

D



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Unexpected Constant Error

2006-09-27 Thread Ben Nadel
Try this:

http://www.talkingtree.com/blog/index.cfm?mode=entryentry=B11F99A1-45A6
-2844-7E6E11C8B765E19B 



..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 27, 2006 10:14 AM
To: CF-Talk
Subject: Unexpected Constant Error

We are getting the following error on a CFMX 7.1/Linux server, we
haven't seen this error before and cannot find any references to it.

Error: unexpected constant #122 65

Anyone ran into this before?


Paul Giesenhagen
QuillDesign
417-885-1375
http://www.quilldesign.com







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Insert best practice

2006-09-27 Thread Ben Nadel
Victor,

I don't think it matters so much. I personally like the second solution
better as it is just more readable and I think it will give you more
flexibility if you need it (structural flexibility, not logical
flexibility). 

On a personal note, what I would do is param the value to an integer,
perhaps Zero then just insert it no matter what. I have issues with the
use of NULLs in a database unless absolutely required:

http://www.bennadel.com/blog/85-Why-NULL-Values-Should-Not-Be-Used-in-a-
Database-Unless-Required.htm

But, that is just me and I don't know your particular situation. In my
experience though, I would rather work with ZERO than with NULL. Plus,
on the output, zero can be converted to a boolean, where as an empty
string cannot (the ColdFusion representation of a NULL value pulled out
of a query).

My 2 cents.

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Victor Moore [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 27, 2006 11:51 AM
To: CF-Talk
Subject: Insert best practice

Hi,

I was wondering which one are best practices when doing a db
insert/update:
cfqueryparam value=#lfield# cfsqltype=CF_SQL_INTEGER
null=#iif((filed eq ), de(yes), de(no))# /,

or
cfif val (field) gt 0)
 cfqueryparam value=#lfield# cfsqltype=CF_SQL_INTEGER /
cfelse
   null
/cfif

First one seems more compact but not sure the delay evaluation. I mean
for a couple a columns I guess it doesn't matter but for a big table it
may add up.
The second one looks more clear. At least for me

Thanks
Victor




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: regexp help

2006-09-27 Thread Ben Nadel
!--- Using java. ---
cfset strTest = strTest.ReplaceAll( [_12]+,  ) /

!--- Using REReplace. ---
cfset strTest = REReplace( strTest, [_12]+, , ALL ) /



..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 27, 2006 2:16 PM
To: CF-Talk
Subject: regexp help

Can some tell me what the regexp would be to remove all instances of _
or 1 or 2 (that's underscore OR one OR two) from a string?

 

Like ffmpti_2 would become ffmpti or carfeed1 would become carfeed.

 

Thanks

 





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: regexp help

2006-09-27 Thread Ben Nadel
Ray,

I don't think there is any real difference. I am just grouping my
characters [_12]+ and noting that at least one item (+) is required for
the match. 

He is just listing them as being OR'd. 

Grouping [] inherently denotes OR. The | is an explicit OR. 

Also, if your example get's bigger, the | actually breaks the expression
up. For instnace, if you wanted to add outlier characters such as
getting rid of the above ONLY IF surronded by A and Z... 

My method would be:

A[_12]+Z

His method would be:

A(_|1|2)+Z 


It's all a matter of personal taste I suppose.

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 27, 2006 2:54 PM
To: CF-Talk
Subject: RE: regexp help

Ben, Claude, just so I know, what's the difference between your
solutions?
Is it merely more than one way to skin a cat, or is one better than
another?

 cfset strTest = REReplace( strTest, [_12]+, , ALL ) /


 REreplace (MyString, _|1|2, , all)




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: regexp help

2006-09-27 Thread Ben Nadel
Rob,

Exactly, no real practical difference here. The only place it becomes
more practical one way or the other is when the situation gets more
complicated. For example, [] is used to group CHARACTERS... But ( | | )
can be used to group SUBSTRINGS ex. (ben is (cool|rad|awesome)) Such a
grouping using [] would be a nightmare.


..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Rob Wilkerson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 27, 2006 3:07 PM
To: CF-Talk
Subject: Re: regexp help

No practical difference.  Ben took the shortcut of using a character set
rather than explicitly stating the OR ( | ) condition.

To be clear, though, either of these will remove any _, 1 or 2 from your
value.  So foo1bar will become foobar.  If the chars to be removed
must be at the end of the string you want to use:

cfset strTest = REReplace( strTest, _?[12]+$, , ALL ) /

I varied Ben's regex slightly, but the gist is still there.  The key
difference is that the $ forces the match to appear at the *end* of
the string, not anywhere in the string.

-- 

Rob Wilkerson


On 9/27/06, Ray Champagne [EMAIL PROTECTED] wrote:
 Ben, Claude, just so I know, what's the difference between your
solutions?
 Is it merely more than one way to skin a cat, or is one better than
another?

  cfset strTest = REReplace( strTest, [_12]+, , ALL ) /


  REreplace (MyString, _|1|2, , all)






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Paired Custom Tags

2006-09-26 Thread Ben Nadel
Also bear in mind that you will have to override the CFMailParam and
CFMailPart tag as these MUST be nested in a CFMail tag. You cannot just
have them free-floating in your CFML code.

I have thrown together a little demo. It's more in repsonse to a nested
tag idea than your specific issues, but maybe it can help:

http://www.bennadel.com/blog/293-ColdFusion-Basics-Nesting-Custom-Tags.h
tm 



..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Carl L [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 26, 2006 6:26 PM
To: CF-Talk
Subject: Re: Paired Custom Tags

If you're going to be overloading/replacing cfmail, also bear in mind
that you need to wrap the whole thing in a cfoutput tag, or else you end
up without any of the inner variable display tags being processed.
(speaking from experience)



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: URL Parameter

2006-09-25 Thread Ben Nadel
Mark,

I appreciate the words of encouragement :D I am really trying hard to
make advances in ColdFusion. Especially in the last year or so. I am
about to unveil a project of that I am using to learn object oriented
programming for ColdFusion. It's gonna be a nice iterative example where
people can look at my code on a daily basis and see the how and WHY I am
doing things. I hope to get feedback so that I can finally bridge the
gap between me and OOP. 

I am fan of ColdFusion :)


..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED] 
Sent: Saturday, September 23, 2006 10:54 AM
To: CF-Talk
Subject: RE: URL Parameter

Looking at your code I'd say it's time we moved you out of your moms
basement and get you access  to some of that stuff - you are ready for
the big time :) It's very innovative. 

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Friday, September 22, 2006 3:06 PM
To: CF-Talk
Subject: RE: URL Parameter

Jon ,

I am a fairly low-level programmer, and by that I mean I never do any
server work or deal with IIS logging or anything of that sort. That is
why I am strongly opposed to things like Mapped Paths and installing
java classes in the java class path... Most of the time I don't have
access to that sort of stuff. Most of my work revolves around creating
slick solutions for people with very little access to stuff.

This of course requires having someone set up an IIS 404 handler, but
that is fairly simple to do. 

That being said, I didn't even know about IIS and 404 error logging :D




Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Jon Clausen [mailto:[EMAIL PROTECTED]
Sent: Friday, September 22, 2006 3:48 PM
To: CF-Talk
Subject: RE: URL Parameter

Ben,

That is a cool method!  I guess that was too much of a blanket statment
for me to say the logging would be all messed up.  Google  
Analytics would definitely a good way to go with the CF only method.   
I use Smarter Stats on my server and it removes all of the 404's from
the stats when it parses the IIS logs  but other stats options might
not.

My bad,
  Jon





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Error 0 - java.lang.ArrayIndexOutOfBoundsException

2006-09-25 Thread Ben Nadel
In standard SQL, I know that when you do a SELECT COUNT() you ALWAYS get
back a row. However, in ColdFusion query of queries, if you do a SELECT
COUNT() on a table that has no rows, the query -of-queries table
actually does not return any rows. It is possible that you are expecting
a value of 0 (zero) as the count, but in fact, the query of queries
has a record count of Zero??

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Loyd Campbell [mailto:[EMAIL PROTECTED] 
Sent: Saturday, September 23, 2006 3:02 PM
To: CF-Talk
Subject: Error 0 - java.lang.ArrayIndexOutOfBoundsException

I'm querying data that is contained in either a current table,
SHIP_HIST, or an archive table, SHIP_HIST_ARC. There is a view setup on
the server, SHIP_HIST_VIEW, that does a union on both tables so if a
user wants to query both old and new data they may. A nightly stored
procedure moves records from current to archive tables based on age, so
there is no duplication of records between the two tables. The current
table is kept fairly small so most queries can be done quickly.

The current version of the report I am working on always queries the
view, regardless of what dates the user is looking for. This is a very
slow process due to the large number of records in the view. In order to
speed up the queries, I am running a quick query to determine the oldest
date in the current table, and as a result of that I name a variable
TableName. If the begin and end dates the user is looking for are
entirely within the current table, TableName is SHIP_HIST.  If the begin
and end dates are both before the oldest date in the current table, the
TableName variable is SHIP_HIST_ARC.  If the begin and end dates span
the oldest date in the current table, then I name TableName
SHIP_HIST_VIEW. This query works fine every time.

Then, I run queries against this initial query to get some subtotals and
grand totals.  My problem is that when the initial query is run against
either SHIP_HIST or SHIP_HIST_VIEW, it runs fine. If the initial query
is run against the SHIP_HIST_ARC table, ColdFusion throws an error; The
header on the debug page is Error Occurred While Processing Request.
The data is a single zero (0). Below that is the area that shows the
filename where the error occurs and then show where this data is being
called from. I have all the queries in separate files so the error is
occurring in ShipHist5.qry. Here is the text of that query:
CFQUERY NAME=#QueryName# DBType=query
SELECT
count(distinct mst_ship_num) AS mst_shp_tot_qty
FROM
ShipHist
/CFQUERY

As I said, it runs fine when the initial query is run against either the
current table or the view, but not the archive table.  It would make
more sense to me if the error came from Oracle, but it is a CF error.

Down in the Exceptions area of debug here is the error message:

Exceptions
13:37:54.054 - java.lang.ArrayIndexOutOfBoundsException - in
D:\inetpub\wwwroot\dev\DMPlusReports\queries\ShipHist5.qry : line 12
0

Can anyone make any sense of this error?  I have used the same technique
to speed up other reports that were originally written against the view
and have had no problems. This one has me stumped. I'd sure appreciate
anyone who might have an idea what is going on here.

Thanks,

Loyd Campbell
Contract CF Programmer
Plano, TX



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: application.cfc move

2006-09-25 Thread Ben Nadel
Don't mean to jump into this late... Sounds like you might be getting
this error:

http://www.bennadel.com/blog/101-ColdFusion-Error-Occurred-While-Process
ing-Request-10-10.htm 
(if that get's cut off:
http://www.bennadel.com/index.cfm?dax=blog:101.view)


..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com


-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Monday, September 25, 2006 6:32 PM
To: CF-Talk
Subject: Re: application.cfc move

hi, thanks for your reply, i am not using 5 = 0 anywhere in my program
:)

it only does that when i have an application.cfc page in the root of my
directory saying:

cfapplication sessionmanagement=yes

if i take this application.cfc out of my root directory then it works
fine



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: URL Parameter

2006-09-22 Thread Ben Nadel
I have done that. I had to set up a 404 handler in IIS that would point
to a specific ColdFusion page. That page then looked at the URL, the 404
error in the CGI.query_string, set values and included the index.cfm
page (essentially). 

You would need access to IIS for that though. Others might have a
non-IIS example.

 
..
Ben Nadel
Certified Advanced ColdFusion Developer
Nylon Technology
350 7th Avenue 
Floor 10 
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com
 
Our deepest fear is not that we are inadequate.
Our deepest fear is that we are powerful beyond measure.
It is our light, not our darkness that most frightens us.
We ask ourselves, Who am I to be brilliant, gorgeous, talented,
fabulous?
Actually, who are you not to be?
 

-Original Message-
From: Brian [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 12:22 PM
To: CF-Talk
Subject: URL Parameter

Wondering if anyone has done this before with just straight CF and not
ISAPI rewrites.

Want to create a url like -- http://www.somesite.com/64673

And then pull that 64673 off as a url parameter for querying and
redirect?

Thanks




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: URL Parameter

2006-09-22 Thread Ben Nadel
 
Dave,

My actual CFM page is super complicated because it integrates with a
custom framework that I have pieced together and actually refers to a
bunch of other objects in my system... At lunch, let me write up a quick
demo CFM page and post it here. Something simple that will demo the idea
of what I am doing. 

Give me like an hour or so and it will be posted.

-ben

..
Ben Nadel
Certified Advanced ColdFusion Developer
Nylon Technology
350 7th Avenue 
Floor 10 
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com
 
Our deepest fear is not that we are inadequate.
Our deepest fear is that we are powerful beyond measure.
It is our light, not our darkness that most frightens us.
We ask ourselves, Who am I to be brilliant, gorgeous, talented,
fabulous?
Actually, who are you not to be?
 

-Original Message-
From: Dave Hatz [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 12:43 PM
To: CF-Talk
Subject: Re: URL Parameter

Ben,
Would you be so kind to post the .cfm page you used when IIS Redirected
404's?  I have been looking for a solution just like this...

Thanks,
Dave



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: URL Parameter

2006-09-22 Thread Ben Nadel
Ok, this was a bit rushed and it watered down version of how mine works,
but it is the basic idea. I know some other people here have commented
about 404 errors and logging. I have absolutely NO issues with this
method. All the Google analytics works. My error handling works.
Everything works perfectly. It is very fast, but has room for
optimization.

Take a look:

http://www.bennadel.com/blog/286-Handling-404-Errors-in-ColdFusion-via-I
IS-Throwing-404-.htm

Or (shorter url... To demonstrate the masking:)

http://bennadel.com/index.cfm?dax=blog:286.view


It is not perfect, but it is the general idea.

 
..
Ben Nadel
Certified Advanced ColdFusion Developer
http://www.bennadel.com
 

-Original Message-
From: Dave Hatz [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 1:15 PM
To: CF-Talk
Subject: RE: URL Parameter

That would be awesome, thanks Ben

Dave 

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Friday, September 22, 2006 9:57 AM
To: CF-Talk
Subject: RE: URL Parameter

 
Dave,

My actual CFM page is super complicated because it integrates with a
custom framework that I have pieced together and actually refers to a
bunch of other objects in my system... At lunch, let me write up a quick
demo CFM page and post it here. Something simple that will demo the idea
of what I am doing. 

Give me like an hour or so and it will be posted.

-ben


Ben Nadel
Certified Advanced ColdFusion Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com
 
Our deepest fear is not that we are inadequate.
Our deepest fear is that we are powerful beyond measure.
It is our light, not our darkness that most frightens us.
We ask ourselves, Who am I to be brilliant, gorgeous, talented,
fabulous?
Actually, who are you not to be?
 

-Original Message-
From: Dave Hatz [mailto:[EMAIL PROTECTED]
Sent: Friday, September 22, 2006 12:43 PM
To: CF-Talk
Subject: Re: URL Parameter

Ben,
Would you be so kind to post the .cfm page you used when IIS Redirected
404's?  I have been looking for a solution just like this...

Thanks,
Dave







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: URL Parameter

2006-09-22 Thread Ben Nadel
Also, here is the direct snippet:

http://www.bennadel.com/snippets/29-Handling-404-Errors-in-ColdFusion.ht
m 



-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 3:37 PM
To: CF-Talk
Subject: RE: URL Parameter

Ok, this was a bit rushed and it watered down version of how mine works,
but it is the basic idea. I know some other people here have commented
about 404 errors and logging. I have absolutely NO issues with this
method. All the Google analytics works. My error handling works.
Everything works perfectly. It is very fast, but has room for
optimization.

Take a look:

http://www.bennadel.com/blog/286-Handling-404-Errors-in-ColdFusion-via-I
IS-Throwing-404-.htm

Or (shorter url... To demonstrate the masking:)

http://bennadel.com/index.cfm?dax=blog:286.view


It is not perfect, but it is the general idea.

 
...
Ben Nadel
Certified Advanced ColdFusion Developer
http://www.bennadel.com
 

-Original Message-
From: Dave Hatz [mailto:[EMAIL PROTECTED]
Sent: Friday, September 22, 2006 1:15 PM
To: CF-Talk
Subject: RE: URL Parameter

That would be awesome, thanks Ben

Dave 

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Friday, September 22, 2006 9:57 AM
To: CF-Talk
Subject: RE: URL Parameter

 
Dave,

My actual CFM page is super complicated because it integrates with a
custom framework that I have pieced together and actually refers to a
bunch of other objects in my system... At lunch, let me write up a quick
demo CFM page and post it here. Something simple that will demo the idea
of what I am doing. 

Give me like an hour or so and it will be posted.

-ben

.
Ben Nadel
Certified Advanced ColdFusion Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com
 
Our deepest fear is not that we are inadequate.
Our deepest fear is that we are powerful beyond measure.
It is our light, not our darkness that most frightens us.
We ask ourselves, Who am I to be brilliant, gorgeous, talented,
fabulous?
Actually, who are you not to be?
 

-Original Message-
From: Dave Hatz [mailto:[EMAIL PROTECTED]
Sent: Friday, September 22, 2006 12:43 PM
To: CF-Talk
Subject: Re: URL Parameter

Ben,
Would you be so kind to post the .cfm page you used when IIS Redirected
404's?  I have been looking for a solution just like this...

Thanks,
Dave









~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: URL Parameter

2006-09-22 Thread Ben Nadel
Jon ,

I am a fairly low-level programmer, and by that I mean I never do any
server work or deal with IIS logging or anything of that sort. That is
why I am strongly opposed to things like Mapped Paths and installing
java classes in the java class path... Most of the time I don't have
access to that sort of stuff. Most of my work revolves around creating
slick solutions for people with very little access to stuff.

This of course requires having someone set up an IIS 404 handler, but
that is fairly simple to do. 

That being said, I didn't even know about IIS and 404 error logging :D



..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Jon Clausen [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 3:48 PM
To: CF-Talk
Subject: RE: URL Parameter

Ben,

That is a cool method!  I guess that was too much of a blanket statment
for me to say the logging would be all messed up.  Google  
Analytics would definitely a good way to go with the CF only method.   
I use Smarter Stats on my server and it removes all of the 404's from
the stats when it parses the IIS logs  but other stats options might
not.

My bad,
  Jon

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: image scraping on ebay

2006-09-22 Thread Ben Nadel
I know you asked how to PREVENT it. I wrote a little pieces on how to
get around it. You might want to just take a look at it. It might help
you figure out how to prevent it. Kind of like asking people to break
into your bank to see if your security is good:

http://www.bennadel.com/blog/134-Ask-Ben-CFHttp-For-Web-Mining-And-Image
-Hot-Linking.htm 

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Matt Quackenbush [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 3:07 PM
To: CF-Talk
Subject: Re: image scraping on ebay

I know this question has already been properly answered, but I thought
I'd just pass along this link which will walk you thru implementing the
technique, should you need it :-)

http://tutorial99.easycfm.com/




On 9/22/06, Michael E. Carluen [EMAIL PROTECTED] wrote:

 With cfcontent, the link to the image will be something like 
 src=myimage.cfm?id-10.  In which case, myimage.cfm holds the 
 cfcontent tag and perhaps prompt to login.  When ebay folks try to 
 link to the image src, they just get prompted to a login page.

 Hth.



  -Original Message-
  From: Chad Gray [mailto:[EMAIL PROTECTED]
  Sent: Friday, September 22, 2006 11:17 AM
  To: CF-Talk
  Subject: image scraping on ebay
 
  Any way to keep people from scraping images off of a web site?
 
  A client is having all kinds of problems with ebay people linking to
 their
  images.
 
  Thanks!
 
 
 

 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Finding current CF Version

2006-09-22 Thread Ben Nadel
CFDump out server:

cfdump var=#SERVER# / 


..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 4:09 PM
To: CF-Talk
Subject: Finding current CF Version

Is there a variable/function that returns the CF version that
you are running?






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs. CF_SQL_TIMESTAMP

2006-09-22 Thread Ben Nadel
Not every DB supports every CFQueryParam cfsqltype. For instance, I used
to use _DATE in MS SQL Server, but then one day it started throwing
errors on SQL Server 2005. If you look in the documentation, it will
show you how everything maps. _TIMESTAMP is supported by MS SQL Server.

As far as CreateODBCDate() and CreateODBCDateTime()... Not sure how
important they are. If you use CFQueryParam, I believe the tag will
format things properly for you. I guess you could use CreateODBCDate()
if you wanted to pass a Date/time object with zerod out time. But then
again, I don't know if there is any advantage to doing that over just
formatting the value you pass to the tag.

I imagine that CreateODBCDate() type functions are used mainly for
databases that do not allow data binding and therefore do not allow
CFQueryParam?? More of a backwards compatability thing... But I might be
talking out of you know where.

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 4:52 PM
To: CF-Talk
Subject: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs.
CF_SQL_TIMESTAMP

I was wondering if someone can point out the main differences
(advantages/disadvantages of each) between #createODBCdate()#,
cfqueryparam cfsqltype=CF_SQL_DATE.,  and cfqueryparam
cfsqltype=CF_SQL_TIMESTAMP.
when used on inserts and updates.  Thanks in advance.





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs. CF_SQL_TIMESTAMP

2006-09-22 Thread Ben Nadel
PS.

Here is where you can see what DB's support which CF_SQL_

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/comm
on/html/wwhelp.htm?context=ColdFusion_Documentationfile=0317.htm 

..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 4:52 PM
To: CF-Talk
Subject: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs.
CF_SQL_TIMESTAMP

I was wondering if someone can point out the main differences
(advantages/disadvantages of each) between #createODBCdate()#,
cfqueryparam cfsqltype=CF_SQL_DATE.,  and cfqueryparam
cfsqltype=CF_SQL_TIMESTAMP.
when used on inserts and updates.  Thanks in advance.





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs. CF_SQL_TIMESTAMP

2006-09-22 Thread Ben Nadel
As far as with is better Not sure. Personally, I never use
CreateODBCDate() or CreateODBCDateTime(). If your database supports
CFQueryParam tag, I would recommend that one. It has several advantages
in terms of query performance. 

Ex.

I would do

WHERE
date_created = cfqueryparam value=#Now()#
cfsqltype=CF_SQL_TIMESTAMP /

 Instead of ...

WHERE
date_created = #CreateODBCDateTime( Now() )#


In fact, if you are using Now(), you wouldn't even need the
CreateODBCDateTime() method call as Now() is already ODBC time stamp.

If you want to know about speed and Cfqueryparam... Here is a good post:

http://www.harelmalka.com/?m=200608


..
Ben Nadel
Certified Advanced ColdFusion Developer
www.bennadel.com
 

-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 22, 2006 5:24 PM
To: CF-Talk
Subject: RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs.
CF_SQL_TIMESTAMP

Thanks Ben. I've been using both createOBDC... and cfqueryparam... on
mySQL/JDBC and have not encountered a problem- which actually lead to
this thread.  If both are OK, then which is better.  Thanks for
mentioning your experience with MSSQL, as I'm sure it's a consideration
when writing modular apps.

 -Original Message-
 From: Ben Nadel [mailto:[EMAIL PROTECTED]
 Sent: Friday, September 22, 2006 2:02 PM
 To: CF-Talk
 Subject: RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE
vs.
 CF_SQL_TIMESTAMP
 
 PS.
 
 Here is where you can see what DB's support which CF_SQL_
 
 http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/co
 mm 
 on/html/wwhelp.htm?context=ColdFusion_Documentationfile=0317.htm
 
 ..
 Ben Nadel
 Certified Advanced ColdFusion Developer www.bennadel.com
 
 
 -Original Message-
 From: Michael E. Carluen [mailto:[EMAIL PROTECTED]
 Sent: Friday, September 22, 2006 4:52 PM
 To: CF-Talk
 Subject: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs.
 CF_SQL_TIMESTAMP
 
 I was wondering if someone can point out the main differences 
 (advantages/disadvantages of each) between #createODBCdate()#, 
 cfqueryparam cfsqltype=CF_SQL_DATE.,  and cfqueryparam 
 cfsqltype=CF_SQL_TIMESTAMP.
 when used on inserts and updates.  Thanks in advance.
 
 
 
 
 
 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Passing ColdFusion Arrays By Reference

2006-09-19 Thread Ben Nadel
Hey all, I was fooling around with some code last night and found a way to
pass ColdFusion arrays by reference, and NOT by value. I am just very
excited about this and though maybe you all would like to know about it to.
From some prelim testing, it looks like passing by reference has HUGE
performance gains and is just all around wicked sweet!

http://www.bennadel.com/blog/275-Passing-Arrays-By-Reference-In-ColdFusion-S
WEEET.htm

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Ben Nadel
No, I am NOT wrapping a structure around an array. I am making a
pass-by-reference VERSION of an array. 

If you wrap something in a structure. Then you need to grab it out of a
structure when referencing it:

cfset objStructure[ array ] = ArrayNew( 1 )/

!--- Update it. ---
cfset ArrayAppend( objStructure[ array ], test ) /

See, if you go the structure route, you have to always reference via the
structure. That is LAME. I am talking about altering the way arrays seem
to function. Pass the array ITSELF by reference. No structures, no nesting,
no nothing... Pure sexyness.

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 19, 2006 8:39 AM
To: CF-Talk
Subject: RE: Passing ColdFusion Arrays By Reference

Hasn't this always been possible?  Didn't you wrap a structure around the
array?





-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: 19 September 2006 13:34
To: CF-Talk
Subject: Passing ColdFusion Arrays By Reference

Hey all, I was fooling around with some code last night and found a way to
pass ColdFusion arrays by reference, and NOT by value. I am just very
excited about this and though maybe you all would like to know about it to.
From some prelim testing, it looks like passing by reference has HUGE
performance gains and is just all around wicked sweet!

http://www.bennadel.com/blog/275-Passing-Arrays-By-Reference-In-ColdFusion-S
WEEET.htm

.
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Ben Nadel
Sometimes I find it makes the code run faster ;) 


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 19, 2006 9:18 AM
To: CF-Talk
Subject: RE: Passing ColdFusion Arrays By Reference

Lol...do you have to comment any references to it as   Pure sexyness.

?



-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: 19 September 2006 14:10
To: CF-Talk
Subject: RE: Passing ColdFusion Arrays By Reference

No, I am NOT wrapping a structure around an array. I am making a
pass-by-reference VERSION of an array. 

If you wrap something in a structure. Then you need to grab it out of a
structure when referencing it:

cfset objStructure[ array ] = ArrayNew( 1 )/

!--- Update it. ---
cfset ArrayAppend( objStructure[ array ], test ) /

See, if you go the structure route, you have to always reference via the
structure. That is LAME. I am talking about altering the way arrays seem
to function. Pass the array ITSELF by reference. No structures, no nesting,
no nothing... Pure sexyness.

.
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 19, 2006 8:39 AM
To: CF-Talk
Subject: RE: Passing ColdFusion Arrays By Reference

Hasn't this always been possible?  Didn't you wrap a structure around the
array?





-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: 19 September 2006 13:34
To: CF-Talk
Subject: Passing ColdFusion Arrays By Reference

Hey all, I was fooling around with some code last night and found a way to
pass ColdFusion arrays by reference, and NOT by value. I am just very
excited about this and though maybe you all would like to know about it to.
From some prelim testing, it looks like passing by reference has HUGE
performance gains and is just all around wicked sweet!

http://www.bennadel.com/blog/275-Passing-Arrays-By-Reference-In-ColdFusion-S
WEEET.htm

...
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/










~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Timeout requests after XX seconds . . .

2006-09-19 Thread Ben Nadel
George,

While I have no info on this... I am fairly certain that I have read that
the timeout for the page is different than the timeout for a CFQuery tag,
hence the issue you are having. 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Earl, George [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 19, 2006 10:26 AM
To: CF-Talk
Subject: Timeout requests after XX seconds . . .

I'm confused.

If the 'Timeout requests after XX seconds' setting in CFAdmin is set to 60
seconds and a request (for us almost always a database request) takes longer
than 60 seconds I get a message in the CF logs that 'The unresponsive thread
count is up to X.' When the request completes I get a message that 'The
unresponsive thread count is down to X.' and another message that the
offending template ran x seconds.

I thought the purpose of the time out setting in CFAdmin was to free up the
offending thread once the time out limit had been reached. But the log file
message implies that the thread is kept open until the request returns from
the database at which time it is then terminated and freed up.

Is this maybe two types of time outs - CF processing time outs vs.
database request time outs? And what I describe above is CF practicing good
database request housekeeping?

Does it make sense that 1) if a thread is kept open until the request
returns from the database, even if that request goes beyond the time out
setting in CFAdmin, and 2) if the CF processing on the returned answer set
is at most a couple of seconds, it would make sense to not time out these
database requests?

Running CF5 . . .  :(

Thanks!

George




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Passing ColdFusion Arrays By Reference

2006-09-19 Thread Ben Nadel
Tom,

Excellent catch. I did not think to test the ArrayResize() method. 

Hmmm, that may hinder the use a lot, for the very reason you are saying. I
don't want people to have to test for type.

Dang!  

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 19, 2006 10:44 AM
To: CF-Talk
Subject: RE: Passing ColdFusion Arrays By Reference

I just run the following test:

cfset javaArray = CreateObject(java, java.util.ArrayList).Init()/
cfset regArray = arrayNew(1) cfset arrayResize(regArray,10)
!--- cfset arrayResize(javaArray,10) ---

cftimer label=Test Java Array type=outline
cfloop index=m from=1 to=10 step=1
cfset javaArray[m] = m
/cfloop
/cftimer

cftimer label=Test ColdFusion Array type=outline
cfloop index=k from=1 to=10 step=1
cfset regArray[k] = k
/cfloop
/cftimer

And a) CF array runs faster due to the benefits of the resize (otherwise the
run time is similar)
b) your version of the array is not supported by the resize, so your array
is not 100% like regular CF array with additional benefit of passing by
reference. One would now have to check a lot more about your array version
to figure out what it supports and what it doesn't support.

TK
http://www.tomkitta.com

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 19, 2006 9:26 AM
To: CF-Talk
Subject: RE: Passing ColdFusion Arrays By Reference


Sometimes I find it makes the code run faster ;)


.
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: CFDocument TimeOut Bug???

2006-09-15 Thread Ben Nadel
Ha ha, no worries. I was like who's this Dave fellow :)

I am really glad that helped you. I was banging my head against the desk! 


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Kris Jones [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 15, 2006 7:57 AM
To: CF-Talk
Subject: Re: CFDocument TimeOut Bug???

Err, I meant Ben actually...
 Oh Dave, thank you!!



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Web page thumbnails

2006-09-15 Thread Ben Nadel
Holy cow, that IS a cool little utility. I have never seen it before. If any
one is interested, I have set up a little demo to see it in action:

http://www.bennadel.com/resources/demo/3/

Tim, thanks a lot for posting!

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 15, 2006 9:05 AM
To: CF-Talk
Subject: Re: Web page thumbnails

 If you're on Windows this is a nitfy command line util that could be 
 run from cfexecute:

 http://www.websitescreenshots.com/
  Tim.

Great Find Tim!!!

--
Casey Dougall
Web Applications Developer
Ph: 518 743-9424  Fax: 743-0337
Mannix Marketing Inc. 33 Park St. Third Floor, Glens Falls, New York 12801
~~
wWw.TerrainAssassin.cOm - Nov1 2006



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Web page thumbnails

2006-09-15 Thread Ben Nadel
Ha ha, no worries. I love me some good code :) 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/



-Original Message-
From: Casey Dougall [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 15, 2006 11:49 AM
To: CF-Talk
Subject: Re: Web page thumbnails

 http://www.bennadel.com/resources/demo/3/

 Tim, thanks a lot for posting!

 ...
 Ben Nadel
 www.bennadel.com
 Certified Advanced ColdFusion Developer

Sweet, thanks Ben, just goes to show you, read cf-talk enough and you don't
have to code anymore LOL.



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Web page thumbnails

2006-09-15 Thread Ben Nadel
That is weird.  I guess for freeware, it's still very good. Besides... Look
at excite.. It's a mess :)

-b

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: cf user [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 15, 2006 1:40 PM
To: CF-Talk
Subject: Re: Web page thumbnails

Try to generate a thumbnail from  www.excite.com 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Web page thumbnails

2006-09-15 Thread Ben Nadel
It's actually a site-wide error mailer... It must be crashing :( 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 15, 2006 1:56 PM
To: CF-Talk
Subject: RE: Web page thumbnails

Hmmm, pretty. 

Also, from the cfmail timeout error, I see Ben is mailing himself every time
someone uses his demo to see what's going on.  Tricky  :)

~Brad

-Original Message-
From: cf user [mailto:[EMAIL PROTECTED]
Sent: Friday, September 15, 2006 12:40 PM
To: CF-Talk
Subject: Re: Web page thumbnails

Try to generate a thumbnail from  www.excite.com 





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Web page thumbnails

2006-09-15 Thread Ben Nadel
Actually, that is very interesting... It looks like the CFExecute was timing
the page out... Which must have thrown an error... But then the error
handler timed out also? Is that possible? Does OnError of the
Application.cfc live in the same request time out constraints? 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 15, 2006 1:56 PM
To: CF-Talk
Subject: RE: Web page thumbnails

Hmmm, pretty. 

Also, from the cfmail timeout error, I see Ben is mailing himself every time
someone uses his demo to see what's going on.  Tricky  :)

~Brad

-Original Message-
From: cf user [mailto:[EMAIL PROTECTED]
Sent: Friday, September 15, 2006 12:40 PM
To: CF-Talk
Subject: Re: Web page thumbnails

Try to generate a thumbnail from  www.excite.com 





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Web page thumbnails

2006-09-15 Thread Ben Nadel
On the developer's website, it says that it uses the IE browser to take the
screen shot. 

As far as the small image looking different than the large one, that's
probably just my settings. You can set the browser size as well as the image
size. I am probably only setting the image size for the small thumb.
Remember, this was just a little demo. I only discovered this app today, so
the demo is not refined. I still think it's a cool little app, especially
since it doesn't need to be installed which means no permissions issues
(unless you have CFExecue permissions issues).

-b 
...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 15, 2006 3:16 PM
To: CF-Talk
Subject: RE: Web page thumbnails

I wonder what type of browser the tag reports itself as, and how it
generates the page.  I'm guessing the pages with a lot of DHTML and dynamic
client-side shmoo are the ones most likely to not render correctly.  

~Brad

-Original Message-
From: cf user [mailto:[EMAIL PROTECTED]
Sent: Friday, September 15, 2006 2:03 PM
To: CF-Talk
Subject: Re: Web page thumbnails

Also, thumbnails look VERY different from the big picture.  See Microsoft
page, as an example.  Usual place for some free cheese is a mousetrap...

That is weird.  I guess for freeware, it's still very good. Besides...
Look
at excite.. It's a mess :)






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: QoQ is killing me

2006-09-14 Thread Ben Nadel
You can't use the function LEFT() in query of queries. Query of queries only
allows for a few functions such as UPPER() and LOWER() for example. 

Can you perform the LEFT() call in the original Query before it gets to CF? 


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Nathan C. Smith [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 14, 2006 11:39 AM
To: CF-Talk
Subject: QoQ is killing me

I'm trying to run a query of queries like this 

cfquery name=qryPCTinfo dbtype=query
SELECT file,serialno,left(serialno,3) as thisPCT,
imatterno, left(imatterno,6) as thisImatterno, patentno,issue,status
FROM qryPatents
WHERE thisPCT = 'PCT' and thisImatterno =
'#variables.thisfamily#'
/cfquery

in CF MX7 and it keeps failing with

Query Of Queries syntax error.
Encountered left. Incorrect Select List, Incorrect select column, 


I just went through the online docs for QoQ and there isn't much mention of
using functions in them.  Is it possible? 
If anybody could take a quick peek at the above and offer any suggestions I
would be grateful.  Especially if I am overlooking something obvious.
Thanks.

-Nate

Nathan Smith  McKee, Voorhees  Sease, P.L.C.



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: wildcard

2006-09-14 Thread Ben Nadel
You can form a query of queries on the directory query perhaps?

cfquery name=qFileSet dbtype=query
SELECT
name
FROM
qDirList
WHERE
name LIKE cfqueryparam value=jsmith%.pdf /
/cfquery

This will get jsmith.pdf, jsmith2.pdf... But will also get
jsmith-big-sexy.pdf (so be carefule). Also, LIKE in query of queries IS case
sensitive so careful on that to. You can do a LOWER() on the name first if
you like.
 
...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 14, 2006 11:41 AM
To: CF-Talk
Subject: wildcard

I have pdf files in a directory that CF reads using cfdirectory. It finds
the filename under the user's name such as jsmith.pdf, but at times a user
may have two pdf files in the directory such as jsmith.pdf and
jsmith2.pdf.

How can I have it find both instances?  Can I use a wildcard character such
as *? 

For example: 
cfloop query=dirlist !--- loop outputs the file names and sizes of each
file --- #name*# /cfloop

I tried this and got an error. See my code below.

Thanks for any help.

Robert O.
HWW

cfloop list=#form.thelist# index=i !--- loop through the list of
names w/ i holding the individual names 
cfoutputname: #i#br

cfdirectory directory=e:/pdfs action=list name=dirlist filter=#i#*
!--- check the directory for the no. of files w/ a name like the user name
exist --- no. of files: #dirlist.recordcount#br !--- shows how many of
each file exists ---

cfloop query=dirlist !--- loop outputs the file names and sizes of each
file --- #name# br /cfloopbr

/cfoutput
/cfloop




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Dynamically calling methods in a CFC

2006-09-14 Thread Ben Nadel
Jeff,

In my experience, you can do this, but when you invoke the method, it does
not invoke within the memory space of the original component. It invokes the
method as if it were a free-standing method. Therefore, it does not have
access to THIS and VARIABLES scopes of the CFC.

This is what I have found when testing, but I may be wrong.

-ben 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Jeff Anderson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 14, 2006 1:58 PM
To: CF-Talk
Subject: Re: Dynamically calling methods in a CFC

Andy,

Try using this:

cfset a = APPLICATION.imgObj[scaleMethod]/

Then:

cfset a(yourArgs) /

If you notice the methods live in the this and variables scopes in the CFC
along with any other variables. Becuase of that, you can treat the method as
a key in the scope struct and create a reference copy to the a variable.

HTH,

Jeff

I'm using Rick Root's image.cfc which contains scaleX and scaleY methods.

Right now I'm doing an if statement with two lines for the call to the CFC.

cfif scaleMethod IS scaleX
 cfset a = APPLICATION.imgObj.scaleX() cfelse
 cfset a = APPLICATION.imgObj.scaleY() /cfif

But I'd like to condense it to this:
cfset a = APPLICATION.imgObj[scaleMethod]()

But that method errors. I've tried these as well:

cfset a = APPLICATION.imgObj[#scaleMethod#]()
cfset a = APPLICATION.imgObj.#scaleMethod#()
cfset a = APPLICATION.imgObj.#scaleMethod#()

But they also failed. I know it's got to be possible, but I'm not sure 
how to do it...anyone?

!//--
andy matthews
web developer
certified advanced coldfusion programmer ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: CFDocument TimeOut Bug???

2006-09-14 Thread Ben Nadel
Dave,

I may or may NOT have had a similar problem just two days ago:

http://www.bennadel.com/blog/266-CFDocument-Errors-And-Resolving-DNS.htm


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Dave Hatz [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 14, 2006 5:37 PM
To: CF-Talk
Subject: CFDocument TimeOut Bug???

I am running a long process that builds a 3meg PDF.  It takes a good 5
minutes easy to process.  This process runs on a server that is sitting
offline and not used for Web access.  Anyways, I am getting the following
error message:

An exception occurred when performing document processing.
The cause of this exception was that:
coldfusion.document.DocumentProcessTimeOutException: The content of this
document process takes more than 6 milliseconds to process..

I am using CFMX v7.0.2, on IIS6 running on an Windows 2003 Box.  2gig of
Ram.  Here is the syntax:

cfdocument format=PDF pagetype=letter orientation=portrait
filename=statements.pdf overwrite=true marginbottom=.10
marginleft=.10 marginright=.10 margintop=.10 
  cfdocumentsection  

  cfloop index=x from=1 to=#ArrayLen(aChecks)# 
  cfinclude template=statement_body.cfm
  /cfloop

  /cfdocumentsection
/cfdocument   

I have set cfsetting requesttimeout=1500 

Can someone please clue me in on what I am doing wrong here?  I setting the
requesttime isn't doing a damn thing,  I have run this fine without the
cfdocument and it runs fine and takes like I said around 5 minutes max


Thanks,
Dave Hatz
 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: cfquery sql= ...

2006-09-13 Thread Ben Nadel
I have never seen that before. Crazy!

-b

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Nathan Strutz [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 13, 2006 4:27 PM
To: CF-Talk
Subject: cfquery sql= ...

Hey all,

I just saw a code sample, and verified it on the livedocs, basically:

cfquery datasource=dsn sql=insert into ...

Since when did cfquery have a sql attribute, and is this deprecated or what?
Maybe i'm just dense, but I've never seen it before.

--
nathan strutz
http://www.dopefly.com/




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: OT Forcing download after N seconds

2006-09-12 Thread Ben Nadel
You can only send one set of headers so you can't send new headers after N
seconds. My best guess would be to just a META redirect to the file after N
seconds.

meta http-equiv=Refresh content=N;url=http://www.domain.com/file.ext; 

Where N is the seconds.

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 12, 2006 10:17 AM
To: CF-Talk
Subject: OT Forcing download after N seconds

I've done the whole forcing a download a bunch of times before, but what
I've never done is force a download after N number of seconds.

Can anyone point me in the right direction with this. I thought maybe meta
refreshes or flushing the response to the browser and then changing the
headers and content type but it's not working.

Thanks.

Adrian Lynch
http://www.halestorm.co.uk/




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


OT: Eclipse word delimiters

2006-09-11 Thread Ben Nadel
Hey all, 

Does anyone know if there is a setting in Eclipse where I can tell it what
to you as a word delimiter? What I am trying to do it get a more efficient
CTRL+RIGHT / CTRL+LEFT. In HomseSite. If you do CTRL+RIGHT it moves the
cursor to the next word. It is really useful. In Eclipse, it mimics this,
but uses too many delimiters. 

For instance the word:

This_is_cool_here

Is ONE word in homesite (ie. one jump with CTRL+RIGHT), but is FOUR words in
Eclipse. This just makes the feature much less useful. I thought maybe there
was a setting for this as I feel this is very common to all windows
applications.

Thanks,
ben

...
Ben Nadel 
Certified Advanced ColdFusion Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


coldfusion.document.DocumentProcessTimeOutException

2006-09-08 Thread Ben Nadel
I am trying to create a PDF via CFDocument. It works fine on the local
server, but it crapping out on the live server with the following error:

An exception occurred when performing document processing. The cause of this
exception was that: coldfusion.document.DocumentProcessTimeOutException: The
content of this document process takes more than 2 milliseconds to
process.

It is an HTML page that is getting converted to a document. Locally it only
take like 10 seconds to run. Live, we have increased the page timeout to 60
seconds and still no luck. We have installed hotfixes. No luck. 

Furthermore, if I include the HtmlEditFormat() of the code, it works just
fine. CFDocument is fine with standard text. But, the fact that it is trying
to render an HTML page is killing it. 

We have written the HTML to a file first to make sure that it's ok.
Everything works fine. 

Any ideas why it is hanging? We are running standard edition, 7,0,1,116466.
It's the ONLY website on this NEW server box.

Thanks,
Ben

...
Ben Nadel 
Certified Advanced ColdFusion Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Using CachedWithin

2006-09-08 Thread Ben Nadel
This is my limited knowledge.

The user of queryparam does not allow the prepared sql statement to be
statically cached because it does not have a set structure (used to cached
the query values). The queryparam makes the statement dynamic.


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 08, 2006 12:28 PM
To: CF-Talk
Subject: Using CachedWithin

I am trying to use the CachedWithin attribute of my cfquery but will not
allow me to do this because I am using cfqueryparam in my Where clause.
 
What is the reason for this?




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: text image clarity

2006-09-08 Thread Ben Nadel
First of all, switch over to FireWorks... It is in many ways superior for
WEB DEVELOPMENT work (that's to stop all the people who get uppity about
photoshop and image manipulation). 

Fireworks also has anti-aliasing support plus it has custom aliasing where
you can determine strength, sharpness, and the number of times you go over
it (can't think of how to describe it better). In my experience, Fireworks
just makes nice photos. Also, when you export, choose GIF  Exact that way
its true colors, not small color sets.

If you want, send me the PNG and I can give it a go.

-ben 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 08, 2006 2:47 PM
To: CF-Talk
Subject: OT: text image clarity

I'm asking this on behalf of a co-worker who is getting frustrated with
something.  How does one create crisp text images in PhotoShop?  We have a
nav bar that the text gets all fuzzy, no matter what settings we use
(anti-aliasing Crisp, Smooth, etc).  He also claims that he has Googled this
topic and hasn't come up with anything that goes more in-depth than
Photoshop provides anti-aliasing options like Crisp, Smooth, etc. etc..

 

Anyone have any advice on how to do this in a sure-fire way?  We also have
Illustrator and Fireworks, if those do the job any better.

 

I know that this isn't a graphics forum, but you guys are geniuses at
everything else, so why not graphics. An example to see what I mean:

 

http://www.cvwp.com/images/m_about.gif

 

Thanks,

 

Ray

 





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: IIS 500 - Internal Server Error

2006-09-07 Thread Ben Nadel
Does the error say 500 null by any chance... If that is the case, it would
be an error in ColdFusion and I can direct you to some stuff. 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 07, 2006 12:56 PM
To: CF-Talk
Subject: IIS 500 - Internal Server Error

Hey all,

 

I just found out today that a specific piece of an application we provide is
throwing an internal server error for a specific client. We've tested this
same area with other clients and it seems to be working fine. Because we run
as an ASP, the fact that this error is tossed for only one client is
boggling me. We've check the data for this client and everything is on the
up and up.

 

Can anyone think of a reason why this page would choke out and CF would have
nothing to say about it?

 

!k






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: IIS 500 - Internal Server Error

2006-09-07 Thread Ben Nadel
Just in case it is a 500 null error, here are some issues that I have had to
address:

http://www.bennadel.com/blog/139-ColdFusion-500-Null-Error-Revisited.htm

http://www.bennadel.com/blog/84-500-null-Mysterious-ColdFusion-Error.htm

These are all COLDFUSION errors ... Well actually MY errors in ColdFusion to
be fair :)

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/



-Original Message-
From: Snake [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 07, 2006 1:35 PM
To: CF-Talk
Subject: RE: IIS 500 - Internal Server Error

I was having the same thing this week.
A developer working off my dev server, kept getting  the internal server
error for one specific page, yet it worked fine for me all the time.
 

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: 07 September 2006 18:14
To: CF-Talk
Subject: RE: IIS 500 - Internal Server Error

Does the error say 500 null by any chance... If that is the case, it would
be an error in ColdFusion and I can direct you to some stuff. 

.
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 12:56 PM
To: CF-Talk
Subject: IIS 500 - Internal Server Error

Hey all,

 

I just found out today that a specific piece of an application we provide is
throwing an internal server error for a specific client. We've tested this
same area with other clients and it seems to be working fine. Because we run
as an ASP, the fact that this error is tossed for only one client is
boggling me. We've check the data for this client and everything is on the
up and up.

 

Can anyone think of a reason why this page would choke out and CF would have
nothing to say about it?

 

!k










~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: IIS 500 - Internal Server Error

2006-09-07 Thread Ben Nadel
Kevin, 

What I would starting doing is putting

cfdump var=HERE / 
cfabort /

Right after your application tag.. If that works (you see HERE on the
browser page), then cut it out and move it farther down the page processing.


Keep doing this until you no longer see HERE, but in fact see the 500 error.
Now you know that whatever is causeing the error is between the current
CFDUmp and wherever the last CFDUMP was.

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 07, 2006 2:06 PM
To: CF-Talk
Subject: RE: IIS 500 - Internal Server Error

I looked through your posts and tried flushing the output to no avail. 

I'm going to look over the page and the data for the 400th time, but I'm not
to optimistic at this point.

!k

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 11:47 AM
To: CF-Talk
Subject: RE: IIS 500 - Internal Server Error

Just in case it is a 500 null error, here are some issues that I have had to
address:

http://www.bennadel.com/blog/139-ColdFusion-500-Null-Error-Revisited.htm

http://www.bennadel.com/blog/84-500-null-Mysterious-ColdFusion-Error.htm

These are all COLDFUSION errors ... Well actually MY errors in ColdFusion to
be fair :)

.
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/



-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 1:35 PM
To: CF-Talk
Subject: RE: IIS 500 - Internal Server Error

I was having the same thing this week.
A developer working off my dev server, kept getting  the internal server
error for one specific page, yet it worked fine for me all the time.
 

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: 07 September 2006 18:14
To: CF-Talk
Subject: RE: IIS 500 - Internal Server Error

Does the error say 500 null by any chance... If that is the case, it would
be an error in ColdFusion and I can direct you to some stuff. 

...
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 12:56 PM
To: CF-Talk
Subject: IIS 500 - Internal Server Error

Hey all,

 

I just found out today that a specific piece of an application we provide is
throwing an internal server error for a specific client. We've tested this
same area with other clients and it seems to be working fine. Because we run
as an ASP, the fact that this error is tossed for only one client is
boggling me. We've check the data for this client and everything is on the
up and up.

 

Can anyone think of a reason why this page would choke out and CF would have
nothing to say about it?

 

!k














~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Application CFC and the URL.

2006-09-06 Thread Ben Nadel
I use the CGI and URL values in my OnApplicationStart() method with no
problems ( I think ). Although an also initialize outside of on
applicationStart method... So not sure. All I know is the site works.

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 06, 2006 3:37 PM
To: CF-Talk
Subject: Application CFC and the URL.

Which events in the application.cfc framework, if any, would have access to
URL variables?

In more specific terms, if I wanted to have an application.cfc function
called based on the existence and|or value of a url variable, how could I do
this?


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any attachments is for the
sole use of the intended
recipient(s) and may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient, please contact the sender and delete any
copies of this message. 





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Bulk data loading

2006-09-06 Thread Ben Nadel
Sorry to come in late in the convo... If you can put the file in a public
directory, I have found from some simple testing that CFHttp is faster than
a buffered file reader... 

http://bennadel.com/blog/200-ColdFusion-CFHttp-To-Query-Much-Faster-Than-Jav
a-Buffered-Reader.htm

DISCLAIMER: I am a ColdFusion programmer, not a Java programmer, so there
are probably issues. 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Chris Tilley [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 06, 2006 3:26 PM
To: CF-Talk
Subject: Re: Bulk data loading

I've tried it but getting an error message:
12:52:15.015 - Expression Exception - in
D:\Inetpub\cf\WorkingCapitalFund\FileReader.cfc : line 65

Variable RETURNSTRING is undefined.

Any ideas why?


On 9/6/06, Rick Root [EMAIL PROTECTED] wrote:

 Rick Root wrote:
  I blogged the method at www.opensourcecf.com =)

 specifically...


 http://www.opensourcecf.com/1/2006/07/Reading-large-files-with-java-ve
 rsus-CFFILE.cfm

 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Locking Theory

2006-09-06 Thread Ben Nadel
In my opinion, only use CFLock when you care if the race condition matters.
Take setting SESSION values for instance. Let's say you have the following
code:

cfset SESSION.FirstName = qUser.first_name /

This would NOT require a lock. Yes, it's shared data. Yes you could have
conflicts. But the question is, does it matter? If a user has two pages that
happen to run this code simultaneously, is there going to be a bad outcome
if no locking? N. Both will set the appropriate value. 

Then take a session counter in the application:

cfset APPLICATION.SessionCount = ( APPLICATION.SessionCount + 1 ) /

Again, you are updating shared memory... But again, does it matter? Can this
ever fire in such a way where it will get hurt? No. No matter what, sessions
are going to be added.

So the questions you need to ask yourself in this order are:

1. Is there a race condition?

2. Does the race condition matter?

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 06, 2006 6:20 PM
To: CF-Talk
Subject: Locking Theory

Okay.. so, is cflock in or out these days?

Should I be using cflock around session variable reads?  writes?

If so, why?

Rick



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: including into a cfset

2006-09-05 Thread Ben Nadel
Dude,

Just set the variable name into an application-level variable:

cfset APPLICATION.Constants.DepartmentName = epidemiology and
biostatistics /

. Then use 

cfset page_location = APPLICATION.Constants.DepartmentName

 Or something to that effect. No need to keep it in a file.

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 05, 2006 10:43 AM
To: CF-Talk
Subject: including into a cfset

okay, I'm sure this is cause I'm just not thinking right this morning, but
I've stared and stared and just don't see the answer.

I have a bit of text that I want to represent in alot of places
(epidemiology and biostatistics) and wish to do:
cfinclude template='department_name.cfm'   which is just  
epidemiology and biostatistics

I also have a variable this is used in alot of places that I also need to
set to this text:
cfset page_location = epidemiology and biostatistics

It would be nice if I could set page_location to the cfinclude, but not only
does it not work, it looks silly:
cfset page_location = cfinclude template='department_name.cfm'

How would I do this ?
page_location is used in other modules not owned by this, so I need to keep
that variable and just set it to the included information.

thanks.


-- 

Daniel Kessler

College of Health and Human Performance
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
Phone: 301-405-2545
http://hhp.umd.edu






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


Query of Queries type cast error

2006-09-05 Thread Ben Nadel
Hey all, I was just working on some query of queries code that used a
manually value-modified query when I got this error:

Error casting an object of type  to an incompatible type. This usually
indicates a programming error in Java, although it could also mean you have
tried to use a foreign object in a different way than it was designed.

I have gotten this error before, and I know I have seen other people post
about it. This is really frustrating, BUT, I just happened to figure out
that this can be solved using JavaCast(). I have never seen this explained
before (though it probably is somewhere), so I thought I would give it a
crack to share the power:

http://www.bennadel.com/blog/237-Setting-ColdFusion-Query-Cell-Values-With-J
avaCast-Fixes-Errors.htm

Finally my query of queries can rock it hardcore again!

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: YesNoFormat() is cool!

2006-08-31 Thread Ben Nadel
Yeah, I do that a good amount :(

Just the other day I came across RemoveChars(), which is exactly what my UDF
MidDelete() did ... It's sad to remake things just cause I  don't know they
already exist  .

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 30, 2006 9:38 PM
To: CF-Talk
Subject: Re: YesNoFormat() is cool!

Believe me - I see a lot of submissions to CFLib for stuff that already
exists. :)

On 8/30/06, Aaron Rouse [EMAIL PROTECTED] wrote:
 I did not discover it until around CF4.  Sometimes it is amazing how 
 long you stick with a known solution when a much better one is 
 integrated into the language.

 On 8/30/06, Ben Forta [EMAIL PROTECTED] wrote:
 
  Will, I believe that one was added back in CF2, although might have 
  been earlier. ;-)
 
  --- Ben
 
 
 

 --
 Aaron Rouse
 http://www.happyhacker.com/


 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: YesNoFormat() is cool!

2006-08-31 Thread Ben Nadel
Agreed. Everything IS a learning experience. I just hope that I don't start
forgetting the things I learned. 


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Robert Feyerherm [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 31, 2006 10:51 AM
To: CF-Talk
Subject: RE: YesNoFormat() is cool!

Ben,

You know everything is a learning experience, even if you learned that you
might want to check cflib first...hehe

-Robert

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 31, 2006 9:45 AM
To: CF-Talk
Subject: RE: YesNoFormat() is cool!

Yeah, I do that a good amount :(

Just the other day I came across RemoveChars(), which is exactly what my UDF
MidDelete() did ... It's sad to remake things just cause I  don't know they
already exist  .

.
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Rich text Editors

2006-08-31 Thread Ben Nadel
I am HUGE fan of XStandard. 

www.xstandard.com

 And my thoughts / experiences on it...

http://www.bennadel.com/blog/tags/15-XStandard-WYSIWYG-blog-entries.htm 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Tom King [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 31, 2006 11:28 AM
To: CF-Talk
Subject: Rich text Editors

Hi All,

Has anyone come across a Rich Text Editor which meets the following
requirements:

- Doesn't use inline styles, i.e p,em,i,h1,h2,h3,h4,h5,h6 only
- Could load an external CSS stylesheet so what you see in the RTE window
takes on the necessary styles of the website in which you're trying to edit
- Filters out cut and pasted formatting (but more specifically, word)
- Has html view
- Has an image browser to browse a predetermined image directory on the
server
- Could be used on Shared Hosting, so not a fully fledged CMS

I've found Widgeditor, which is almost there, but sadly not being developed
anymore.
Anything in Java/Flash which springs to mind?

I've got quite far using Widgeditor + Cffile/Directory for writing and
creating pages via a admin section, but it's not that user friendly..

Thanks all,

T




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Method for printing labels from browser?

2006-08-31 Thread Ben Nadel
Sometimes, to print labels, I do them all in a table then stream it to the
browser as an .MHT file. This is a web archive file that Microsoft Word will
open. MS Word should handle the lining up of the TDs well through out the
entire document. 

This only works if you are willing to open up MS word to print.

cfheader name=content-disposition value=attachement;
filename=labels.mht /
cfcontent type=application/ms-word /
 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 31, 2006 3:48 PM
To: CF-Talk
Subject: Method for printing labels from browser?

Hi, all.

I'm running a CF query and populating a browser with addresses using the MOD
3 code on a cell to create 3 columns, then trying to use a css
page-break-after command when the rows reach 30,
(3 columns of 10 labels per page) and trying to use MOD 30 to trigger the
page break.

I'm having trouble getting things to line up properly from page to page and
even getting the page break.

Anyone have any methods for printing labels from a browser or know of an
online info about that?

I'm close, but no joy so far.

Thanks,

Rick





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: CFLOCK problem

2006-08-31 Thread Ben Nadel
I would argue that that is not only a horrible abuse (LOCKING on SEVER to
set something in SESSION), but that this situation doesn't even need a lock
at all. The race condition here seems unimportant. In fact, it is locking
for one CFSET but not the other. Get rid of this lock.

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Ken [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 31, 2006 6:04 PM
To: CF-Talk
Subject: CFLOCK problem

Hi. I am analyzing another programmers code for possible code problems that
may be causing our servers to crash every so often, especially under high
traffic.

Can someone please tell if the code below is abusing the cflock. I am
thinking the cflock scope should be set to session instead of server scope.
Could this be responsible for crashing our CF server?

The code is:

cfif not parameterexists(session.ord)
cfif parameterexists(TEXTFIELD)
cflock scope=server type=exclusive timeout=3600 cfset session.ord =
#TEXTFIELD# /cflock cfelse cfset session.ord =  /cfif /cfif

Thanks,
K



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: SOT CSS issue

2006-08-30 Thread Ben Nadel
Quote the background image url Ex url( ../images/blam.gif );

Also reemember that URL are relative to the style sheet, NOT the calling
page. 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Victor Moore [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 30, 2006 1:27 PM
To: CF-Talk
Subject: SOT CSS issue

Hello,

I'm trying to replace my inline style with an external style sheet.

I have:
body bgcolor=#ff text=#00 leftmargin=0 topmargin=0
marginwidth=0 marginheight=0 background=images/form_bkg.gif

which displays fine

if I replace with:
body class=signform

and in signform.css I have
body.signform{margin:0px 0px 0px 0px; padding:0px; background: #ff;
background-image: url (images/form_bkg.gif)}

the background image is not displayed. I know that the style sheet is being
used because if I change the background color to something else that the
color on the form changes, but whatever I do I cannot get the background
image to display and I have run out of ideas.

Any idea what I'm doing wrong?

Thanks
Victor




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: GROUP BY error

2006-08-30 Thread Ben Nadel
You could either do something like selecting the content as a substring
(which will work in group by) or you could skip the Group BY and run  the
count as sub-query


SELECT
...
SUBSTRING(  clubroom.cb_content, 0, 1000 ) AS cb_content
...
FROM
...
GROUP BY
...
SUBSTRING(  clubroom.cb_content, 0, 1000 )
...


Or maybe...


SELECT
...
(
SELECT COUNT(*) FROM 
)
FROM
...
WHERE
...

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 30, 2006 6:37 PM
To: CF-Talk
Subject: GROUP BY error

Hi guys,

I have the following query...

SELECT clubroom.cb_id, clubroom.cb_dCreated, clubroom.cb_dModified,
clubroom.cb_content, clubroom.cb_isArchive,
COUNT(clubroom_images.cbi_id) AS image_count FROM clubroom LEFT OUTER JOIN
clubroom_images ON clubroom.cb_id = clubroom_images.cb_id GROUP BY
clubroom.cb_id, clubroom.cb_dCreated, clubroom.cb_dModified,
clubroom.cb_content, clubroom.cb_isArchive ORDER BY clubroom.cb_dCreated
DESC

And get the following error...

Error Executing Database Query.  
[Macromedia][SQLServer JDBC Driver][SQLServer]The text, ntext, and image
data types cannot be compared or sorted, except when using IS NULL or LIKE
operator. 

Now I have checked the elements and it appears that the error is relating to
the cb_content field which is a text field. When this is removed from the
query the query runs fine.

In order to use the COUNT function I need to have the GROUP BY ?? and I also
need the cb_content field.

Any help would be greatly appreciated by this SQL dummie!

Mike :o)





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: GROUP BY error

2006-08-30 Thread Ben Nadel
Sorry, I was on the phone for a bit:


SELECT 
r.cb_id, 
r.cb_dCreated, 
r.cb_dModified, 
r.cb_content, 
r.cb_isArchive,
(
SELECT
COUNT( * )
FROM
clubroom_images i
WHERE
i.cb_id = r.cb_id
) AS image_count
FROM 
clubroom  r
ORDER BY 
r.cb_dCreated DESC 


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Mike Little [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 30, 2006 6:39 PM
To: CF-Talk
Subject: Re: GROUP BY error

hmmm...

now i cannot get at my getArticles.image_count variable ??



 sort of like this?
 
 SELECT clubroom.cb_id, clubroom.cb_dCreated, clubroom.cb_dModified, 
 clubroom.cb_content, clubroom.cb_isArchive, (
   SELECT COUNT(cbi_id) AS image_count 
   FROM clubroom_images
 )
 FROM clubroom LEFT OUTER JOIN clubroom_images ON clubroom.cb_id = 
 clubroom_images.cb_id ORDER BY clubroom.cb_dCreated DESC
 
 thanks for the prompt response.
 
 Mike
:o)



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: COM and CF...

2006-08-29 Thread Ben Nadel
I was looking up VARIANT stuff when I was trying to mimic sending ASP
response objects... From what I remember (and I never figured it out
successfully) is that VARIANT data types can be many things. I don't think
there is any one VARIANT type... But I have never used it and could be
wy off base. 


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 29, 2006 11:33 AM
To: CF-Talk
Subject: COM and CF...

All,

I have a COM component but a method call seems to hang CF/Page  any idea
what CF object type I need to pass to a VARIANT in order for it to work?

ServerExecuteXml([in]VARIANT, [out,in,optional]VARIANT,
[out,in,optional]VARIANT, [out, retval]VARIANT)

What object type does CF need to generate for the VARIANT datatype to work??

N



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: select control

2006-08-29 Thread Ben Nadel
Wait, are you trying to narrow it down in CF or in the interface once the
page has been generated... If it's in the interface, then FireFox should
allow you to do this. IE 6 and earlier will only allow you to use the first
letter... But I hear that IE 7 will allow you to type in a whole value. 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Rusty Owens [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 29, 2006 11:28 AM
To: CF-Talk
Subject: select control

OK, this is strange question because I know I have done this in the past. I
have a standard html select control. I wrap the a query around the options
to pull values from a query. The values are numeric and I have them sorted
in ascending order. If there is a value in the record that I want to get to
immediately I am unable to do so. For example, if the number 28506 is a
value, I would like to start typing that number and narrow down to that
value but it isn't working. If I just have a loop and go from 1 to 3 and
loop through the query I able to do just that. If there something about
cfoutput that prevents this from working like this?



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: select control

2006-08-29 Thread Ben Nadel
I think maybe he is thinking about a COMBO box (as seen in standard desktop
applications)... There are hacks for this, but it is not built into HTML
Yet :) 


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 29, 2006 11:48 AM
To: CF-Talk
Subject: Re: select control

that's not the way an HTML select element works.  you can do it by typing
the first character of the option...but not drilling down by using
multiple characters.

i think there are some javascripts that will do it...possibly some sort of
AJAX...but it's not a behavior that's native to an HTML select.

On 8/29/06, Rusty Owens [EMAIL PROTECTED] wrote:
 OK, this is strange question because I know I have done this in the 
 past. I have a standard html select control. I wrap the a query around 
 the options to pull values from a query. The values are numeric and I 
 have them sorted in ascending order. If there is a value in the record 
 that I want to get to immediately I am unable to do so. For example, 
 if the number 28506 is a value, I would like to start typing that 
 number and narrow down to that value but it isn't working. If I just 
 have a loop and go from 1 to 3 and loop through the query I able 
 to do just that. If there something about cfoutput that prevents this 
 from working like this?

 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Peoples of the list..... arise and bring down my server!

2006-08-29 Thread Ben Nadel
 

 File not found: /wtomlinson/Store/contact.cfm

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: loathe [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 29, 2006 3:37 PM
To: CF-Talk
Subject: RE: Peoples of the list. arise and bring down my server!

https://www947.ssldomain.com/wtomlinson/Store/contact.cfm

404

 -Original Message-
 From: Will Tomlinson [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, August 29, 2006 3:25 PM
 To: CF-Talk
 Subject: Peoples of the list. arise and bring down my server!
 
 Could some of you folks hit my site and initialize my umpteen million 
 cfc's so I can see if it brings down my CrystalTech CF server?
 
 Add stuff to your cart, click around... just don't actually BUY 
 anything cause it's for real. :) I don't know how else to load test 
 this app other than a real world stampede.
 
 Thanks a ton as usual!
 
 The site is: www.thevolleyballclothingstore.com
 
 Will
 
 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: How to tell what template called a function?

2006-08-29 Thread Ben Nadel
I haven't done too much with this, but you could potentially use the
ServiceFactory to figure out which was the last template called. You would
have to call the code within your function, then query it to figure out
which was last... Not sure how they are ordered off hand.


!--- Create ColdFusion service factory. ---
cfset objFactory = CreateObject( java, coldfusion.server.ServiceFactory
) /

!--- Get the debugging service. ---
cfset objDebugging = objFactory.GetDebuggingService() /

!--- 
Get the events table. This includes all events that have taken
place, not just 
template executions. 
---
cfset qEvents = objDebugging.GetDebugger().GetData() /

cfdump var=#qEvents# / 


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Per Djurner [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 29, 2006 5:12 PM
To: CF-Talk
Subject: How to tell what template called a function?

Does anyone know if there is a way I can tell what template (and what
line) called a specific function?

Something along the lines of what you get in cfcatch.tagContext but without
having to throw an error to get it.

Maybe there is some magic under the hood Java that can be used to get the
info?

/ Per



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: How to tell what template called a function?

2006-08-29 Thread Ben Nadel
There is always GetBaseTemplatePath() and GetCurrentTemplatePath()... But
those are limited... 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Per Djurner [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 29, 2006 5:50 PM
To: CF-Talk
Subject: Re: How to tell what template called a function?

Thanks, it only works when debugging is enabled though.
Is there not a way to get this kind of info with debugging off?

On 8/29/06, Ben Nadel [EMAIL PROTECTED] wrote:
 I haven't done too much with this, but you could potentially use the 
 ServiceFactory to figure out which was the last template called. You 
 would have to call the code within your function, then query it to 
 figure out which was last... Not sure how they are ordered off hand.


 !--- Create ColdFusion service factory. --- cfset objFactory = 
 CreateObject( java, coldfusion.server.ServiceFactory
 ) /

 !--- Get the debugging service. ---
 cfset objDebugging = objFactory.GetDebuggingService() /

 !---
 Get the events table. This includes all events that have taken 
 place, not just
 template executions.
 ---
 cfset qEvents = objDebugging.GetDebugger().GetData() /

 cfdump var=#qEvents# /


 ...
 Ben Nadel
 www.bennadel.com
 Certified Advanced ColdFusion Developer

 Need Help?
 www.bennadel.com/ask-ben/


 -Original Message-
 From: Per Djurner [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, August 29, 2006 5:12 PM
 To: CF-Talk
 Subject: How to tell what template called a function?

 Does anyone know if there is a way I can tell what template (and what
 line) called a specific function?

 Something along the lines of what you get in cfcatch.tagContext but 
 without having to throw an error to get it.

 Maybe there is some magic under the hood Java that can be used to 
 get the info?

 / Per



 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: (Admin) New Hardware for House of Fusion

2006-08-28 Thread Ben Nadel
Sweeet :) 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 28, 2006 5:12 AM
To: CF-Talk
Subject: (Admin) New Hardware for House of Fusion

The entire House of Fusion website has been moved over to a new machine.
This is a dual CPU, 2 gig machine which should handle the increase in
traffic I've been seeing. If anyone sees any problems with the site, please
email me ASAP so I can make sure it's fixed. 

Thanks



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: regex help

2006-08-28 Thread Ben Nadel
Try this:

#REReplaceNoCase(
a href=this,that and the otherword/a,
(a[^]*)((?!/a).)*?(/a[^]*),
\2,
ALL
)#

That uses a negative look ahead... I can't remember if that is supported in
CF directly or not. If it is not, try this:

#REReplaceNoCase(
a href=this,that and the otherword/a,
(a[^]*)(.)*?(/a[^]*),
\2,
ALL
)#


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 28, 2006 8:12 AM
To: CF-Talk
Subject: regex help

Was wondering how I would strip out everything between

a href=this,that and the otherword/a and just leave the word?


Any ideas



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: regex help

2006-08-28 Thread Ben Nadel
Ok cool, then it's look behinds that are not supported. I know one of them
is not supported. 

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 28, 2006 9:19 AM
To: CF-Talk
Subject: Re: regex help

ColdFusion MX supports positive and negative look aheads.

Try this:

#REReplaceNoCase(
   a href=this,that and the otherword/a,
   (a[^]*)((?!/a).)*?(/a[^]*),
   \2,
   ALL
)#

That uses a negative look ahead... I can't remember if that is 
supported in CF directly or not. If it is not, try this:

#REReplaceNoCase(
   a href=this,that and the otherword/a,
   (a[^]*)(.)*?(/a[^]*),
   \2,
   ALL
)#


..
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Monday, August 28, 2006 8:12 AM
To: CF-Talk
Subject: regex help

Was wondering how I would strip out everything between

a href=this,that and the otherword/a and just leave the word?


Any ideas



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: (Admin) New Hardware for House of Fusion

2006-08-28 Thread Ben Nadel
 
Michael,

If you need a spare desk to sit at for a day or two, you are always welcome
at Nylon. 212.691.1134.

...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/


-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 28, 2006 8:25 AM
To: CF-Talk
Subject: Re: (Admin) New Hardware for House of Fusion

Only if I iron out the little issues of back and forth mail server/site
caching, logging and a few other misc fun things. That and put a new,
non-Google banner on the site to get editorial assistants/interns and all
this while some contractor tears down the ceiling of my home office. Fun

Anyone have a spare desk in the NY area for me for the next day or so?

Sweeet :)

..
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Monday, August 28, 2006 5:12 AM
To: CF-Talk
Subject: (Admin) New Hardware for House of Fusion

The entire House of Fusion website has been moved over to a new machine.
This is a dual CPU, 2 gig machine which should handle the increase in 
traffic I've been seeing. If anyone sees any problems with the site, 
please email me ASAP so I can make sure it's fixed.

Thanks



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Frameworks Conf 2006 Call for Speakers due 9/29/06

2006-08-28 Thread Ben Nadel
Hey, I didn't see anything on the site about costs or anything... Is that
info available yet? 


...
Ben Nadel 
www.bennadel.com
Certified Advanced ColdFusion Developer

Need Help?
www.bennadel.com/ask-ben/

-Original Message-
From: Michael Smith [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 28, 2006 4:19 PM
To: CF-Talk
Subject: Frameworks Conf 2006 Call for Speakers due 9/29/06

The Frameworks 2007 conference will be located in the Washington DC area, in
January/February 2007. We will have lots of great speakers like last year
(including Hal Helms and Michael Smith) and we also want to get your ideas
for new speakers on fresh topics too. This year in addition to Fusebox and
FLiP we will have sessions on other frameworks such as Mach-ii, Model-Glue,
Ruby On Rails and others.
We also want to include .Net and Java frameworks and methodologies.
I think there is a great opportunity for learning from foreign frameworks
and cross pollination :-)

If you are either interested in speaking yourself or have a suggestion for a
topic, please submit your topic by Friday 9/29/06 5pm at

http://www.frameworksconference.com/


*
Fusebox and Frameworks Conference
January/February 2006 TBA
Washington DC
http://www.frameworksconference.com/
*



--
Michael Smith, TeraTech Inc - Tools for Programmers(tm) TeraTech voted Best
Consulting Service by CFDJ readers!
CF/ASP Web, VB, Math, Access programming tools and consulting
405 E Gude Dr Ste 207, Rockville MD 20850 USA Please check out
http://www.teratech.com/ - email mailto:[EMAIL PROTECTED], or call us for
more information; in the USA at 1-800-447-9120,
+1-301-424-3903 International, Fax 301-762-8185  Thanks!






~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Cross Joins and lists and forms oh my!

2006-08-25 Thread Ben Nadel
Maybe you could go with a join on persons to countries and a join on persons
to zip:

Contact_zip_jn
 -contact_id,
 -zip_id

contact_country_jn
  -contact_id
  -country_id


That way, you can categorize them in both ways with out having them to
overlap. Depends on how complicated you queries need to be. Like, if a
person is joined to a country, do they ALSO have to be joined to all those
zip codes? Or is it ok for the application to store only explicitly set up
joins?

...
Ben Nadel 
www.bennadel.com


-Original Message-
From: Richard Dillman [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 25, 2006 1:55 PM
To: CF-Talk
Subject: SOT: Cross Joins and lists and forms oh my!

In my endevors to build this table structure for my Fostercare site we have
a list of County Contacts spacific to each county.  I have a cross join
table to match county ID's, Contacts,  County Rolls and weather they recieve
emails.  Of course now there is a snag and a spacific county wants to split
up their county by zipcode.

I do  have a zipcode table with Zip, county, city, state, area code,
daylight saveings time, and Time Offset.

the long and short of it is i have
1032 zipcodes
93 Counties
10 Positions

If i had to store a person who is over say 3 counties (which is 200+
 zipcodes) how might i best go about inserting him and selecting the
appropriate zipcodes?  Same for someone who is over the North East Quardrant
of a spacific County (just 5 zipcodes)

Im leaning twards a Stored prcedure that will include all zips in a county
and letting them select a whole county,  and/or showing  div to show
checkboxes for all the zips in that county should they want a partial.

What would any of you do in this case?

/rant

--
--
Richard Dillman
[EMAIL PROTECTED]
(317) 916-8341

I think it's T double-E double-R double-R double-I double-F double-I
double-C, C, C. - the Goose in 'Charlotte's Web'




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Top 100 ColdFusion Programmers

2006-08-24 Thread Ben Nadel
I think the key is well-rounded Most of us cannot just know CF... We
have to know HTML, css, javascript... We have to know how to cut up images
and make templates. 

One of the things I like to do in an interview is ask the interviewee what
they love most about ColdFusion. Most people, in my experience, will just
tell you that they love the easy of development. But the second you get
someone who gets all gushy about how awesome query of queries is or how
useful it is that CF is built on top of Java, these should be flags that
this person knows there stuff. 

That's how I *find* good programms... As far as who are the best one's out
there??? Just take a look at the the peole on Fullasagood.com or
feed-squirrel.com... There are a lot of regulars that post about frameworks,
OOP, and real architecture type stuff that is, IMO, way beyond the level
that most of us function at ( I won't list names cause I don't want to leave
anyone out ). 

...
Ben Nadel 
Adobe Certified Advanced ColdFusion Developer
www.bennadel.com


-Original Message-
From: Block, Jon [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 24, 2006 1:45 PM
To: CF-Talk
Subject: Top 100 ColdFusion Programmers

When hiring, it would be helpful to know who out there is the best. When I
run ads, I get all types of Yahoo's who think they know ColdFusion.
I'd like to be able to see who are the very best ColdFusion coders out there
and try to steal one of them for my company. How do you guys find the
absolute best coders when hiring?

If you want to put comments on my blog, that'd be nice.
http://jonathanblock.com/blog/jonsblog/100bestcoldfusionprogrammers

Jon
(ps - if you are a recruiter, DO NOT contact me)




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Cold Fusion growth

2006-08-24 Thread Ben Nadel
Unofficially, it is growing very well If you can get Michael Dinowitz to
tell you how many NEW visitor his up Houseoffusion.com looking for
coldfusion info. It in the thousdands a day I think. I can't tell you one
way or another, but that might be a good indication of the general interest
in ColdFusion. 


...
Ben Nadel 
www.bennadel.com


-Original Message-
From: Robert Walters [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 24, 2006 4:55 PM
To: CF-Talk
Subject: Cold Fusion growth

Anyone have info on if Cold Fusion is seeing any growth of usage and if Cold
Fusion programmers are increasing or decreasing in general?

Thanks...Rob



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: CFQUERY of non-swequential primary key ids

2006-08-23 Thread Ben Nadel
I am not sure why you are doing the second query... Why make the
*randomization* more complicated than it has to be???

Simplify:

!--- GET 2ND VALUE TO BE PASSED TO RANDRANGE ---
CFQUERY name=get_vids_a datasource=#datasource# maxrows=1
select 
vidwee_id
from 
vidweek
/CFQUERY

 CFQUERY name=get_vids2 datasource=#datasource#
   select vow_up_lgnail_file,vidwee_id,vow_title
   from vidweek
   where vidwee_id = #get_vids_a[ vidwee_id ][ RandRange( 1,
get_vids_a.RecordCount ) ]#
   /CFQUERY

CFSET lgthbimg = #get_vids2.vow_up_lgnail_file#

img src=VideoOfTheWeek/home/cfoutput#lgthbimg#/cfoutput width=262
height=231 border=0


...
Ben Nadel 
www.bennadel.com

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 23, 2006 12:14 PM
To: CF-Talk
Subject: CFQUERY of non-swequential primary key ids

All,

I'm doing a query and randomly displaying images from within each record but
records have been removed so I don't have sequential id values.

PROBLEM:
When I run this code sometime I get images, sometimes I get nothing. 
Should I be running a different random'izer? 8-) Any ideas?

CODE:
   !--- GET 2ND VALUE TO BE PASSED TO RANDRANGE ---
   CFQUERY name=get_vids_a datasource=#datasource# maxrows=1
   select *
   from vidweek
   order by vidwee_id desc
   /CFQUERY
   !--- GET 1ST VALUE TO BE PASSED TO RANDRANGE ---  CFQUERY
name=get_vids_b datasource=#datasource# maxrows=1
   select *
   from vidweek
   order by vidwee_id asc
   /CFQUERY
   cfset VAL_ID = #RandRange(get_vids_b.vidwee_id, get_vids_a.vidwee_id,
SHA1PRNG)#
   !--- USE THAT ID VALUE TO SET IMAGE NAME ---
   CFQUERY name=get_vids2 datasource=#datasource#
   select vow_up_lgnail_file,vidwee_id,vow_title
   from vidweek
   where vidwee_id = #VAL_ID#
   /CFQUERY
CFSET lgthbimg = #get_vids2.vow_up_lgnail_file#

img src=VideoOfTheWeek/home/cfoutput#lgthbimg#/cfoutput width=262
height=231 border=0



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: CFQUERY of non-swequential primary key ids

2006-08-23 Thread Ben Nadel
Let's get jiggy with it and get even simpler... ONE database call:

 CFQUERY name=get_vids2 datasource=#datasource#
   select  TOP 1
vow_up_lgnail_file,
vidwee_id,
vow_title
   from 
vidweek
   order by
newid() ASC
/CFQUERY


This leverages the *randomness* of MS SQL's UUID creator - newid() - and TOP
1.

Not sure if this works on anything but MS SQL server.

...
Ben Nadel 
www.bennadel.com


-Original Message-
From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 23, 2006 12:47 PM
To: CF-Talk
Subject: RE: CFQUERY of non-swequential primary key ids

How very inefficient. How about something like this: 

cfquery name=get_vid_ids datasource=#datasource# SELECT vidwee_id FROM
vidweek /cfquery

cfset idList=valueList(get_vid_ids.vidwee_id)

cfset idPosition=randRange(1,listLen(idList),SHA1PRNG)

cfset VAL_ID=listGetAt(idList,idPosition)

CFQUERY name=get_vids2 datasource=#datasource#
   select vow_up_lgnail_file,vidwee_id,vow_title
   from vidweek
   where vidwee_id = #VAL_ID#
/CFQUERY

CFSET lgthbimg = #get_vids2.vow_up_lgnail_file#


There is also a function on CFLIB to randomly select rows from a database
table:

http://www.cflib.org/udf.cfm?id=524

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Sent: Wednesday, August 23, 2006 12:14 PM
To: CF-Talk
Subject: CFQUERY of non-swequential primary key ids

All,

I'm doing a query and randomly displaying images from within each record but
records have been removed so I don't have sequential id values.

PROBLEM:
When I run this code sometime I get images, sometimes I get nothing. 
Should I be running a different random'izer? 8-) Any ideas?

CODE:
   !--- GET 2ND VALUE TO BE PASSED TO RANDRANGE ---
   CFQUERY name=get_vids_a datasource=#datasource# maxrows=1
   select *
   from vidweek
   order by vidwee_id desc
   /CFQUERY
   !--- GET 1ST VALUE TO BE PASSED TO RANDRANGE ---  CFQUERY
name=get_vids_b datasource=#datasource# maxrows=1
   select *
   from vidweek
   order by vidwee_id asc
   /CFQUERY
   cfset VAL_ID = #RandRange(get_vids_b.vidwee_id, get_vids_a.vidwee_id,
SHA1PRNG)#
   !--- USE THAT ID VALUE TO SET IMAGE NAME ---
   CFQUERY name=get_vids2 datasource=#datasource#
   select vow_up_lgnail_file,vidwee_id,vow_title
   from vidweek
   where vidwee_id = #VAL_ID#
   /CFQUERY
CFSET lgthbimg = #get_vids2.vow_up_lgnail_file#

img src=VideoOfTheWeek/home/cfoutput#lgthbimg#/cfoutput
width=262 height=231 border=0





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: cfexecute problem...

2006-08-23 Thread Ben Nadel
What happens if you run this same command from the command line manually,
outside of CF, does anything weird happen? 


...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com
 
Some people call me the space cowboy. Some people call me the gangster of
love.

-Original Message-
From: Gabriel Bulfon [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 23, 2006 3:03 PM
To: CF-Talk
Subject: Re: cfexecute problem...

I don't know why, but the cfexecute or a command that i run (exp, from
oracle) don't release the file handler.




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Figuring out significant digit.

2006-08-23 Thread Ben Nadel
I remember significant digits... Ahh, that takes me back to Introductory
Physical Science in 8th grade :) 

This doesn't quite work... But it might give you some ideas:

Where INTVALUE ist he number you are getting the percentage of (ex. 93, 1.1,
14) and .75 is the percentage in the equation.


cfset intValue = 14 /
cfset intDiv = (10 * (Len(intValue) - 1)) /


#(NumberFormat((intValue * .75 ) / intDiv, 0.  RepeatString(0,
Len(intValue) - 1)) * intDiv)#


Its rounding up... I can't remember the rules to sig-digits...

...
Ben Nadel 
www.bennadel.com


-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 23, 2006 4:22 PM
To: CF-Talk
Subject: Figuring out significant digit.

This is a bit unusual.  I want to figure out 75% of a given number and then
round | floor | ceiling this number to a significant digit of the number.
This is probably best described with examples.

75% of 93 = 69.75 floor to 60.
75% of 1.1 = 0.825 floor to 0.8
75% of 14 = 11.25 floor to 10
75% of .001 = 0.00075 floor to 0.0007
 
I am creating a series of charts from dynamic data.  I want to set the
minimum value of the chart based on a percentage of the minimum value being
displayed.  But I don't want to use values like 0.825 when my data is 1.1,
..9,1.3 ect.

Does this make sense?  I would also like to do a similar thing to set the
top of the chart axis by adding 10% to the max value of the data series.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any attachments is for the
sole use of the intended
recipient(s) and may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient, please contact the sender and delete any
copies of this message. 





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: To float or not, that is the question.

2006-08-23 Thread Ben Nadel
The display should change automatically in all the new generation browsers
that I have seen. You might be getting Javascript errors or there might be
something like a br clear=all / after it that is negating the effects.

...
Ben Nadel 
www.bennadel.com


-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 23, 2006 6:10 PM
To: CF-Talk
Subject: To float or not, that is the question.

Or more accurately, if one where to change the float state dynamically with
JavaScript, would one expect the display to be redrawn?

I'm playing with a concept where I have elements that initially start out
un-floated.  But I have a control that changes the state of the state of the
float property to left with [object].style.float = 'left'.  This does not
seem to trigger a change in the appearance of the content in the browser.

If this is not the way it is supposed to work, is there someway to work
around it?


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any attachments is for the
sole use of the intended
recipient(s) and may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient, please contact the sender and delete any
copies of this message. 





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: CFIdea: how to implement

2006-08-22 Thread Ben Nadel
Thank Rob :) 

...
Ben Nadel 
www.bennadel.com


-Original Message-
From: Robert Feyerherm [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 22, 2006 8:38 AM
To: CF-Talk
Subject: RE: CFIdea: how to implement

I think Ben's idea is great.  I also think it might be cool if when you did
return that page you returned a gif or jpeg graphic that was like a smiley
face and some text that said, X Points Awarded or something like that.  

-Robert

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 22, 2006 7:31 AM
To: CF-Talk
Subject: RE: CFIdea: how to implement

I say go really really simple. At the bottom of the article page include
some javascript like this:

script type=text/javascript

setTimeout(
// Function to get called after 60 seconds.
function(){
var imgRequest = new Image();

imgRequest.src =
reward_user.cfm?id=#...#article_id=#...#key=#Hash( SESSION.CFID 
SESSION.CFTOKEN  id  article_id )#
},

// Run after 60 seconds
60 * 1000
);

/script 


This would, after 60 seconds, create an image and then try to set it's
source to a CFM page. This would in essence call that CFM page. The image
would break (or you could return a gif based on CFContent). The
reward_user.cfm page would reward the user based on the user id (id), the
article id (article_id) and a key (the HASH value). The HASH value is meant
to help stop anyone else from guessing a reward URL. Then on the
reward_user.cfm page, you would want to make sure you never credited someone
twice I suppose. 

.
Ben Nadel
www.bennadel.com


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Sent: Monday, August 21, 2006 11:03 PM
To: CF-Talk
Subject: CFIdea: how to implement

I have a CFidea and I wanted to seek advice on the best way to implement
it.
I'm concerned that this idea will be taxing on my shared web hosting
server.

After buildinig sites for employors and contracts, I've finally built a
site
for myself.
My site is a news and downloadable magazine (which I sell for $9.95/yr) 

THE IDEA
On my site(s), I posts related stories from within my industry. I want
to
reward my readers and build loyalty. I want to reward my readers for
each
story they read with X point(s).  As long as they stay on the page for
more
than 10-15 (?) seconds they will be rewarded. I want to track this to
avoid
users from just clicking through stories to get points.  Once they
accumulate x number of points, they will receive one of the four issues
for
free. If they collect enough points, they can get an entire year for
free
and earn additional issues beyond their first year or give their points
to
friends or co-workers. When visitors reads stories from my site, my
google
ads are displayed which makes me money. I also want to convey to
potential
advertisers that our we reward our reader base.  No other news site
within
this industry does this.  

THE CODE
The reader signs up by providing only their e-mail address and confirm
their
e-mail address through an automated reply from my site with a
confirmation
link they must click on. 
As an option if they want to earn reward points, I ask them to sign in
with
just their e-mail address to initiate and track their points, then get
the
current time with #CreateODBCDateTime(now())# and store it as a session
variable. When they click and go to another page on the site, even if
it's
not a story, capture the #CreateODBCDateTime(now())# again and compare
the
times and update their profile with X point(s) if the time difference
meets
my x seconds per page criteria. If someone just rapidly clicks from
story to
story to accumalate points, the points will not be counted. If they like
the
site and decide to become a loyal reader, then they will receive these
additonal benefits and be rewarded for their loyalty.

Thoughts on the coding approach?

Thanks in advance.

D-







~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RSS feeds and # sign

2006-08-22 Thread Ben Nadel
I just started getting an Xml Parse error on my RSS feed... I narrowed the
problem down to the fact that one of the titles had # signs in it. I don't
quite understand the error, so I was hoping someone could help me out.

I originally had:

title#XmlFormat( REQUEST.EntryQuery.name )#/title

This caused errors and now I have:

title#XmlFormat( Replace( REQUEST.EntryQuery.name, ##, , ALL )
)#/title

This seems to be fine. But shouldn't XmlFormat() escape any characters that
cause errors. I don't like the idea of having to use Replace() and was
hoping someone could point me in the right directions.

Thanks!

...
Ben Nadel 
www.bennadel.com


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: RSS feeds and # sign

2006-08-22 Thread Ben Nadel
I am thinking that maybe this is not the error... Even with that line, I get
an error sometimes!!! 

...
Ben Nadel 
www.bennadel.com

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 22, 2006 10:26 AM
To: CF-Talk
Subject: RSS feeds and # sign

I just started getting an Xml Parse error on my RSS feed... I narrowed the
problem down to the fact that one of the titles had # signs in it. I don't
quite understand the error, so I was hoping someone could help me out.

I originally had:

title#XmlFormat( REQUEST.EntryQuery.name )#/title

This caused errors and now I have:

title#XmlFormat( Replace( REQUEST.EntryQuery.name, ##, , ALL )
)#/title

This seems to be fine. But shouldn't XmlFormat() escape any characters that
cause errors. I don't like the idea of having to use Replace() and was
hoping someone could point me in the right directions.

Thanks!


Ben Nadel
www.bennadel.com




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: RSS feeds and # sign

2006-08-22 Thread Ben Nadel
I figured it out... The page was timing out and it was showing a Cerro at
the bottom of the page. Now I just have to figure out why the page is timing
out sometimes and running instantly other times :(

...
Ben Nadel 
www.bennadel.com

-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 22, 2006 10:26 AM
To: CF-Talk
Subject: RSS feeds and # sign

I just started getting an Xml Parse error on my RSS feed... I narrowed the
problem down to the fact that one of the titles had # signs in it. I don't
quite understand the error, so I was hoping someone could help me out.

I originally had:

title#XmlFormat( REQUEST.EntryQuery.name )#/title

This caused errors and now I have:

title#XmlFormat( Replace( REQUEST.EntryQuery.name, ##, , ALL )
)#/title

This seems to be fine. But shouldn't XmlFormat() escape any characters that
cause errors. I don't like the idea of having to use Replace() and was
hoping someone could point me in the right directions.

Thanks!


Ben Nadel
www.bennadel.com




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: What is the easiest way to get the true length of a list.

2006-08-22 Thread Ben Nadel
Young Jedi,

Be careful with the Java split method... In your example, the length is
indeed 4... However, this:

cfset lst = jedi,homer,,, /
#ArrayLen(lst.split(,))#

Only has TWO array elements. It seems to only count list items until no more
valid items are found. This seems to be confirmed at the bottom of:

http://www.rgagnon.com/javadetails/java-0438.html

An interesting thing about String.split():

  s.split( ) - {,,s}
.split( )- {}
 .split( )   - {} (!)
   .split( ) - {} (!)
  s .split( )- {,,s} (!) 


...
Ben Nadel 
www.bennadel.com

-Original Message-
From: JediHomer [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 22, 2006 1:25 PM
To: CF-Talk
Subject: Re: What is the easiest way to get the true length of a list.

You could possibly do something like...

cfset lst = jedi,homer,,rocks /
cfoutput#ArrayLen(lst.split(,))#/cfoutput

Which will output 4 and not 3


HTH



On 22/08/06, Ian Skinner [EMAIL PROTECTED] wrote:
 Counting all the elements, including the empty ones?

 Do I need to modify the list to put some throwaway character to get all
the elements counted, or is there a better way?

 For Example:  listLen(This is an Element,,) needs to equal 3.

 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA

 -
 | 1 |   |
 -  Binary Soduko
 |   |   |
 -

 C code. C code run. Run code run. Please!
 - Cynthia Dunning

 Confidentiality Notice:  This message including any attachments is for 
 the sole use of the intended
 recipient(s) and may contain confidential and privileged information. 
 Any unauthorized review, use, disclosure or distribution is 
 prohibited. If you are not the intended recipient, please contact the 
 sender and delete any copies of this message.



 



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: grabbing remote images

2006-08-22 Thread Ben Nadel
I have done some work with CFHTTP... This might help point you in the right
direction:

Ask Ben: CFHttp For Web Mining And Image Hot Linking
http://www.bennadel.com/index.cfm?dax=blog:134.view

Image Hot Linking Work-Around (Full Demo)
http://www.bennadel.com/snippets/13-Image-Hot-Linking-Work-Around-Full-Demo-
..htm


This will help get you one image at a time  via CF... However, it can't get
you a list of file names unless there are links.

If there are links though, I am sure there are even better Desktop solutions
like Offline Explorer than can browser a site and safe all the content to
a folder on your computer.

...
Ben Nadel 
www.bennadel.com


-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 22, 2006 5:15 PM
To: CF-Talk
Subject: SOT: grabbing remote images

Hey All,

We have a client that is having issues with their hosting
companyessentially data and images are being held hostage.

So the situation is that we MAY be able to get the data we are after, but
the way they store images causes us a problem.  The images are stored in the
file system and the data contains file names.  So even if we get the data we
don't have the macthing files.

We can of course reproduce the URL that the images reside at.

So does anyone have an automated method of grabbing those images form a
remote URL and saving them to our server's file system?

I honsetly can't think of whether or not this is doable via CFHTTP...it's
been so long since I used it.

Anyways...thanks in advance for any bright ideas.  I'm swamped right now and
creative thinking is eluding me ;-)

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: grabbing remote images

2006-08-22 Thread Ben Nadel
Yeah, give it a look over. If you think an offline-explorer type situation
will not work with your setup, you can certainly jimmy up some CFHttp to
save the images. 

...
Ben Nadel 
www.bennadel.com


-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 22, 2006 5:42 PM
To: CF-Talk
Subject: Re: grabbing remote images

Thanks Ben,

I'll read what you sent me shortly...

I just want to be clear though this is NOT a site grabbing situation (it's
dynamic and AFAIK the desktop apps for site ripping may not work on dynamic
sites...I could of course be wrong).

We will have the table that contains the image file names.

We have the URL that those images can be located at (plus the file name from
the
table)

Combined we can reference the images directly (i.e. 
www.domainName.com/images/imageNameFromDB)

From that I need to be able to save the remote image locally (on our 
Dev server
that is).

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: grabbing remote images

2006-08-22 Thread Ben Nadel
My examples were regarding hotlinking, but the issue is the same... Grab the
image URL as a binary return object... Then you can either save it
yourself... Or even better yet perhaps, you can use the FILE attribute of
CFHttp and have it save the binary response for you??

cfhttp 
url=http://static.flickr.com/84/221928348_bfcf7fe4cd.jpg?v=0; 
method=GET 
useragent=Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
rv:1.8.0.2) Gecko/20060308 Firefox/1.5.0.2 
getasbinary=yes
result=objGrab

cffile 
action=WRITE 
file=#ExpandPath( './test_girl.jpg' )# 
output=#objGrab.FileContent# 
addnewline=false 
fixnewline=false
/

cfdump var=#objGrab# / 


...
Ben Nadel 
www.bennadel.com

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 22, 2006 5:46 PM
To: CF-Talk
Subject: Re: grabbing remote images

Yep...as I suspected Ben...your examples are for hot linking only and do not
provide me with a local copy of the image file.

That saidnice workaround with the referrer params!

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: hash()

2006-08-21 Thread Ben Nadel
I have not as I don't think this is built into ColdFusion directly. If you
can, find someone who has worked with Google Checkout, as I believe they
need to do just that in order to encrypt the the shopping cart XML. In fact,
you might want to try looking at the Google Checkout documentation, as they
might have CF examples.

...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com
 
Some people call me the space cowboy. Some people call me the gangster of
love.

-Original Message-
From: R J Kvamme [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 21, 2006 10:37 AM
To: CF-Talk
Subject: hash()

Has anyone used Hash() in combonation with a private key todigitally sign
some xml?

Thanks

Rolf





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: URL var encoding/decoding in CF6.1

2006-08-21 Thread Ben Nadel
What about:

UrlEncodedFormat( Encrypt( URL.somevalue, my_key ) )  

Then

UrlDecode( Decrypt( URL.somevalue, my_key ) )


...
Ben Nadel 
www.bennadel.com

-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 21, 2006 11:08 AM
To: CF-Talk
Subject: URL var encoding/decoding in CF6.1

Hey gang,

I'm looking for a good, simple solution to encode one or more URL variables,
pass them through, and decode them. URLEncodedFormat() etc isn't what I
need, as I want to obfuscate the contents of the vars.

I see CharEncode() and CharDecode() would likely do the trick for me, but
alas, we're not on CF 7. We're still running 6.1.

I poked around the DevEx as well and didn't find anything that caught my
eye.

Any helpful nudges would be greatly appreciated.
--Scott



~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: cfquery: search numeric IN/Contains/Like

2006-08-21 Thread Ben Nadel
Paul,

I am not sure if you want to get the subset to match in the DB or in the CF
variable???

You could always loop over the WHERE items.

SELECT
*
FROM
[table]
WHERE
1 = 0

cfloop index=i list=#FORM.search#
OR
CAST( ClientID AS VARCHAR(12)) LIKE '%i%'
/cfloop


The above will match PART of the search form in the FULL id in the database.
I guess you might be able to go the other way as well:


SELECT
*
FROM
[table]
WHERE
1 = 0

cfloop index=i list=#FORM.search#
OR
'i' LIKE '%' + CAST( ClientID AS VARCHAR(12)) + '%'
/cfloop


This will match part of the database ID in the search form...


I have NOT tested this... But maybe It can give you some ideas.


...
Ben Nadel 
www.bennadel.com


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 21, 2006 4:34 PM
To: CF-Talk
Subject: cfquery: search numeric IN/Contains/Like

i cant get the IN/CONTAINS to work on searching a numeric field.
i can can get the result if the passed value is the exact Number.
but if i want the subset of a number or any results with 1300 then i cant
get it to work.

i have googled it, every way i can think

cfquery name=ClientList_Query dbtype=query SELECT * FROM
ClientList_Query1 WHERE 0 = 0

!--- Search by ClientID ---
cfif FORM.search IS NOT 
 AND ClientID IN (#FORM.search#)
/cfif

ORDER BY #DefOrder# #URL.OrderByType#
/cfquery




~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


RE: Encrypted data insert

2006-08-21 Thread Ben Nadel
You could maybe use UrlEncodedFormat() after the encypt... This will escape
the characters... Its not intuitive, but it should work. You might want to
also try another algorithm, but I am not that experienced with encryption. 

...
Ben Nadel 
www.bennadel.com


-Original Message-
From: Josh Nathanson [mailto:[EMAIL PROTECTED] 
Sent: Monday, August 21, 2006 5:21 PM
To: CF-Talk
Subject: Encrypted data insert

Hey all,

I am trying to insert an encrypted string into a MySQL database.  When
inserted, the db seems to add extra characters on the end of the encrypted
string, which makes it so that the string cannot be decrypted successfully. 
It seems to add a couple of spaces plus the dreaded box character.  Is there
some sort of encoding issue perhaps?  Anyone run into this before?  If I use
some combination of the encoding and algorithm attributes will it take care
of this issue?

Yes it's a cc number, and yes I know you're not supposed to store cc
numbers, even encrypted, but unfortunately in the real world it must be done
sometimes.

-- Josh





~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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


<    1   2   3   4   5   6   7   8   9   10   >