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: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
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
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
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?
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.
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
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?
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
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
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..
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
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
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
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?
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
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
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
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
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
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
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?
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?
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
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
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
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
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
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
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
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
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