Re: Passing arguments into base class

[Jason Durham]

I tried to answer this twice but neither of my previous emails went
through.  I'm trying from another account.

Byron's last example passing the value from the child object to the parent
definitely works.  I'm not sure what's in your Util class, but the name of
it seems to imply using it as a mixin is the avenue I'd take.


Jason Durham

On Fri, Feb 6, 2015 at 1:23 PM, Byron Mann byronos...@gmail.com wrote:


 This might work, if I'm understanding.

 component name='baseClass' {

   variables.utilClass = '';

public any function init(utilClass utilClass){
  variables.utilClass = arguments.utilClass;
   }

 }

 In your derived class you can do this.

 component extends='baseClass'{
   public any function init(utilClass utilClass){
 super.init(argumentCollection=arguments);
   }
 }


 

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

SSL certificate problem with 3rd party

[Jason Durham]

A payment processor changed one of their certificates which is causing CF
to throw an exception when we try to connect via CFHTTP using SSL.

The error message is: *I/O Exception: Name in certificate
`internetsecure.com http://internetsecure.com' does not match host name
`test.internetsecure.com http://test.internetsecure.com'*

You can view the certificate by navigating to
https://test.internetsecure.com.  My browser doesn't seem to have problems
with this cert, and I see a SAN that indicates this certificate should be
valid for test.internetsecure.com.

I've tried importing this cert into the keystore but received the same
error.

Can anyone provide assistance as to why CF 8.0.1 isn't happy with this
certificate?

Jason Durham


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

Coldspring docs?

[Jason Durham]

Coldspringframework.org is down.  Are the docs for 1.2 hosted somewhere
that is currently accessible?  I already found the 2.0 docs on
SourceForge.net.

Jason Durham


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

Re: Access laptop from iPad

[Jason Durham]

In most cases in typical home networks, all you need to do is configure the
firewall(s) on the computer acting as a web server.
On May 20, 2012 12:47 PM, Andrew Grosset rushg...@yahoo.com wrote:


 I have Railo, mysql etc running on my laptop which I access using the url:
 http://127.0.0.1: (using a home wireless network)

 I would like to be able to access the same url on my iPad or iPhone using
 my home wireless network, just wondering how you recommend setting this up?

 Andrew

 

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

Re: Access laptop from iPad

[Jason Durham]

BTW, you won't be able to use the exact same URL as what you provided.
You'll want to set a static IP (or DHCP reservation) for the web server and
use that IP for the URL.
On May 20, 2012 12:50 PM, Jason Durham jqdur...@gmail.com wrote:

 In most cases in typical home networks, all you need to do is configure
 the firewall(s) on the computer acting as a web server.
 On May 20, 2012 12:47 PM, Andrew Grosset rushg...@yahoo.com wrote:


 I have Railo, mysql etc running on my laptop which I access using the
 url: http://127.0.0.1: (using a home wireless network)

 I would like to be able to access the same url on my iPad or iPhone using
 my home wireless network, just wondering how you recommend setting this up?

 Andrew

 

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

Re: Cheap CF9 Hosting

[Jason Durham]

I've used them. No complaints.
On Jul 31, 2011 9:23 PM, Chad Baloga cbal...@gmail.com wrote:

 I am looking for a cheap place to host a site with CF9. This is just a
site I am making for my family. Has anyone has any problems with
http://hostek.com? Thanks

 

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

Re: Cheap CF9 Hosting

[Jason Durham]

I've used them. No complaints.
On Jul 31, 2011 9:23 PM, Chad Baloga cbal...@gmail.com wrote:

 I am looking for a cheap place to host a site with CF9. This is just a
site I am making for my family. Has anyone has any problems with
http://hostek.com? Thanks

 

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

Re: Tutorials using CF Builder 2

[Jason Durham]

My guess is they sell waaay more DW licenses.

Jason Durham


On Wed, Jun 29, 2011 at 12:43 PM, Rick Faircloth
r...@whitestonemedia.comwrote:


 I never did respond to you Wil... sorry.

 I don't need to know how to use CFB 2,
 but would like some of the toturials from
 Adobe to use CFB 2, instead of Dreamweaver
 as the IDE.

 I couldn't find even one.

 Rick

 -Original Message-
 From: Wil Genovese [mailto:jugg...@trunkful.com]
 Sent: Monday, June 27, 2011 1:18 PM
 To: cf-talk
 Subject: Re: Tutorials using CF Builder 2


 The Start Page in ColdFusion Builder 2 has many of such resources.

 This blog post of mine details these.


 http://www.trunkful.com/index.cfm/2011/3/25/Getting-Started-ColdFusion-Build
 er-2



 Wil Genovese
 Sr. Web Application Developer/
 Systems Administrator
 CF Webtools
 www.cfwebtools.com

 wilg...@trunkful.com
 www.trunkful.com

 On Jun 27, 2011, at 12:14 PM, Rick Faircloth wrote:

 
  I'm surprised by the lack (as in, couldn't find
  even one!) of tutorials that utilize CF Builder.
 
  Plenty of tutorials that utilize Dreamweaver, but
  none that I saw after searching the Adobe site
  that use CF Builder.
 
  Several tutorials show *how* to use CF Builder, but
  none, such as, Building Website with HTML5 and CSS3
  that don't use Dreamweaver.
 
  What's up with that?  I'd think CF Builder, by now,
  would have some tutorials produced by Adobe, as they
  have with Dreamweaver...
 
 
 
 



 

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

Re: RE: loop timing out

[Jason Durham]

Any chance the looping couple be done in a stored proc?
On Jun 28, 2011 10:20 AM, Rick Faircloth r...@whitestonemedia.com wrote:

 I've never had any problem with cfthread and request timeout.
 Now, realize, that I don't think I've ever used request timeout
 in conjunction with cfthread. The only time I've used cfthread
 is with a scheduled task and was just supposed to run as long
 as it needed to complete its work. I've never been concerned
 with shutting it down after a certain period of time.

 And the admin setting doesn't seem to affect any of the scheduled
 tasks utilizing cfthread.

 Others have a better/more-informed perspective for Azadi?


 -Original Message-
 From: Azadi Saryev [mailto:azadi.sar...@gmail.com]
 Sent: Tuesday, June 28, 2011 10:47 AM
 To: cf-talk
 Subject: Re: loop timing out


 Rick,
 i was under the impression that cfthred always obeyed request timeout
 setting in cf admin...
 at least in my experience i could never make a thread run longer than
 cfadmin setting, no matter which other way i tried to alter the request
 timeout value (cfsetting, url variable)...
 am i wrong? is my experience skewed somehow?

 Azadi


 On 28/06/2011 22:16 , Rick Faircloth wrote:
 Bummer... cfthread really helped with long-running scheduled tasks.


 -Original Message-
 From: daniel kessler [mailto:dani...@umd.edu]
 Sent: Tuesday, June 28, 2011 7:32 AM
 To: cf-talk
 Subject: Re: loop timing out


 What about running the task in a cfthread?

 I have some tasks that run on a schedule (or manually triggered)
 for an hour or two without issue...
 It sounds interesting, but from my checking, it doesn't appear to be a
CF7
 tag.







 

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

Re: CF vs. Java Web Developer

[Jason Durham]

This is a pretty interesting and, in some cases, comical discussion.  I
LOL'd when I read working in an office helped cure nicotine addiction.  It
sounds funny to hear it... but I *get* where you're coming from. :)

Like Mary Jo, I find that working in an office causes many more distractions
for me.  As much as I wanted to keep my door closed, my headphones on and my
keyboard rattling... the bosses frequently couldn't resist interrupting me
for something that was ultimately unimportant.


Jason Durham


On Thu, Jun 23, 2011 at 10:40 AM, John M Bliss bliss.j...@gmail.com wrote:


 Again, just to be safe, Dear future employer, Russ is talking about
 himself
 / some people. Many people will not have these problems so please *do*
 consider hiring telecommuters.

 On Thu, Jun 23, 2011 at 10:35 AM, Russ Michaels r...@michaels.me.uk
 wrote:

 
  Moving to an office also helped me stop smoking. When at home I would go
  downstairs for a smoke whenever I felt like it, at the REAL office I
 simply
  didn't bother.
  I worked from home for many years and it did work well, but in the end I
  became complacent and bored, I think due to the fact that work and home
  were
  the same thing and it felt like I was at work 24/7.
  It really does help to be able to separate work from home life, having a
  separate room as an office helps, as long as when you close the door work
  is
  over. For me it is never over as running a hosting co means  I am doing
  support as long as I am awake, but I guess for people that can get away
  with
  9-5 it is slightly different.
 
  But as Jacob mentioned, if your married the wife does tend to think that
 if
  your home your not really working, so you can do chores for her.
 
  Russ
 
 
 

 

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

Re: CF vs. Java Web Developer

[Jason Durham]

Depends on experience.

In general, a Java developer could be more-easily trained in CF.

Jason Durham


On Mon, Jun 20, 2011 at 12:18 PM, scott bloodworth 
sbloodwo...@rinovelty.com wrote:


 Have heard that these two skill sets work hand in hand.  One can easily
 learn the other environment fairly easy, is this true?  is there a benefit
 in looking for one or the other in employment?

 

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

Re: CF vs. Java Web Developer

[Jason Durham]

It seems like the nitpicking thus far is really superfluous.  Learning CFML
doesn't get you any closer to being a Java developer than learning .NET.
The converse is probably true (learning .NET is a better step in that
direction).

If you already know CFML and are looking to expand your skillset, Java would
compliment your skills in CF. Being that you posed this question, I imagine
learning Java won't be easy but if you have the desire and time, I say go
for it.

FWIW, I wasn't insinuating anything by my last comment.  I'm just under the
impression that you haven't spent much time with Java.  Pick up a book or
two and see if you like it.

Jason Durham


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

Re: email from variable?

[Jason Durham]

If the user has entered their email address in a form, there are two
potential ways to get it.  If the form has method of POST, the email
address will be in the FORM scope of the action page.  If the form has a
method of GET, the email address will be in the URL scope.

Jason Durham


On Tue, Jun 14, 2011 at 1:19 PM, Guust Nieuwenhuis i...@lagaffe.be wrote:


 Only if you asked the user to provide his/her email address. There is no
 way ColdFusion (or any other technology) can know this by itself.


 Kind regards,

 Guust Nieuwenhuis

 Adobe Community Champion
 www.lagaffe.be


 On 14 Jun 2011, at 20:16, Orlini, Robert wrote:

 
  Hello,
 
  How can I get the email address of a user who submitted a form so I can
 send them a reply receipt? I looked over any cgi variables and of course
 could not find one. I want to use it in a cfmail script.
 
  Thanks.
 
  RO
  HWW
 
 
 

 

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

Re: cf9 query not returning identityCol

[Jason Durham]

It's theResult.generatedKey
On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote:

 I am frustrated. :(

 In the cf9 docs, it says that cfquery is supposed to return, in the result
 variable, the identity column value of the inserted record. However it is
 not working from me.

 Would one of you kind souls point out my mistake?

 cfquery datasource=someDsn name=insertRecord result=theResult
 INSERT INTO
 someTable
 (
 firstName,
 lastName
 )
 VALUES
 (
 cfqueryparam cfsqltype=cf_sql_varchar maxlength=20
 value=#arguments.firstName#,
 cfqueryparam cfsqltype=cf_sql_varchar maxlength=20
 value=#arguments.lastName#
 )
 /cfquery

 cfoutput#theResult.identityCol#/cfoutput

 When I run this, identityCol is not there.

 I am indeed using an autonumbering identity column in the database.

 Yes, I know I can just add a select to this query to get at it, but I
really
 want this to work, dammit!


 

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

Re: cf9 query not returning identityCol

[Jason Durham]

It works on SQL 2008.
On Jun 4, 2011 6:35 PM, Robert Rhodes rrhode...@gmail.com wrote:

 That's for MYSQL. I am using SQL Server 2005. The docs say identityCol

 But I will give it a try..

 Nope., didn't work. Thanks, though. :)

 On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote:


 It's theResult.generatedKey
 On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote:
 
  I am frustrated. :(
 
  In the cf9 docs, it says that cfquery is supposed to return, in the
 result
  variable, the identity column value of the inserted record. However it
is
  not working from me.
 
  Would one of you kind souls point out my mistake?
 
  cfquery datasource=someDsn name=insertRecord result=theResult
  INSERT INTO
  someTable
  (
  firstName,
  lastName
  )
  VALUES
  (
  cfqueryparam cfsqltype=cf_sql_varchar maxlength=20
  value=#arguments.firstName#,
  cfqueryparam cfsqltype=cf_sql_varchar maxlength=20
  value=#arguments.lastName#
  )
  /cfquery
 
  cfoutput#theResult.identityCol#/cfoutput
 
  When I run this, identityCol is not there.
 
  I am indeed using an autonumbering identity column in the database.
 
  Yes, I know I can just add a select to this query to get at it, but I
 really
  want this to work, dammit!
 
 
 



 

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

Re: cf9 query not returning identityCol

[Jason Durham]

http://blog.bittersweetryan.com/2011/01/getting-generated-key-from-query-in.html.

On Jun 4, 2011 6:40 PM, Jason Durham jqdur...@gmail.com wrote:
 It works on SQL 2008.
 On Jun 4, 2011 6:35 PM, Robert Rhodes rrhode...@gmail.com wrote:

 That's for MYSQL. I am using SQL Server 2005. The docs say identityCol

 But I will give it a try..

 Nope., didn't work. Thanks, though. :)

 On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote:


 It's theResult.generatedKey
 On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote:
 
  I am frustrated. :(
 
  In the cf9 docs, it says that cfquery is supposed to return, in the
 result
  variable, the identity column value of the inserted record. However it
 is
  not working from me.
 
  Would one of you kind souls point out my mistake?
 
  cfquery datasource=someDsn name=insertRecord result=theResult
  INSERT INTO
  someTable
  (
  firstName,
  lastName
  )
  VALUES
  (
  cfqueryparam cfsqltype=cf_sql_varchar maxlength=20
  value=#arguments.firstName#,
  cfqueryparam cfsqltype=cf_sql_varchar maxlength=20
  value=#arguments.lastName#
  )
  /cfquery
 
  cfoutput#theResult.identityCol#/cfoutput
 
  When I run this, identityCol is not there.
 
  I am indeed using an autonumbering identity column in the database.
 
  Yes, I know I can just add a select to this query to get at it, but I
 really
  want this to work, dammit!
 
 
 



 

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

Re: down?

[Jason Durham]

How many people just freaked out because they thought one of *their own*
websites were down?

Jason Durham


On Wed, May 25, 2011 at 2:27 PM, Michael Muller mich...@mullertech.comwrote:


 Is the website down?

 MM


 
 Michael Muller
 cell (413) 320-5336
 http://MontagueWebWorks.com
 ** Powered by ROCKETFUSION **

 Information is not knowledge
 Knowledge is not wisdom

 Eschew Obfuscation



 

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

Re: cgi.host_name Security Exploit

[Jason Durham]

Dave pretty much summed it up.  Anybody who knows what a HOSTS file is,
knows how to mask the server_name. :)

Jason Durham


On Fri, May 13, 2011 at 2:28 PM, Dave Watts dwa...@figleaf.com wrote:


  I have recently discovered a security flaw that I have reported to the
 Adobe
  team regarding the use of the variable cgi.host_name.
 
  As you know, the cgi.host_name is typically the hostname of the server or
  the websites domain name. I've discovered an exploit that allows a user
 to
  basically change this variable to anything they want for the user's
 current
  session. This exploit could be spread across sessions  in instances where
 a
  website is caching absolute links using the cgi.host_name variable. It
 could
  also be used to take advantage of applications that assume the
 cgi.host_name
  variable is a constant, therefore developed applications don't take
  precautions to sanitize this variable before inserting it into a database
  could have issues.

 While it's a good thing you're telling people about this, I'm not sure
 I'd categorize it as a security flaw with CF, or even a security flaw
 in general.

 CF doesn't have anything to do with creating or validating many of the
 CGI variables. They're provided by the browser's HTTP request headers,
 or by the web server. CF just uses what it's given. Of course, those
 values are inherently untrustworthy and should always be sanitized.

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

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite

 

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

Re: (ot) Shameful

[Jason Durham]

I've had problems yesterday and today loading the AIR demo.  I tried FF4,
Chrome 11 and IE8 on two different internet connections.  The modal opens
and the player appears but the movie never starts.  If I click play, the
movie turns dark gray and stops.

Also, the cfspreadsheet demo has a dark overlay on it that makes it very
difficult to read.  I haven't tried any others.

Me.setAttire(flamesuit);

Jason Durham


On Tue, May 10, 2011 at 10:55 PM, Maureen mamamaur...@gmail.com wrote:


 Sounds like short between the chair and keyboard.

 On Tue, May 10, 2011 at 5:30 PM, Gerald Guido gerald.gu...@gmail.com
 wrote:
 
  Works on this end. Mac and PC. IE and FF.
 
   ID ten T error by chance??
 
  Curious -G!
 
  On Tue, May 10, 2011 at 8:03 PM, Irvin Gomez ir...@pixel69.com wrote:
 
 
  The Adobe Coldfusion 9 demos do not work and have not worked for who
 knows
  how long. I guess that's the best way to show Adobe's commitment to its
  comatose product.
 
  http://www.adobe.com/products/coldfusion/demos

 

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

Re: (ot) Shameful

[Jason Durham]

The AIR demo appears to just be a Flash movie demonstrating integration with
CF.  :)  I've tried to update my Flash plugin but, alas, Adobe says updates
happen automatically.


On Wed, May 11, 2011 at 8:33 AM, Russ Michaels r...@michaels.me.uk wrote:


 perhaps try re-installing Air ?

 On Wed, May 11, 2011 at 2:26 PM, Jason Durham jqdur...@gmail.com wrote:

 
  I've had problems yesterday and today loading the AIR demo.  I tried FF4,
  Chrome 11 and IE8 on two different internet connections.  The modal opens
  and the player appears but the movie never starts.  If I click play, the
  movie turns dark gray and stops.
 
  Also, the cfspreadsheet demo has a dark overlay on it that makes it very
  difficult to read.  I haven't tried any others.
 
  Me.setAttire(flamesuit);
 
 
 Jason Durham
 
 
  On Tue, May 10, 2011 at 10:55 PM, Maureen mamamaur...@gmail.com wrote:
 
  
   Sounds like short between the chair and keyboard.
  
   On Tue, May 10, 2011 at 5:30 PM, Gerald Guido gerald.gu...@gmail.com
   wrote:
   
Works on this end. Mac and PC. IE and FF.
   
 ID ten T error by chance??
   
Curious -G!
   
On Tue, May 10, 2011 at 8:03 PM, Irvin Gomez ir...@pixel69.com
  wrote:
   
   
The Adobe Coldfusion 9 demos do not work and have not worked for who
   knows
how long. I guess that's the best way to show Adobe's commitment to
  its
comatose product.
   
http://www.adobe.com/products/coldfusion/demos
  
  
 
 

 

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

Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?

[Jason Durham]

It seemed awkward for me at first... but now I dislike working on IIS6. :)

