Java Out Log

2009-08-12 Thread Rob O'Brien

I think I'm overlooking a setting somewhere.

 

I'm running a Java library that I'm trying to debug. I've set the library to
log this debugging information. All is well on my local machine, but not on
the test box.

 

Now, the output is done using Java's System.out.println() and on my local
machine I can find that output in
C:\ColdFusion8\runtime\logs\coldfusion-out.log

 

Unfortunately, that file isn't being created on my test box. I'm 99%
confident that I'm looking in the correct location on the server (being
/coldfusion8/runtime/logs) because there's coldfusion-event.log, which gets
updated with new event info.

 

So, a couple of points:

* Local box = Windows, Test box = Linux

* Both are CF8

* Both have same JRE version

* Local box does have more robust CF debug output settings active,
but I wouldn't think that these settings directly affect Java system output.

 

I've looked through CF Admin for settings that may be applicable, but found
nothing. Google hasn't been much help, either.

 

Any help is appreciated.

 

Rob



~|
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:325405
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Java Out Log

2009-08-12 Thread Rob O'Brien

Remember that time I was 99% sure I was looking in the right place? Me
either.

 

I found the output in the ColdFusion log /coldfusion8/logs/cfserver.log

 

Strange that the behavior (read; location) is different between boxes
(Win/Linux?)

 

Rob

 

  _  

From: Rob O'Brien 
Sent: Wednesday, August 12, 2009 1:01 PM
To: 'cf-talk@houseoffusion.com'
Subject: Java Out Log

 

I think I'm overlooking a setting somewhere.

 

I'm running a Java library that I'm trying to debug. I've set the library to
log this debugging information. All is well on my local machine, but not on
the test box.

 

Now, the output is done using Java's System.out.println() and on my local
machine I can find that output in
C:\ColdFusion8\runtime\logs\coldfusion-out.log

 

Unfortunately, that file isn't being created on my test box. I'm 99%
confident that I'm looking in the correct location on the server (being
/coldfusion8/runtime/logs) because there's coldfusion-event.log, which gets
updated with new event info.

 

So, a couple of points:

* Local box = Windows, Test box = Linux

* Both are CF8

* Both have same JRE version

* Local box does have more robust CF debug output settings active,
but I wouldn't think that these settings directly affect Java system output.

 

I've looked through CF Admin for settings that may be applicable, but found
nothing. Google hasn't been much help, either.

 

Any help is appreciated.

 

Rob



~|
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:325406
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Twitter + OAuth Integration

2009-08-02 Thread Rob O'Brien

I just wanted to let everyone know that I just posted an article on how to
accomplish Twitter integration with OAuth and ColdFusion.

 

I had a difficult time finding information about this particular topic, so I
hope it helps others.

 

Here's the link to my blog post: http://bit.ly/SGYrv/

 

I hope it's useful.

 

Rob

 

 

 



~|
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:325173
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Twitter oAuth

2009-08-02 Thread Rob O'Brien

I just sent another email on this topic, but didn't see this thread first.
My bad.

Here's a solution I just posted on my blog:
http://bit.ly/SGYrv/

Hope it helps.

Rob


-Original Message-
From: nobosh [mailto:bhellm...@gmail.com] 
Sent: Sunday, July 26, 2009 7:54 PM
To: cf-talk
Subject: Re: Twitter oAuth


Hi Philip,

Did you ever have a chance to write a Twitter/CF/oAuth manual? I'm going
through the same experience you mentioned, trying to figure out
oauth.riaforge.org but haven't been able to find any documentation, examples
or tutorials. 

Any help is appreciated.

Thanks,

Brett


Philip Kaplan-2 wrote:
 
 
 In case anyone's interested, I figured it all out with the help of some
 off-list folks.  Contact me if you need help with this.
 Perhaps I will write a quick Twitter/ColdFusion/oAuth manual in the
 future.
 
 On Mon, Apr 6, 2009 at 7:00 PM, Philip Kaplan pkap...@gmail.com wrote:
 
 Anyone here have any experience with oAuth?  Or better yet with Twitter's
 oAuth implementation?
 I'm just not making any headway.  I've downloaded this:
 http://oauth.riaforge.org/

 But there's very little documentation on the CF oAuth side or on the
 Twitter side.

 Anyone ever get oAuth to work?  I don't really know where to start.


 
 
 



~|
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:325174
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 won't this insert work?

2008-04-09 Thread Rob O'Brien
Assuming you have no_acres defined as an INT, when an empty record insert is
attempted, it's actually attempting to insert an empty string, not NULL.
Because it's trying to enter the empty string, it's going to throw a type
error on the string vs numeric mismatch.


~|
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:303063
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


500 The ClientScope service is not available.

2008-03-28 Thread Rob O'Brien
Fellow CF Junkies:

 

A client has just reported an error he received while running a monthly
task, using a CF script I wrote over 6 months ago and has never produced any
trouble.

 

500 The ClientScope service is not available.

 