Jason Durham


On Wed, May 11, 2011 at 10:09 AM, Russ Michaels r...@michaels.me.uk wrote:


 it takes some getting used to that's for sure, but once you do then you
 will
 like it :-)

 On Wed, May 11, 2011 at 3:52 PM, Robert Rhodes rrhode...@gmail.com
 wrote:

 
  It was a pain to find, but thatworked .  Thanks.
 
  I really don't like the new IIS 7  interface...
 
  On Wed, May 11, 2011 at 3:45 AM, Kym Kovan dev-li...@mbcomms.net.au
  wrote:
 
  
   On 11/05/2011 17:02, Robert Rhodes wrote:
   
Well, it wasn't as easy as I had hoped.
   
I installed cf 9 as a standalone installation.  I updated to 9.01 and
applied the 9.01 hotfix.
   
I then ran the web Server Configuration Tool, and got an error:
   
ASP.Net Window's feature is not installed. They are required to
  configure
IIS7 Connector.
   
I am installing this on Wn2K8 R2 Web Server Edition as  I mentioned
   above.
   
So now what? :)
  
   In the Server Manager home page go to the Roles section and add the
   needed service. By default only the minimum is installed so you need to
   add in ASP.Net, etc.
  
  
  
   --
   Yours,
  
   Kym Kovan
   mbcomms.net.au
  
  
  
  
 
 

 

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

Re: Ack! CF9 pages not serving pages on IIS7.5 (404.3 error)

[Jason Durham]

Run wsconfig again (add/remove sites)
On May 11, 2011 2:00 PM, Robert Rhodes rrhode...@gmail.com wrote:

 Ok, I downloaded cf 9 and installed it on WIn2K8 R2 Web Server Edition.as
a
 standalone installation.

 I then ran the 9.01 updater and he 9.01 hotfix.

 Finally, I ran the webserver config tool and selected IIS all sites.

 Now when I load a cf template I get a 404.3 error and this message:

 HTTP Error 404.3 - Not Found
 The page you are requesting cannot be served because of the extension
 configuration. If the page is a script, add a handler. If the file should
be
 downloaded, add a MIME map.

 I am sure I did something wrong. Any suggestions

 RR


 

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

SOT: SQL CTE update

[Jason Durham]

I apologize if this is an inappropriate place to ask this question.

I'm using a CTE for a recursive query to assemble navigation.  In the CTE,
I'm creating a column that contains the depth of the navigation.  This depth
is ultimately inserted into the class of an HTML element.   I'm refactoring
how my breadcrumbs are created and want to use a similar method.  The catch
is, breadcrumbs start from the bottom of a recursive tree and work their way
up.  This is causing undesired behavior on the depth calculation.  The
bottom-most element is 0.  It's parent is 1.  It's grandparent is 2 (and so
forth).  I need to reverse the order of this field.

I'm currently trying to use a cursor to loop back over the CTE and update
the depth field manually.  However, it appears that I'm I can't access the
data stored in the temporary table (CTE) from with in the cursor.  Should I
be going about this a different way?

Here is the SQL...

DECLARE @THEID INT
SET @THEID=88;

DECLARE BC_Cursor CURSOR FOR
WITH Breadcrumbs(Navigation_ID, Parent_ID, Navigation_Name, Depth) AS
(
SELECT Navigation_ID, Parent_ID, Navigation_Name, 0
FROM Navigation
WHERE Navigation_ID = @THEID

UNION ALL

SELECT n.Navigation_ID, n.Parent_ID, n.Navigation_Name, bc.Depth+1
FROM Navigation n
INNER JOIN Breadcrumbs bc
ON bc.Parent_ID = n.Navigation_ID
)
SELECT * FROM Breadcrumbs OPTION (MAXRECURSION 8)
FOR UPDATE;

DECLARE @maxRows int;
SET @maxRows = @@ROWCOUNT; --- Will be used to renumber the depth

OPEN BC_Cursor;
FETCH NEXT FROM BC_Cursor;
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM BC_Cursor;  --- This prints each row.  Instead of
outputting them, I need to update and ultimately return the whole (virtual)
table.
END;
CLOSE BC_Cursor;

DEALLOCATE BC_Cursor;


Thanks in advance.

Jason Durham


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

Re: SOT: SQL CTE update

[Jason Durham]

Nevermind... all I could see were nails.  I'll create a temp table for the
regular navigation and use that table for breadcrumbs (the depth is
accurately created on that query).

Jason Durham


On Tue, Mar 29, 2011 at 1:44 PM, Jason Durham jqdur...@gmail.com wrote:

 I apologize if this is an inappropriate place to ask this question.

 I'm using a CTE for a recursive query to assemble navigation.  In the CTE,
 I'm creating a column that contains the depth of the navigation.  This depth
 is ultimately inserted into the class of an HTML element.   I'm refactoring
 how my breadcrumbs are created and want to use a similar method.  The catch
 is, breadcrumbs start from the bottom of a recursive tree and work their way
 up.  This is causing undesired behavior on the depth calculation.  The
 bottom-most element is 0.  It's parent is 1.  It's grandparent is 2 (and so
 forth).  I need to reverse the order of this field.

 I'm currently trying to use a cursor to loop back over the CTE and update
 the depth field manually.  However, it appears that I'm I can't access the
 data stored in the temporary table (CTE) from with in the cursor.  Should I
 be going about this a different way?

 Here is the SQL...

 DECLARE @THEID INT
 SET @THEID=88;

 DECLARE BC_Cursor CURSOR FOR
 WITH Breadcrumbs(Navigation_ID, Parent_ID, Navigation_Name, Depth) AS
 (
 SELECT Navigation_ID, Parent_ID, Navigation_Name, 0
 FROM Navigation
 WHERE Navigation_ID = @THEID

 UNION ALL

 SELECT n.Navigation_ID, n.Parent_ID, n.Navigation_Name, bc.Depth+1
 FROM Navigation n
 INNER JOIN Breadcrumbs bc
 ON bc.Parent_ID = n.Navigation_ID
 )
 SELECT * FROM Breadcrumbs OPTION (MAXRECURSION 8)
 FOR UPDATE;

 DECLARE @maxRows int;
 SET @maxRows = @@ROWCOUNT; --- Will be used to renumber the depth

 OPEN BC_Cursor;
 FETCH NEXT FROM BC_Cursor;
 WHILE @@FETCH_STATUS = 0
 BEGIN
 FETCH NEXT FROM BC_Cursor;  --- This prints each row.  Instead of
 outputting them, I need to update and ultimately return the whole (virtual)
 table.
 END;
 CLOSE BC_Cursor;

 DEALLOCATE BC_Cursor;


 Thanks in advance.

 Jason Durham



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

Re: SOT: SQL CTE update

[Jason Durham]

The in example I posted, I'm calculating the depth in the select statement.
The depth is determined by the order in which the row is returned.  If I
start from a child, the child is returned first (therefore it's 0).  If I
start from the parent (top level nav), the parent is 0.   Consider this...

Typical nav.. (depth is in parenthesis).  The tree is built from the top
down.

Home (0)
-Products (1)
- -Car (2)
- -Truck (2)
-Support (1)
- -Software (2)
- - -*Drivers *(3)

Breadcrumbs...  The tree is built from the bottom up.

*Drivers *(0)
-Software (1)
- -Support (2)
- - -Home (3)

The depth is backwards.  The depth is not a fixed column.

Like I said... the solution hit me.  The entire site's navigation is
generated with the correct depth onAppStart().  I'll just cache it via a
temp table.

Jason Durham


On Tue, Mar 29, 2011 at 2:14 PM, Dan G. Switzer, II dswit...@pengoworks.com
 wrote:


 Why bother with cursors or temp tables at all and just sort across Depth
 desc instead of Depth asc?

 -Dan

 On Tue, Mar 29, 2011 at 2:59 PM, Jason Durham jqdur...@gmail.com wrote:

 
  Nevermind... all I could see were nails.  I'll create a temp table for
 the
  regular navigation and use that table for breadcrumbs (the depth is
  accurately created on that query).
 
  Jason Durham
 
 
  On Tue, Mar 29, 2011 at 1:44 PM, Jason Durham jqdur...@gmail.com
 wrote:
 
   I apologize if this is an inappropriate place to ask this question.
  
   I'm using a CTE for a recursive query to assemble navigation.  In the
  CTE,
   I'm creating a column that contains the depth of the navigation.  This
  depth
   is ultimately inserted into the class of an HTML element.   I'm
  refactoring
   how my breadcrumbs are created and want to use a similar method.  The
  catch
   is, breadcrumbs start from the bottom of a recursive tree and work
 their
  way
   up.  This is causing undesired behavior on the depth calculation.  The
   bottom-most element is 0.  It's parent is 1.  It's grandparent is 2
 (and
  so
   forth).  I need to reverse the order of this field.
  
   I'm currently trying to use a cursor to loop back over the CTE and
 update
   the depth field manually.  However, it appears that I'm I can't access
  the
   data stored in the temporary table (CTE) from with in the cursor.
  Should
  I
   be going about this a different way?
  
   Here is the SQL...
  
   DECLARE @THEID INT
   SET @THEID=88;
  
   DECLARE BC_Cursor CURSOR FOR
   WITH Breadcrumbs(Navigation_ID, Parent_ID, Navigation_Name, Depth) AS
   (
   SELECT Navigation_ID, Parent_ID, Navigation_Name, 0
   FROM Navigation
   WHERE Navigation_ID = @THEID
  
   UNION ALL
  
   SELECT n.Navigation_ID, n.Parent_ID, n.Navigation_Name, bc.Depth+1
   FROM Navigation n
   INNER JOIN Breadcrumbs bc
   ON bc.Parent_ID = n.Navigation_ID
   )
   SELECT * FROM Breadcrumbs OPTION (MAXRECURSION 8)
   FOR UPDATE;
  
   DECLARE @maxRows int;
   SET @maxRows = @@ROWCOUNT; --- Will be used to renumber the depth
  
   OPEN BC_Cursor;
   FETCH NEXT FROM BC_Cursor;
   WHILE @@FETCH_STATUS = 0
   BEGIN
   FETCH NEXT FROM BC_Cursor;  --- This prints each row.  Instead
  of
   outputting them, I need to update and ultimately return the whole
  (virtual)
   table.
   END;
   CLOSE BC_Cursor;
  
   DEALLOCATE BC_Cursor;
  
  
   Thanks in advance.
  
  
 Jason Durham
  
 
 
 

 

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

Re: I think I'm confused...

[Jason Durham]

Run Notepad.exe as Administrator
Open C:\windows\system32\drivers\etc\hosts (no file extension)
Add 127.0.0.1 www.mydomain.com to the last line
Open web server and configure to route by hostname www.mydomain.com


Windows (by default) looks to your hosts file for name resolution before 
checking a DNS server.  I do something like this for all of my dev sites.

Sent from my iPhone

On Feb 23, 2011, at 8:52 PM, Rick Faircloth r...@whitestonemedia.com wrote:

 
 I've started working on an MSOC application
 and was setting up some test code which uses
 the cgi.server_name as the determining value
 for setting all the specific site variables.
 
 Then, I realized that this wouldn't work for
 local development using http://localhost; because
 there would be not cgi.server_name (except localhost)
 to reference in the browser.
 
 I guess I can set up a domain in the database
 for localhost and treat that the same way I would
 treat a regular domain, but I wouldn't be able to
 switch between various sites locally that way.
 
 Is an MSOC app testable for various domains only
 on a server, where DNS is running, as opposed to locally?
 
 (There is probably a simple solution for this, but
 I've been reading and thinking about this so much
 I can't see the forest for the trees!
 
 ???
 
 Rick
 
 
 
 

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

Re: Inline structure notation as argument fails

[Jason Durham]

I'm using 9,0,1,274733.

Jason Durham


On Wed, Feb 16, 2011 at 5:43 PM, Sean Corfield seancorfi...@gmail.comwrote:


 CF9 or CF9.0.1? ISTR a bug in this area that got fixed sometime along
 the way...?

 On Wed, Feb 16, 2011 at 1:05 PM, Jason Durham jqdur...@gmail.com wrote:
 
  I'm re-writing an event handler to utilize CF9s scripting enhancement.
  The
  majority of the handler was already written in cfscript, including the
 line
  of code I'm having problems with.  After making the change to full
 script,
  I'm getting an exception indicating Variable EVENT is undefined.
 
  http://coldbox.pastebin.com/CGRVf25z
 
  By moving the structure to its own variable, the code executes without
  error.   Is this expected behavi

 

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

Inline structure notation as argument fails

[Jason Durham]

I'm re-writing an event handler to utilize CF9s scripting enhancement.  The
majority of the handler was already written in cfscript, including the line
of code I'm having problems with.  After making the change to full script,
I'm getting an exception indicating Variable EVENT is undefined.

http://coldbox.pastebin.com/CGRVf25z

By moving the structure to its own variable, the code executes without
error.   Is this expected behavior?

Jason Durham


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

Re: Charge for meetings

[Jason Durham]

I agree with Brian Cane.

Jason Durham


On Sat, Feb 5, 2011 at 4:37 PM, Brian Cain bcc9...@gmail.com wrote:


 I follow the same basic rule. No charge on the initial consult, but hourly
 after that. It helps force the client to prepare and think through why they
 really want.

 Sent from my iPhone

 On Feb 5, 2011, at 4:19 PM, Phillip Vector vec...@mostdeadlygame.com
 wrote:

 
  I charge per hour. If you want to have a meeting for that time, I
  charge for it. Talk away. :)
 
  Now, the initial meeting, I tend not to charge for. But those I like
  to keep short and focused.
 
  On Sat, Feb 5, 2011 at 2:05 PM, Paul Alkema paulalkemadesi...@gmail.com
 wrote:
 
  Hi All,
  I have a question; when you guys do consulting or freelance programming,
 do
  you charge for meetings? Or do you absorb meeting time into your fees?
 
  Thanks,
  Paul
 
 
 
 
 

 

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

Re: nested SQL update statement to replace CF script

[Jason Durham]

If _all_ children _aways_ get published (like your pseudocode indicates),
why not just flag the parent category?

If you want to do it all in SQL, try...
http://msdn.microsoft.com/en-us/library/ms186243.aspx

Jason Durham


On Fri, Jan 28, 2011 at 1:16 AM, wabba must...@wabba.net wrote:


 Hi all, read a lot, post rarely. Anyway, try to keep this simple as
 possible
 - I have a database of items stored within nested categories using a pivot
 table to establish parent/childs for the categories (the can virtually nest
 indefinitely, one child cat can be under multiple parents, etc). There are
 roughly 30,000 items within 3,000 categories. There are a handful of top
 level categories. One of the top level categories gets published to an
 external site regularly, while the others don't. I use a bit flag on the
 items to determine which items get published and which don't, so that only
 the items we want published get transferred.

 Currently I use a nested CF custom tag to set the publish flags - I feed it
 a top level categoryID, it sets Publish=1 on the items in that category,
 then calls itself in a loop with all of the CategoryID where the
 ParentCatID=CategoryID. Something like this:

 (cf_pushlishtree custom tag):
 cfquery
 Update item SET Publish=1 WHERE CategoryID=CurrentCat
 /cfquery
 cfquery name=getsubcats
 Select CategoryID FROM CatPivot WHERE ParentCatID=CurrentCat
 /cfquery

 cfloop query=getsubcats
cf_publishtree CurrentCat=#CurrentCat#
 /cfloop


 ...It works fine but is slow and will timeout before it finishes, and I
 can't restart it where it leaves off. I would think this could be done
 right
 in MS SQL by having a nested function or stored procedure that can do the
 update and then loop itself from the select, but I can't figure out how - I
 don't think an UPDATE is allowed in a function, and a stored procedure
 can't
 be called from a select statement. I considered adding a TopCategoryID to
 the item or category table as it would make publishing very simple, but we
 can't as categories can exist anywhere in the category structure, often
 under multiple parents simultaneously.



 

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

RE: Internationalization of Week() function in CF - Last resort to Java

[Jason Durham]

Thanks for sharing.

-Original Message-
From: Nando [mailto:d.na...@gmail.com]
Sent: Wednesday, December 22, 2010 7:42 AM
To: cf-talk
Subject: Internationalization of Week() function in CF - Last resort to Java


I'm developing a scheduling application in CF. While doing so, I've
discovered that there are a variety of different methods for determining the
week number, and that depending on the locale, a week can begin on Saturday,
Sunday or Monday. The first week of the year can be determined in a variety
of ways, and can be numbered in a variety of ways, such that January 1 of a
given year might be in week 0, 1, 52 or 53. Complicating this somewhat is
that there is no clear indication which standard CF's inbuilt Week()
function follows.

All this might not seem so important to Americans, but here in Europe, week
numbers are often used in calenders and agendas. A question such as Can we
arrange a meeting during week 43? can be rather common. The question, for
me, was What standard is followed in Europe to determine week numbers.

The closest thing I found to a universal standard is the ISO week date
system, and I decided that's good enough for me. Reading the technical
definition makes it sound pretty complex, but it can be reduced to weeks
start on monday and the first week of the year is the first week with work
days in it, which effectively means the week that contains January 4.

There's a ISOWeek function on cflib that tries, but fails to generate the
correct ISO week number some years.

Long story short, I eventually solved this, as a last resort, by dropping
down to Java. I'm an absolute novice at Java and wanted to ask if anyone
could improve on the UDF I came up with before I submit it to CFLib ...

cfscript
function ISOWeek(inputDateObj) {
var inputDate = DateFormat(inputDateObj,-mm-dd);
var formatter =
CreateObject(java,java.text.SimpleDateFormat).init(-MM-dd);
var theDate = formatter.parse(inputDate); c =
CreateObject(java,java.util.Calendar).getInstance();
c.setTimeInMillis(theDate.getTime());
c.setFirstDayOfWeek(c.MONDAY);
c.setMinimalDaysInFirstWeek(4);
return c.get(c.WEEK_OF_YEAR);
}
/cfscript

... using the following references and a good measure of fumbling around.

http://www.jarvana.com/jarvana/view/com/h2database/h2/1.2.128/h2-1.2.128-sou
rces.jar!/org/h2/util/DateTimeIso8601Utils.java?format=ok
http://www.java2s.com/Tutorial/Java/0040__Data-Type/CreateajavautilDateObjec
tfromaYearMonthDayFormat.htm
http://www.coldfusionmuse.com/index.cfm/2009/2/23/Unpacking-Java-In-Coldfusi
on

I also want to suggest that Week() is internationalized appropriately in CF
as an enhancement request.

Thanks,

Nando

--
Nando M. Breiter
Aria Media
CP 234
6934 Bioggio
Switzerland

+41 91 606 6372

www.aria-media.com




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

RE: Broken code after CF9.01 patch

[Jason Durham]

Heh... my line break didn't show up in the last email either.

Has anyone else experienced similar behavior?


-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com]
Sent: Friday, October 08, 2010 4:57 PM
To: cf-talk
Subject: RE: Broken code after CF9.01 patch