It's not something I've ever seen before, have not been able to duplicate,
and for which I can find nothing on Google (except other website which have
also experienced this error).

 

I'm not overly concerned about it since the script is now running smoothly,
but I would also like to understand what it is and how it may have occurred.


 

Thanks guys,

 

Rob O

 

 



~|
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:302282
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Opening a txt file in notepad

2007-09-24 Thread Rob O'Brien
Jared:

You can't necessarily force Notepad, but you can output the text file as an
attachment and allow the end user to open it in his or her default app
associated with TXT files.
 
Give this a shot:

cfheader name=Content-Disposition value=attachment; filename=file.txt
cfcontent type=text/plain file=C:\filepath\file.txt 

Make sure you do not output anything else to the browser... including
whitespace and debugging info.

Rob


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


RE: CFQUERY Results in Natural SQL Order?

2007-09-20 Thread Rob O'Brien
I've run into very few instances where the alpha sorting of query columns
has been a bother. However, I just ran into one yesterday.

I wanted to use CFTABLE as a quick and easy way to display an unknown
recordset. Using COLUMNLIST from the CFQUERY result wouldn't work - I wanted
the 'natural' order of my columns.

I found a nifty little method in the query that allowed me to gain that
information: GetColumnNames()

cfset ColNameArray = Query.GetColumnNames()
cfset ColNameList = ArrayToList(ColNameArray)

From there, I was able to loop over the list and generate my CFTABLE in the
correct order.

Now, this doesn't restructure the recordset, but rather gives you access to
the proper order of column names. Hopefully this will be helpful towards
whatever you're trying to accomplish.

Oh, and for the record - the other time alpha sorting irks me is when I want
to do a quick CFDUMP to see the raw data. Obviously not important to the end
application, but it annoys me :)

Rob

-Original Message-
From: Todd Mathews 
Sent: Thursday, September 20, 2007 3:08 AM
To: CF-Talk
Subject: CFQUERY Results in Natural SQL Order?

Does anyone know of a simple way to have the results of a CFQUERY return the
results in the natural sql result order instead of always returning
everything in a sorted column order?

IE: 

Select waypointName, areaName, directionScope, bufferName from xx

Should return the columns in the natural order of the sql query (in this
case  waypointName,areaName, directionScope,bufferName) instead of the
current default alphanumeric column sorting which returns the columns using
an alphabetical sort of (areaName,bufferName,directionScope,waypointName).

We're currently using the following approach to restore the natural order
but would LOVE to find a more simplified solution.. In a perfect world this
would be a param option for CFQUERY (think something like resultOrder='NAT'
or resultOrder='ALPHA' hopefully this conveys the general idea):

!--- use getMetadata to get the names and data types of the fields ---
cfset querymeta=getMetaData(getRecs)
!--- build colList and field name / type query ---
cfset thisColList = 
cfset queryInfo=QueryNew(colName,colType)
cfloop index=i from=1 to=#arrayLen(querymeta)#
cfset thisColName = querymeta[i].name
cfset thisColType = UCase(querymeta[i].TypeName)
cfset thisColList = listAppend(thisColList,thisColName)
cfset tmp=QueryAddRow(queryInfo)
cfset tmp=QuerySetCell(queryInfo,colName,thisColName)
cfset tmp=QuerySetCell(queryInfo,colType,thisColType)
/cfloop

The above code restores the natural SQL result order and gets the job done
but a more simple solution would be quite welcome.

Anyone have any thoughts or no any secrets?

Todd





~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

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


RE: Darn syntax

2007-09-20 Thread Rob O'Brien
Give this a go:

-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 20, 2007 3:07 PM
To: CF-Talk
Subject: Darn syntax

Let's try this again. the list seems to be funky.

 

I've got the table driven system with all these profile reads. The profiles
don't change often so I want to cache unless I'm testing. If I'm live I want
my cache time at several days. 

So I set:

 

cfset cache_time=2, 0, 0, 0

OR 

cfset cache_time=0, 0, 0, 0

 

Now on my profile query statement, instead of saying

 

cachedwithin=#CreateTimeSpan(2, 0, 0, 0)#

 

I want to say 

 

cachedwithin=#CreateTimeSpan(#cache_time#)#

 

But it don't like that. I've tried various combos using and not using
EVALUATE, etc. but it just doesn't want to obey me.

 

Anyone see the correct syntax. I'm sure this is nothing more than a syntax
problem but I'm not seeing it right now.

 

Thanks,

 

Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 

F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .






~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


RE: Darn syntax

2007-09-20 Thread Rob O'Brien
Let's try that again:

cfif
cfset cache_time = CreateTimeSpan(2, 0, 0, 0)
cfelse
cfset cache_time = CreateTimeSpan(0, 0, 0, 0)
/cfif
cfquery cachedwithin=#cache_time#/cfquery

Rob

-Original Message-
From: Rob O'Brien 
Sent: Thursday, September 20, 2007 4:36 PM
To: 'cf-talk@houseoffusion.com'
Subject: RE: Darn syntax

Give this a go:

-Original Message-
From: Robert Harrison 
Sent: Thursday, September 20, 2007 3:07 PM
To: CF-Talk
Subject: Darn syntax

I've got the table driven system with all these profile reads. The profiles
don't change often so I want to cache unless I'm testing. If I'm live I want
my cache time at several days. 

So I set:

 

cfset cache_time=2, 0, 0, 0

OR 

cfset cache_time=0, 0, 0, 0

 

Now on my profile query statement, instead of saying

 

cachedwithin=#CreateTimeSpan(2, 0, 0, 0)#

 

I want to say 

 

cachedwithin=#CreateTimeSpan(#cache_time#)#

 

But it don't like that. I've tried various combos using and not using
EVALUATE, etc. but it just doesn't want to obey me.

 

Anyone see the correct syntax. I'm sure this is nothing more than a syntax
problem but I'm not seeing it right now.

 

Thanks,

 

Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 

F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

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


RE: cfwindow making page jump to top..

2007-09-11 Thread Rob O'Brien
If you add return false; to your onClick, it will negate the original
behavior of the anchor tag, thus only executing the other onClick functions
and not the actual click action.

a href=## onclick=javascript:ColdFusion.Window.show('window#Section#');
return false;Show students that didn't complete an evaluation/a

Rob


-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 11, 2007 10:07 PM
To: CF-Talk
Subject: cfwindow making page jump to top..

Man I love this cfwindow tag. My only problem is, on a long page with a
vertical scrollbar, if you click the link that pops the cfwindow open, the
page jumps to the top. 

The window opens like it should, but you're back at the top of the page. Any
ideas on what I'm doin wrong? 

Here's my code. It's inside a cfoutput query:

td align=center
a href=##
onclick=javascript:ColdFusion.Window.show('window#Section#')Show students
that didn't complete an evaluation/a
cfwindow name=window#Section# width=150 draggable=true
h4#Section#/h4
cfloop list=#incStudentList# index=thisItem
#thisItem#br /
/cfloop
/cfwindow 
/td

Thanks,
Will







~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

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


RE: Adding events to outlook calendar

2007-07-19 Thread Rob O'Brien
I really want to go on a rant about the wait for CF8 responses, but I'm
trying hard not to. Obviously CF8 isn't an option yet, so here's an
actionable answer...

Dave, you'll want to use vCalendar or iCalendar specs to form a file that's
compatible with Outlook. The app I'm working with uses the older vCalendar
format and it works great in Outlook. In the iCalendar Wikipedia article, it
states that there are some Outlook compatibility issues.

http://en.wikipedia.org/wiki/VCalendar
http://en.wikipedia.org/wiki/ICalendar

When you've formed the file according to the specs, you can make it
available for downloading or output it to the browser using CFHEADER and
CFCONTENT, at which time a dialogue should appear to download the data.

Here's a small snip from my app:

--
cfset uuid = replace(CreateUUID(),-,,ALL)
cfheader name=Content-Disposition value=attachment;
filename=#uuid#.vcf
cfcontent type=application/vcf  
[output here without any extraneous whitespace]
--

For the output, it's actually a custom tag that is called to output a
correctly formatted vFile. 

I use the uuid as a file name just so it's unique and a valid name. I can't
remember the details as to why, but I had trouble with naming that this
resolved.

If you're testing this in an environment with debugging turned on, you'll
want to suppress that output because it'll include that data in the vCal
file and it won't work. Took me a long time to figure that one out the first
time I did this.

Hope that helps.

Rob


-Original Message-
From: Bosky, Dave
Sent: Thursday, July 19, 2007 12:12 PM
To: CF-Talk
Subject: Adding events to outlook calendar

We've got a course registration page that I want to integrate with
outlook calendars.
Any CF custom tags available that will create events inside individual
outlook calendars?
Or a nice example of how this can be done? 
 
Thanks,
 
Dave Bosky | Information Services | HTC | direct:  843-369-8613 | fax:
843-369-7178 | [EMAIL PROTECTED]

**
HTC Disclaimer:  The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader of this
message is not the intended recipient, or an employee or agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited.  If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.  Thank you.
**




~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

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


RE: Problems with encrypt and decrypt

2007-07-19 Thread Rob O'Brien
Encrypt() is resulting in a character that is being stripped by the use of 
trim(). It looks like a whitespace/CR/etc. using the example CC#.

If you want to trim the input, do it upfront on the cc value itself, then go 
into the encrypt/decrypt routine. There's no need to trim the result of encrypt 
or decrypt, as you may be changing the value.

cfoutput
cfset key = 0X44po5
cfset tt = 4003
cfset tt = trim(tt)

POrig: #tt#/P

cfset encryptCC = encrypt(tt, key)
PEncrypted: #encryptCC#/P

cfset ccnumber = decrypt(encryptCC, key) 
PDecrypted: #ccnumber#/P
/cfoutput