Sorry for the poorly formatted code sample below.  Here it is again with a
line break...

coverageID = reReplaceNoCase( li, \AOPT_([0-9]+)\Z, \1 );
oCoverage = MaintenancePlanService.getCoverage( props : { coverageID =
coverageID } );

I've implemented a work-around by omitting the inline structure notation.

props = structNew();
props.coverageID = reReplaceNoCase( li, \AOPT_([0-9]+)\Z, \1 );
oCoverage = MaintenancePlanService.getCoverage( props = props );

-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com]
Sent: Friday, October 08, 2010 4:41 PM
To: cf-talk
Subject: RE: Broken code after CF9.01 patch


Correction... that's the 9.0.1 patch.  The filename was
ColdFusion_update_901_WWEJ_win64.exe on Windows 7 Pro 64 bit using IIS7 with
the IIS compatibility stuff still active.

-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com]
Sent: Friday, October 08, 2010 4:37 PM
To: cf-talk
Subject: Broken code after CF9.1 patch


Today, I patched my CF9 development machine with the latest .exe available
from Adobe.  The following code is now broken...


Transfer ORM throws an exception because coverageID is empty.   If I dump
the arguments in getCoverage(), I see a struct with a single key of
coverageID and an [empty string] value.  However, if I dump coverageID
before the Service is called (after first line  above), I see that
coverageID = 3.

Has anyone else experienced a similar problem?


Confidentiality Warning: This e-mail contains information intended only for
the use of the individual or entity named above. If the reader of this
e-mail is not the intended recipient or the employee or agent responsible
for delivering it to the intended recipient, any dissemination, publication
or copying of this e-mail is strictly prohibited. The sender does not accept
any responsibility for any loss, disruption or damage to your data or
computer system that may occur while using data contained in, or transmitted
with, this e-mail. If you have received this e-mail in error, please
immediately notify us by return e-mail.








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

PDF scaling

[Jason Durham]

How do I keep ColdFusion from scaling my content when I use cfdocument 
type=pdf?

h1 style=font-size:36pxHello, World./h1

I've clearly set a fixed font size but it comes out to something closer to 
28px.  I've used cfdocument type=pdf scale=100 also, however the docs say 
you only need to use scale if you want it smaller than 100%.


Confidentiality Warning: This e-mail contains information intended only for the 
use of the individual or entity named above. If the reader of this e-mail is 
not the intended recipient or the employee or agent responsible for delivering 
it to the intended recipient, any dissemination, publication or copying of this 
e-mail is strictly prohibited. The sender does not accept any responsibility 
for any loss, disruption or damage to your data or computer system that may 
occur while using data contained in, or transmitted with, this e-mail. If you 
have received this e-mail in error, please immediately notify us by return 
e-mail.


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

RE: Manipulating a PDF brochure

[Jason Durham]

Thanks again Jochem.

I enabled rich text and set the binding to XHTML which seemed like it would
have given me what I wanted.  I used
![CDATA[ullitest/lilitest2/li/ul]] which resulted in
ullitest/lilitest2/li/ul being displayed in the field.  Adding
the body tag (or even html + body) resulted in the HTML being rendered
as plain text.

As you suggested, I also created a blank PDF, typed the values in using
Acrobat and saved it out.  The field named changed to Open instead of
Equipment, like it should be.  I'll do more testing with this.

The brochure doesn't require a form.  I was just hoping not to reinvent the
wheel (create the form in HTML).

-Original Message-
From: Jochem van Dieten [mailto:joch...@gmail.com]
Sent: Friday, October 08, 2010 2:39 AM
To: cf-talk
Subject: Re: Manipulating a PDF brochure


On Thu, Oct 7, 2010 at 11:13 PM, Jason Durham wrote:
 I've been tasked with generating a sales brochure with a couple of
variable components.  I would like to be able to render HTML inside an
existing PDF document that was designed in a graphics program.  I've been
playing with LiveCycle and have been able to get CF to insert plain text
into form fields via cfpdfform.  However, I have some fields that will
require a list with line breaks between phrases.  I'm unable to find a
method of encoding line breaks so that CF will insert them properly into the
PDF.

Make sure you enable rich text on your form fields, then insert the HTML.
IIRC you need a body tag and everything in between, possibly inside a CDATA.
Probably the easiest way to find out is to build the form, fill it out in
Acrobat and extract the form fields to see what they contain.

If your brochure doesn't require a form you have a lot more freedom in your
HTML if you use cfdocument to generate PDF with your content and overlay
that over the background as a watermark.

Jochem


--
Jochem van Dieten
http://jochem.vandieten.net/



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

Broken code after CF9.1 patch

[Jason Durham]

Today, I patched my CF9 development machine with the latest .exe available from 
Adobe.  The following code is now broken...

coverageID = reReplaceNoCase( li, \AOPT_([0-9]+)\Z, \1 );
oCoverage = MaintenancePlanService.getCoverage( props : { coverageID = 
coverageID } );

Transfer ORM throws an exception because coverageID is empty.   If I dump the 
arguments in getCoverage(), I see a struct with a single key of coverageID 
and an [empty string] value.  However, if I dump coverageID before the Service 
is called (after first line  above), I see that coverageID = 3.

Has anyone else experienced a similar problem?


Confidentiality Warning: This e-mail contains information intended only for the 
use of the individual or entity named above. If the reader of this e-mail is 
not the intended recipient or the employee or agent responsible for delivering 
it to the intended recipient, any dissemination, publication or copying of this 
e-mail is strictly prohibited. The sender does not accept any responsibility 
for any loss, disruption or damage to your data or computer system that may 
occur while using data contained in, or transmitted with, this e-mail. If you 
have received this e-mail in error, please immediately notify us by return 
e-mail.


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

RE: Broken code after CF9.01 patch

[Jason Durham]

Correction... that's the 9.0.1 patch.  The filename was
ColdFusion_update_901_WWEJ_win64.exe on Windows 7 Pro 64 bit using IIS7 with
the IIS compatibility stuff still active.

-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com]
Sent: Friday, October 08, 2010 4:37 PM
To: cf-talk
Subject: Broken code after CF9.1 patch


Today, I patched my CF9 development machine with the latest .exe available
from Adobe.  The following code is now broken...

coverageID = reReplaceNoCase( li, \AOPT_([0-9]+)\Z, \1 ); oCoverage =
MaintenancePlanService.getCoverage( props : { coverageID = coverageID } );

Transfer ORM throws an exception because coverageID is empty.   If I dump
the arguments in getCoverage(), I see a struct with a single key of
coverageID and an [empty string] value.  However, if I dump coverageID
before the Service is called (after first line  above), I see that
coverageID = 3.

Has anyone else experienced a similar problem?


Confidentiality Warning: This e-mail contains information intended only for
the use of the individual or entity named above. If the reader of this
e-mail is not the intended recipient or the employee or agent responsible
for delivering it to the intended recipient, any dissemination, publication
or copying of this e-mail is strictly prohibited. The sender does not accept
any responsibility for any loss, disruption or damage to your data or
computer system that may occur while using data contained in, or transmitted
with, this e-mail. If you have received this e-mail in error, please
immediately notify us by return e-mail.




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

RE: Broken code after CF9.01 patch

[Jason Durham]

Sorry for the poorly formatted code sample below.  Here it is again with a
line break...

coverageID = reReplaceNoCase( li, \AOPT_([0-9]+)\Z, \1 );
oCoverage = MaintenancePlanService.getCoverage( props : { coverageID =
coverageID } );

I've implemented a work-around by omitting the inline structure notation.

props = structNew();
props.coverageID = reReplaceNoCase( li, \AOPT_([0-9]+)\Z, \1 );
oCoverage = MaintenancePlanService.getCoverage( props = props );

-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com]
Sent: Friday, October 08, 2010 4:41 PM
To: cf-talk
Subject: RE: Broken code after CF9.01 patch


Correction... that's the 9.0.1 patch.  The filename was
ColdFusion_update_901_WWEJ_win64.exe on Windows 7 Pro 64 bit using IIS7 with
the IIS compatibility stuff still active.

-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com]
Sent: Friday, October 08, 2010 4:37 PM
To: cf-talk
Subject: Broken code after CF9.1 patch


Today, I patched my CF9 development machine with the latest .exe available
from Adobe.  The following code is now broken...


Transfer ORM throws an exception because coverageID is empty.   If I dump
the arguments in getCoverage(), I see a struct with a single key of
coverageID and an [empty string] value.  However, if I dump coverageID
before the Service is called (after first line  above), I see that
coverageID = 3.

Has anyone else experienced a similar problem?


Confidentiality Warning: This e-mail contains information intended only for
the use of the individual or entity named above. If the reader of this
e-mail is not the intended recipient or the employee or agent responsible
for delivering it to the intended recipient, any dissemination, publication
or copying of this e-mail is strictly prohibited. The sender does not accept
any responsibility for any loss, disruption or damage to your data or
computer system that may occur while using data contained in, or transmitted
with, this e-mail. If you have received this e-mail in error, please
immediately notify us by return e-mail.






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

Manipulating a PDF brochure

[Jason Durham]

I've been tasked with generating a sales brochure with a couple of variable 
components.  I would like to be able to render HTML inside an existing PDF 
document that was designed in a graphics program.  I've been playing with 
LiveCycle and have been able to get CF to insert plain text into form fields 
via cfpdfform.  However, I have some fields that will require a list with 
line breaks between phrases.  I'm unable to find a method of encoding line 
breaks so that CF will insert them properly into the PDF.

Any words of wisdom?



Confidentiality Warning: This e-mail contains information intended only for the 
use of the individual or entity named above. If the reader of this e-mail is 
not the intended recipient or the employee or agent responsible for delivering 
it to the intended recipient, any dissemination, publication or copying of this 
e-mail is strictly prohibited. The sender does not accept any responsibility 
for any loss, disruption or damage to your data or computer system that may 
occur while using data contained in, or transmitted with, this e-mail. If you 
have received this e-mail in error, please immediately notify us by return 
e-mail.


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

CF wait for cfdoc type=pdf rendering?

[Jason Durham]

I've run into a situation where this exception is being thrown...

Message The resource I:\temp\148B8F9B-9360-3A68-13B177C579EF0537.pdf was not 
found.
Detail The root cause was: ''.

One event fires to create a PDF and send an email (with attachment).  I'm 
wondering if cfmail is trying to attach a PDF that hasn't been completely 
created.  Is it common behavior for CF to wait for cfdocument rendering 
before processing the rest of the request?

FYI, the PDF is indeed not in the temp directory.  However, I presume the PDF 
rendering stopped due to this exception.  If I comment out the email code, the 
PDF is generated appropriately.



Confidentiality Warning: This e-mail contains information intended only for the 
use of the individual or entity named above. If the reader of this e-mail is 
not the intended recipient or the employee or agent responsible for delivering 
it to the intended recipient, any dissemination, publication or copying of this 
e-mail is strictly prohibited. The sender does not accept any responsibility 
for any loss, disruption or damage to your data or computer system that may 
occur while using data contained in, or transmitted with, this e-mail. If you 
have received this e-mail in error, please immediately notify us by return 
e-mail.


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

RE: Positional argument collection

[Jason Durham]

This is untested...

SomeComponent.someMethod(evaluate(ArrayToList(positionalArgs)));


-Original Message-
From: enigment [mailto:enigm...@gmail.com]
Sent: Wednesday, October 06, 2010 10:48 AM
To: cf-talk
Subject: Re: Positional argument collection


Thanks for chiming in Michael.

Using ArrayToList would pass all three values as a single string. I'm
looking for a generic way to pass each array element as an individual
argument, regardless of how many there are. Take another look at the
examples I gave.

Dave

On Wed, Oct 6, 2010 at 11:02 AM, Michael Grant mgr...@modus.bz wrote:

 I'm not exactly sure what you're asking but would some variation of
 this work for you?

 SomeComponent.someMethod(ArrayToList(positionalArgs));

 Of course you may need to qualify the list etc if you are passing
 strings, but I think that suits your example.


 On Wed, Oct 6, 2010 at 10:54 AM, enigment enigm...@gmail.com wrote:


 Say I have an array of values, arbitrary length, that I want to pass
 as the arguments to a method.

 For example, with this:
  positionalArgs = ['foo', 'bar', 42]; // this varies, may be any
 length I want to make this call:
  SomeComponent.someMethod('foo', 'bar', 42);

 Is there a positional equivalent to argumentCollection, or some other
 language construct that I don't know about to do this? If the
 arguments were in a structure, I could pass it as the
 argumentCollection, but I don't know how to do this by position in a
 clean way.

 Only thing I thought of is a switch statement with some finite number
 of cases, each of which calls the method with a specific number of
 arguments, like this (partial):
   case 2:
  SomeComponent.someMethod(positionalArgs[1], positionalArgs[2]);
  break;
   case 3:
  SomeComponent.someMethod(positionalArgs[1], positionalArgs[2],
 positionalArgs[3]);
  break;
   etc...

 Any thoughts? Thanks,

 Dave







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

RE: Positional argument collection

[Jason Durham]

Whoops.. read the rest of the email below.

var I = positionalArgs.iterator();
var arg = ;

while( i.hasNext() ) {
arg = i.next();
SomeComponent.someMethod(arg);
}

That will call someMethod() for each array value.  You could use a For loop
with i LTE arrayLen(positionalArg) if you don't want to use iterator().

-Original Message-
From: enigment [mailto:enigm...@gmail.com]
Sent: Wednesday, October 06, 2010 10:48 AM
To: cf-talk
Subject: Re: Positional argument collection


Thanks for chiming in Michael.

Using ArrayToList would pass all three values as a single string. I'm
looking for a generic way to pass each array element as an individual
argument, regardless of how many there are. Take another look at the
examples I gave.

Dave

On Wed, Oct 6, 2010 at 11:02 AM, Michael Grant mgr...@modus.bz wrote:

 I'm not exactly sure what you're asking but would some variation of
 this work for you?

 SomeComponent.someMethod(ArrayToList(positionalArgs));

 Of course you may need to qualify the list etc if you are passing
 strings, but I think that suits your example.


 On Wed, Oct 6, 2010 at 10:54 AM, enigment enigm...@gmail.com wrote:


 Say I have an array of values, arbitrary length, that I want to pass
 as the arguments to a method.

 For example, with this:
  positionalArgs = ['foo', 'bar', 42]; // this varies, may be any
 length I want to make this call:
  SomeComponent.someMethod('foo', 'bar', 42);

 Is there a positional equivalent to argumentCollection, or some other
 language construct that I don't know about to do this? If the
 arguments were in a structure, I could pass it as the
 argumentCollection, but I don't know how to do this by position in a
 clean way.

 Only thing I thought of is a switch statement with some finite number
 of cases, each of which calls the method with a specific number of
 arguments, like this (partial):
   case 2:
  SomeComponent.someMethod(positionalArgs[1], positionalArgs[2]);
  break;
   case 3:
  SomeComponent.someMethod(positionalArgs[1], positionalArgs[2],
 positionalArgs[3]);
  break;
   etc...

 Any thoughts? Thanks,

 Dave







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

RE: CF wait for cfdoc type=pdf rendering?

[Jason Durham]

Thanks Jochem.

-Original Message-
From: Jochem van Dieten [mailto:joch...@gmail.com]
Sent: Wednesday, October 06, 2010 3:10 PM
To: cf-talk
Subject: Re: CF wait for cfdoc type=pdf rendering?


On Wed, Oct 6, 2010 at 5:43 PM, Jason Durham wrote:
 Message The resource I:\temp\148B8F9B-9360-3A68-13B177C579EF0537.pdf was
not found.
 Detail The root cause was: ''.

 One event fires to create a PDF and send an email (with attachment).  I'm
wondering if cfmail is trying to attach a PDF that hasn't been completely
created.

It is more likely cfmail is deleting the attachment after sending it.

  Is it common behavior for CF to wait for cfdocument rendering before
processing the rest of the request?

Yes.

Jochem


--
Jochem van Dieten
http://jochem.vandieten.net/



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

CFML app to share and sell photos online?

[Jason Durham]

I have a co-worker looking for an application where she can upload, watermark, 
share and sell digital photos online.  She would prefer something that already 
integrates with PayPal.  Is there anything out there built in CFML I can show 
her?

TIA



Confidentiality Warning: This e-mail contains information intended only for the 
use of the individual or entity named above. If the reader of this e-mail is 
not the intended recipient or the employee or agent responsible for delivering 
it to the intended recipient, any dissemination, publication or copying of this 
e-mail is strictly prohibited. The sender does not accept any responsibility 
for any loss, disruption or damage to your data or computer system that may 
occur while using data contained in, or transmitted with, this e-mail. If you 
have received this e-mail in error, please immediately notify us by return 
e-mail.


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

RE: Anyone else have the latest CFBuilder crashing constantly?

[Jason Durham]

I'm having the same problem on Win7 64-bit.  Build date of CFB shows Feb 27, 
2010.

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au]
Sent: Friday, March 12, 2010 2:59 AM
To: cf-talk
Subject: RE: Anyone else have the latest CFBuilder crashing constantly?


Cutting and pasting chews through memory very quickly, it was raised as a
bug and Adobe just closed it straight away.

Now that either means it is fixed or they are not going to fix it so let's
see.

But as I described to Adobe, I went from 77mb of heap space and after
copying and pasting about 5 to 10 times from another file my heap space had
grown out to 250mb before ColdFusion Builder then crashed.

There are a lot of memory leaks with ColdFusion Builder, that just ends up
chewing through memory way to fast.



-Original Message-
From: Roger Austin [mailto:raust...@nc.rr.com]
Sent: Friday, 12 March 2010 2:51 AM
To: cf-talk
Subject: RE: Anyone else have the latest CFBuilder crashing constantly?


 For me, CFB beta 3 has been unstable to a point where I went
back to text editors to get work done. There is a problem
when I cut and paste a lot. Every paste would set off something
in CFB which seemed to need to time out before it came back to
life.
 Also, there were problems when I would type a double
quote and CFB would go numb on me for a while. I definitely
had to watch the screen as I typed since I had no idea when it
would go mental on me.
 I ended up turning off all the helpers in the system
which turns it into a fancy text editor and allows me to get
work done. I sure hope they fix all these problems before it
goes into production. I assumed that there would be another
beta, but that may not happen.




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332905
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: form testing

[Jason Durham]

Download the Firefox Web Developer toolbar and disable Javascript.  Or... 
simply comment out the client-side Javascript.

-Original Message-
From: succ...@ramonecung.com [mailto:succ...@ramonecung.com]
Sent: Tuesday, April 13, 2010 8:34 AM
To: cf-talk
Subject: form testing


Heya! I'm testing an in house developed app and I'm wondering what the best wat 
to post data to a form is that gets around client side validation (including 
the maxlength property of a text field and select boxes having pre-defined 
data).

I basically want to ensure the server side validation is solid. I figured there 
would be a firefox extension for this but my google fu is weak today.

Thanks for the tips.
Ramon Ecung II, BS, ACHDS, MCP
Sent from my Mobile Device



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332886
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: cfscript for cfsetting

[Jason Durham]

That link is for the CFML equivalents in CFScript.  If it's not there... there 
is no equivalent. :)

-Original Message-
From: Carol F [mailto:cfcn...@gmail.com]
Sent: Tuesday, January 26, 2010 2:04 PM
To: cf-talk
Subject: Re: cfscript for cfsetting


sorry, I saw that page before, but I could not find cfsetting, or is it
somewhere buried there?

On Tue, Jan 26, 2010 at 10:23 AM, Matt Quackenbush quackfu...@gmail.comwrote:


 The CF9 docs have had this ever since CF9 was released.


 http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSe9cbe5cf462523a02805926a1237efcbfd5-7fff.html






~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330153
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Why .Net is on its last legs

[Jason Durham]

Personally, I think it's related to the instable economy.  Pack your bags and 
move your family to Northern Virginia.  Those guys are complete clowns!  I read 
somewhere that they are all using Allair Cold Fuzion.

-Original Message-
From: Tom Kitta [mailto:t...@tomkitta.com]
Sent: Thursday, January 21, 2010 4:11 PM
To: cf-talk
Subject: Why .Net is on its last legs


So I moved to a .Net shop a while back and I can say that .Net is on its last 
legs. Well, its nice to program these elegant elaborate fully object oriented 
systems in C# and be able to whip out a console application once in a while, as 
needed. Sure, it makes one feel smart to throw all these fancy acronyms and 
names and have a full knowledge that the stuff you work on is so complicated 
that a mere mortal cannot handle it.

The only problem with all of that is that for all of above benefits there is a 
high price to pay. And that price is development speed. If you need something 
now, .Net is not a rapid application development platform. Its more of a snail 
development with detective work... I mean sometimes you are spending a lot of 
time figuring out where the code is.

So if the world needs in the future are for things to be delivered yesterday... 
.Net is definitely on its last legs unless something even better than latest DB 
improvements in 4.0 comes out. Or MS just threatens everyone with sudden death.

Just my 2c.


From: Qing Xia txiasum...@gmail.com
Sent: Thursday, January 21, 2010 1:50 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: Why i fear ColdFusion is on its last legs

Now, here's the ultimate test: let's post a ASP.NET is dying thread to
their mailing list and see if the response is as strong.  [?]







~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329982
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: setting up new site IIS, now urls are getting appended..

[Jason Durham]

Show us the anchor tag and any other relevant information.

-Original Message-
From: morchella [mailto:morchella.delici...@gmail.com]
Sent: Tuesday, January 19, 2010 5:30 PM
To: cf-talk
Subject: setting up new site IIS, now urls are getting appended..


ok i have set up a new site in IIS.
now on a page that has a simple link
it is being appended with the site IP

so link looks like http://12.345.678.910/www.google.com
instead of  http://www.google.com

i am sure i have seen this in the past, just not sure where to look.
or what to change.

thanks a bunch!
-m



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329807
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

(ot) SQL query aliases in SQL Management Studio

[Jason Durham]

My apologies for posting an OT message to a ColdFusion list.  RDMS are so 
closely tied to our day-to-day job in writing CF, that perhaps the list will be 
tolerant of such a question.

I'm writing a View for our CRM package to use.  The SQL works as I've written 
it, but Management Studio keeps aliasing my tables and I can't find a way to 
either a) prevent Management Studio from adding the aliases or b) correctly 
write my own aliases which returns the proper data.  If I execute the SQL as 
written, it works.  However, after it's executed the first time, the View  
referenced in the 2nd JOIN is aliased and causes Unsupported Data Type to be 
returned for MyCustomField2 on subsequent executions.

The query is quite large, but I've simplified it for this list.

WORKING SQL

SELECT dbo.tblOpportunities.OpportunityKeyID, 
dbo.tblOpportunties.OpportunityName,
F1.CustomFieldValue AS MyCustomField1,
F2.CustomFieldValue AS MyCustomField2
FROM tblOpportunities
LEFT OUTER JOIN
(
SELECT OpportunityKeyID, CustomFieldValue
FROM dbo.tvw_CustomOpportunityFieldData
WHERE  OrdinalPosition = 1
)  AS F1 ON F1.OpportunityKeyID = dbo.tblOpportunities.OpportunityKeyID
LEFT OUTER JOIN
(
SELECT OpportunityKeyID, CustomFieldValue
FROM dbo.tvw_CustomOpportunityFieldData
WHERE  OrdinalPosition = 2
)  AS F2 ON F2.OpportunityKeyID = dbo.tblOpportunities.OpportunityKeyID




SQL MANAGEMENT STUDIO ALIAS ADDED

SELECT dbo.tblOpportunities.OpportunityKeyID, 
dbo.tblOpportunties.OpportunityName,
F1.CustomFieldValue AS MyCustomField1,
F2.CustomFieldValue AS MyCustomField2
FROM tblOpportunities
LEFT OUTER JOIN
(
SELECT OpportunityKeyID, CustomFieldValue
FROM dbo.tvw_CustomOpportunityFieldData
WHERE  OrdinalPosition = 1
)  AS F1 ON F1.OpportunityKeyID = dbo.tblOpportunities.OpportunityKeyID
LEFT OUTER JOIN
(
SELECT OpportunityKeyID, CustomFieldValue
FROM dbo.tvw_CustomOpportunityFieldData AS 
tvw_CustomOpportunityFieldData_2 /** THIS WAS ALTERED ***/
WHERE  OrdinalPosition = 2
)  AS F2 ON F2.OpportunityKeyID = dbo.tblOpportunities.OpportunityKeyID




Confidentiality Warning: This e-mail contains information intended only for the 
use of the individual or entity named above. If the reader of this e-mail is 
not the intended recipient or the employee or agent responsible for delivering 
it to the intended recipient, any dissemination, publication or copying of this 
e-mail is strictly prohibited. The sender does not accept any responsibility 
for any loss, disruption or damage to your data or computer system that may 
occur while using data contained in, or transmitted with, this e-mail. If you 
have received this e-mail in error, please immediately notify us by return 
e-mail.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329307
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) SQL query aliases in SQL Management Studio

[Jason Durham]

Thanks Dave.  Worked like a charm.  I'll just have to annotate the SQL so 
future modifications to this View don't cause the same problem I've been 
fighting.

-Original Message-
From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com]
Sent: Tuesday, December 22, 2009 10:48 AM
To: cf-talk
Subject: Re: (ot) SQL query aliases in SQL Management Studio


Hi Jason,

I would recommended creating the view from a query window, and not the
design view that SQL Management studio uses

Simply add a 'Create View dbo. AS' before the statement that works and
run it in the query window

Hope this helps
-Dave

On Tue, Dec 22, 2009 at 11:34 AM, Jason Durham jdur...@cti-stl.com wrote:


 My apologies for posting an OT message to a ColdFusion list.  RDMS are so
 closely tied to our day-to-day job in writing CF, that perhaps the list will
 be tolerant of such a question.

 I'm writing a View for our CRM package to use.  The SQL works as I've
 written it, but Management Studio keeps aliasing my tables and I can't find
 a way to either a) prevent Management Studio from adding the aliases or b)
 correctly write my own aliases which returns the proper data.  If I execute
 the SQL as written, it works.  However, after it's executed the first time,
 the View  referenced in the 2nd JOIN is aliased and causes Unsupported Data
 Type to be returned for MyCustomField2 on subsequent executions.

 The query is quite large, but I've simplified it for this list.

 WORKING SQL
 
 SELECT dbo.tblOpportunities.OpportunityKeyID,
 dbo.tblOpportunties.OpportunityName,
 F1.CustomFieldValue AS MyCustomField1,
 F2.CustomFieldValue AS MyCustomField2
 FROM tblOpportunities
 LEFT OUTER JOIN
(
 SELECT OpportunityKeyID, CustomFieldValue
FROM dbo.tvw_CustomOpportunityFieldData
WHERE  OrdinalPosition = 1
 )  AS F1 ON F1.OpportunityKeyID = dbo.tblOpportunities.OpportunityKeyID
 LEFT OUTER JOIN
(
 SELECT OpportunityKeyID, CustomFieldValue
FROM dbo.tvw_CustomOpportunityFieldData
WHERE  OrdinalPosition = 2
 )  AS F2 ON F2.OpportunityKeyID = dbo.tblOpportunities.OpportunityKeyID




 SQL MANAGEMENT STUDIO ALIAS ADDED
 
 SELECT dbo.tblOpportunities.OpportunityKeyID,
 dbo.tblOpportunties.OpportunityName,
 F1.CustomFieldValue AS MyCustomField1,
 F2.CustomFieldValue AS MyCustomField2
 FROM tblOpportunities
 LEFT OUTER JOIN
(
 SELECT OpportunityKeyID, CustomFieldValue
FROM dbo.tvw_CustomOpportunityFieldData
WHERE  OrdinalPosition = 1
 )  AS F1 ON F1.OpportunityKeyID = dbo.tblOpportunities.OpportunityKeyID
 LEFT OUTER JOIN
(
 SELECT OpportunityKeyID, CustomFieldValue
FROM dbo.tvw_CustomOpportunityFieldData AS
 tvw_CustomOpportunityFieldData_2 /** THIS WAS ALTERED ***/
WHERE  OrdinalPosition = 2
 )  AS F2 ON F2.OpportunityKeyID = dbo.tblOpportunities.OpportunityKeyID



 
 Confidentiality Warning: This e-mail contains information intended only for
 the use of the individual or entity named above. If the reader of this
 e-mail is not the intended recipient or the employee or agent responsible
 for delivering it to the intended recipient, any dissemination, publication
 or copying of this e-mail is strictly prohibited. The sender does not accept
 any responsibility for any loss, disruption or damage to your data or
 computer system that may occur while using data contained in, or transmitted
 with, this e-mail. If you have received this e-mail in error, please
 immediately notify us by return e-mail.






~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329311
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Basic user stats via Coldfusion

[Jason Durham]

You could capture the CGI variables on onRequestStart and insert them into the 
DB onSessionEnd.  You will lose data on server restarts for active sessions.

-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com]
Sent: Tuesday, December 15, 2009 10:54 AM
To: cf-talk
Subject: RE: Basic user stats via Coldfusion


Ian,

This sounds like you should be looking at the webserver logs.  If you
are using IIS, you can have it log the Windows Login info in the IIS
logs.

I don't know if Apache can or not.

Then you can use something like LOG Parser from Microsoft to search the
log files just like you would with a database.

Steve


-Original Message-
From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk]
Sent: Tuesday, December 15, 2009 11:47 AM
To: cf-talk
Subject: RE: Basic user stats via Coldfusion


Hi Jason

All I am trying to do is track what url's on our Intranet a unique user
accesses each day.  There could be a couple of hundred pages.

The problem with most analytics software is that they do not capture the
user's windows logon/network ID so we can identify exactly who is
viewing what on the Intranet.  Analytic software such as Google just
captures a users IP address which is dynamic and changes each day so we
can't tell what employees are accessing certain areas of the Intranet.

It would be great if Coldfusion could help provide a solution for this
ot if anybody knows of any analytical software that would capture this
information?



-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com]
Sent: 07 December 2009 17:32
To: cf-talk
Subject: RE: Basic user stats via Coldfusion


Am I properly restating this...

You want to track what pages each user hits in a day.

How many pages are we talking about?  Couple dozen?  Couple hundred?
Couple thousand?

-Original Message-
From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk]
Sent: Monday, December 07, 2009 11:06 AM
To: cf-talk
Subject: Basic user stats via Coldfusion


On our intranet I have a coldfusion script that captures a user's
network/loginid

cfset user = listLast(cgi.REMOTE_USER,\) 

This variable is then run against a user table with the following
'where' clause

WHERE uPPER(NETWORK_ID) = '#ucASE(user)#'

This then captures user info such as

Loginid
Name
Job Title
Department
IP address etc


How would you restrict the query so it only runs once on each page per
day for each user, instead of running every time the page is loaded?


And where would this query be better placed, as I don't really want to
include it in each page manually.


Any ideas would be welcome?










~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329171
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Basic user stats via Coldfusion

[Jason Durham]

Am I properly restating this...

You want to track what pages each user hits in a day.

How many pages are we talking about?  Couple dozen?  Couple hundred?  Couple 
thousand?

-Original Message-
From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk]
Sent: Monday, December 07, 2009 11:06 AM
To: cf-talk
Subject: Basic user stats via Coldfusion


On our intranet I have a coldfusion script that captures a user's
network/loginid

cfset user = listLast(cgi.REMOTE_USER,\) 

This variable is then run against a user table with the following
'where' clause

WHERE uPPER(NETWORK_ID) = '#ucASE(user)#'

This then captures user info such as

Loginid
Name
Job Title
Department
IP address etc


How would you restrict the query so it only runs once on each page per
day for each user, instead of running every time the page is loaded?


And where would this query be better placed, as I don't really want to
include it in each page manually.


Any ideas would be welcome?




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328916
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Find city/state by IP Address?

[Jason Durham]

Anybody know of a web service that provides a city/state based upon an IP 
address?  I found many sites that perform the service, but none of them will 
allow me to use their tools remotely.

Jason


Confidentiality Warning: This e-mail contains information intended only for the 
use of the individual or entity named above. If the reader of this e-mail is 
not the intended recipient or the employee or agent responsible for delivering 
it to the intended recipient, any dissemination, publication or copying of this 
e-mail is strictly prohibited. The sender does not accept any responsibility 
for any loss, disruption or damage to your data or computer system that may 
occur while using data contained in, or transmitted with, this e-mail. If you 
have received this e-mail in error, please immediately notify us by return 
e-mail.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328836
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Accordion - How do you?

[Jason Durham]

HAHA

-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com]
Sent: Thursday, December 03, 2009 6:09 PM
To: cf-talk
Subject: Re: Accordion - How do you?


My bad in advance

what is jquery?

http://tinyurl.com/mbteqj

G!

On Thu, Dec 3, 2009 at 6:53 PM, Kim Hoopingarner 
k.hoopingar...@e-details.com wrote:


 what is jquery?





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328837
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Find city/state by IP Address?

[Jason Durham]

Thanks for the link.  I'm in the same boat as that person.  This is a low 
traffic site, so I'm looking for something dirty cheap, or free.  I should have 
specified that initially. :)

-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com]
Sent: Friday, December 04, 2009 10:14 AM
To: cf-talk
Subject: RE: Find city/state by IP Address?


Found this:
http://askville.amazon.com/Free-IP-address-Location-API-country-state-provin
ce/AnswerViewer.do?requestId=56161316



-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com]
Sent: Friday, December 04, 2009 10:05 AM
To: cf-talk
Subject: Find city/state by IP Address?


Anybody know of a web service that provides a city/state based upon an IP
address?  I found many sites that perform the service, but none of them will
allow me to use their tools remotely.

Jason


Confidentiality Warning: This e-mail contains information intended only for
the use of the individual or entity named above. If the reader of this
e-mail is not the intended recipient or the employee or agent responsible
for delivering it to the intended recipient, any dissemination, publication
or copying of this e-mail is strictly prohibited. The sender does not accept
any responsibility for any loss, disruption or damage to your data or
computer system that may occur while using data contained in, or transmitted
with, this e-mail. If you have received this e-mail in error, please
immediately notify us by return e-mail.






~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328841
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Find city/state by IP Address?

[Jason Durham]

Thanks again for the reply. My eyes were moving faster than my brain when I 
read that site.  The online demo seems to return my ISP's home office, rather 
than my location.  I'll keep digging though.

-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com]
Sent: Friday, December 04, 2009 10:25 AM
To: cf-talk
Subject: RE: Find city/state by IP Address?


That's fine, although that link seems to indicate that MaxMind is free at
the city level (which it sounds like you want).

-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com]
Sent: Friday, December 04, 2009 10:20 AM
To: cf-talk
Subject: RE: Find city/state by IP Address?


Thanks for the link.  I'm in the same boat as that person.  This is a low
traffic site, so I'm looking for something dirty cheap, or free.  I should
have specified that initially. :)

-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com]
Sent: Friday, December 04, 2009 10:14 AM
To: cf-talk
Subject: RE: Find city/state by IP Address?


Found this:
http://askville.amazon.com/Free-IP-address-Location-API-country-state-provin
ce/AnswerViewer.do?requestId=56161316



-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com]
Sent: Friday, December 04, 2009 10:05 AM
To: cf-talk
Subject: Find city/state by IP Address?


Anybody know of a web service that provides a city/state based upon an IP
address?  I found many sites that perform the service, but none of them will
allow me to use their tools remotely.

Jason


Confidentiality Warning: This e-mail contains information intended only for
the use of the individual or entity named above. If the reader of this
e-mail is not the intended recipient or the employee or agent responsible
for delivering it to the intended recipient, any dissemination, publication
or copying of this e-mail is strictly prohibited. The sender does not accept
any responsibility for any loss, disruption or damage to your data or
computer system that may occur while using data contained in, or transmitted
with, this e-mail. If you have received this e-mail in error, please
immediately notify us by return e-mail.










~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328843
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Find city/state by IP Address?

[Jason Durham]

The client requesting this would probably not pay enough to make it worth your 
effort.  Maybe $100-150 _a year_.  Of course, that's just my instinct.  I'd 
have to clear it with them.

-Original Message-
From: Jason Todd [mailto:ja...@alpinehomeair.com]
Sent: Friday, December 04, 2009 10:41 AM
To: cf-talk
Subject: Re: Find city/state by IP Address?