Rob

-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 19, 2007 2:49 PM
To: CF-Talk
Subject: Problems with encrypt and decrypt

I am playing around with encrypt and decrypt in CF and I ran into a issue.
First, here is the code:

cfoutput
cfset key = X44po

cfset tt = 4003

cfset encryptCC = '#trim(encrypt(trim(tt), key))#' 
P#tt#/P

P#encryptCC# /P
cfset ccnumber = #trim(decrypt(trim(encryptCC), key))# 

P#ccnumber#  /P
/cfoutput

When I run this, the decrypt is 4002.  If I change the number to
be encrypted, sometimes it decrypts correctly and sometimes it does not.

The same is true if I change the key.

Any ideas?

Thanks
Jacob




~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

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


RE: Spam to my CF-Talk address

2007-07-05 Thread Rob O'Brien
I've traded a few emails with Michael regarding this topic. 

All you have to do is Google your email address and you'll see that messages
to this group are publicly viewable online. The direct sender's email
address is stripped, but any message which was replied to and now a part of
the message body will remain. 

Posting online is a good thing for searching and archival purposes, but not
when email addresses are posted as well. Spammers will scrape them and use
found addresses for spam. 

As many of us are, I'm protective of my email address. For quite awhile, my
email address would produce no search results in Google. Then House of
Fusion started showing up and now other sites have pulled in House of Fusion
content to their sites, where I now get results.

On 5/3, Michael acknowledged the problem and said he would fix it. On 5/31,
I sent him another message to let him know that it still wasn't fixed. Now
another month later, it's still happening.

Let him know that you're concerned about this. Many voices will be louder
than a few.

Rob