We have regularly refreshed data in SQL and have considered opening up a web 
server to it as our internal systems will be moving to accessing via web 
services instead of ODBC. Are you looking to pay by transaction or flat fee? 
Also, what volume of requests are you looking at? If you're just looking for a 
good source of data, I can dig up where we get ours. I've used a few providers 
and found there to be a vast difference in quality.


 Anybody know of a web service that provides a city/state based upon an
 IP address?  I found many sites that perform the service, but none of
 them will allow me to use their tools remotely.

 Jason

 
 Confidentiality Warning: This e-mail contains information intended
 only for the use of the individual or entity named above. If the
 reader of this e-mail is not the intended recipient or the employee or
 agent responsible for delivering it to the intended recipient, any
 dissemination, publication or copying of this e-mail is strictly
 prohibited. The sender does not accept any responsibility for any loss,
 disruption or damage to your data or computer system that may occur
 while using data contained in, or transmitted with, this e-mail. If
 you have received this e-mail in error, please immediately notify us
 by return e-mail.




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328848
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Find city/state by IP Address?

[Jason Durham]

Thanks for the link.  I ran across them via Google.  Their pages are s busy 
but I found what I needed there.

http://www.ip2location.com/XXX.XXX.XXX.XXX is enough for this client.  They'll 
just have to click a link.

-Original Message-
From: Jason Todd [mailto:ja...@alpinehomeair.com]
Sent: Friday, December 04, 2009 10:46 AM
To: cf-talk
Subject: Re: Find city/state by IP Address?


Found our db provider who we've had good success with. Accuracy/inclusion is 
significantly higher than maxmind.

http://www.ip2location.com

Only option is to download the data to db, though.


 Anybody know of a web service that provides a city/state based upon an
 IP address?  I found many sites that perform the service, but none of
 them will allow me to use their tools remotely.

 Jason

 
 Confidentiality Warning: This e-mail contains information intended
 only for the use of the individual or entity named above. If the
 reader of this e-mail is not the intended recipient or the employee or
 agent responsible for delivering it to the intended recipient, any
 dissemination, publication or copying of this e-mail is strictly
 prohibited. The sender does not accept any responsibility for any loss,
 disruption or damage to your data or computer system that may occur
 while using data contained in, or transmitted with, this e-mail. If
 you have received this e-mail in error, please immediately notify us
 by return e-mail.




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328850
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Find city/state by IP Address?

[Jason Durham]

Thanks Tony!  That works like a champ.

-Original Message-
From: Tony Bentley [mailto:t...@tonybentley.com]
Sent: Friday, December 04, 2009 11:47 AM
To: cf-talk
Subject: Re: Find city/state by IP Address?


http://ipinfodb.com/ip_query.php?ip=

cfhttp method=get 
URL=http://ipinfodb.com/ip_query.php?ip=#cgi.REMOTE_ADDR#; result=test /
cfset xmmm = xmlparse(test.filecontent)
cfset countrycode = xmmm.response.countrycode.xmltext
cfset countryname = xmmm.response.countryname.xmltext
cfset city = xmmm.response.city.xmltext
cfset zippostalcode =  
xmmm.response.zippostalcode.xmltext
cfset latitude = xmmm.response.latitude.xmltext
cfset longitude =  xmmm.response.longitude.xmltext
cfset gmtoffset = xmmm.response.gmtoffset.xmltext
cfset dstoffset = xmmm.response.dstoffset.xmltext
cfset regionname = xmmm.response.regionname.xmltext
cfset regioncode = xmmm.response.regioncode.xmltext




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328865
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: RPC server is unavailable

[Jason Durham]

Assuming the DCs are online, it's almost always (in my experience) related to 
DNS.

-Original Message-
From: Andrew Peterson [mailto:webmas...@mail.ioc.state.il.us]
Sent: Friday, December 04, 2009 12:40 PM
To: cf-talk
Subject: RPC server is unavailable


Hi,

We're getting an RPC server is unavailable error when I try to authenticate a 
user using NT Authentication. Always worked - now it does not. The issue 
affects multiple servers on our network - and both CF9 and CF8. While I'm 
certain it is not a CF issue, I want our network dept to be certain as well. 
Anyone have this issue that can shed some light on a resolution? Thanks. Code 
is as follows:

ntauth = createObject(java, jrun.security.NTAuth);
ntauth.init(arguments.domain);
groups = ntauth.GetUserGroups(arguments.userid);

Error is as follows:

java.lang.RuntimeException - in C:\Inetpub\wwwroot\ntsecurity.cfc : line 82

The RPC server is unavailable.





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328866
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: MORE form insanity

[Jason Durham]

Is the CF/HTML you're posting really cut/pasted from the actual templates?  It 
appears not because you're missing a C in cfoutput query=list_units.

As others have said... get the Firefox Web Developer toolbar and validate your 
HTML frequently.  You're violating at least 3 best practices in the code 
you've provided (SELECT *, no cfqueryparam and malformed HTML).

-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com]
Sent: Thursday, November 05, 2009 8:40 AM
To: cf-talk
Subject: RE: MORE form insanity


You'll get fewer unexpected results if your HTML is valid.

1) Close your option tags. This isn't 1997.
2) all attributes must have values:
multiple=multiple
http://webdesign.about.com/od/htmltags/p/blatmultiple.htm

I might guess that the reason you're having dupe outputs is that your query
column name is the same as your FORM name. Possibly the values are
outputting from both values since you're not scoping your var in the output.

Dump both the query, and the FORM scope and see what you get.

-Original Message-
From: Timothy Laureska [mailto:tlaure...@dhmh.state.md.us]
Sent: Thursday, November 05, 2009 8:20 AM
To: cf-talk
Subject: MORE form insanity


Hello:
Thanks to those that pointed out the missing SELECTED on the last question,
but here's a another mystery to me :

I  have this select statement:

select name=unit_id_other multiple
foutput query=list_units
option value=#unit_id##unit_name#
/cfoutput
/select

going to this processing output template query:

cfquery datasource=#datasource# name=find_other_unit SELECT * FROM
dhmh_units where unit_id IN (#form.unit_id_other#) /cfquery

cfoutput query=find_other_unit#unit_id_other#,/cfoutput

Which yields duplicate data For example, when I just select two items from
the dropdown box, I get this output:  26,20, 26, 20

Output of the form variable by itself is a single set of data:  26, 20

Any assistance would be appreciated







~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328074
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: TechCrunch calls ColdFusion outmoded technology

[Jason Durham]

Their comments didn't upset me.  ColdFusion has changed quite a bit since 2000. 
 Not to mention, the app has been evolving for nearly a decade. It sounded like 
they got something up quick and the site took off.  Sounds like ColdFusion 
was a rock star for 6-9 years if you ask me. :o)

Only now does it finally have a modern architecture, built on Java and 
designed to scale.
Psst... ColdFusion MX-9 has had a Java backend.



-Original Message-
From: Rick Mason [mailto:rhma...@gmail.com]
Sent: Monday, November 02, 2009 5:19 PM
To: cf-talk
Subject: TechCrunch calls ColdFusion outmoded technology


Eric Schonfeld writing on TechCrunch about the b2b site mfg.com that
recently was rebuilt from the ground up.  He said the rebuilding was
necessary because it was still using the outmoded technology of ColdFusion.

http://www.techcrunch.com/2009/11/02/mfg-com-takes-off-the-cuffs-with-manufacturing-marketplace-redesign/

I don't like seeing the business tech press getting this wrong.  I don't
know if he was told that by the mfg.com people or he just made the judgement
based on what he might have read in a trade journal.



Rick




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327934
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

(ot) iPhone app developer request

[Jason Durham]

I'm asking this for a friend... he's looking for a developer to create a 
simple application for the iPhone.  If you're interested, please contact me 
off list.

Jason



Confidentiality Warning: This e-mail contains information intended only for the 
use of the individual or entity named above. If the reader of this e-mail is 
not the intended recipient or the employee or agent responsible for delivering 
it to the intended recipient, any dissemination, publication or copying of this 
e-mail is strictly prohibited. The sender does not accept any responsibility 
for any loss, disruption or damage to your data or computer system that may 
occur while using data contained in, or transmitted with, this e-mail. If you 
have received this e-mail in error, please immediately notify us by return 
e-mail.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327807
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: create datasource in cfm page

[Jason Durham]

http://www.talkingtree.com/blog/index.cfm/2006/6/22/Verify-DSN-AdminAPI

-Original Message-
From: Richard White [mailto:rich...@j7is.co.uk]
Sent: Tuesday, October 20, 2009 10:11 AM
To: cf-talk
Subject: create datasource in cfm page


hi

is there a way to create a data source in a cfm page as opposed to the cf 
administrator

thanks

richard



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327380
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF load times on VPS

[Jason Durham]

This sounds like a good question for the CF server list.  Not trying to be 
rude, but rather helpful in getting a prompt solution to your inquiry. :)

-Original Message-
From: Chip Beck [mailto:chipb...@gmail.com]
Sent: Wednesday, September 16, 2009 9:42 AM
To: cf-talk
Subject: CF load times on VPS


Forgive me in advance for this seemingly vague question, but I'm mostly just
asking for suggestions on a general method of troubleshooting this...
I just switched from a CrystalTech semi-dedicated server to a KickAssVPS
because my company needed the reliability and speed of our CMS to be
more consistent / improved. I have duplicated the site and have been running
different pages to test load times. Any .cfm file on the CrystalTech server
that takes, say, around a few hundred milliseconds to load normally, loads
on the new KickAssVPS server twice as fast. Any .cfm file that has a much
larger load time, like one page that takes nearly 5000ms to load takes twice
as LONG on the KickAssVPS.

Again, I realize how vague this question is and how there are 1,000 things
that may be happening here, but I was wondering if anyone had any idea why
smaller files would process much quicker, and larger files slower. What
information can I provide the list so I can get some suggestions? Help me
help you help me!




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326353
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CNAME or sub domain

[Jason Durham]

Use a CNAME to point to your web server/site and apply an ISAPI filter (for 
IIS) or mod_rewrite (for Apache) to rewrite the URL.


-Original Message-
From: Andrew Grosset [mailto:rushg...@yahoo.com]
Sent: Saturday, September 12, 2009 7:23 PM
To: cf-talk
Subject: CNAME or sub domain


I have a site under development and one directoty is a forums section: 
mywebsite.com/forums. I would like to have this directory mapped as 
forums.mywebsite.com should I use a CNAME solution (I currently have a CNAME 
setup
 - pics.mywebsite.com - which goes to amazon). My idea being that I should 
launch the site as forums.mywebsite.com and have it pointed to 
mywebsite.com/forums which gives me the flexibility to put the forums section 
wherever without
changing the url in the future. So my question is: whats the best way to handle 
this?




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326249
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Is this possible with component methods in cf8?

[Jason Durham]

I don't see why you can't do this.  However, the detailed answer on how to do 
this depends on countless variables.

Here is a high level suggestion...
===
User submits form and is directed to update status page
An object is created for each of the images and registers with an Observer
Each object resizes, saves, whatever the images, and contains the state 
(uploading, validating, resizing, saving, error)
The update status page contacts the Observer for the states of the 
Observables every few seconds



-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: Friday, September 11, 2009 11:49 PM
To: cf-talk
Subject: Is this possible with component methods in cf8?


What I'd like to do concerns uploading and processing images which sometimes
takes

awhile and leaves the user wondering what's happening while they're waiting.



If the user is uploading, say 10 photos, and all the photos have to be
resized into two different

images, renamed, saved, etc., the process can take some time.



I was wondering if I could set up a method of process 1 images, then return
the name of the

image to the user via ajax, with a message such as Image house1.jpg
processed., then when

image two has been uploaded and processed, Image house2.jpg processed,
etc. until all

images have been processed.



This would keep the user informed of the progress and keep them from
worrying that the

process was hanging up.



So, the question is, can messages (via cfreturn) be sent back to the client
multiple times

from a method?  Or perhaps there's a different way to achieve this?



Any suggestions or ideas?



Thanks,



Rick




---

Those who hammer their guns into plows will plow for those who do not.  -
Thomas Jefferson








~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326250
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: What's the best way to handle returning two queries from a component for looping?

[Jason Durham]

There are lots of ways to accomplish that.  The simplest way seems to be
with SQL JOINs and group the output.


-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com] 
Sent: Wednesday, May 27, 2009 1:39 PM
To: cf-talk
Subject: What's the best way to handle returning two queries from a
component for looping?


Hi, all...

After a *lot* of work in jQuery, specifically AJAX, I'm finally back
some
more *friendly* territory
with CF again as a focus.

Anyway, I'm expanding my ability to use cfc methods and have just run
into a
situation where I
need to do a typical loop one query to get a title and loop another
query
inside the first query
to output details from another query, so I get:

Title 1
 - details 1
 - details 2
 - details 3

Title 2
 - details 1
 - details 2
 - details 3

Instead of:

Title 1
 - details 1
Title 1
 - details 2

etc...

This is a no-brainer for standard on-page queries, but getting the
info
back from a method(s) is a little trickier.
It's a little dark in the room and so far, no light bulbs have come on
over
my head...

Do I have to return two queries in a struct?  Can I loop the structs as
I do
queries?  Is this where methods and
extend other methods come into play?

I read part of a chapter online from one of the CF8 books which seemed
to
use a getMetaData function or something
like that to loop over parts of extended functions...I didn't quite
understand that brief explanation.

Hoping someone can point me in the right direction...approach to take?
Tutorial for this?

Thanks for any advice.

Rick

-- 


--
Ninety percent of the politicians give the other ten percent a bad
reputation.  Henry Kissinger




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322844
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Parsing large CSVs and inserting in MSSQL

[Jason Durham]

I have been tasked with providing a mechanism to upload/parse/perform a
couple of checks/save CSV data.  The current test file is 28,000 records
(~16 columns).  I expect this file to grow in size each month, to an
indeterminate number (hundreds of thousands).

 

It seems that I'll need to set a limit on the number of rows being
processed at each time.   The two obvious options (in my eyes)... 

 

#1 break the CSV up into several smaller CSV files and write them back
to the file system before processing each individually (all checks
performed in memory)

#2 set a large timeout value and attempt to load all of the records from
the CSV into a temp table, retrieving back smaller, more manageable
record sets

 

Currently, I'm doing #2 but not limiting the number of records (28,000).
The data is getting into the temp table, being retrieved, but the final
insert is causing ColdFusion to hang.  The final insert consists of one
cfquery with an internal loop over the temp table query object.  The
final insert is within a single transaction so I can rollback if it
fails.

 

This process will only take place on my development machine, connecting
to the live database.  2.6 Core 2 Duo, 4GB, Vista 32 with a 100MB
connection to production server running MS SQL 2005 Express.

 

Perhaps I need to take a step back and consider alternatives.  Btw, the
checks I'm performing are simply that 2 of the columns do not contain
a unique value (FKs).  I'm currently doing this with QoQs but I could
probably push this off with a fairly complicated query to MS SQL.  What
do the CF wizards suggest?   

 

TIA



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322777
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Parsing large CSVs and inserting in MSSQL

[Jason Durham]

Thanks to everybody who has replied.  It appears I need to do some
homework on MS SQL.  :)

-Original Message-
From: Mark Kruger [mailto:mkru...@cfwebtools.com] 
Sent: Tuesday, May 26, 2009 11:03 AM
To: cf-talk
Subject: RE: Parsing large CSVs and inserting in MSSQL


Jason,

This is not what you want to hear but

My advice would be don't use CF to do this. DTS (or SSIS) is quite
capable
of doing this in about 1/30 the time that CF is able to do this. One of
our
DTS packages consumes a file of over 300k rows in less than 15 seconds
every
few minutes. You can't get that with CF no matter how hard you try :) 

But if you insist on doing it with CF, don't use CFFILE. Instead read
the
lines in one at a time using a line reader technique - that will allow
you
to handle one line at a time instead of reding the entire file into
memory.

-Mark

Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com] 
Sent: Tuesday, May 26, 2009 10:53 AM
To: cf-talk
Subject: Parsing large CSVs and inserting in MSSQL


I have been tasked with providing a mechanism to upload/parse/perform a
couple of checks/save CSV data.  The current test file is 28,000 records
(~16 columns).  I expect this file to grow in size each month, to an
indeterminate number (hundreds of thousands).

 

It seems that I'll need to set a limit on the number of rows being
processed at each time.   The two obvious options (in my eyes)... 

 

#1 break the CSV up into several smaller CSV files and write them back
to
the file system before processing each individually (all checks
performed in
memory)

#2 set a large timeout value and attempt to load all of the records from
the
CSV into a temp table, retrieving back smaller, more manageable record
sets

 

Currently, I'm doing #2 but not limiting the number of records (28,000).
The data is getting into the temp table, being retrieved, but the final
insert is causing ColdFusion to hang.  The final insert consists of one
cfquery with an internal loop over the temp table query object.  The
final
insert is within a single transaction so I can rollback if it fails.

 

This process will only take place on my development machine, connecting
to
the live database.  2.6 Core 2 Duo, 4GB, Vista 32 with a 100MB
connection to
production server running MS SQL 2005 Express.

 

Perhaps I need to take a step back and consider alternatives.  Btw, the
checks I'm performing are simply that 2 of the columns do not contain
a
unique value (FKs).  I'm currently doing this with QoQs but I could
probably
push this off with a fairly complicated query to MS SQL.  What
do the CF wizards suggest?   

 

TIA







~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322792
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Parsing large CSVs and inserting in MSSQL

[Jason Durham]

I have a dormant 'roided out MS SQL 2008 Standard box I can use in lieu.
In fact, the plan was to migrate to that after I've built this module.
:)

Thanks for catching that (and for your help).

Jason

-Original Message-
From: Mark Kruger [mailto:mkru...@cfwebtools.com] 
Sent: Tuesday, May 26, 2009 1:37 PM
To: cf-talk
Subject: RE: Parsing large CSVs and inserting in MSSQL


Jason,

Here's a big uh oh for you If you are using MSSQL express you
don't
have the SSIS services that come with it. DTS may be possible through
installing the active X controls on the same server - but you may be out
of
luck if you want to do SSIS.

-Mark
 


Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com] 
Sent: Tuesday, May 26, 2009 1:27 PM
To: cf-talk
Subject: RE: Parsing large CSVs and inserting in MSSQL


Thanks to everybody who has replied.  It appears I need to do some
homework
on MS SQL.  :)

-Original Message-
From: Mark Kruger [mailto:mkru...@cfwebtools.com]
Sent: Tuesday, May 26, 2009 11:03 AM
To: cf-talk
Subject: RE: Parsing large CSVs and inserting in MSSQL


Jason,

This is not what you want to hear but