-Original Message-
From: James Wolfe [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 05, 2007 8:41 AM
To: CF-Talk
Subject: Spam to my CF-Talk address

I have a custom address which only receives mail for CF-Talk. I have shared
this address with no one and have not used it in any location other than on
the CF-Talk forum.

I have, as of yesterday, begun receiving spam on that address (3 messages
thus far).

Without accusing Michael of selling our addresses, I wanted to know if
anyone else has had the same experience. An sampling of the messages I
received are:

Date: 7/4 12:44AM 
From: Carol [EMAIL PROTECTED]  
Subject:  The following is TangLong International Group INC the product
message which brings for you.

Date: 7/4 4:32AM  
From: [EMAIL PROTECTED] 
Subject: Your email was selected (won)




~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

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


RE: Easy-to-develop recurring billing?

2007-06-27 Thread Rob O'Brien
Payflowpro is a good service that I used for an eCommerce solution a few years 
back. There's a CF tag floating around out there somewhere.

PayPal also offers a good SDK for CF7 that I've implemented to the point of a 
fully-operational demo, but haven't put it into production yet. It's on my 
forever-long TODO list.

Rob

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 27, 2007 3:59 PM
To: CF-Talk
Subject: RE: Easy-to-develop recurring billing?

Ive only used payflowpro and verisign for this. It was 

...:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 27, 2007 1:59 PM
To: CF-Talk
Subject: Easy-to-develop recurring billing?

Whats the easiest gateway to deal with (as in program a solution for...
preferably something with a tag already developed) with respect to setting
up recurring payments?  Ideally it would support monthly and weekly
open-ended.  It would also have to support single transactions.

Anyone have a favorite where code is available either at the Exchange or
from the gateway's support group?

--
[EMAIL PROTECTED]
Janitor, The Robertson Team
mysecretbase.com





~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

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


OO style - dynamic set get methods

2007-06-14 Thread Rob O'Brien
So, I'm just starting to go into OO-style CF development and I have a quick
theory question... Mind you, this is brand new to me, so be gentle.

When setting up my Location Bean, I started to go through each of the
individual variables and created a get() and set() method for each of them.
I got about halfway through and decided that I was tired of creating
repetitive functions. I thought to myself, why can't I just create simple,
dynamic get() and set() functions to handle all of these variables
dynamically?

Rather than setName(value), why not setVar(Name,value)?

Since these methods are inherently dumb (nothing but a cfset and a cfreturn
as I've seen implemented), why does it matter that I have an individual
method for each? Validation would come in an additional business layer
anyway. 

I guess I'm looking for pros/cons. This seems like a more dynamic, elegant
way to set/get, but I'd like to know where the pitfalls are.

Thanks! 
Rob


~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

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


CFMAIL, CFMAILPART, CFIF and Whitespace

2007-05-31 Thread Rob O'Brien
Hey guys - 

 

I'm trying to use CFMAIL and CFMAILPART to send Text  HTML email to my
users. The email could contain: only Text, only HTML, or both depending on
the application.

 

Because of that, I utilize CFIF within CFMAIL to determine which parts of
the email to include.

 

For the most part, it works like a charm. However, I've been getting
complaints from Hotmail users who only see blank emails. After looking at
the email's source code, I see that there's a secondary, blank text part
in the email. My assumption is that Hotmail sees 2 text parts and the 2nd
overrides the first. Ok, so I'll clean up the code and get rid of the extra
whitespace - well, I can't seem to accomplish that.

 

Here's my original CF code:

 

CFMAIL TO=#trim(TO)# FROM=#trim(FROM)# SUBJECT=#trim(SUBJECT)#
spoolEnable=Yes

   CFIF isDefined(TEXT) AND len(trim(TEXT)) GT 0

  CFMAILPART type=TEXT
wraptext=74#trim(TextHeader)##Chr(13)##Chr(10)##TEXT#/CFMAILPART

   /CFIF

   CFIF isDefined(HTML) AND len(trim(HTML)) GT 0

  CFMAILPART type=HTML
charset=utf-8#HTMLHeader##HTML#/CFMAILPART

   /CFIF

/CFMAIL

 

And the Email Source it produced (I've highlighted it yellow to help show
the extra whitespace):

server:  mail.myserver.com:25

from:  My Name [EMAIL PROTECTED]

to:  [EMAIL PROTECTED]

subject:  test

type:  text/plain; charset=UTF-8

X-Mailer:  ColdFusion MX Application Server

bodypart-start:  text/plain; charset=UTF-8

body:  

body:  This is a test of the email messaging system.

bodypart-end:  text/plain; charset=UTF-8

bodypart-start:  text/plain; charset=UTF-8

body:  

body: 

body:

body: 

body: 

body:  

bodypart-end:  text/plain; charset=UTF-8

 


Now, because of the extra whitespace, I figured CFMAIL was seeing it as
additional text and automatically inserting another text part. I reduced my
CF code to a single line with no space between the tags. In this scenario,
it still output this:

 

server:  mail.myserver.com:25

from:  My Name [EMAIL PROTECTED]

to:  [EMAIL PROTECTED]

subject:  test

type:  text/plain; charset=UTF-8

X-Mailer:  ColdFusion MX Application Server

bodypart-start:  text/plain; charset=UTF-8

body:  

body:  This is a test of the email messaging system.

bodypart-end:  text/plain; charset=UTF-8

bodypart-start:  text/plain; charset=UTF-8

bodypart-end:  text/plain; charset=UTF-8

 

I haven't tested the 2nd format on Hotmail, but one would assume that a 2nd
defined text part would have the same result whether it contained blank
space or nothing at all. 

 

Is there an issue with CFMAILPART, the use of CFIF within CFMAIL, my use of
any of it? Any guidance is appreciated.

 

Rob



~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


RE: CFMAIL, CFMAILPART, CFIF and Whitespace

2007-05-31 Thread Rob O'Brien
Scott, I gave that a go, but the additional text part is still included.

Rob 


~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

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


RE: CFMAIL, CFMAILPART, CFIF and Whitespace

2007-05-31 Thread Rob O'Brien
I've tested up and down - here's what I've come up with.

The only way I was able to get rid of the additional text part was to remove
the CFMAILPART with type=text and simply include the text within the
CFMAIL tag.

No matter how little I put into a defined text part (even a literal string),
an additional, albeit empty, text part was generated at the end of the email
file.

So, fine. I include my text without a CFMAILPART tag and then include the
HTML with a CFMAILPART tag. This actually works...

Only one problem. Now the HTML part is generated first and the text comes
second, even though I placed the text first in the code. As you said, Scott,
the text should come first - I've known this for a long time and it's always
how I've done it. Simplest first for text-only or older email clients. There
have even been accounts of modern web-based clients like GMail, Hotmail and
Yahoo using text instead of HTML when text comes last.

Is it really this hard for CF7 to generate multipart email? I've done this
for years without issue by using manual boundries. However, this is the
first time I've utilized CFMAILPART.

Rob

-Original Message-
From: Scott Weikert 
Sent: Thursday, May 31, 2007 11:30 AM
To: CF-Talk
Subject: Re: CFMAIL, CFMAILPART, CFIF and Whitespace

Rob O'Brien wrote:
 Scott, I gave that a go, but the additional text part is still included.

   
Well in the 'text' mailpart - try ditching the chr(13) and chr(10) bits, 
and just put in a plain old return, i.e.

CFMAILPART type=TEXT
wraptext=74#trim(TextHeader)#
#TEXT#/CFMAILPART

If that doesn't do it, just slap some plain text in there and send to
yourself, and see if you get the 2nd text bit. Add things back in one at a
time 'til you get the 2nd text bit again, then that should tell you what's
causing it.


~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

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


Suggestions for a quick easy Press Release app

2007-05-30 Thread Rob O'Brien
I'd like to leverage the collective opinion base out there...

I've been searching for a quick  easy press release / news update script
to incorporate into a client site. I'm looking to save myself the time of
writing one from scratch, but it's been difficult to search on such common
terms as press release or news publishing and software or script
without getting extraneous results. 

Are there any suggestions out there? Free would be great, but not necessary.

I appreciate the help.

Rob


~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

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


RE: password form not working -- strange

2007-05-24 Thread Rob O'Brien
I bet you're using the Enter key rather than clicking on the submit button.
If you do that, the submit field will not be passed as a form field.

Your best bet is to either test directly on password or insert a hidden
input and test on that field.

HTH,
Rob

-Original Message-
From: Bobby Tomato [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 24, 2007 1:11 PM
To: CF-Talk
Subject: password form not working -- strange

Strange problem... I'm trying to create a simple password form. Once the
user presses the submit button, the ColdFusion code has a conditional to see
if the field contained the password or not, and then execute some code.

Here's what's happening: if I type in the password, the conditional doesn't
execute, but if I copy/paste the password, it works fine. Just to make sure,
I made the password something really simple so it's not a typo error
(open).

I've tried this on two different ColdFusion servers, and I get the same
result. I've tried it using both IE7 and Firefox 2.

Here's the code that I have, I've simplified it down (the file is called
test.cfm):

cfcode

cfparam name=msg default=

cfif IsDefined(Form.Submit)
cfif Form.password EQ open
cfset msg = Success!
/cfif
/cfif

form method=post action=test.cfm
input name=password type=password size=17 id=password /br
/
input name=Submit type=submit id=Submit value=Submit /
/form

pThe password is quot;openquot; /p
pcfoutputb#msg#/b/cfoutput/p

/cfcode



~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

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


Simple FORM post?

2007-05-15 Thread Rob O'Brien
I'm developing a script that will allow remote servers to use a script
include on their pages to include a relatively simple search form and then
post back to my site to perform the search. Seems straightforward enough,
but the remote form post isn't populating the local CF FORM struct - it
remains empty. 

 

Here's a quick step-by-step:

 

1)   Remote site includes script type=text/javascript
src=http://myhost.com/search.cfm;/script

2)   Search.cfm generates all the HTML necessary for the form, it's
escaped and returned as a single document.write() to the remote host. The
form is presented on the remote site without trouble.

3)   The search term is entered and the form submitted to my server as a
POST

4)   When testing on localhost, all is well. The FORM vars are available
and the search is performed flawlessly. When testing on the prod server,
CF's FORM struct is empty. 

 

I'm using CF's built-in web server locally and IIS on prod. I feel like I'm
missing something stupid. 

 

Any help is appreciated.

 

Rob



~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

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


RE: Simple FORM post?

2007-05-15 Thread Rob O'Brien
Once the form/html content is written to the remote page, there's no more JS
involved in coming back to my server - just a simple form submittal. 

I figure that if POST wouldn't work for me, I'll just use GET instead and
then deal with URL variables rather than FORM. I've implemented this and
everything is working. 

At this point, my conclusion is that the POST method has limitations when
used from a remote server/page, although I can't find anything on the web
that speaks to this. I feel stupid because this seems like a simple rule
that I should have picked up in all of my web development experience... oh
well.

Thanks for the reply
Rob

-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 15, 2007 3:20 PM
To: CF-Talk
Subject: RE: Simple FORM post?

Tough to say what could be going on without looking at any code, but
have you considered that there may be a cross-site scripting security
issue at play?  Does Firefox report anything it its JS console?
Mark

-Original Message-
From: Rob O'Brien [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, May 15, 2007 3:19 PM
To: CF-Talk
Subject: Simple FORM post?

I'm developing a script that will allow remote servers to use a script
include on their pages to include a relatively simple search form and
then post back to my site to perform the search. Seems straightforward
enough, but the remote form post isn't populating the local CF FORM
struct - it remains empty. 

 

Here's a quick step-by-step:

 

1)   Remote site includes script type=text/javascript
src=http://myhost.com/search.cfm;/script

2)   Search.cfm generates all the HTML necessary for the form, it's
escaped and returned as a single document.write() to the remote host.
The form is presented on the remote site without trouble.

3)   The search term is entered and the form submitted to my server
as a
POST

4)   When testing on localhost, all is well. The FORM vars are
available
and the search is performed flawlessly. When testing on the prod server,
CF's FORM struct is empty. 

 

I'm using CF's built-in web server locally and IIS on prod. I feel like
I'm missing something stupid. 

 

Any help is appreciated.

 

Rob







~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278200
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 Rant: SQL Server

2007-05-03 Thread Rob O'Brien
If you properly reference all fields, you'll see that it does throw an
error.

Try [table].USERID and you'll see.

Since you don't specify a table, USERID is ambiguous and will allow USERID
from the other table in the query.

Also, if both tables contained USERID, you'd get an ambiguous column error.

Rob

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 03, 2007 10:19 AM
To: CF-Talk
Subject: Re: OT Rant: SQL Server

On 5/3/07, Dave Watts [EMAIL PROTECTED] wrote:
 
  The subquery:
 
  select distinct USERID
  from ADSPRD.dbo.research_request_log
  where submitted  '2007-01-01'
 

 Don't blame SQL Server, it's doing exactly what you told it to do. Since
 USERID is in the parent query, you are running a correlated subquery.

 http://www.databasejournal.com/features/mssql/article.php/3485291