My advice would be don't use CF to do this. DTS (or SSIS) is quite
capable
of doing this in about 1/30 the time that CF is able to do this. One of
our
DTS packages consumes a file of over 300k rows in less than 15 seconds
every
few minutes. You can't get that with CF no matter how hard you try :) 

But if you insist on doing it with CF, don't use CFFILE. Instead read
the
lines in one at a time using a line reader technique - that will allow
you
to handle one line at a time instead of reding the entire file into
memory.

-Mark

Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com

-Original Message-
From: Jason Durham [mailto:jdur...@cti-stl.com] 
Sent: Tuesday, May 26, 2009 10:53 AM
To: cf-talk
Subject: Parsing large CSVs and inserting in MSSQL


I have been tasked with providing a mechanism to upload/parse/perform a
couple of checks/save CSV data.  The current test file is 28,000 records
(~16 columns).  I expect this file to grow in size each month, to an
indeterminate number (hundreds of thousands).

 

It seems that I'll need to set a limit on the number of rows being
processed at each time.   The two obvious options (in my eyes)... 

 

#1 break the CSV up into several smaller CSV files and write them back
to
the file system before processing each individually (all checks
performed in
memory)

#2 set a large timeout value and attempt to load all of the records from
the
CSV into a temp table, retrieving back smaller, more manageable record
sets

 

Currently, I'm doing #2 but not limiting the number of records (28,000).
The data is getting into the temp table, being retrieved, but the final
insert is causing ColdFusion to hang.  The final insert consists of one
cfquery with an internal loop over the temp table query object.  The
final
insert is within a single transaction so I can rollback if it fails.

 

This process will only take place on my development machine, connecting
to
the live database.  2.6 Core 2 Duo, 4GB, Vista 32 with a 100MB
connection to
production server running MS SQL 2005 Express.

 

Perhaps I need to take a step back and consider alternatives.  Btw, the
checks I'm performing are simply that 2 of the columns do not contain
a
unique value (FKs).  I'm currently doing this with QoQs but I could
probably
push this off with a fairly complicated query to MS SQL.  What
do the CF wizards suggest?   

 

TIA











~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322794
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

ColdFusion version of ImageFolio?

[Jason Durham]

I have a friend with a  hobby business that is looking to sell some
photos.  He's looking for a web app that allows him to upload, watermark
and sell digital images similar to ImageFolio.   He'll probably want
some customization options so I'd like to find a solution in ColdFusion.
Anybody have any recommendations?

 

Here is an example of an existing installation of ImageFolio..

http://www.racingperspectives.com/cgi-bin/store/imageFolio.cgi?direct=Br
et_Kepner_Photos/Domestic_Body_Styles/GIR_2009-03-25_Wednesday

 

TIA 

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320989
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 *exactly* does cgi.server_name return.

[Jason Durham]

Since IIS uses the DNS alias in the URL and that can easily be spoof by
modifying your HOSTS file, I use a Java class if I need to identify a
machine (like for environmental changes).

InetAddress = createObject(java, java.net.InetAddress);
hostName = InetAddress.getLocalHost().getHostName();

At least in IIS, this returns the fully qualified domain name of the
ColdFusion machine.  It looks like Mike is using Apache, so this might
not be of specific use to him.  However, it's here for others to find
later. :)

Jason

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320480
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) Ionic's Isapi Rewrite Filter and Site Crash

[Jason Durham]

If you're using IIS7, there is a URL rewrite module for the IISMC.  

http://learn.iis.net/page.aspx/460/using-url-rewrite-module/

-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net] 
Sent: Wednesday, January 07, 2009 8:06 PM
To: cf-talk
Subject: (ot) Ionic's Isapi Rewrite Filter and Site Crash

If anybody is familiar with Ionic's Isapi Rewrite Filter...

I have asked folks over on the Ionic's forum about this, but there's not

much traffic there and I *bet* somebody here can answer before I get 
replies. Sorry for the OT, but I need to figure this out sooner than
later!

First, I'm *not* a server administrator. I know just enough to make 
small tweaks and get myself into trouble. So be kind!

Trying to set up my first rewrite:

RewriteRule  ^/attorney/([^/]+)$   /lawyers/get-bio.cfm?attorney=$1

Should rewrite: www.mysite.com/attorney/bob_smith to 
www.mysite.com/lawyers/get-bio.cfm?attorney=bob_smith. Correct? The 
code above is the *only* thing in the .ini file. Do I need anything
else?

I placed the .dll and .ini file in a folder on the server. Went into the

IIS Admin (IIS 7 I think...) and added the.dll to the ISAPI filters. 
Didn't do anything else. Was planning on restarting the server late this

evening when site activity was quite.However, the site immediately went 
down. There's a problem with the resource you're trying to access 
500 error...'

I removed the filter from the ISAPI filter window, and the site was back

up. Tried a second time just to be sure. Yup - site went down 
immediately. No stop/start IIS.

OK, now I'm afraid to do anything else. I can't afford to take the site 
down again by mistake.

I'll happily attempt to list other settings or stuff from log files if 
needed to help me figure what I've got wrong. You *might* have to tell 
me where to look though...

The site in question is a Coldfusion site, but sections are .net. There 
are two aspnet_filters listed already. Possible conflict?

Log file shows: The HTTP Filter DLL 
C:\Windows\System32\IsapiRewrite\IsapiRewrite4.dll failed to load.  The 
data is the error.

Not sure what to do next. Help?



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317629
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Variable within a variable

[Jason Durham]

Assuming your email message is _not_ in the database, just use
cfsavecontent  and appropriately nested cfoutput.

cfsavecontent variable=emailContent
cfoutput
pDear #customer#:/p 
pPay your $(*ing bill already./p
/cfoutput 
/cfsavecontent

-Original Message-
From: Seb Duggan [mailto:s...@sebduggan.com] 
Sent: Saturday, December 27, 2008 10:59 AM
To: cf-talk
Subject: Re: Variable within a variable

Either:

1. Have a separate file with just the content of the email, including  
the variables you want replaced, and include it in your cfmail like  
this:

cfmail ...
cfinclude template=myemailtemplate.cfm /
/cfmail

or:

2. If your template text is in a database, you could generate a temp  
file on the fly with the template text in it, then include that file  
as above. I'm not sure what the performance implications of this would  
be, but you'd have to weigh that against how often the process is  
called. Alternatively, generate the appropriate flat file whenever the  
template is updated.

But I've also used Dominic's method of replaceing a [variable] token  
in the template using Replace().


Seb


Seb Duggan
Web  ColdFusion Developer

e:  s...@sebduggan.com
t:  07786 333184
w:  http://sebduggan.com

On 27 Dec 2008, at 13:38, Maya MacDonald wrote:

 Seb,

 Thank you for the reply.

 I am not quite sure I am following how I would include this as a  
 flat file?

 Thanks,
 Devin



Seb Duggan
Web  ColdFusion Developer

e:  s...@sebduggan.com
t:  07786 333184
w:  http://sebduggan.com





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317165
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CF-based freelancer time/billing system?

[Jason Durham]

Thanks for sharing.  You make a very valid point (flexibility).  I
haven't jumped into the code for Project Tracker, but it seems to have a
good base for me to build upon.  I think I might extend the capabilities
of that tool (if the licensing/author allows).  Joe Danziger's blog says
that he plans to implement time tracking soon (posted 12/10/08).  I
hope soon means in the next couple of weeks. :o)

Thanks for all of the input.

-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com] 
Sent: Thursday, December 18, 2008 10:44 PM
To: cf-talk
Subject: Re: CF-based freelancer time/billing system?

I looked at all kinds of billing systems, and ended up writing my own.
  I found there was always something missing that i needed - the
ability to price a line independently of all the others,  or the
ability to use a currency other than AUD for example,  or be able to
send a copy of an invoice where the client alleges he never got it.
At least one feature i needed was missing from all the systems i
looked at.

So I wrote my own.  It's not all that difficult.   You need a means of
putting line items into an account ready to be billed - software sold,
hours worked,  domain names registered,   etc etc. Then you need a
separate way to query that account and assemble those line items into
an invoice,  do the arithmetic calculations,  prepare a PDF of your
invoice and email it to the client.   Then you need to be able to send
copies to people who dont pay you because they  allege they never
received the invoice,Next, you need a way to keep track of who's
paid you and who hasnt.And lastly you need to be able to produce
reports for tax and other purposes.

All involve adding records to a table,  and/or querying the table and
displaying them in one way or another. There is no fancy
processing required or ajax or flex or any of that. (although there
are things you can do to make it all slicker and sexier using tools
like ajax and flex) but its fairly straightforward from a coldfusion
point of view.

I have a clients table,  a price list table, a recurring charges table
(for my hosting accounts and domain name registry - to handle the
repeating monthly/quarterly/biannual/annual  charges)   and an
invoices table.   Thats it.

It took me a day to write and test my invoicing app, and a total of
about half a day since then for tweaks and mods i've made

At first, i tried to be cute and tie the hours to be billed in my
invoicing  to a little time counter app i have, but that never worked
because i dont always bill exactly the  hours i work on a project.
For example some projects i record the hours but bill a fixed price.
Or if it's maintenance work, some of the work is billable, some isnt.
 It all got too complicated.   So instead i have the time-tracking app
(called Trax-Time but it would suit an AIR app perfectly) running
separately,  and i use the reporting stuff in that to tell me how many
hours i've spent on what, then i handle billing separately.It
takes me a total of about an hour a month to handle the routine
billing tasks.


I say all this not to brag, because i dont think its anything to brag
about,  but to make the point that it's not that hard to get exactly
the billing system that suits you rather than have to change your
business systems to suit some one else's idea of how your business
should run.  It's simple and does precisely what i want it to, and no
more.  And if my business model changes in any way i have the stuff to
change my billing system to match the new business model.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month


On Fri, Dec 19, 2008 at 1:25 PM, Jason Durham jdur...@cti-stl.com
wrote:
 Thanks for the links.  Unfortunately none of those have a billing
 component to it.  I like Project Tracker and may consider adding the
 billing stuff myself.

 Jason

 -Original Message-
 From: John M Bliss [mailto:bliss.j...@gmail.com]
 Sent: Thursday, December 18, 2008 4:51 PM
 To: cf-talk
 Subject: Re: CF-based freelancer time/billing system?

 Have you checked out riaforge.org?  Some possibilities...?

 http://lighthousepro.riaforge.org
 http://projecttracker.riaforge.org
 http://pronto.riaforge.org

 On Thu, Dec 18, 2008 at 4:47 PM, Jason Durham jdur...@cti-stl.com
 wrote:

 I'm looking for an inexpensive tool to keep track of time logs for
 side
 work.  Specifically, I'd like to be able to setup automated billing
 and
 allow the customer to view progress on their project.   Google landed
 me
 on ProWorkFlow.com which seems to fit the bill, however it might be a
 little more than I need.  5GB of storage at $200 a month is
excessive,
 IMO.



 Are there any other less expensive (or open source) projects out
 there?



 Jason






~|
Adobe® ColdFusion® 8 software 8

RE: CF-based freelancer time/billing system?

[Jason Durham]

Thanks for the link.  I'll look into that. :)

-Original Message-
From: Mark Phillips [mailto:m...@vertabase.com] 
Sent: Friday, December 19, 2008 9:59 AM
To: cf-talk
Subject: Re: CF-based freelancer time/billing system?

The Vertabase Timer is a free time-tracking widget in AIR (built in
Flex). It can export data via a JSON post, XML or CSV.
http://timer.vertabase.com.  

Sounds like it could do the time tracking component nicely then export
the data whenever you need to your internal system.

If you're interested, there is also a CF based web service we've been
developing that would allow you to add tasks to and pull time from
multiple widgets.  You can grab data from it via WSDL.  Its still in
early beta, but send me an email if you're interested in taking a look
at it.

-Mark

www.vertabase.com/cfpm
The Easiest Way to Manage Better



I'm looking for an inexpensive tool to keep track of time logs for side
work.  Specifically, I'd like to be able to setup automated billing and
allow the customer to view progress on their project.   Google landed
me
on ProWorkFlow.com which seems to fit the bill, however it might be a
little more than I need.  5GB of storage at $200 a month is excessive,
IMO.  

 

Are there any other less expensive (or open source) projects out there?

 

Jason 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316982
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CF-based freelancer time/billing system?

[Jason Durham]

I'm looking for an inexpensive tool to keep track of time logs for side
work.  Specifically, I'd like to be able to setup automated billing and
allow the customer to view progress on their project.   Google landed me
on ProWorkFlow.com which seems to fit the bill, however it might be a
little more than I need.  5GB of storage at $200 a month is excessive,
IMO.  

 

Are there any other less expensive (or open source) projects out there?

 

Jason



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316938
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF-based freelancer time/billing system?

[Jason Durham]

Thanks for the links.  Unfortunately none of those have a billing
component to it.  I like Project Tracker and may consider adding the
billing stuff myself.

Jason

-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com] 
Sent: Thursday, December 18, 2008 4:51 PM
To: cf-talk
Subject: Re: CF-based freelancer time/billing system?

Have you checked out riaforge.org?  Some possibilities...?

http://lighthousepro.riaforge.org
http://projecttracker.riaforge.org
http://pronto.riaforge.org

On Thu, Dec 18, 2008 at 4:47 PM, Jason Durham jdur...@cti-stl.com
wrote:

 I'm looking for an inexpensive tool to keep track of time logs for
side
 work.  Specifically, I'd like to be able to setup automated billing
and
 allow the customer to view progress on their project.   Google landed
me
 on ProWorkFlow.com which seems to fit the bill, however it might be a
 little more than I need.  5GB of storage at $200 a month is excessive,
 IMO.



 Are there any other less expensive (or open source) projects out
there?



 Jason



 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316945
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Parsing timestamp set by phpBB

[Jason Durham]

I have a date represented as 993124800 in my database that php's
date() function is able understand and format.  I'm running into dead
ends trying to have ColdFusion parse this date correctly.  That date
should work out to...

 

June 21, 2001, 7:00 am

 

I've searched Google, RiaForge and CFLib.  The only working solution is
to use Sean Corfield's cf_php but I'm not sure my shared host will
accept his jars.  Can anyone offer some guidance?

 

TIA

 

Jason Durham

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314775
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Parsing timestamp set by phpBB

[Jason Durham]

Thank you Wil and CS.  I was able to output the date how I want it
with...

#DateFormat(DateAdd(s, 993124800, January 1 1970
00:00:00),long)#
#TimeFormat(DateAdd(h,-getTimeZoneInfo().utcHourOffset,DateAdd(s,
993124800, January 1 1970 00:00:00)),long)#

Now I'll go back through it to simplify its reuse.  Thanks!

-Original Message-
From: Wil Genovese [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 03, 2008 10:49 AM
To: cf-talk
Subject: Re: Parsing timestamp set by phpBB

If its EPOCH time then this will work.  I wrote a simple function for
that
ages ago.

cfscript

/*##
###
# epochtime by Wil
Genovese   #
#take a time format and convert either to or from
epoch   #

#
#
#datetime - actual value to
convert   #
#conversion - the type of conversion to
do#
#  E2D for epoch to
date  #
#  D2E for date to
epoch  #
# example
usage:  #
#  Convert 1162576737 to
#epochtime(1162576737,E2D,0)#br  #
 #  Convert '#now()#' to
#epochtime(now(),D2E,1)#br  #


#*/

function epochtime(datetime,method) {
var epoch = January 1 1970 00:00:00;
if (method eq E2D){
return Dateadd(s,datetime,epoch);
} else if (method EQ D2E) {
return DateDiff(s,epoch,datetime);
}
}
/cfscript

Wil Genovese
Sr. Web Application Developer



On Mon, Nov 3, 2008 at 10:37 AM, C S [EMAIL PROTECTED] wrote:

 I have a date represented as 993124800 in my database that php's
 date() function is able understand and format.  I'm running into dead
 ends trying to have ColdFusion parse this date correctly.  That date
 should work out to...


 That looks like an epoch time. Try
 http://www.cflib.org/index.cfm?event=page.udfbyidudfid=654

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314779
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Blowin our own horn: New CF Site

[Jason Durham]

Kudos to you for making a non-traditional 3 column layout like we're all
accustomed to.  I think some folks get upset when they don't get what
they are expecting.  Sure... I agree that placing navigation in places
that are easy to find is important.  However, ad agencies tend to be
artsy... and 'artsy' is anything but cookie cutter.

Like others have mentioned, I think the main navigation needs some
tweaks.  I'm 'ok' with the orientation of the next, but not the font (or
color).  I personally think you've got too many colors going on (grey,
light blue, dark blue, orange bullets, red bullets, yellow bullets).  I
think a more consistent color palette would make the site look more
professional.  Opinions may vary.

As others have mentioned, I dig the silhouettes.  Creative idea.

The page took a fair amount of time to load... I actually didn't wait
for the main animation to finish loading before I went clicking around.
Otherwise, it works okay.

Why not let the news (news.cfm) stretch to the edge of the container?
The scrollbar hanging 200 px off the right seems odd to me.  I'd make
those elements expand the width of the black area.

I also agree with the comment about the bios.  Names/titles would be
handy.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314694
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Date stored as varchar in legacy DB, QofQ error Unsupported Type Comparison Exception

[Jason Durham]

I'm writing an interface into a phpBB database where I need to perform
calculations on a date.  Unfortunately, phpBB stores a 'birthdate' field
as varchar(10).  This has uncovered a couple of challenges for me.  

 

I want to be able to pull users by a range of dates as well as just the
month.  This doesn't seem very eloquent... but I thought it would get me
what I needed...

 

cfquery name=qry datasource=foo 

SELECT u.username, str_to_date(replace(replace(trim(u.user_birthday),-
,-),- ,-), '%e-%c-%Y') as birthday, u.user_id,
u.user_inactive_reason, u.user_birthday,
mid(str_to_date(replace(replace(trim(u.user_birthday),- ,-),-
,-), '%e-%c-%Y'),6,2) as birth_month

FROM phpbb_users u

 WHERE user_birthday NOT LIKE '%- 0-%'

 AND user_birthday NOT LIKE '0-%'

AND   user_birthday
NOT LIKE '0- 0-%'

AND
user_birthday NOT LIKE ''

 
AND `user_inactive_reason` = 0

ORDER BY u.username

/cfquery

 

 

And then I run a QofQ based upon some supplied arguments...

 

cfquery name=qofq dbtype=query

SELECT *

  FROM qry

cfif ARGUMENTS.fallsInMonths

WHERE birth_month BETWEEN cfqueryparam
cfsqltype=cf_sql_integer value=#left(ARGUMENTS.startDate,2)# / 

AND cfqueryparam
cfsqltype=cf_sql_integer value=#left(ARGUMENTS.endDate,2)# /