That doesn't make sense to me.  I've done correlated subqueries plenty
of times, and always referenced something in the where clause to the
parent query.  We do this a lot with EXISTS clauses.

But it makes no sense why this works even as a correlated subquery,
because select userid from research_request_log would imply that I
want to select the field userid FROM the table named
research_request_log

It just doesn't make any sense!  If the glove don't fit.. you must acquit!

Rick

Did I mention that it doesn't make any sense?



~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


RE: encrypt/decrypt bug

2007-04-27 Thread Rob O'Brien
Could you post the entire encrypt/decrypt code snip?

-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 27, 2007 11:45 AM
To: CF-Talk
Subject: encrypt/decrypt bug

This is driving me crazy!!

For this code:

cfif IsDefined(form.myVAR) AND #form.myVAR# NEQ 
   cfset encrpt_myVAR=encrypt(#trim(FORM.myVAR)#,#encCODE#)
/cfif

Figure this out. Here's a few test:
---
Form Entry: Decrypted output: 
Form Entry: 2   Decrypted output: =
form Entry: 22  Decrypted output: 22
form entry: 3332Decrypted output: 333=
form entry: abcdef2 Decrypted output: abcdef2
form entry: abcdef32Decrypted output abcdef3=
form entry: abcdef33Decrypted output abcdef33


I can pretty much put anything I want into the form field and it 
encrypts correctly - UNLESS it ends in a 2. Then it's screwed - 
sometimes. I can't tell if the problem is on the encrypt or decrypt side 
either.

During these test, the var encCODE was kept constant. I haven't tried 
yet, but wonder if changing it would make a difference. Will try that next.

Something I'll get a  some instead of the equal sign. It's ONLY a 2 
that does this. WTF?

Any ideas at all? Is there a patch from the version below to fix this? 
It's driving myself and a client insane right now!!!


Level: Enterprise
Name: ColdFusion Server
Version 7,0,2,142559



~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

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


RE: Trouble with RIGHT function

2007-04-24 Thread Rob O'Brien
The way you're using right() and replace() is incorrect.

RIGHT(URL.GROUPS, 1) will return the last character in the string. In this
case, a comma.

Then with replace(), you're using the result of right() (the comma) and
replacing the first instance (and only the first, since you didn't specify
ALL in replace) within URL.GROUPS with nothing.

What you intended to do is strip off the last character. You should do some
checking to make sure there is in fact an extraneous comma at the end, and
then do something like this:

cfset URL.Group = left(URL.GROUPS,len(URL.GROUPS)-1)

That will take the leftmost X characters (X being one less than the total
length of the string).

It's not necessarily pretty, but it accomplishes what you are trying to do.

Rob


-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 24, 2007 2:21 PM
To: CF-Talk
Subject: Trouble with RIGHT function

I have a query that is getting a string for the WHERE clause from the a URL
variable, and I am building the URL variable in JS on the form submit. What
happens is that the JS puts a comma at the end of the string. No big deal. I
figured that I would just use the RIGHT function to rebuild the string on
the submitted page, stripping the comma off the end. However, it is not
working. The original string looks like this:

3, 4, 5, 6,

When I do this:

cfset URL.Group = REPLACE(URL.GROUPS, RIGHT(URL.GROUPS, 1),'')

I get 3 4, 5, 6,

I am not sure why this is happening. The only thing that I can think of is
that the space between the comma and number is making CF think that 3, is
the end of the string. Does this sound correct?

Thanks,

-- 
Bruce Sorge

I'm a mawg: half man, half dog. I'm my own best friend!




~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

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


Testing Database Connection within Application

2007-04-19 Thread Rob O'Brien
I've done my searching online, throughout several groups, and now I turn to
you guys.

 

I've been having trouble figuring out how to detect, from within my
ColdFusion application, whether or not my database connection is valid. 

 

The DB setup is valid, but my goal is to automatically detect when the
database server is temporarily down/unavailable in order to display an
automatic maintenance message in the case of a crash or true maintenance
when the database is offline.

 

I've tried to put a simple query into my Application file and use CFQUERY's
Timeout to force a quick (5 second) error within a CFTRY, but I'm inclined
to think that it only has an affect on SQL Server when it's up and running,
but taking too long to return a result. With my current attempt, it's taking
up to 18 seconds to fail, which is just too long. Even using CFSETTING to
set RequestTimeout to a lower value doesn't seem to have an affect.

 

This was my attempt:

 

  CFTRY

CFQUERY datasource=#DBDATASOURCE# username=#DBUSERNAME#
password=#DBPASSWORD# name=testConnection timeout=5

  SELECT TOP 1 THEME_ID FROM TBL_THEME

/CFQUERY

  CFCATCH

!-- DB Connection failed --

cfinclude template=Maint.cfm

CFABORT

  /CFCATCH

  /CFTRY

 

If it matters, we're using MSSQL now, though we're planning to switch to
MySQL eventually. I know there are timeout differences with CFQUERY's
Timeout in conjunction with different DB drivers and I'd like to come up
with a single, generic solution.

 

I appreciate any feedback.

 

Rob



~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

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


RE: URL fieldnames

2007-04-19 Thread Rob O'Brien
You can generate a list using ArrayToList(StructKeyArray(URL))

-Original Message-
From: Richard Cooper [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 19, 2007 10:29 AM
To: CF-Talk
Subject: URL fieldnames

Hi,

Is there are URL version of FORM.fieldnames?

Richard



~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

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


RE: Testing Database Connection within Application

2007-04-19 Thread Rob O'Brien
That's what I'm doing now. Unfortunately, the call to the database is taking
too long to timeout (16-18 seconds). I was hoping for a way to speed that up
to 3-5 seconds.

-Original Message-
From: Billy Cox [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 19, 2007 10:50 AM
To: CF-Talk
Subject: RE: Testing Database Connection within Application

You could wrap your database call in a cftry block and then specify code to
run when an error happens.


cftry

cfquery

/cfquery

cfcatch type=database
code to run in event of database error (cfmail?)
/cfcatch

/cftry



-Original Message-
From: Rob O'Brien [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 19, 2007 10:38 AM
To: CF-Talk
Subject: Testing Database Connection within Application


I've done my searching online, throughout several groups, and now I turn to
you guys.



I've been having trouble figuring out how to detect, from within my
ColdFusion application, whether or not my database connection is valid.



The DB setup is valid, but my goal is to automatically detect when the
database server is temporarily down/unavailable in order to display an
automatic maintenance message in the case of a crash or true maintenance
when the database is offline.



I've tried to put a simple query into my Application file and use CFQUERY's
Timeout to force a quick (5 second) error within a CFTRY, but I'm inclined
to think that it only has an affect on SQL Server when it's up and running,
but taking too long to return a result. With my current attempt, it's taking
up to 18 seconds to fail, which is just too long. Even using CFSETTING to
set RequestTimeout to a lower value doesn't seem to have an affect.



This was my attempt:



  CFTRY

CFQUERY datasource=#DBDATASOURCE# username=#DBUSERNAME#
password=#DBPASSWORD# name=testConnection timeout=5

  SELECT TOP 1 THEME_ID FROM TBL_THEME

/CFQUERY

  CFCATCH

!-- DB Connection failed --

cfinclude template=Maint.cfm

CFABORT

  /CFCATCH

  /CFTRY



If it matters, we're using MSSQL now, though we're planning to switch to
MySQL eventually. I know there are timeout differences with CFQUERY's
Timeout in conjunction with different DB drivers and I'd like to come up
with a single, generic solution.



I appreciate any feedback.



Rob







~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7  
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

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


RE: Testing Database Connection within Application

2007-04-19 Thread Rob O'Brien
I tested shutting down my datasource, and it retured false in about 1-2
seconds in my local environment.

This looks like exactly what I'm looking for and I really appreciate the
effort.

I tested the same way. I stop the SQL Server service and then refresh the
script. 

Unfortunately, this still takes 16-18 seconds to return False (tested
locally). If you're reporting 1-2 seconds, I'm thinking there's another
factor involved. Any ideas?

Rob


~|
Create Web Applications With ColdFusion MX7  Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

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


RE: Broadcasting RSS from your site

2007-04-19 Thread Rob O'Brien
That could be done, but I'm about to implement the same type of system and
with thousands upon thousands of requests for a seldom-changing feed, I'll
be statically writing each feed (I'll have multiple) once per day to lessen
the load on the server, rather than creating the same file repeatedly for
each request.

Rob

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 19, 2007 9:19 PM
To: CF-Talk
Subject: RE: Broadcasting RSS from your site

Why write the file?  Why not dynamically generate the feed when it's
requested by a reader?

M!ke 

-Original Message-
From: Adrian Wagner [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 19, 2007 8:46 PM
To: CF-Talk
Subject: Re: Broadcasting RSS from your site

I think, that is excactely how you do it. That's how I do it anyhow.
My site (personal travel website) doesn't have daily updates, so, I
actually create the xml's manually from the CMS (button excecuting the
'create rss feed' functionality). However, you obviously can chuck that
into a scheduled task or even automatically output the xml file after
every change to the DB. I reckon, that depends on your business needs.
 
Dunno, maybe there are better ways to do it. It works for me though and
the RSS feed is actually used quite a bit.
 
Good luck.
a.

 [EMAIL PROTECTED] 20/04/2007 9:38:22 am 

I'd like to add a couple of RSS Broadcast Channels to a site.

Easiest way seems to be:

1. Create an admin page for add/edit items to database 2. Any change to
the database uses cffile to write a
new properly formatted XML file to the server.


Almost seems too easy, therefor I *know* I'm missing something. Am I?



~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

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