cfelse

 WHERE birthday BETWEEN cfqueryparam cfsqltype=cf_sql_date
value=#ARGUMENTS.startDate# /  !--- error points to this line ---

AND cfqueryparam
cfsqltype=cf_sql_date value=#ARGUMENTS.endDate# /   

/cfif

ORDER BY birthday

/cfquery

 

The end result is (line is denoted above)...

 

Query Of Queries runtime error.

Comparison exception while executing BETWEEN.

Unsupported Type Comparison Exception: The BETWEEN operator does not
support comparison between the following types:

Left hand side expression type = LONG.

Right hand side expression type = STRING.

 

 

It seems it may have been simpler just to treat the birthday field as a
string, rather than convert it into a date.  Any help is very much
appreciated!

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

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

RE: Flash Site Links Sanity Check

[Jason Durham]

At one point my browser hung and only revealed an Email Jim hyperlink.
This was in the address bar
http://www.mypersonalbrilliance.com/about/;.  I clicked through them 20
or so times after that without a problem.

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 19, 2008 11:46 AM
To: CF-Talk
Subject: Flash Site Links Sanity Check

Hi all,

 

We're having reports of links not being clickable in a site:

 

Take a look at this URL (which has been live for 3 years):  

http://www.mypersonalbrilliance.com

 

Also, look at this URL (also live for 3 years):

http://blog.mypersonalbrilliance.com

 

For both sites, click a few of the links in the black bar at top, and
the
four floating links in the lights area at top.

 

Clickable with redirection? Any problems?  

 

I've rechecked the crossdomain.xml file and inserted the eolas js fix
from
adobe (for the double click problem in IE).  I can't find any issues
(nor
recreate the problem), but my client is having intermittent problems.
We've
tried it here and remotely on several machines, using WinXP - FF2, FF3,
IE6
and IE7.

 

Thank for your help.

 

Mark






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

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

RE: (ot) Best FTP Software 4 Windows

[Jason Durham]

I use the FireFTP plugin for Firefox as well. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

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

RE: Clarification Required Concerning CFC...

[Jason Durham]

As others have mentioned... don't fight OO. :)  It takes a bit of time
to adjust but it will all come together and you'll be a more productive
developer as a result.

As someone mentioned, the variable scope is local to the page (doesn't
matter if the file ends in cfc or cfm).  You aren't *including* a
component, you're creating a copy of it in memory.  When you initialize
each of the objects, sometimes they require variables to function (DSN
is a good example).  Take this as an example...

Let's say you want to group all of your data access (queries) functions
into one CFC.  All of these functions merely get/insert/update based
upon arguments sent to them.  While they may return different results,
they are essentially 'reset' after they are executed.  Since you're
going to have several methods that all depend on the same DSN, you can
inject the DSN into the init() function and store the variable in a
scope that is available to all methods on that 'page'.   Since this CFC
merely returns queries, you could store this CFC in a scope that allows
it to persist across many page requests.  For the purpose of learning,
think about it this way...


From Application.cfc...

cffunction name=onApplicationStart() returntype=boolean
output=false

   !--- Store DB info to be injected into objects that need it ---
   cfset var dsn = myDsn /
   cfset var dbUser = myUser /
   cfset var dbPwd = myPwd /

   !--- Create all of my objects that perform CRUD operations ---
   cfset oUserGateway =
createObject(component,path.to.UserGateway).init(myDsn,myUser,myPwd)
/
   cfset oHomeGateway =
createObject(component,path.to.UserGateway).init(myDsn,myUser,myPwd)
/
   cfset oNewsletterGateway =
createObject(component,path.to.NewsletterGateway).init(myDsn,myUser,
myPwd) /

   ... include any other application stuff you want ...

/cffunction

When you're application loads, you create variables to hold your DB
credentials and DSN.  Then you inject variables into each of your CFCs
that communicate with that DB.  Now let's look inside one of those
Gateway objects.

From UserGateway.cfc...

!--- Pseudo constructor method ---
cffunction name=init access=public output=no
returntype=UserGateway
   cfargument name=DSN type=string required=yes hint=ColdFusion
datasource name. /
   cfargument name=dbUsr type=string required=yes
hint=ColdFusion datasource's username. /
   cfargument name=dbPwd type=string required=yes
hint=ColdFusion datasource's password. /
  
 cfset VARIABLES.dsn = ARGUMENTS.dsn /
 cfset VARIABLES.dbUsr = ARGUMENTS.dbUsr /
 cfset VARIABLEs.dbPwd = ARGUMENTS.dbPwd /

 cfreturn this /
/cffunction

!--- Get list of users by is_Active database field ---
cffunction name=getUsers access=public output=no
returntype=query
   cfargument name=isActive type=boolean required=no
default=false hint=Limit results to users marked active in
database./

   !--- var all variables I want to disappear after this method runs
---
   cfset var qOut =  /

   !--- Get users ---
   cfquery name=qOut datasource=variables.dsn
username=variables.dbUsr password=variables.dbPwd
  SELECT *
  FROM tbl_User
  WHERE 0=0 cfif Arguments.isActive AND is_Active = 1/cfif
   /cfquery

   cfreturn qOut /
/cffunction

There are a couple of OO practices going on here.  In Application.cfc,
you have injected the DB config/credentials into the init() method.  The
init() method simply passes those arguments into the variables scope
when the object is created. All of the methods from within that
component have access to the variables scope.  Therefore... all of them
have access to the DB config/credentials. So now you've got a
Application.oUserGateway object hanging around in memory for you to use
to perform CRUD operations on Users.  When it's time for you to get a
list of users, you can simply invoke the method on any template in the
application by doing this...

From within XYC.cfm

!--- Get active users from database ---
cfset qActiveUsers = Application.oUserGateway.getUsers(true) /

The cfinvoke equivalent is this...
cfinvoke component=Application.oUserGateway method=getUsers
returnvariable=qActiveUsers isActive=true / 

You see how much extra typing is involved with cfinvoke, which is why
I prefer the cfset way to do it.  Anyway, that invocation is accessing
the UserGateway from memory, running getUsers with an argument value of
'true'.  That may seem like quite a bit of typing just to get a user
list huh?  The beauty is, you can reuse that UserGateway object on
another app because it knows *nothing* about *anything* that hasn't been
explicitly provided.  If your DB password changes, you make ONE change
(onApplicationStart) and reload the app.  That is a basic form of
encapsulation.  If application requires new user fields in the database,
or is_active changes from Boolean to another datatype, it's much easier
to search/replace/modify all of your queries in one place.

Setting up the OO model takes some time.  What 

RE: CFC confusion. please help!

[Jason Durham]

I'm definitely not the authority on ColdFusion and OO, however I have
asked lots and lots of questions.  The answer is almost always, 'it
depends.'  I return query objects all of the time.  Sometimes I'll
return a struct with a couple of variables and the query object inside.
Do what makes sense for your situation. 

-Original Message-
From: Lori Stone [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 23, 2008 8:36 AM
To: CF-Talk
Subject: CFC confusion. please help!

We are starting to build a new application.  We are having major
confusion issues regarding the use of cfc's.  My boss has a java
background but not a coldfusion background.  I have been using cfc's
since mx came out but not to their full advantage.  We have been reading
about setter/getter beans, gateway objects, and dao, etc.  We are trying
to figure out the best way to set up this application for reusability
and scaling.  Can someone please explain the use of setter/getter,
return types, and anything else you think would help with understanding
the new use of cfc's. I have always returned query objects but
apparently that is not the best practice.  I don't understand the
problem with returning query objects.  I would love to understand the
reasoning and what the return type should be. 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

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

RE: KInda OT - FF3 and flash forms

[Jason Durham]

Works for me on FF 3.0

-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 19, 2008 3:36 PM
To: CF-Talk
Subject: RE: KInda OT - FF3 and flash forms

If anyone has a moment, can they look at this page in FF3 and let me
know if
they see the cfcalendar flash widget?

http://www.hothorse.com/flash/test.cfm

I don't see anything. It's there in IE, and in FF2

Thanks for your time guys.

Will




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

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

RE: Would this create session variables?

[Jason Durham]

Others may have conflicting opinions... but I don't access the session
scope from within a component.  From the calling template, set the
result into the appropriate scope.

For example... ALL from your .cfm template...

cfset qAgent = agentLibrary.get_agent(agent_id) /

cfloop list=#qAgent.columnList# index=i
cfset session[i] = get[i][1] /
/cfloop

That way... if another subdomain/site/whatever wants to return the
qAgent into a struct or variables scope (or whatever), you don't have to
touch the CFC.  Keep the application specific code within the
application specific files (model, top of template, whatever).

This is the mindset I live by, but I certainly recognize people should
do what works for them best. HTH

Jason


-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 18, 2008 9:58 AM
To: CF-Talk
Subject: RE: Would this create session variables?

Thanks for the tip and code, Alan  Barney!
It's working great!

I was concerned that I may end up having to hard-code
the variables and that would greatly reduce the
reusability of the cfc.

Rick

 -Original Message-
 From: Barney Boisvert [mailto:[EMAIL PROTECTED]
 Sent: Monday, June 16, 2008 11:57 PM
 To: CF-Talk
 Subject: Re: Would this create session variables?
 
 try this:
 
 cfloop list=#get_agent.columnList# index=i
   cfset session[i] = get[i][1] /
 /cfloop
 
 cheers,
 barneyb
 
 On Mon, Jun 16, 2008 at 8:44 PM, Rick Faircloth
 [EMAIL PROTECTED] wrote:
  Would this part of a cffunction create
  individual session variables from the query?
 
  cfquery name=get_agent datasource=c21ar
  SELECT *
FROM our_agents
   WHERE website = '#arguments.website#'
  /cfquery
 
  cfset session.get_agent = get_agent /
 
  cfif get_agent.recordCount
 
  cfreturn session.get_agent/
 
  Back on the invoking page, the returnvariable
  is 'get_agent'.
 
  I've tried to access the specific field data
  from the cfreturn as session variables, such as:
 
  session.agent_header (agent_header is defined by the query)
 
  but I'm getting an error that session.agent_header isn't defined.
 
  Based on the cfdump data, it looks like the entire query is becoming
  a session variable (???) rather than getting all the query data
  defined as individual session variables.
 
  I'm trying to get...
 
  session.agent_header = '#get_agent.agent_header#'
  session.first_name = '#get_agent.first_name#'
 
  without manually coding all the variables.
 
  etc.
 
  Thanks,
 
  Rick
 
 
 
 
 
 
 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

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

RE: cfc question...

[Jason Durham]

You don't *have* to use cfinvoke.  I prefer not to.

Once you have instantiated (created an instance of it in memory) the
object like you wrote below... you can 'invoke' any of the methods by
calling them via the object instance name.

!--- Instantiate agentLibrary component ---
cfset agentLibrary =
createObject(component,components.agents.agent).init(application.dsn
) /

!--- Get a list of agents, hold in query object called 'qAgents' ---
cfset qAgents = agentLibrary.getAgents() /

!--- Loop through agents and output their names ---
cfoutput query=qAgents
Agent Name = DB_FIELD_AGENT_NAME br /
/cfoutput

Soon you will find the answer to all of your questions regarding OOP or
CFCs will be it depends.  What does your agentLibrary CFC do?  If your
agentLibrary CFC interacts with a database (as you have indicated), then
what you're doing is correct.  Set a variable to hold your DSN/DB
credentials, and reference that variable when instantiating any
components that have to access the DB. 



-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 16, 2008 3:57 PM
To: CF-Talk
Subject: RE: cfc question...

Ok, let me see if I'm understanding this...

cfset agentLibrary =
createObject(component,components.agents.agent).init(
datasourcename ) /

The part above goes in the calling page before the cfinvoke
statement, right?  If so, how does this work with the cfinvoke
statement?
Is agentLibrary above becoming the variable that will hold
all the data returned by the cfc function, agent?

And I've always defined my db's using
cfset dsn='datasource'
in my application.cfm file, so if I continue doing that, then
I guess the creation of the agentLibrary variable above would be:

cfset agentLibrary = createObject('component',
'components.agents.agent').init(#dsn#) /
or something?

Or would defining the variable 'dsn' in my application.cfm become
an obsolete practice in the 'cfc era'???

Also, in your code below, I don't see the variable 'agentLibrary' being
used
after creation (instantiation?)...so how does it fit into the cfc
functionality?

Rick


 -Original Message-
 From: Mike Kear [mailto:[EMAIL PROTECTED]
 Sent: Monday, June 16, 2008 1:29 AM
 To: CF-Talk
 Subject: Re: cfc question...
 
 Ok syntax error  forgot the closing quotes.   Make that:
 
 
 cfset agentLibrary =
createObject(component,components.agents.agent) /
 
 
 And usually at the top of an object like that (if it's for the kinds
 of things i think it is) you would have an init() functionthat you
 tell the component the datasource name. That looks something like:
 
 !--- Constructor / initialisation ---
 cffunction name=init access=Public returntype=agent
 output=false hint=Initialises the component
 cfargument name=datasourcename required=true type=string /
   cfset variables.dsn = arguments.datasourcename /
   cfreturn this /
 /cffunction
 
 
 It seems a bit of extra typing to have that at the top of your cfc,
 but for reasons of encapsulation (sorry for using the jargon!)  its
 best to have the cfc so that if it needs to know something you'll tell
 it, rather than have it rely on finding what it needs in application
 or session scope or something.So if you have that init() function
 in your component, you'd instantiate it by chaining the .init() method
 when you invoke it.  ( You can chain methods one behind the other )
 
 cfset agentLibrary =
 createObject(component,components.agents.agent).init(
 datasourcename ) /
 
 Throughout your cfc, wherever any function needs to run a query on the
 datasource, it will do it like so:
 
 cfquery name=qThisQuery datasource=#variables.dsn#
SELECT AgentID from Agents
   WHERE  GRPOffCE = cfqueryparam value=#officeid#
 cfsqltype=cf_sql_varchar/
 /cfquery
 
 
 That way you can easily reuse the component without having to need the
 datasource to exist in application scope or anywhere else for that
 matter.  The cfc needs to know the datasourcename so you tell it that
 when you instantiate the cfc.
 
 
 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
 
 
 
 On Mon, Jun 16, 2008 at 3:15 PM, Mike Kear [EMAIL PROTECTED]
wrote:
  I think you're nearly there, Rick.Just make sure you are
following
  the rules about how to set out paths for components:
 
  if your component is in
  e:\inetpub\webroot\c21ar\components\agents\agent.cfc   and the web
  root is at e:\inetpub\webroot\c21ar,  then you would invoke the
  component with the following: (Instantiate is another term that
  confused me at first - how is 'instantiate' different from'invoke'?
  answer:  it's the same thing)
 
  cfset agentLibrary =
createObject(component,components.agents.agent) /
 
 
 
 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date

RE: cfc question...

[Jason Durham]

Yessir.  You can supply any arguments you need within those parenthesis.
:)

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 17, 2008 1:39 PM
To: CF-Talk
Subject: RE: cfc question...

Thanks, Jason!  I'll work on this approach.
Seems much simpler to work with once the function
is instantiated in memory.

Here's a question:  Would I include argument variables
in a call like this?

cfset qAgents = agentLibrary.getAgents() /

I assume the parenthesis are empty because no arguments
are involved?

However, if I wanted to get a particular agent's info:

cfset qAgent = agentLibrary.get_agent_info( url.agentid ) /
if using a url, or
cfset qAgent = agentLibrary.get_agent_info( form.agentid ) /
if using a form variable to id the agent.
Correct?

Rick

 -Original Message-
 From: Jason Durham [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 17, 2008 11:09 AM
 To: CF-Talk
 Subject: RE: cfc question...
 
 You don't *have* to use cfinvoke.  I prefer not to.
 
 Once you have instantiated (created an instance of it in memory) the
 object like you wrote below... you can 'invoke' any of the methods by
 calling them via the object instance name.
 
 !--- Instantiate agentLibrary component ---
 cfset agentLibrary =

createObject(component,components.agents.agent).init(application.dsn
 ) /
 
 !--- Get a list of agents, hold in query object called 'qAgents' ---
 cfset qAgents = agentLibrary.getAgents() /
 
 !--- Loop through agents and output their names ---
 cfoutput query=qAgents
   Agent Name = DB_FIELD_AGENT_NAME br /
 /cfoutput
 
 Soon you will find the answer to all of your questions regarding OOP
or
 CFCs will be it depends.  What does your agentLibrary CFC do?  If
your
 agentLibrary CFC interacts with a database (as you have indicated),
then
 what you're doing is correct.  Set a variable to hold your DSN/DB
 credentials, and reference that variable when instantiating any
 components that have to access the DB.
 
 
 
 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED]
 Sent: Monday, June 16, 2008 3:57 PM
 To: CF-Talk
 Subject: RE: cfc question...
 
 Ok, let me see if I'm understanding this...
 
 cfset agentLibrary =
 createObject(component,components.agents.agent).init(
 datasourcename ) /
 
 The part above goes in the calling page before the cfinvoke
 statement, right?  If so, how does this work with the cfinvoke
 statement?
 Is agentLibrary above becoming the variable that will hold
 all the data returned by the cfc function, agent?
 
 And I've always defined my db's using
 cfset dsn='datasource'
 in my application.cfm file, so if I continue doing that, then
 I guess the creation of the agentLibrary variable above would be:
 
 cfset agentLibrary = createObject('component',
 'components.agents.agent').init(#dsn#) /
 or something?
 
 Or would defining the variable 'dsn' in my application.cfm become
 an obsolete practice in the 'cfc era'???
 
 Also, in your code below, I don't see the variable 'agentLibrary'
being
 used
 after creation (instantiation?)...so how does it fit into the cfc
 functionality?
 
 Rick
 
 
  -Original Message-
  From: Mike Kear [mailto:[EMAIL PROTECTED]
  Sent: Monday, June 16, 2008 1:29 AM
  To: CF-Talk
  Subject: Re: cfc question...
 
  Ok syntax error  forgot the closing quotes.   Make that:
 
 
  cfset agentLibrary =
 createObject(component,components.agents.agent) /
 
 
  And usually at the top of an object like that (if it's for the kinds
  of things i think it is) you would have an init() functionthat
you
  tell the component the datasource name. That looks something
like:
 
  !--- Constructor / initialisation ---
  cffunction name=init access=Public returntype=agent
  output=false hint=Initialises the component
  cfargument name=datasourcename required=true type=string /
  cfset variables.dsn = arguments.datasourcename /
  cfreturn this /
  /cffunction
 
 
  It seems a bit of extra typing to have that at the top of your cfc,
  but for reasons of encapsulation (sorry for using the jargon!)  its
  best to have the cfc so that if it needs to know something you'll
tell
  it, rather than have it rely on finding what it needs in application
  or session scope or something.So if you have that init()
function
  in your component, you'd instantiate it by chaining the .init()
method
  when you invoke it.  ( You can chain methods one behind the other )
 
  cfset agentLibrary =
  createObject(component,components.agents.agent).init(
  datasourcename ) /
 
  Throughout your cfc, wherever any function needs to run a query on
the
  datasource, it will do it like so:
 
  cfquery name=qThisQuery datasource=#variables.dsn#
 SELECT AgentID from Agents
WHERE  GRPOffCE = cfqueryparam value=#officeid#
  cfsqltype=cf_sql_varchar/
  /cfquery
 
 
  That way you can easily reuse the component without having to need
the
  datasource to exist in application scope or anywhere else for that
  matter

RE: cfc question...

[Jason Durham]

Did you get it straightened out Rick?  Azadi gave you what you need.
You need to explicitly call the component using a path from the web root
(dot notation).

From Azadi's email...
cfinvoke component=dot.delimited.path.to.cfc.from.webroot
method=your_cfc_method_name_here ...

For your situation...
cfinvoke component=c21-ar.components.agent method=get_agent_info
returnvariable=agent_info agent_id=url.agent_id /




-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Sunday, June 15, 2008 11:57 PM
To: CF-Talk
Subject: RE: cfc question...

I looked over the info and I'm sure I'll end up doing that,
but I still have to execute the code at some point, which leads
me back to the question of how to set up paths for the cfc's.

Let's say I've got a root folder of
e:\inetpub\webroot\c21ar
and a component folder path of
e:\inetpub\webroot\c21ar\components

How do I set the path when using the cfinvoke function?
All the examples I've used have the cfc in the same folder as
the calling document, so it hasn't been an issue.

Now that it is, I can't figure out how to satisfy the cfinvoke
function concerning the path to a cfc other that in the same folder
as the calling document.

I tried the source attribute in the cfinvoke function, but that
just returned an error any way I coded it.

CF Admin Mappings?  IIS Mappings?  Virtual Directories?
I know this is probably something simple, but I'm just not getting it.

Hints, anyone?

Thanks,

Rick



 -Original Message-
 From: Gerald Guido [mailto:[EMAIL PROTECTED]
 Sent: Monday, June 16, 2008 12:02 AM
 To: CF-Talk
 Subject: Re: cfc question...
 
  Anyway, what's lame about putting all the cfc's together in a
directory
 where I can find them easily?
 
 There is nothing lame about it (you gotta stick them somewhere). What
he
 means is that you are going to want to stick them in memory (the
application
 scope) cuz there is a lot of overhead with firing them up
(instantiating or
 creating an instance of them) every time you need to use them.
Basically you
 are caching them.
 
 You can do the same thing with functions too. It is pretty damn slick.
I
 blarged on the matter here:

http://www.myinternetisbroken.com/index.cfm/2008/5/24/Caching-Functions-
-Creating-variables-that-are
-
 executable
 
 G$
 
 
 On Sun, Jun 15, 2008 at 11:49 PM, Rick Faircloth
[EMAIL PROTECTED]
 wrote:
 
  Now, Will... all that's a bit complicated for a newbie to cfc's!
  Didja haf'ta make it so hard! I just wanted a path! :o)
 
  Anyway, what's lame about putting all the cfc's together in a
directory
  where I can find them easily?
 
 
   -Original Message-
   From: Will Tomlinson [mailto:[EMAIL PROTECTED]
   Sent: Sunday, June 15, 2008 11:00 PM
   To: CF-Talk
   Subject: Re: cfc question...
  
   Another issue I've run into is how to help my calling page find
   my cfc's.  While learning, I've just placed the cfc in the same
   folder as the calling page.  But now I'm placing them in a
components
   folder and the calling page can't find it.
  
   Rick, I mostly initialize them in application scope in
Application.cfc
  
   Like this:
  
   cfset APPLICATION.reportDAO =
 
CreateObject(component,cfcs.reportDAO).init(dsn=APPLICATION.dsn)
  
   Then build a constructor in your cfc like so:
  
   cffunction name=init access=public returntype=reportDAO
  output=false
  hint=Returns an instance of the CFC initialized with the
correct
  settings.
 cfargument name=dsn
 cfset variables.dsn = arguments.dsn
 cfreturn this
   /cffunction
  
   Once you do all that, it's ready to use anywhere in the
application.
  
   Just refer to it using the application scope:
  
   cfset getReport = APPLICATION.reportDAO.monthEnd()
  
   Puttin it in a cfc's directory is lame, but I'm sure more advice
will
  roll in for ya.  :)
  
   hth,
   Will
  
  
 
 
 
 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

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

RE: cfc question...

[Jason Durham]

Ah... you were trying to use a relative path (../folder/cfcs/etc).
No-can-do. You have to provide an _absolute_ path to a component via
cfinvoke and createObject() using dot notation.  



-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 16, 2008 1:59 PM
To: CF-Talk
Subject: RE: cfc question...

Yes, I did get it, finally, Jason.  Thanks to you and everyone
who has given advice!  I've got a lot to think about and consider
making the change from .cfm and includes to cfc's, but I'm off to
a good start, I think.  The first step for me is to get something
*simple* to work and then to build my knowledge from there.

What was complicating my path problem was the fact that the main website
has a component folder and a certain webroot.

The folder that is holding the templates for the subdomains is also the
webroot folder for those subdomains.

I was trying to use the components in the main website's folder, which
is
above the subdomain folder (webroot folder for subdomains) in the folder
hierarchy.  That wasn't working.

I think what I had to understand is that the dot notation and paths
for the cfc's is logical, not physical.  I was trying to figure out
some
way to jump back up two folder levels and down one to get into the
main website component folder...wasn't working.

I finally just created a component folder in the subdomain root folder
and then I could easily access it.

Does my newbie confusion make any sense?

Rick



 -Original Message-
 From: Jason Durham [mailto:[EMAIL PROTECTED]
 Sent: Monday, June 16, 2008 10:20 AM
 To: CF-Talk
 Subject: RE: cfc question...
 
 Did you get it straightened out Rick?  Azadi gave you what you need.
 You need to explicitly call the component using a path from the web
root
 (dot notation).
 
 From Azadi's email...
 cfinvoke component=dot.delimited.path.to.cfc.from.webroot
 method=your_cfc_method_name_here ...
 
 For your situation...
 cfinvoke component=c21-ar.components.agent method=get_agent_info
 returnvariable=agent_info agent_id=url.agent_id /
 
 
 
 
 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED]
 Sent: Sunday, June 15, 2008 11:57 PM
 To: CF-Talk
 Subject: RE: cfc question...
 
 I looked over the info and I'm sure I'll end up doing that,
 but I still have to execute the code at some point, which leads
 me back to the question of how to set up paths for the cfc's.
 
 Let's say I've got a root folder of
 e:\inetpub\webroot\c21ar
 and a component folder path of
 e:\inetpub\webroot\c21ar\components
 
 How do I set the path when using the cfinvoke function?
 All the examples I've used have the cfc in the same folder as
 the calling document, so it hasn't been an issue.
 
 Now that it is, I can't figure out how to satisfy the cfinvoke
 function concerning the path to a cfc other that in the same folder
 as the calling document.
 
 I tried the source attribute in the cfinvoke function, but that
 just returned an error any way I coded it.
 
 CF Admin Mappings?  IIS Mappings?  Virtual Directories?
 I know this is probably something simple, but I'm just not getting it.
 
 Hints, anyone?
 
 Thanks,
 
 Rick
 
 
 
  -Original Message-
  From: Gerald Guido [mailto:[EMAIL PROTECTED]
  Sent: Monday, June 16, 2008 12:02 AM
  To: CF-Talk
  Subject: Re: cfc question...
 
   Anyway, what's lame about putting all the cfc's together in a
 directory
  where I can find them easily?
 
  There is nothing lame about it (you gotta stick them somewhere).
What
 he
  means is that you are going to want to stick them in memory (the
 application
  scope) cuz there is a lot of overhead with firing them up
 (instantiating or
  creating an instance of them) every time you need to use them.
 Basically you
  are caching them.
 
  You can do the same thing with functions too. It is pretty damn
slick.
 I
  blarged on the matter here:
 

http://www.myinternetisbroken.com/index.cfm/2008/5/24/Caching-Functions-
 -Creating-variables-that-are
 -
  executable
 
  G$
 
 
  On Sun, Jun 15, 2008 at 11:49 PM, Rick Faircloth
 [EMAIL PROTECTED]
  wrote:
 
   Now, Will... all that's a bit complicated for a newbie to cfc's!
   Didja haf'ta make it so hard! I just wanted a path! :o)
  
   Anyway, what's lame about putting all the cfc's together in a
 directory
   where I can find them easily?
  
  
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 15, 2008 11:00 PM
To: CF-Talk
Subject: Re: cfc question...
   
Another issue I've run into is how to help my calling page find
my cfc's.  While learning, I've just placed the cfc in the same
folder as the calling page.  But now I'm placing them in a
 components
folder and the calling page can't find it.
   
Rick, I mostly initialize them in application scope in
 Application.cfc
   
Like this:
   
cfset APPLICATION.reportDAO =
  
 CreateObject(component,cfcs.reportDAO).init(dsn=APPLICATION.dsn

RE: Best CF editor?

[Jason Durham]

After being at cf.Objective() and seeing Eclipse used and promoted by so
many developers, I'm doing my best to adopt it.  Code completion and
integrated FTP are the two items I miss the most.  I get frustrated with
Eclipse closing my elements but not enough to have to type the closing
tag every time. Yes, I'm aware that there are some behaviors that I can
tweak with regard to closing and auto-insertion. Unfortunately, there is
no 'work exactly like DW does' checkbox. :)

It's nice to see some DWers come out of the closet!  So who's going to
get the DW logo tattooed on their arm and apply for a project with Mark?
:)



-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 02, 2008 3:55 AM
To: CF-Talk
Subject: Re: Best CF editor?

On Saturday 31 May 2008, Michael Christensen wrote:
 and HomeSite for the large files (until I may eventually have time to
split
 them up). 

That's the thing, CFEclipse chokes on files once their size gets so big
you 
should refactor them anyway :-)

-- 
Tom Chiverton



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England
and Wales under registered number OC307980 whose registered office
address is at Halliwells LLP, 3 Hardman Square, Spinningfields,
Manchester, M3 3EB.  A list of members is available for inspection at
the registered office. Any reference to a partner in relation to
Halliwells LLP means a member of Halliwells LLP.  Regulated by The
Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and
may be confidential or legally privileged.  If you are not the addressee
you must not read it and must not use any information contained in nor
copy it nor inform any person other than Halliwells LLP or the addressee
of its existence or contents.  If you have received this email in error
please delete it and notify Halliwells LLP IT Department on 0870 365
2500.

For more information about Halliwells LLP visit www.halliwells.com.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306558
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 CF editor?

[Jason Durham]

I thought FTP support was provided via the Aptana plugin.  I've also
been busy learning Coldbox, Transfer and Coldspring so I haven't had
much time to explore (cf)Eclipse. :)

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 02, 2008 9:20 AM
To: CF-Talk
Subject: Re: Best CF editor?

You are aware - I hope - that CFEclipse has FTP support? It's the FIle
Browser. It works both with local paths and FTP paths. One benefit it
has over RDS is:

a) Most folks disable RDS on production
b) I love that w/ FTP, I can specify a folder to jump to immediately.
With RDS I have to dig down to my files.


On Mon, Jun 2, 2008 at 8:59 AM, Jason Durham [EMAIL PROTECTED]
wrote:
 After being at cf.Objective() and seeing Eclipse used and promoted by
so
 many developers, I'm doing my best to adopt it.  Code completion and
 integrated FTP are the two items I miss the most.  I get frustrated
with
 Eclipse closing my elements but not enough to have to type the closing
 tag every time. Yes, I'm aware that there are some behaviors that I
can
 tweak with regard to closing and auto-insertion. Unfortunately, there
is
 no 'work exactly like DW does' checkbox. :)

-- 

===
Raymond Camden, VP of Software Dev, Broadchoice

Email : [EMAIL PROTECTED]
Blog : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.org



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306575
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 CF editor?

[Jason Durham]

Ah... shows how much I know.  I didn't know there was a CS4 yet. :) 

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 29, 2008 8:34 AM
To: CF-Talk
Subject: Re: Best CF editor?

Did you try it with DW CS4? I assume all extensions for CS3 would work
for CS4. I'd be willing to give DWCS4 another try if so. I need to
play with the SVN integration a bit though. I'm curious if it supports
file labels like Eclipse though. And right click ops to view history,
etc.

On Thu, May 29, 2008 at 8:29 AM, Jason Durham [EMAIL PROTECTED]
wrote:
 http://www.adobe.com/support/coldfusion/downloads.html

 I was just able to download and install the extensions.  It appears
the
 new tags and functions are now supported with DW CS3.

 -Original Message-
 From: Raymond Camden [mailto:[EMAIL PROTECTED]
 Sent: Thursday, May 29, 2008 8:28 AM
 To: CF-Talk
 Subject: Re: Best CF editor?

 Seriously - although I'm sure there is a good reason. This is just a
 beta though. I'm sure we've all memorized all 50 of the new image
 functions anyway.

 On Thu, May 29, 2008 at 8:24 AM, Andy Matthews
 [EMAIL PROTECTED] wrote:
 Seriously? CF8 has been out for over 6 months now.

 -Original Message-
 From: Raymond Camden [mailto:[EMAIL PROTECTED]
 Sent: Thursday, May 29, 2008 8:11 AM
 To: CF-Talk
 Subject: Re: Best CF editor?

 I played with it. Doesn't really do anything for me. Not that I gave
 it a
 fair shake down though. DW just isn't for me. If you want code help
 though, don't use the new DW. It doesn't recognize CF8 tags yet.

 On Thu, May 29, 2008 at 8:07 AM, Will Swain [EMAIL PROTECTED]
wrote:
 Will the built in SVN support in the new dreamweaver encourage
people
 to use it for cf development I wonder?
--


 ===
 Raymond Camden, VP of Software Dev, Broadchoice

 Email : [EMAIL PROTECTED]
 Blog : www.coldfusionjedi.com
 AOL IM : cfjedimaster

 Keep up to date with the community: http://www.coldfusionbloggers.org



 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Coldspring docs?

[Jason Durham]

I'm hoping the person(s) who handle the Coldspring docs can be found on
this list.  I'm getting a CF error when trying to access the documents.

 

http://www.coldspringframework.org/index.cfm?objectid=389CE41C-F61D-DDF6
-61D577E5A370B2F5

 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Coldspring docs?

[Jason Durham]

Thank you sir.

-Original Message-
From: Matt Williams [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 30, 2008 9:43 AM
To: CF-Talk
Subject: Re: Coldspring docs?

Try this page:
http://coldspringframework.org/docs/

Also, there is a ColdSpring specific mailing list:
http://groups.google.com/group/coldspring-users



On Fri, May 30, 2008 at 9:32 AM, Jason Durham [EMAIL PROTECTED]
wrote:
 I'm hoping the person(s) who handle the Coldspring docs can be found
on
 this list.  I'm getting a CF error when trying to access the
documents.




http://www.coldspringframework.org/index.cfm?objectid=389CE41C-F61D-DDF6
 -61D577E5A370B2F5







 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306361
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 CF editor?

[Jason Durham]

To save some of you the effort... I did this in CS3.  After saving the
file and reopening it, I saw this...

?xml version=1.0?
!DOCTYPE galleries [
!ENTITY galleries SYSTEM
http://labs.adobe.com/technologies/spry/demos/gallery/galleries/galleri
es.xml
]
root

galleriesgallerysitename/sitenamephotographer/photographerc
ontactinfo/contactinfoemail/emailsecurity/security/gallery
gallerysitename/sitenamephotographer/photographercontactinfo
/contactinfoemail/emailsecurity/security/gallerygallerysit
ename/sitenamephotographer/photographercontactinfo/contactinfo
email/emailsecurity/security/gallery/galleries
/root

-Original Message-
From: Massimo Foti [mailto:[EMAIL PROTECTED] 
Sent: Friday, May 30, 2008 10:23 AM
To: CF-Talk
Subject: Re: Best CF editor?

I think it's worth to let people know that avoid using DW's Design View 
doesn't make you save from code corruption. Most documented cases are
caused 
by translators, unfortunately translators run before you load the 
document, and they do no matter if you are in Code view or Design View.

Want to see DW's code corruption in action? Create an xml file
containing 
this code, then open it in DW CS 3 or earlier (in Code View, there is no

Design View for XML):

?xml version=1.0?
!DOCTYPE galleries [
!ENTITY galleries SYSTEM
http://labs.adobe.com/technologies/spry/demos/gallery/galleries/galleri
es.xml
]
root
galleries;
/root

As far as I know, this specific case is fixed in DW CS 4. Along the
years DW 
has improved a lot on this area, but it's not 100% safe, it will never
be.

As for me, I use both DW and Ecplise, most of the time I have both of
them 
opened at the same time, sometimes I open TopStyle too :-)


Massimo Foti, web-programmer for hire
Tools for ColdFusion, JavaScript and Dreamweaver:
http://www.massimocorner.com





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306365
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 CF editor?

[Jason Durham]

http://www.adobe.com/support/coldfusion/downloads.html

I was just able to download and install the extensions.  It appears the
new tags and functions are now supported with DW CS3.

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 29, 2008 8:28 AM
To: CF-Talk
Subject: Re: Best CF editor?

Seriously - although I'm sure there is a good reason. This is just a
beta though. I'm sure we've all memorized all 50 of the new image
functions anyway.

On Thu, May 29, 2008 at 8:24 AM, Andy Matthews
[EMAIL PROTECTED] wrote:
 Seriously? CF8 has been out for over 6 months now.

 -Original Message-
 From: Raymond Camden [mailto:[EMAIL PROTECTED]
 Sent: Thursday, May 29, 2008 8:11 AM
 To: CF-Talk
 Subject: Re: Best CF editor?

 I played with it. Doesn't really do anything for me. Not that I gave
it a
 fair shake down though. DW just isn't for me. If you want code help
 though, don't use the new DW. It doesn't recognize CF8 tags yet.

 On Thu, May 29, 2008 at 8:07 AM, Will Swain [EMAIL PROTECTED] wrote:
 Will the built in SVN support in the new dreamweaver encourage people
 to use it for cf development I wonder?
--

===
Raymond Camden, VP of Software Dev, Broadchoice

Email : [EMAIL PROTECTED]
Blog : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.org



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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