Flash Site Links Sanity Check
Hi all, We're having reports of links not being clickable in a site: Take a look at this URL (which has been live for 3 years): http://www.mypersonalbrilliance.com Also, look at this URL (also live for 3 years): http://blog.mypersonalbrilliance.com For both sites, click a few of the links in the black bar at top, and the four floating links in the lights area at top. Clickable with redirection? Any problems? I've rechecked the crossdomain.xml file and inserted the eolas js fix from adobe (for the double click problem in IE). I can't find any issues (nor recreate the problem), but my client is having intermittent problems. We've tried it here and remotely on several machines, using WinXP - FF2, FF3, IE6 and IE7. Thank for your help. Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Recursion Output Help
Hi All, Been working on a recursion output for several days now without success. Using a single category table with ID, Name, ParentID. The nesting is up to four layers deep. Problem is, I want to tie the results set to documents that have been posted, with the categoryID referencing the documentID. And only showing those collapsable tree elements that have documents (without breaking the tree). If anyone is open to assisting with display output, for fee, I'd greatly appreciate it. I don't care about what format the display takes (flash, html, jquery, extjs, etc.) as long as it loads reasonably quickly. Need to do this pretty quickly, by mid-next week. Can show you all the params via webex. Using CF8 and MS-SQL 2000. Contact me off list if your interested. EDT Time zone. Thanks, Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Recursion Output Help
I did. Couldn't figure out that logic + tree breaks when I only want to return nodes and levels that correspond with documents/db listings on the server. -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2008 2:09 PM To: CF-Talk Subject: Re: Recursion Output Help Did you look at this: http://nstree.riaforge.org/ On Thu, Jul 24, 2008 at 1:36 PM, Mark Leder [EMAIL PROTECTED] wrote: Hi All, Been working on a recursion output for several days now without success. Using a single category table with ID, Name, ParentID. The nesting is up to four layers deep. Problem is, I want to tie the results set to documents that have been posted, with the categoryID referencing the documentID. And only showing those collapsable tree elements that have documents (without breaking the tree). If anyone is open to assisting with display output, for fee, I'd greatly appreciate it. I don't care about what format the display takes (flash, html, jquery, extjs, etc.) as long as it loads reasonably quickly. Need to do this pretty quickly, by mid-next week. Can show you all the params via webex. Using CF8 and MS-SQL 2000. Contact me off list if your interested. EDT Time zone. Thanks, Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Baffling Error
Somebody has a bad link to your site? This happens on all sites (30 or so), the beginning url is valid, it's just at the first ' (single tick), junk is automatically appended on the string. -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2008 12:11 PM To: CF-Talk Subject: Re: Baffling Error Somebody has a bad link to your site? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301755 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Baffling Error
Hi, I've been going through my error logs on CF8/IIS6, and repeatedly come up with this message (note the URL will be for any site that's on my server, this is an example): http://rosemariespeaks.com/'http:/rosemariespeaks.com/index.cfm The filename, directory name, or volume label syntax is incorrect null The error occurred on line -1. I've been searching all over Google for issues related to IIS6, but haven't found anything. I use an application.cfc in the front end of all my sites. Is there something I could be doing in the application.cfc or in IIS to prevent these malformed urls? Thanks, Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301648 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Baffling Error
Hi, I've been going through my error logs on CF8/IIS6, and repeatedly come up with this message (note the URL will be for any site that's on my server, this is an example): http://rosemariespeaks.com/'http:/rosemariespeaks.com/index.cfm The filename, directory name, or volume label syntax is incorrect null The error occurred on line -1. I've been searching all over Google for issues related to IIS6, but haven't found anything. I use an application.cfc in the front end of all my sites. Is there something I could be doing in the application.cfc or in IIS to prevent these malformed urls? Thanks, Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301654 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Baffling Error
The problem is that there are bots pounding all my sites with malformed urls. I get anywhere from 20 to 100 per day. Is there a way to filter/regex stop that from occuring before it throws an error? -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2008 1:04 PM To: CF-Talk Subject: Re: Baffling Error I've been going through my error logs on CF8/IIS6, and repeatedly come up with this message (note the URL will be for any site that's on my server, this is an example): I'm with Matt here, it looks like someone, somewhere has a bad link to your site. Your site appears to be functioning perfectly. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Baffling Error
Create a custom 404 that is caught by both CF and IIS/Apache that redirects to /index.cfm ? So, what would the regex or script look like? Because there are lots of variations in the malformed URL. Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Manually inserting Ajax script calls
Been playing around with some of the new CF8 Ajax tools. I notice that when a tool is placed on a page (in this case cftooltip), the scripts needed to run the tooltip are inserted automatically at runtime in the head of the document. Since I have a CMS where I would want to control the placement/insertion of the javascripts, is there a way to do this manually (ie, from the \cfide\scripts\ajax\ directory). Would it really be that simple? Am I missing something here? Thanks for your help. Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP! RE: error with ColdFusion 8 ODBC Agent
This STILL does not work. I put the file on the server in the directory CFIDE/administrator. I use terminal services to get to my server. I log into CF8 admin. Then I replace the URL string with: http://127.0.0.1/cfide/administrator/remove.cfm (remove is what I called the page). Same issue, I'm not authorized to run this page. What am I doing wrong? Mark -Original Message- From: Hareni Venkatramanan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 03, 2007 3:18 AM To: CF-Talk Subject: RE: HELP! RE: error with ColdFusion 8 ODBC Agent Hi Mark, You need to be logged in as admin to avoid getting this error. Can you try running the scripts from CFIDE/administrator directory? Thanks, Hareni Adobe CF team ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290498 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HELP! RE: error with ColdFusion 8 ODBC Agent
I just did an install on a production server and cannot get this script to run. I get this error: The current user is not authorized to invoke this method What am I doing wrong? How do I fix? Uninstalling and reinstalling CF8 is not an option, since I have all the mappings, cf and cfx tags and browserhawk installed and running. Mark -Original Message- From: Hareni Venkatramanan [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 2:17 AM To: CF-Talk Subject: RE: error with ColdFusion 8 ODBC Agent Hi Matthew, Sometimes, it might happen that the ODBC services Coldfusion8 ODBC Agent and Coldfusion 8 ODBC Server do not get installed properly for new J2EE deployment and in services property the path keeps pointing to an old deployment directory and hence they do not start up. What you can do is, remove the existing ODBC services using remove-odbcservices.cfm having the script given below: cfscript createObject(component,cfide.adminapi.administrator).login(admin); myObj = createObject(component,cfide.adminapi.datasource); writeOutput(Removing ODBC Services...br); returnValue = myObj.removeODBCservice(); writeOutput(ODBC Services removed); /cfscript And then, install the ODBC services using install-odbcservices.cfm having the script given below: cfscript createObject(component,cfide.adminapi.administrator).login(admin); myObj = createObject(component,cfide.adminapi.datasource); writeOutput(Installing ODBC Services...br); returnValue = myObj.installODBCservice(); writeOutput(ODBC Services installed); /cfscript Then, try starting ColdFusion ODBC Server service. Thanks, Hareni -Original Message- From: Matthew Smith [mailto:[EMAIL PROTECTED] Sent: 22 August 2007 01:25 To: CF-Talk Subject: error with ColdFusion 8 ODBC Agent I am trying to add a datasource to my new install of CF8 developer edition. When I went to do so in cf admin, the admin said The ColdFusion ODBC Server service is not running or has not been installed. So I figured the service wasn't set to automatic and went into services to start it up. When I tried to start the service, I got this error: Could not start the ColdFusion 8 Odbc Server service on Local computer. Error 3 The system cannot find the path specified. I did a clean install of windows and CF 8. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289798 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Content Placeholders
in the i18n world, java MessageFormat's are often used for dynamic content like this. it's flexible, quick as an added bonus handles locale formatting where needed. Where would I find something like that? Mark ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285669 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Content Placeholders
Hi, Trying to figure out how to use a placeholder in dynamic content to pull in other content at runtime. A user is entering text on a page in a database driven CMS system. If they insert a token or Placeholder in the middle of the copy somewhere (such as %%ref01%%), I would want that placeholder to dynamically insert additional text/graphics copy pulled from a different query, the inserted copy corresponding to that query's ref01 ID. I could have two or three different placeholders within the page, each corresponding to a different ID. I'm sure something like this is possible, but my searches for placeholder and token haven't turned up much. Thanks for your assistance, Mark ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Content Placeholders
Yeah, I was thinking about some type of conditional logic that would parse the entire html to look for an instance of **image01** to trigger the replace. Mark -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Sunday, August 05, 2007 1:17 PM To: CF-Talk Subject: RE: Content Placeholders I've done this in the past to allow the user to place images at specific places in their articles. I used tokens like... **image1** **image2** **image3** Etc... Then gave them a drop down menu for each image to select which image to display in each position. On the front end... If image1 is defined, #replace(str, '**image1**', 'img src=pathtoimage.jpg alt= title= /', 'all')# And the same thing for the others. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFQuery and MySQL
I have a new MySQL connection set up in CF7 - verifies correctly (called mysqldb). Within this connection I have a db called ABC, and then tables within this db. I can't get the cfquery to work correctly: If I use: cfquery name=insertA datasource=mysqldb I get the error: No database selected If I use: cfquery name=insertA datasource=abc I get the error: Datasource ABC could not be found I suspect the first error is closer to the solution. How do I get a cfquery to point to the right db? THANKS! Mark ~| 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:282696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQuery and MySQL
That worked, thanks for clearing that up for me. -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 8:40 AM To: CF-Talk Subject: Re: CFQuery and MySQL This may help with the set up (but I'm assuming as it verifies it probably ok): http://www.oxalto.co.uk/index.cfm/2007/7/2/Setting-up-a-MySQL- database-with-Unicode--properly-in-Coldfusion-7 T On 2 Jul 2007, at 13:18, Mark Leder wrote: I have a new MySQL connection set up in CF7 - verifies correctly (called mysqldb). Within this connection I have a db called ABC, and then tables within this db. I can't get the cfquery to work correctly: If I use: cfquery name=insertA datasource=mysqldb I get the error: No database selected If I use: cfquery name=insertA datasource=abc I get the error: Datasource ABC could not be found I suspect the first error is closer to the solution. How do I get a cfquery to point to the right db? THANKS! Mark ~| 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:282703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RegEx help
I'm really not very good at this, so I'm grateful for any help. I've been using one of those regex editors, but I just can't seem to get my head around the way it's used (regEx buddy). What I want to do is take a URL string, such as /level-1/2nd-level/index.cfm and just keep the string which is between the first set of / (level-1 no quotes). How would this be written? Thanks, Mark ~| 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:273197 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RegEx help
Thanks to all, Gareth's solution works great. Though I want to study Ben's more (one first glance I got bug-eyed looking at it). Thanks, Mark ~| 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:273216 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Ideas and approaches
I have a plain text email that this pushed out when triggered by a third party app (BaseCampHQ). Inside Basecamp, I can point this email to any fixed address I choose. What I want to do is: receive this email inside CF, then parse the body, glitz it up with HTML, and resend out to a list of people. I would assume that I set up CFPop to receive the mail, but I don't know how to do is grab the text body of the message, so I can save in a var and paste into the new HTML message I create with CFMail. What is/are good approaches to doing that? Thanks for your help. Mark ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270998 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Ideas and approaches
The CFPOP tag returns a query on action=getAll, which has a column BODY which presumably has the text that you want to manipulate. It sure does! I should have read the docs more thoroughly. That should solve the problem. Thanks for your input. Mark ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FCKeditor File Browsing question
One option would be to install CFFM on the remote server to serve as the file manager, and disable all upload/modify/manipulate capabilities... then you could just point fckeditor to the remote instance of CFFM. CFFM 1.14has a readOnly property allowing to to use it as a public file repository.. Great idea, thanks. Mark ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
FCKeditor File Browsing question
Haven't used FCK much, but I'm curious, can the file browser mechanism be set to browse a public directory on a remote server (which is in another city)? In other words, could I set it to browse using a FQDN: http://www.somesite.com/assets/images/... Thanks, Mark ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270254 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Line Breaks in Plain Text CFMail - GRRR!
Yes, this does work correctly in plain text email. Thanks to everyone's help with this. Mark === cfset crlf = chr(13) chr(10) cfset VARIABLES.formFieldsCopy = cfif Len(ARGUMENTS.rsvpUserBadgeName) cfset VARIABLES.formFieldsCopy = VARIABLES.formFieldsCopy Attendee Name Badge: ARGUMENTS.rsvpUserBadgeName crlf /cfif cfif Len(ARGUMENTS.rsvpGuest01Name) cfset VARIABLES.formFieldsCopy = VARIABLES.formFieldsCopy Guest Name: ARGUMENTS.rsvpGuest01Name crlf /cfif cfif Len(ARGUMENTS.rsvpGuest01BadgeName) cfset VARIABLES.formFieldsCopy = VARIABLES.formFieldsCopy Guest Name Badge: ARGUMENTS.rsvpGuest01BadgeName crlf /cfif If you still have the problem, try another e-mail client. Outlook has the nasty habit of removing line breaks it thinks are unnecessary. Jochem ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Line Breaks in Plain Text CFMail - GRRR!
Instead of doing all your cfifs etc within the cfmail tag - do it all prior to the cfmail tag, and build up your content within a variable, just the way you want to. That'll avoid any extra linefeeds etc. Then just spit out that variable in the cfmail tag, within the cfmailpart type=text/cfmailpart bits if that's the route you're going. Both you and Jochem have a good idea, which I will test later tommorow. It must be that cfsavecontent that chokes on chr(). Got hammered on other issues, so I couldn't respond right away. Mark ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Line Breaks in Plain Text CFMail - GRRR!
I just cannot get this to work. Sending plain text email, want to force a line break. I've tried chr(10), chr(13), chr(13) chr(10), with and without pound signs, restarted CFMX7. The arguments are outputting correctly. What's the trick to this? cfset carr = chr(13) chr(10) cfprocessingdirective suppresswhitespace=yes cfsavecontent variable=VARIABLES.formFieldsCopy cfoutput cfif Len(ARGUMENTS.rsvpUserBadgeName)Attendee Name Badge: #ARGUMENTS.rsvpUserBadgeName##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01Name)Guest Name: #ARGUMENTS.rsvpGuest01Name##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01BadgeName)Guest Name Badge: #ARGUMENTS.rsvpGuest01BadgeName#/cfif /cfoutput /cfsavecontent /cfprocessingdirective ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Line Breaks in Plain Text CFMail - GRRR!
So how do I get rid of the extra lines where CFIF statements are bypassed in the code? The savecontent var that I'm building has about 35 cfif statements. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 5:15 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! Remove your 'supresswhitespace' tag. That supresses carriage returns if I remember correctly. Dave -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 4:10 PM To: CF-Talk Subject: Line Breaks in Plain Text CFMail - GRRR! I just cannot get this to work. Sending plain text email, want to force a line break. I've tried chr(10), chr(13), chr(13) chr(10), with and without pound signs, restarted CFMX7. The arguments are outputting correctly. What's the trick to this? cfset carr = chr(13) chr(10) cfprocessingdirective suppresswhitespace=yes cfsavecontent variable=VARIABLES.formFieldsCopy cfoutput cfif Len(ARGUMENTS.rsvpUserBadgeName)Attendee Name Badge: #ARGUMENTS.rsvpUserBadgeName##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01Name)Guest Name: #ARGUMENTS.rsvpGuest01Name##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01BadgeName)Guest Name Badge: #ARGUMENTS.rsvpGuest01BadgeName#/cfif /cfoutput /cfsavecontent /cfprocessingdirective ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Line Breaks in Plain Text CFMail - GRRR!
Viewing in MS Outlook as an email message. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 5:24 PM To: CF-Talk Subject: Re: Line Breaks in Plain Text CFMail - GRRR! Are you viewing this in an email or outputting it to a web template? savecontent should generate the line feeds for you and save the content the way it was originally. If you are outputting to a template then you need to wrap whatever in a pre tag. Doug B. - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, January 27, 2007 3:10 PM Subject: Line Breaks in Plain Text CFMail - GRRR! I just cannot get this to work. Sending plain text email, want to force a line break. I've tried chr(10), chr(13), chr(13) chr(10), with and without pound signs, restarted CFMX7. The arguments are outputting correctly. What's the trick to this? cfset carr = chr(13) chr(10) cfprocessingdirective suppresswhitespace=yes cfsavecontent variable=VARIABLES.formFieldsCopy cfoutput cfif Len(ARGUMENTS.rsvpUserBadgeName)Attendee Name Badge: #ARGUMENTS.rsvpUserBadgeName##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01Name)Guest Name: #ARGUMENTS.rsvpGuest01Name##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01BadgeName)Guest Name Badge: #ARGUMENTS.rsvpGuest01BadgeName#/cfif /cfoutput /cfsavecontent /cfprocessingdirective ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267866 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Line Breaks in Plain Text CFMail - GRRR!
Good call, I've been thinking along this line. Let me test out and I'll let you know. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 5:55 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! Well, one option would be to put them all on one line. :) But that would be a nightmare to support coding wisesohere's another hack you could do without modifying how your e-mail will look in Outlook: cfset carr = createUUID() !--- (supply a unique character string here, just using createUUID() to simplify) --- cfprocessingdirective suppresswhitespace=yes cfsavecontent variable=VARIABLES.formFieldsCopy cfoutput cfif Len(ARGUMENTS.rsvpUserBadgeName)Attendee Name Badge: #ARGUMENTS.rsvpUserBadgeName##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01Name)Guest Name: #ARGUMENTS.rsvpGuest01Name##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01BadgeName)Guest Name Badge: #ARGUMENTS.rsvpGuest01BadgeName#/cfif /cfoutput /cfsavecontent /cfprocessingdirective cfset variables.formFieldsCopy = replace(variables.formFieldsCopy,carr,chr(13)chr(10),all) Let me know if that works. Dave -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 4:24 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! So how do I get rid of the extra lines where CFIF statements are bypassed in the code? The savecontent var that I'm building has about 35 cfif statements. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 5:15 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! Remove your 'supresswhitespace' tag. That supresses carriage returns if I remember correctly. Dave -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 4:10 PM To: CF-Talk Subject: Line Breaks in Plain Text CFMail - GRRR! I just cannot get this to work. Sending plain text email, want to force a line break. I've tried chr(10), chr(13), chr(13) chr(10), with and without pound signs, restarted CFMX7. The arguments are outputting correctly. What's the trick to this? cfset carr = chr(13) chr(10) cfprocessingdirective suppresswhitespace=yes cfsavecontent variable=VARIABLES.formFieldsCopy cfoutput cfif Len(ARGUMENTS.rsvpUserBadgeName)Attendee Name Badge: #ARGUMENTS.rsvpUserBadgeName##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01Name)Guest Name: #ARGUMENTS.rsvpGuest01Name##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01BadgeName)Guest Name Badge: #ARGUMENTS.rsvpGuest01BadgeName#/cfif /cfoutput /cfsavecontent /cfprocessingdirective ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Line Breaks in Plain Text CFMail - GRRR!
Didn't work. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 6:03 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! Good call, I've been thinking along this line. Let me test out and I'll let you know. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 5:55 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! Well, one option would be to put them all on one line. :) But that would be a nightmare to support coding wisesohere's another hack you could do without modifying how your e-mail will look in Outlook: cfset carr = createUUID() !--- (supply a unique character string here, just using createUUID() to simplify) --- cfprocessingdirective suppresswhitespace=yes cfsavecontent variable=VARIABLES.formFieldsCopy cfoutput cfif Len(ARGUMENTS.rsvpUserBadgeName)Attendee Name Badge: #ARGUMENTS.rsvpUserBadgeName##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01Name)Guest Name: #ARGUMENTS.rsvpGuest01Name##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01BadgeName)Guest Name Badge: #ARGUMENTS.rsvpGuest01BadgeName#/cfif /cfoutput /cfsavecontent /cfprocessingdirective cfset variables.formFieldsCopy = replace(variables.formFieldsCopy,carr,chr(13)chr(10),all) Let me know if that works. Dave -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 4:24 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! So how do I get rid of the extra lines where CFIF statements are bypassed in the code? The savecontent var that I'm building has about 35 cfif statements. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 5:15 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! Remove your 'supresswhitespace' tag. That supresses carriage returns if I remember correctly. Dave -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 4:10 PM To: CF-Talk Subject: Line Breaks in Plain Text CFMail - GRRR! I just cannot get this to work. Sending plain text email, want to force a line break. I've tried chr(10), chr(13), chr(13) chr(10), with and without pound signs, restarted CFMX7. The arguments are outputting correctly. What's the trick to this? cfset carr = chr(13) chr(10) cfprocessingdirective suppresswhitespace=yes cfsavecontent variable=VARIABLES.formFieldsCopy cfoutput cfif Len(ARGUMENTS.rsvpUserBadgeName)Attendee Name Badge: #ARGUMENTS.rsvpUserBadgeName##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01Name)Guest Name: #ARGUMENTS.rsvpGuest01Name##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01BadgeName)Guest Name Badge: #ARGUMENTS.rsvpGuest01BadgeName#/cfif /cfoutput /cfsavecontent /cfprocessingdirective ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Line Breaks in Plain Text CFMail - GRRR!
Fixing the line break problem, tried your code a number of ways. Moved the cfprocessingdirective inside the cfsavecontent, outside the cfsavecontent. Made sure the replace function was after the closing cfprocessingdirective and cfsavecontent tags. The uuid is placed correctly and shows up, but the replace won't insert the cr lf. FWIW, I'm running this code inside a cfc. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 8:24 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! What didn't work? -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 6:10 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! Didn't work. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 6:03 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! Good call, I've been thinking along this line. Let me test out and I'll let you know. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Saturday, January 27, 2007 5:55 PM To: CF-Talk Subject: RE: Line Breaks in Plain Text CFMail - GRRR! Well, one option would be to put them all on one line. :) But that would be a nightmare to support coding wisesohere's another hack you could do without modifying how your e-mail will look in Outlook: cfset carr = createUUID() !--- (supply a unique character string here, just using createUUID() to simplify) --- cfprocessingdirective suppresswhitespace=yes cfsavecontent variable=VARIABLES.formFieldsCopy cfoutput cfif Len(ARGUMENTS.rsvpUserBadgeName)Attendee Name Badge: #ARGUMENTS.rsvpUserBadgeName##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01Name)Guest Name: #ARGUMENTS.rsvpGuest01Name##carr#/cfif cfif Len(ARGUMENTS.rsvpGuest01BadgeName)Guest Name Badge: #ARGUMENTS.rsvpGuest01BadgeName#/cfif /cfoutput /cfsavecontent /cfprocessingdirective cfset variables.formFieldsCopy = replace(variables.formFieldsCopy,carr,chr(13)chr(10),all) Let me know if that works. Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFHeader No Cache Sanity Check
I don't know if its just me or the code I've used for a while, but seems like since the first of this year (or thereabouts) IE (6 or 7) seems to ignore page caching instructions and caches pages. (I'm not seeing this behavior in FF). Wondering if a MS Patch has caused a problem or if others have noticed any changes. As a sanity check, here's the code I use to prevent page caching. Does the ordering of it make a difference? Should any lines be in locations other near the top of head/head? Is any of this repetitive or not necessary? head meta http-equiv=Content-Type content=text/html; charset=utf-8 / meta http-equiv=Content-Language content=en-us / title#ARGUMENTS.contentHeadTitle#/title meta name=abstract content=#ARGUMENTS.contentHeadAbstract# / meta name=keywords content=#ARGUMENTS.contentHeadKeywords# / meta name=description content=#ARGUMENTS.contentHeadDescription# / meta name=copyright content=#ARGUMENTS.contentHeadCopyright# / meta name=robots content=#ARGUMENTS.contentHeadRobots# / meta name=revisit-after content=#ARGUMENTS.contentHeadRevisitAfter# / meta name=MSSmartTagsPreventParsing content=#ARGUMENTS.contentHeadMSSmartTags# / meta http-equiv=imagetoolbar content=#ARGUMENTS.contentHeadImageToolbar# / cfheader name=cache-control value=no-cache, no-store, must-revalidate / cfheader name=cache-control value=post-check=0, pre-check=0 / cfheader name=expires value=Mon, 26 Jul 1997 05:00:00 GMT / cfheader name=last-modified value=Mon, 26 Jul 1997 05:00:00 GMT / cfheader name=pragma value=no-cache / meta name=expires content=#DateFormat(ARGUMENTS.contentHeadExpires, 'ddd, dd mmm ')# #TimeFormat(ARGUMENTS.contentHeadExpires, 'HH:mm:ss')# GMT / meta http-equiv=expires content=#DateFormat(ARGUMENTS.contentHeadExpires, 'ddd, dd mmm ')# #TimeFormat(ARGUMENTS.contentHeadExpires, 'HH:mm:ss')# GMT / meta http-equiv=pragma content=no-cache / /head Thanks, Mark ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFHeader No Cache Sanity Check
Don't know. If they are of equal value I suppose one or more should be deleted. But which one(s)? -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 10, 2007 5:43 PM To: CF-Talk Subject: Re: CFHeader No Cache Sanity Check Is there a reason to set http-equiv meta tags when you are setting the actual headers already? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Cfdocument and cfloop
I have a member directory where I'm using CFDocument to create a PDF. The query results are outputted using a cfloop around a table. Problem is, right now, I can only output one record per page before the cfdocumentitem=pagebreak occurs. If I remove the pagebreak, there will be 3 or 4 member records, and a member record can break across two pages, which doesn't look right. Is there a way to force the cfloop to loop (2) records per page, then insert the pagebreak, then loop two more records on the next page, and so on? Here's an example of the printout (one record per page) www.nsaohio.com/directory/ /Code/ cfdocument format=pdf filename=#APPLICATION.downloadFiles#nsaohio_ProMember_Directory.pdf overwrite=yes pagetype=letter margintop=1 marginright=1 marginbottom=1 marginleft=1.5 html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / cfoutput link rel=stylesheet href=#SESSION.css.screen# type=text/css media=screen / link rel=stylesheet href=#SESSION.css.print# type=text/css media=print / /cfoutput /head body cfdocumentitem type=header br / br / div style=font:normal bold 18px Tahoma; color:black; text-align:center; text-decoration:underline;NSA Ohio Professional Member Directory/div /cfdocumentitem cfloop query=qSpeakerList cfoutput table border=0 cellspacing=0 cellpadding=2 width=100% class=borderAllSides align=center ... Other table content here ... trtd colspan=3 class=text12left style=padding:0 6px 6px 6px;#memberProfile# /td/tr /table br / /cfoutput cfdocumentitem type=pagebreak / /cfloop cfdocumentitem type=footer br / cfoutput div style=font:normal normal 16px Tahoma; color:black; text-align:center; #DateFormat(Now(), ', DD, ')#nbsp;##8212;nbsp;Page #cfdocument.currentpagenumber# of #cfdocument.totalpagecount# /div /cfoutput /cfdocumentitem /body /html /cfdocument ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265610 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Counting Cfcontent Downloads
When using CFContent, how would I write to a db AFTER a file is downloaded (such as a counter/date) in the background, without opening a new page? I do have each file listed in a db, with all the normal file scope fields (size, name, etc). [This E-mail scanned for viruses by Declude EVA] ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264426 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Counting Cfcontent Downloads
at least a prompt to download the file. They could still be counted and simply hit close or concel on the download prompt or even download half of the file and then cancel though. I don't think you are going to get around that in any easy way. That's what I told the client, that I can't control the user action once the prompt is presented. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL Concetenation inside CFQuery
I'm using this cfquery to pull records from an MSSQL 2005 db: SELECT U.userID, U.userFirstName, U.userMiddleName, U.userLastName, (U.userFirstName + SPACE(1) + U.userMiddleName + SPACE(1) + U.userLastName) AS assignedName FROM a_Table It works great, with one exception. In some cases, the U.userMiddleName datafield is a NULL value. When that occurs, the entire assignedName alias is NULL for that record row, not just inserting an empty space between the first and last names as I would expect. When all three datafields (first,middle,last) have values, a valid assignedName is returned. Is there a workaround? Thanks, Mark [This E-mail scanned for viruses by Declude EVA] ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263913 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Flash Player 8+ requirement for an App
FYI there are corporate clients (I can think of a very large university) who administratively prevent users from downloading updated components of anything. This client in question is stuck on v7, so none of my flash v8 will play. -Original Message- From: John Dowdell [mailto:[EMAIL PROTECTED] Sent: Monday, December 11, 2006 4:01 PM To: CF-Talk Subject: Re: Flash Player 8+ requirement for an App OÃuz Demirkapı wrote: If you have an application which requires Flash 8+ to run but your client`s clients could not update their Flash player because of lack of knowledge or without having required rights. Or if you have a Flex2 application which requires Flash Player 9+ with same situation. What would you suggest to your client? For How can I get Adobe Flash Player deployed to an intranet? then there's an intranet kit available: http://www.adobe.com/licensing/distribution/ For Is the general public able to upgrade their Players? then yes, they are, at the rate of well over five million a day, making it the most rapidly-adopted software in history. http://www.adobe.com/products/player_census/flashplayer/version_penetration. html For How can I persuade my client that it's okay to specify Adobe Flash Player 9? then the most effective technique seems to be to work to first discover what their actual objections are. jd -- John Dowdell . Adobe Developer Support . San Francisco CA USA Weblog: http://weblogs.macromedia.com/jd Aggregator: http://weblogs.macromedia.com/mxna Technotes: http://www.macromedia.com/support/ Spam killed my private email -- public record is best, thanks. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263627 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Outgoing CF Mail undelivered
For the past two days, all CF generated mail (using CF Mail or ims Mail's CFX tag) are bouncing after being sent and immediately being forwarded to the undeliverable folder. I'm using IIS SMTP server for the push out. I've checked to make sure the service is running, and we have made no changes to the SMTP server settings, nor to the settings for the CFMail, etc. I've also checked DNSStuff just in case we got our IP blacklisted, which it is not. And, I see no rhyme or reason as to where the mail is to be sent to, it still bounces. I've also checked to make sure that we have a valid From address. Looking at the mail.log, the messages are either: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 [EMAIL PROTECTED] No such user here (the vast majority of log entries). Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 Authentication is required for relay Usually comes from the form mail Now, the majority of the messages for the past two days have been a list we send to everyday without problem, there can't be that many invalid addresses. Also, some of the other form mail that bounces is a autoresponse sent back to the user who filled out the form, using their own address. I'm out of ideas on how to solve this. Help. Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Outgoing CF Mail undelivered
I'll see if this works - I do think we found a setting problem with Smartermail which may have caused the issue. Thanks, Mark -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 5:59 PM To: CF-Talk Subject: Re: Outgoing CF Mail undelivered Seen this happen before (as far back as the 4.5 days til now). Something hung up in CFs connection to your mail server. Even though the connection may be good now, it'll still drop it all to undelivered. Stop CF. Move all mail from your spool into a copy folder. Restart CF services. Move messages from the copy folder back into the spool about 100 at a time, waiting to drag the next set until you see the spool empty. Move messages from your undelivered folder back into the spool folder at about 100 at a time, waiting for the spool to empty each time. Cutter __ http://blog.cutterscrossing.com Mark Leder wrote: For the past two days, all CF generated mail (using CF Mail or ims Mail's CFX tag) are bouncing after being sent and immediately being forwarded to the undeliverable folder. I'm using IIS SMTP server for the push out. I've checked to make sure the service is running, and we have made no changes to the SMTP server settings, nor to the settings for the CFMail, etc. I've also checked DNSStuff just in case we got our IP blacklisted, which it is not. And, I see no rhyme or reason as to where the mail is to be sent to, it still bounces. I've also checked to make sure that we have a valid From address. Looking at the mail.log, the messages are either: Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 [EMAIL PROTECTED] No such user here (the vast majority of log entries). Invalid Addresses; nested exception is: class javax.mail.SendFailedException: 550 Authentication is required for relay Usually comes from the form mail Now, the majority of the messages for the past two days have been a list we send to everyday without problem, there can't be that many invalid addresses. Also, some of the other form mail that bounces is a autoresponse sent back to the user who filled out the form, using their own address. I'm out of ideas on how to solve this. Help. Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
DateAdd in Query Statement
I'm attempting to filter a query set based on a date. However, it looks like the DateAdd function is not in an ODBC format, so I can't compare the current date to the filePostDate + twgFileExpDate. I've looked around CFLib without success. How would I write this? cfset ARGUMENTS.twgFileExpDate = 21 SELECT F.fileURL, F.filePostDate, F.caseID FROM #APPLICATION.prefix#_Clients_Files_List F WHERE F.caseID = cfqueryparam cfsqltype=cf_sql_char value=#ARGUMENTS.caseID# AND #CreateODBCDateTime(Now())# = #DateAdd('D',ARGUMENTS.twgFileExpDate,F.filePostDate)# Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SSL Providers
ComodoGroup.com - get the reseller pricing. Thanks, Mark -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Monday, November 27, 2006 9:15 AM To: CF-Talk Subject: SSL Providers Anyone have any recommendations for SSL certificates? I've used Verisign and Network Solutions. Net Sol is cheaper. Are there any others out there that are safe and cheaper? Thanks, -- Matt Williams It's the question that drives us. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DateAdd in Query Statement
Outstanding! That was it (the filePostDate value not existing problem). Thanks Jim and Ryan. Thanks, Mark -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Monday, November 27, 2006 9:26 AM To: CF-Talk Subject: Re: DateAdd in Query Statement Mark Leder wrote: I'm attempting to filter a query set based on a date. However, it looks like the DateAdd function is not in an ODBC format, so I can't compare the current date to the filePostDate + twgFileExpDate. I've looked around CFLib without success. How would I write this? cfset ARGUMENTS.twgFileExpDate = 21 SELECT F.fileURL, F.filePostDate, F.caseID FROM #APPLICATION.prefix#_Clients_Files_List F WHERE F.caseID = cfqueryparam cfsqltype=cf_sql_char value=#ARGUMENTS.caseID# AND #CreateODBCDateTime(Now())# = #DateAdd('D',ARGUMENTS.twgFileExpDate,F.filePostDate)# You are trying to do the dateadd on F.filePostDate on the CF side of things, but the F.filePostDate value will not exist until the query is being run...use a function on the db side of things... AND #CreateODBCDateTime(Now())# = DATEADD(day, #ARGUMENTS.twgFileExpDate#, F.filePostDate) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SQL Problem
I'm stumped on this. How to I retrieve records that do not match (I'm wanting to display orphaned Companies that are not associated with Projects). Tried and using NOT and NOT IN() without success. SELECT C.company, C.companyID, C.companyCity, C.companyState, C.companyZip, P.companyID FROM dbTable_Clients_Companies_List C, dbtable_Clients_Projects_List P WHERE C.companyID P.companyID ORDER BY C.company ASC Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Problem
Jim, Thank you, that worked perfectly. Admittedly, I get confused by the LEFT/ON attribs in queries. Thanks, Mark -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 11:56 AM To: CF-Talk Subject: Re: SQL Problem Mark Leder wrote: I'm stumped on this. How to I retrieve records that do not match (I'm wanting to display orphaned Companies that are not associated with Projects). Tried and using NOT and NOT IN() without success. SELECT C.company, C.companyID, C.companyCity, C.companyState, C.companyZip, P.companyID FROM dbTable_Clients_Companies_List C, dbtable_Clients_Projects_List P WHERE C.companyID P.companyID ORDER BY C.company ASC Thanks, Mark If there is no match, then the right side of that is going to be NULL, and then the comparison will always resolve to FALSE. Try this... SELECT C.company, C.companyID, C.companyCity, C.companyState, C.companyZip,P.companyID FROM dbTable_Clients_Companies_List C LEFT JOIN dbtable_Clients_Projects_List P ON C.companyID = P.companyID WHERE P.companyID IS NULL ORDER BY C.company ASC ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260698 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SQL Problem
That works too. Thanks Dave. Thanks, Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 11:56 AM To: CF-Talk Subject: RE: SQL Problem I'm stumped on this. How to I retrieve records that do not match (I'm wanting to display orphaned Companies that are not associated with Projects). Tried and using NOT and NOT IN() without success. SELECT C.company, C.companyID, C.companyCity, C.companyState, C.companyZip, P.companyID FROM dbTable_Clients_Companies_List C, dbtable_Clients_Projects_List P WHERE C.companyID P.companyID ORDER BY C.company ASC SELECT c.company, c.companyID, c.companyCity, c.companyState, c.companyZip FROMdbTable_Clients_Companies_List c WHERE c.companyID NOT IN (SELECT p.companyID FROM dbtable_Clients_Projects_List p) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore and Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Question regarding my first consulting job
Rate? I am thinking of charging $60 / hour for development Depends where you are. $60 is too low in my estimation, if you're in the US. Should I ask for 20% ahead of time, or just wait till completion for payment? Get minimum 50% up front before you move a mouse. This keeps people from pulling the plug without you getting paid for work already completed. Should I setup a visual structure first Yes, mapping the business process first is always a good idea - clarifies everyone's thinking and eliminates a bunch of rewrites. convert his access DB to SQL? Absolutely, get it out of Access and into a relational db. Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Online Help
Maybe I'll wait til then. I can hobble along with Visio/snag it for the time being. Robohelp does seem to offer the most robust feature set I've found in my research. Thanks for the reply. Thanks, Mark -Original Message- From: Joshua Cyr [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 8:34 AM To: CF-Talk Subject: RE: Online Help I use RoboHelp, as buggy as it is. They have a new version due at somepoint since they put out a request for beta testers. Wish I knew more, but that is all I have. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Monday, November 06, 2006 5:49 PM To: CF-Talk Subject: Online Help What are folks using/recommeding for online help documentation for web apps? Robohelp? Others? I'd like some ability to integrate with CF (conditional logic) and maybe some flash generation, but not mandatory. Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: WYSIWYG Text Editors
Xstandard.com Thanks, Mark -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 12:20 PM To: CF-Talk Subject: WYSIWYG Text Editors I'm looking for a list of WYSIWYG text editors for forms. I'm aware of Active Edit, Tinymce and FCKeditor. Free, Shareware or paid can all be considered. What is important is the editor's ability to easily and cleanly handle international/extended/special characters. Easy integration into ColdFusion is important as well. Suggestions and comments welcome. Thank You -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Online Help
Also, look at these lists of WYSIWYG editors: http://wysiwyg.skybuilders.com/report.html http://www.geniisoft.com/showcase.nsf/WebEditors Thanks, Mark -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 12:24 PM To: CF-Talk Subject: RE: Online Help Maybe I'll wait til then. I can hobble along with Visio/snag it for the time being. Robohelp does seem to offer the most robust feature set I've found in my research. Thanks for the reply. Thanks, Mark -Original Message- From: Joshua Cyr [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 8:34 AM To: CF-Talk Subject: RE: Online Help I use RoboHelp, as buggy as it is. They have a new version due at somepoint since they put out a request for beta testers. Wish I knew more, but that is all I have. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Monday, November 06, 2006 5:49 PM To: CF-Talk Subject: Online Help What are folks using/recommeding for online help documentation for web apps? Robohelp? Others? I'd like some ability to integrate with CF (conditional logic) and maybe some flash generation, but not mandatory. Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Query when using UUID
I'm using a cross select control on a form page, so I can select many twgCaseNumbers (varchar) at a time. This code works correctly in other logic when I employ simple integers for the FORM.caseID. However, in this scenario, I'm using UUID's as the FORM.caseID's. It breaks when more than one UUID is in the FORM.caseID list. Is there any way to solve it using UUID's as the values? cfquery name=qSelectedCases datasource=#REQUEST.dsnSQL# SELECT P.caseID, P.twgCaseNumber FROM MyClient_Clients_Projects_List P WHERE P.caseID IN ('#FORM.caseID#') ORDER BY P.twgCaseNumber ASC /cfquery cfset VARIABLES.caseNumberSelectedValues = ValueList(qSelectedCases.caseID) cfset VARIABLES.caseNumberSelectedTitles = ValueList(qSelectedCases.twgCaseNumber) Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259297 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query when using UUID
Steve, Thanks, that worked. Didn't know about the undocumented list attribute of cfqueryparam. Thanks, Mark -Original Message- From: Steve Bryant [mailto:[EMAIL PROTECTED] Sent: Monday, November 06, 2006 10:59 AM To: CF-Talk Subject: Re: Query when using UUID This should be the easiest way: cfquery name=qSelectedCases datasource=#REQUEST.dsnSQL# SELECT P.caseID, P.twgCaseNumber FROM MyClient_Clients_Projects_List P WHERE P.caseID IN (cfqueryparam value=#FORM.caseID# cfsqltype=CF_SQL_VARCHAR list=Yes) ORDER BY P.twgCaseNumber ASC /cfquery HTH, Steve Bryant 918-449-9440 Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ I'm using a cross select control on a form page, so I can select many twgCaseNumbers (varchar) at a time. This code works correctly in other logic when I employ simple integers for the FORM.caseID. However, in this scenario, I'm using UUID's as the FORM.caseID's. It breaks when more than one UUID is in the FORM.caseID list. Is there any way to solve it using UUID's as the values? cfquery name=qSelectedCases datasource=#REQUEST.dsnSQL# SELECT P.caseID, P.twgCaseNumber FROM MyClient_Clients_Projects_List P WHERE P.caseID IN ('#FORM.caseID#') ORDER BY P.twgCaseNumber ASC /cfquery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Online Help
What are folks using/recommeding for online help documentation for web apps? Robohelp? Others? I'd like some ability to integrate with CF (conditional logic) and maybe some flash generation, but not mandatory. Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Log analyser for CF
So where's the download link? Is it publically available? Thanks, Mark -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, October 13, 2006 10:17 AM To: CF-Talk Subject: Re: Log analyser for CF Check out flogr from scott stroz: Here is the category URL for Flogr at Scott's blog. Ignore the top entry which seems to be misplaced: http://www.boyzoid.com/blog/index.cfm/Flogr On 10/13/06, Claude Schneegans [EMAIL PROTECTED] wrote: Hi, Is anyone aware of some tool that would analyze the CF log files like schedule.log and mailsent.log, and maintain a database easier to work with, so that an application could query for messages actually sent, failures, errors and reasons for? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Log analyser for CF
So how do I get to svn:... From a web browser to download? FF throws an error. Thanks, Mark -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, October 13, 2006 11:08 AM To: CF-Talk Subject: Re: Log analyser for CF I'd imagine it is here: The SVN repo, svn://www.boyzoid.com/logreader/logReader, has been updated On 10/13/06, Mark Leder [EMAIL PROTECTED] wrote: So where's the download link? Is it publically available? Thanks, Mark -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, October 13, 2006 10:17 AM To: CF-Talk Subject: Re: Log analyser for CF Check out flogr from scott stroz: Here is the category URL for Flogr at Scott's blog. Ignore the top entry which seems to be misplaced: http://www.boyzoid.com/blog/index.cfm/Flogr On 10/13/06, Claude Schneegans [EMAIL PROTECTED] wrote: Hi, Is anyone aware of some tool that would analyze the CF log files like schedule.log and mailsent.log, and maintain a database easier to work with, so that an application could query for messages actually sent, failures, errors and reasons for? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Path problem
I looking to use a flash app to display images which are read from an XML file (slideshowpro) in a password protected admin area of the site. The app requires that the path to each image be pointed as an absolute URL (for example: http://www.somesite.com/images/image1.jpg http://www.somesite.com/images/image1.jpg ). However, the project requires (for security reasons) that the images reside in a non-accessible directory on the server (for example: c:\clientfiles\someSiteFiles\image1.jpg). I have Win 2003, and have tried an IIS virtual directory mapping to this non-accessible directory to /somesiteFiles without luck. Is there a way to make this work, or are there other flash image display apps that would allow this? Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256509 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Money no Object - Best Online Editor for dealing with cut'n paste from Word
I'll second Ben's vote for xStandard. Thanks, Mark -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 11:18 AM To: CF-Talk Subject: RE: Money no Object - Best Online Editor for dealing with cut'n paste from Word I am a huge fan of xstandard. There is a Free version and a Pro version. The Pro version has most excellent word pasting abilities. The website is: www.xstandard.com. CAUTION: It does require the installation of a browser plugin. FireFox allows you to do this automatically, IE requires a download and install. We use this with many of our admins and no one cares about the installation. The power of the editor is well worth it. I use it for my own personal site and it rock. Feel free to check out my blog posts about it: http://www.bennadel.com/blog/tags/15-XStandard-WYSIWYG-blog-entries.htm Cheers, Ben ... Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 11:13 AM To: CF-Talk Subject: Money no Object - Best Online Editor for dealing with cut'n paste from Word Admin section of a site needs better cut'n paste from Word. Currently the site is using fckEditor - but the client is still not happy with the way it handles Word stuff. Neither am I, but Word is the problem, not fckEditor. Still, they aren't happy and don't care about how much money they spend to get happy. Currently I'm looking at Ektron eWebEditPro+XML Any other great ideas? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256520 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Money no Object - Best Online Editor for dealing with cut'n paste from Word
Up til a few years ago, it was WordPerfect and nothing but WordPerfect until hell freezes over. Thanks, Mark -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 11:35 AM To: CF-Talk Subject: Re: Money no Object - Best Online Editor for dealing with cut'n paste from Word Andy Matthews wrote: I assume that an intermediate step is out? Ie, copying from word, pasting into Notepad, copying from Notepad into FCK? That's been my directive to them all along, but they're LAWYERS, and they're gonna use WORD and nothing but the WORD until hell freezes over. So, gotta keep the client happy! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256521 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Path problem
Ben, that's a good idea, and I think I can make that work. Thanks, Mark -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 10:35 AM To: CF-Talk Subject: RE: Path problem You could have flash call a CFM page to Load the image and the CFM page could use a CFContent tag to stream a file from another location. This will make it not-secure, but Remember Flash is client-side so it can only access things via URLs (as far as I know)... Unless you get into more Flex stuff and data services probably. ... Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 10:26 AM To: CF-Talk Subject: Path problem I looking to use a flash app to display images which are read from an XML file (slideshowpro) in a password protected admin area of the site. The app requires that the path to each image be pointed as an absolute URL (for example: http://www.somesite.com/images/image1.jpg http://www.somesite.com/images/image1.jpg ). However, the project requires (for security reasons) that the images reside in a non-accessible directory on the server (for example: c:\clientfiles\someSiteFiles\image1.jpg). I have Win 2003, and have tried an IIS virtual directory mapping to this non-accessible directory to /somesiteFiles without luck. Is there a way to make this work, or are there other flash image display apps that would allow this? Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256522 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Path problem
Indeed browsing directly did work. So I must be missing something inside the flash widget. Thanks for your insight, Dave. Thanks, Mark Flash, like your browser, has no ability to access files on your web server unless those files have valid URLs. What happens if you try to resolve those URLs in your browser? Creating a virtual directory should work, if you do it correctly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore and Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256547 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Date Add
How do I take a current date/time #now()# and add a number of days to it, such as 14 days into the future, then convert to #CreateODBCDateTime()# so I can stick in a db? Can't find anything on cflib, and I'm confused by the syntax of dateAdd()... Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255593 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Date Add
That worked. Thanks for the quick help. Thanks, Mark -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 10:08 PM To: CF-Talk Subject: Re: Date Add cfset myDate = DateAdd('d',14,Now()) / Then in your query: #CreateODBCDateTime(myDate)# Can also be combined to one statement: #CreateODBCDateTime(DateAdd('d',14,Now()))# On 10/4/06, Mark Leder [EMAIL PROTECTED] wrote: How do I take a current date/time #now()# and add a number of days to it, such as 14 days into the future, then convert to #CreateODBCDateTime()# so I can stick in a db? Can't find anything on cflib, and I'm confused by the syntax of dateAdd()... Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255595 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Project Management Tool
Ditto for proworkflow - awesome. Thanks, Mark -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 10:27 AM To: CF-Talk Subject: RE: CF Project Management Tool proworkflow -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 10:05 AM To: CF-Talk Subject: CF Project Management Tool All, Can anyone recommend a CF Web based project management tool for a corporate office environment? Free or for sale. Thanks. D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254762 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: easiest/fastest to implement payment processor?
My vote also for authorize.net - integration was easy. Thanks, Mark -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Friday, September 22, 2006 9:58 PM To: CF-Talk Subject: Re: easiest/fastest to implement payment processor? So the only person who can attest that is Will Tomlinison? He fixes cars for a living... So like I said... it's pretty simple. .and Mary Jo! And probably Jared. And my last day was today. So everyone can look forward to me posting more regularly everyday! Aren't you excited?? :) Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Viaklix
Deanna, Give this a whirl - I haven't used viaklix in about 4 years with another client, worked then, params might be slightly different now. Let me know, as I'm getting ready to do on for a different client: cfsetting enablecfoutputonly=yes !--- Convert the four digit year to the last two digts-merge the month and year expiration to one four digit number --- CFLOCK SCOPE=SESSION TYPE=READONLY TIMEOUT=10 !--- Convert the year to two digits --- CFSET VARIABLES.expYY = Right(SESSION.ecom.CreditCardExpirationYear, 2) !--- Send the form variables to the Authorizing Agent --- CFHTTP URL=https://www.viaklix.com/process.asp; method=post CFHTTPPARAM type=FORMFIELD name=ssl_show_form value=FALSE CFHTTPPARAM type=FORMFIELD name=ssl_result_format value=ASCII CFHTTPPARAM type=FORMFIELD name=ssl_merchant_ID value=[providedID] CFHTTPPARAM type=FORMFIELD name=ssl_pin value=[providedpin] CFHTTPPARAM type=FORMFIELD name=ssl_transaction_type value=SALE CFHTTPPARAM type=FORMFIELD name=ssl_amount value=#VARIABLES.productprice# CFHTTPPARAM type=FORMFIELD name=ssl_description value=#VARIABLES.productName# CFHTTPPARAM type=FORMFIELD name=ssl_card_number value=#SESSION.ecom.CreditCardNumber# CFHTTPPARAM type=FORMFIELD name=ssl_exp_date value=#SESSION.ecom.CreditCardExpirationMonth##VARIABLES.expYY# CFHTTPPARAM type=FORMFIELD name=ssl_company value=#SESSION.ecom.BillToCompanyName# CFHTTPPARAM type=FORMFIELD name=ssl_first_name value=#SESSION.ecom.FirstName# CFHTTPPARAM type=FORMFIELD name=ssl_last_name value=#SESSION.ecom.LastName# CFHTTPPARAM type=FORMFIELD name=ssl_avs_address value=#SESSION.ecom.BillToAddress1# CFHTTPPARAM type=FORMFIELD name=ssl_city value=#SESSION.ecom.BillToCity# CFHTTPPARAM type=FORMFIELD name=ssl_state value=#SESSION.ecom.BillToStateProvince# CFHTTPPARAM type=FORMFIELD name=ssl_avs_zip value=#SESSION.ecom.BillToZipPostalCode# CFHTTPPARAM type=FORMFIELD name=ssl_country value=#SESSION.ecom.BillToCountry# CFHTTPPARAM type=FORMFIELD name=ssl_email value=#SESSION.ecom.EmailAddress# CFHTTPPARAM type=FORMFIELD name=ssl_phone value=#SESSION.ecom.DayPhoneCountryCode# #SESSION.ecom.DayPhoneAreaCode# #SESSION.ecom.DayPhoneNumber# /CFHTTP /CFLOCK !--- Retrieve the transaction results from the Credit Card Processor --- CFSET VARIABLES.ccpVars = #CFHTTP.FILECONTENT# !--- Convert the string to a comma-delimited format, replacing spaces with commas --- CFSET VARIABLES.ccpVars = REREPLACE(VARIABLES.ccpVars, [[:space:]], ,, ALL) !--- Assign a New variable to each of the comma delimited items in the list --- CFSET VARIABLES.ssl_result = ListFirst(VARIABLES.ccpVars) CFSET VARIABLES.ssl_result_message = ListGetAt(VARIABLES.ccpVars, 2) CFSET VARIABLES.ssl_txn_id = ListGetAt(VARIABLES.ccpVars, 3) CFSET VARIABLES.ssl_approval_code = ListGetAt(VARIABLES.ccpVars, 4) !--- Change the variable character length to keep only those characters to the right of the = sign --- CFSET URL.approved = RemoveChars(VARIABLES.ssl_result, 1, 11) CFSET VARIABLES.resultsMessage = RemoveChars(VARIABLES.ssl_result_message, 1, 19) CFSET VARIABLES.ccpTransactionID = RemoveChars(VARIABLES.ssl_txn_id, 1, 11) CFSET VARIABLES.ccpApprovalCode = RemoveChars(VARIABLES.ssl_approval_code, 1, 18) !--- Test Output of Variables --- !--- CFOUTPUT #URL.approved#br #VARIABLES.resultsMessage#br / #VARIABLES.ccpTransactionID#br / --- Thanks, Mark -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 1:59 PM To: CF-Talk Subject: Re: Viaklix From what I understand, it's just form posting. Not too complicated and really unrelated for the most part to the technology used. -d On 9/18/06, Jesse Kuhn [EMAIL PROTECTED] wrote: I am looking to use viaklix as well. Has anyone done this successfully yet... their developers guide only supports asp development. I am putting
RE: cfform flash stopped working...
Same problem as in CFChart that I'm whining about. I'll send this thread to adobe. I have an open incident with them. Thanks, Mark -Original Message- From: Kris Jones [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 11:57 PM To: CF-Talk Subject: Re: cfform flash stopped working... Yes. This is probably the dreaded Microsoft fix that requires active content to be clicked on prior to loading. They say that the 7.0.2 update takes care of it, but it didn't fix it for cfreport in flashpaper for us. (It works great in Firefox). Hi, I have a cfform of format flash that we've been using for over a year and a half now without any problems. We have not modified it whatsoever. All of a sudden now it's not working. All that occurs is a blank screen in the area where the flash form used to appear. I thought maybe it had something to do with the new version of flash out, so I upgraded my flash to version 9 and closed my browsers and restarted and I still get the same thing. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Updater 2 problems...
this has always been the case Show me documentation... Thanks, Mark -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 11:01 AM To: CF-Talk Subject: RE: CF Updater 2 problems... O trust me, I know. =] I always assumed that IIS had global mappings like Apache, but I guess I was wrong... now I'm trying to hack together something with mod_rewrite which is looking less than promising... !k -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 6:46 PM To: CF-Talk Subject: RE: CF Updater 2 problems... There are several things in CFMX that require the CFIDE virtual directory and the JRUNSCRIPTS virtual directory on every site, and this has always been the case. Our control panel creates these by default for every site. CFCHART Flash Remoting CFFORM - Snake -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: 01 September 2006 19:33 To: CF-Talk Subject: RE: CF Updater 2 problems... Kevin, I'm having the same problem here with CFChart and have opened a tech support issue with Adobe this past Monday. The only STOPGAP fix Adobe has provided has been to set a CFIDE virtual directory FOR EVERY SITE in IIS 6, pointing to your CFIDE directory (previously I had the CFIDE only in the default web site of IIS6). As you can imagine, this is not a long term acceptable solution. I also received an email from another CF'er with the same problem. This is definitely a bug in CFMX 7.0.2 updater. I'm now talking to Server System support at Adobe - the incident has been escalated. Thanks, Mark -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 1:48 PM To: CF-Talk Subject: CF Updater 2 problems... Hey all, Just so you know, I never patch a machine or software the day the update is released. Mainly because there could be un-foreseen issues, but also so that any kinks that are still around get taken care of as well (revisions). That being said, I waited until now to patch our CF servers to 7.0.2 thinking that I had done enough homework. I double checked the knowledge base as well as the known issues and didn't find any reference that could affect us. Little did I know that after installing this update, it would kill CFChart? I originally was using my own EOLAS fix that was functioning properly and figured that the 2 combined were blowing up. Once I removed my version, the problem still persisted. I jumped on the newsgroups and found some references to other people having the same issue. I've double checked the update by hand and everything went as it should. The JS file is where it should be. The CFIDE mapping is correct in the admin. which begs the question, why is this happening and how do I fix it? Has anyone had this issue with their upgrade? Any idea's? Sincerely, !k ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Updater 2 problems...
So why will cfchart work without the per site cfide mapping when viewed in FF, but not in IE, and, why did this break going from 7.01 to 7.02? Thanks, Mark -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 05, 2006 9:00 PM To: CF-Talk Subject: RE: CF Updater 2 problems... this has always been the case Show me documentation ... I don't know from documentation, but Snake is right - you've always needed a /CFIDE URL mapping for certain features of the product to work, starting with CFFORM's JavaScript back in the CF 2-3 timeframe (I forget which). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Updater 2 problems...
Kevin, I'm having the same problem here with CFChart and have opened a tech support issue with Adobe this past Monday. The only STOPGAP fix Adobe has provided has been to set a CFIDE virtual directory FOR EVERY SITE in IIS 6, pointing to your CFIDE directory (previously I had the CFIDE only in the default web site of IIS6). As you can imagine, this is not a long term acceptable solution. I also received an email from another CF'er with the same problem. This is definitely a bug in CFMX 7.0.2 updater. I'm now talking to Server System support at Adobe - the incident has been escalated. Thanks, Mark -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Friday, September 01, 2006 1:48 PM To: CF-Talk Subject: CF Updater 2 problems... Hey all, Just so you know, I never patch a machine or software the day the update is released. Mainly because there could be un-foreseen issues, but also so that any kinks that are still around get taken care of as well (revisions). That being said, I waited until now to patch our CF servers to 7.0.2 thinking that I had done enough homework. I double checked the knowledge base as well as the known issues and didn't find any reference that could affect us. Little did I know that after installing this update, it would kill CFChart? I originally was using my own EOLAS fix that was functioning properly and figured that the 2 combined were blowing up. Once I removed my version, the problem still persisted. I jumped on the newsgroups and found some references to other people having the same issue. I've double checked the update by hand and everything went as it should. The JS file is where it should be. The CFIDE mapping is correct in the admin. which begs the question, why is this happening and how do I fix it? Has anyone had this issue with their upgrade? Any idea's? Sincerely, !k ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251799 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFChart Breaks in IE6
It's actually a bug in the updater - confirmed by Adobe Engineering. The updater changed the path of CFIDE inside IIS. They were able to recreate the problem. I'll provide more details shortly. Thanks, Mark -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, August 28, 2006 8:37 PM To: CF-Talk Subject: Re: CFChart Breaks in IE6 Correct, GraphData.cfm is a servlet filter and shouldn't exist as a file. If the graph shows in FF but not in IE then it's not that. Can you put up an example so we can see? On 8/29/06, Mark Leder [EMAIL PROTECTED] wrote: FYI - there is no GraphData.cfm within the CFIDE directory in CFMX7.02, at least not on mine. Thanks, Mark -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFChart Breaks in IE6
Hi All, Using MX 7.02 with IIS6. Been using a cfchart routine to display simple data for some time now. Has always worked with no errors (JS or otherwise) in FF. Breaks in IE6 with a JS error message thrown stating an object expected. I was originally thinking that it was a Flash version problem (9 vs 8) but breaks in both. I'm wondering if it has something to do with an IE patch, as the chart worked before with no error message (and I haven't made any changes to the code). If its related to Eolas, is there a way to wrap the Adobe Active content fix tag around it? Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251236 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFChart Breaks in IE6
Hi All, Using MX 7.02 with IIS6. Been using a cfchart routine to display simple data for some time now. Has always worked with no errors (JS or otherwise) in FF. Breaks in IE6 with a JS error message thrown stating an object expected. I was originally thinking that it was a Flash version problem (9 vs 8) but breaks in both. I'm wondering if it has something to do with an IE patch, as the chart worked before with no error message (and I haven't made any changes to the code). If its related to Eolas, is there a way to wrap the Adobe Active content fix tag around it? Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFChart Breaks in IE6
I've always had a mapping to /cfide in CFAdmin (for all sites), pointing to c:\cfusionmx7\wwwroot\cfide. So why would it work in the past and not now? Doing some more research uncovered a bug in 7.02 updater, but on review, that didn't solve the problem for me. Thanks, Mark -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, August 28, 2006 9:51 AM To: CF-Talk Subject: Re: CFChart Breaks in IE6 The problem is that CF already does wrap JS code around it, but you don't have the /cfide directory mapped for your site. You can make the mapping or copy the relevant scripts from the /cfide/scripts/ folder. Look at the source of the page and you'll see what I mean. On 8/28/06, Mark Leder [EMAIL PROTECTED] wrote: Hi All, Using MX 7.02 with IIS6. Been using a cfchart routine to display simple data for some time now. Has always worked with no errors (JS or otherwise) in FF. Breaks in IE6 with a JS error message thrown stating an object expected. I was originally thinking that it was a Flash version problem (9 vs 8) but breaks in both. I'm wondering if it has something to do with an IE patch, as the chart worked before with no error message (and I haven't made any changes to the code). If its related to Eolas, is there a way to wrap the Adobe Active content fix tag around it? -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251260 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFChart Breaks in IE6
Here's the cfchart Flash widget generated inside FF 1.56. I've changed nothing in months, why is it now broken in IE? OBJECT classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354 codebase=http://active.macromedia.com/flash2/cabs/swflash.cab#version=4,0,2 ,0 ID=Images_513764312016_SWF name=Images_513764312016_SWF WIDTH=400 HEIGHT=300 PARAM NAME=movie VALUE=/CFIDE/GraphData.cfm?graphCache=wc50graphID=Images/513764312016. SWF/ PARAM NAME=quality VALUE=high/ PARAM NAME=bgcolor VALUE=#FF/ EMBED src=/CFIDE/GraphData.cfm?graphCache=wc50graphID=Images/513764312016.SW F quality=high bgcolor=#FF WIDTH=400 HEIGHT=300 TYPE=application/x-shockwave-flash PLUGINSPAGE=http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_ Version=ShockwaveFlash /EMBED /OBJECT Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFChart Breaks in IE6
FYI - there is no GraphData.cfm within the CFIDE directory in CFMX7.02, at least not on mine. Thanks, Mark -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Monday, August 28, 2006 2:05 PM To: CF-Talk Subject: RE: CFChart Breaks in IE6 Here's the cfchart Flash widget generated inside FF 1.56. I've changed nothing in months, why is it now broken in IE? OBJECT classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354 codebase=http://active.macromedia.com/flash2/cabs/swflash.cab#version=4,0,2 ,0 ID=Images_513764312016_SWF name=Images_513764312016_SWF WIDTH=400 HEIGHT=300 PARAM NAME=movie VALUE=/CFIDE/GraphData.cfm?graphCache=wc50graphID=Images/513764312016. SWF/ PARAM NAME=quality VALUE=high/ PARAM NAME=bgcolor VALUE=#FF/ EMBED src=/CFIDE/GraphData.cfm?graphCache=wc50graphID=Images/513764312016.SW F quality=high bgcolor=#FF WIDTH=400 HEIGHT=300 TYPE=application/x-shockwave-flash PLUGINSPAGE=http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_ Version=ShockwaveFlash /EMBED /OBJECT Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Project Management Software
Take a look at proworkflow. www.proworkflow.com Thanks, Mark -Original Message- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: Thursday, August 17, 2006 8:25 AM To: CF-Talk Subject: Project Management Software Does anyone currently use a windows based software program that tracks the life a project and can also handle daily time sheets for employees so an administrator can track what each employee does all day. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250141 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
vcf (Vcard) Generation
Any ideas/tutorials/etc. on how to generate vcards using content from a db? Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: vcf (Vcard) Generation
Thank your for your help! Thanks, Mark -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Friday, August 11, 2006 9:29 AM To: CF-Talk Subject: Re: vcf (Vcard) Generation http://steeev.f2o.org/vcard/ On 8/11/06, Mark Leder [EMAIL PROTECTED] wrote: Any ideas/tutorials/etc. on how to generate vcards using content from a db? Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249578 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Proper Case
Try using CapFirst() from cflib.org, works great, though you will still have to write a regex for things like McMillan. Thanks, Mark -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Monday, August 07, 2006 5:14 PM To: CF-Talk Subject: Proper Case Just wondering if there is an Easier way of doing these things. By default I submit all text fields to the DB: dbvalue = '#lcase(form.field)#' then with CSS Style my outputs as span style=text-transform:capitalize#dbvalue#/span for fields Like Name or Address... Is this the best way to be handling this? Or is their some way to pass the form field Value pre converted to Proper before it is inserted? I've burned by data entry ppl that suck before. -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 IF-THEN-ELSE its a way of life! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Compare cfdirectory name
I'm trying to compare a URL passed value to the results of a cfdirectory, then direct the user depending on whether or not the file exists in the cfdirectory list. As a simple example: url.DIRECTURL= GR newsletter vol 14 issue 5 June 06.doc dList.NAME = GR newsletter vol 14 issue 5 June 06.doc (from the cfdirectory list) cfif URL.directURL EQ dList.nameYescfelseNo/cfif I cannnot get this to work, even though the name and the URL are exactly the same. I've tried urlencode and decode in various ways without success. Even if the file and the URL are named without spaces or using underscores between words, it still doesn't work. Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244671 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Compare cfdirectory name
I figured this out using a loop. Thanks, Mark -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Friday, June 23, 2006 2:17 PM To: CF-Talk Subject: Compare cfdirectory name I'm trying to compare a URL passed value to the results of a cfdirectory, then direct the user depending on whether or not the file exists in the cfdirectory list. As a simple example: url.DIRECTURL= GR newsletter vol 14 issue 5 June 06.doc dList.NAME = GR newsletter vol 14 issue 5 June 06.doc (from the cfdirectory list) cfif URL.directURL EQ dList.nameYescfelseNo/cfif I cannnot get this to work, even though the name and the URL are exactly the same. I've tried urlencode and decode in various ways without success. Even if the file and the URL are named without spaces or using underscores between words, it still doesn't work. Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244688 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recommendations: WYSIWYG/RTF applet that handles automatic image uploading...
Dan, You might want to talk to xStandard directly about the word formatting issue. I've found them to be very accomodating. So far, it's the best of the bunch I've seen. Thanks, Mark -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 20, 2006 9:16 AM To: CF-Talk Subject: Recommendations: WYSIWYG/RTF applet that handles automatic image uploading... Guys/Gals, I've been research WYSIWYG/RTF controls to use in our product. I'm specifically looking for control that will automatically upload images. This means you must be able to cut-n-paste from a Word document that includes images and the images should automatically be uploaded to the server (whether that happens via Ajaxian-like process or as a multipart/form doesn't matter.) So far, I've found the following products: XStandard (http://www.xstandard.com/) * PRO: Produces the best looking XHTML * PRO: Very simple interface * CON: Can lose formatting from Word Documents * CON: Not cross-browser compatible. Ektron eWebEditPro (http://www.ektron.com/ewebeditpro.aspx) * PRO: Nice interface * PRO: Lots of features * CON: Expensive * CON: I'd really like the +XML edition, but it's like $17k Sferyx HTMLEditor Applet Edition (http://www.sferyx.com/htmleditorapplet/) * PRO: Pretty feature rich * PRO: Decent pricing * CON: Klunky implementation (the API is very strange to work with) * CON: The automatic uploading of images isn't working w/IIS6 at the moment--working with them to fix the problem. If this doesn't work, it's out of the running. RealObjects edit-on Pro (http://www.realobjects.com/edit-on_Pro_4.435.0.html) * Haven't gotten my trial license yet. Ephox EditLive! (http://www.ephox.com/products/editliveforjava/) * PRO: Very nice overall * CON: Expensive licensing. The biggest problem I have with many of these products is licensing. Several of these products, for our use anyway, would require a per Server CPU license (which doesn't make any sense to me) and they get very pricy in a multi-web server environment where you have multiple CPUs. Our user base in general isn't very computer savvy, so we really need a product that will allow them to cut-n-paste from Word and have formatting and images left intact. This means products like fckEditor, TinyMCE, etc won't work. These implementations are built upon the RTE components built-in to the browsers. They require you to manually upload the images you want to use, before you can correctly insert them into the document. If you have any comments on any of the above products or have some other recommendations, I'd love to hear them. Thanks! -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recommendations: WYSIWYG/RTF applet that handles automatic image uploading...
Here may be an answer: http://www.xstandard.com/page.asp?p=A6F1F641-E4F4-456B-8CF2-5825291010C3 Thanks, Mark -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 20, 2006 4:57 PM To: CF-Talk Subject: RE: Recommendations: WYSIWYG/RTF applet that handles automatic image uploading... Rick, I am not sure if Xstandard does that. I just suggest that he look into it. I am not sure if ANYTHING will be able to do that. Word embeds images into its own code. Everything on the web has to point to an image at a source URL. I am not sure that making that transition is possible. Xstandard is pretty powerful though, and their support may have a good solution. Ben Nadel www.bennadel.com -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 20, 2006 4:54 PM To: CF-Talk Subject: Re: Recommendations: WYSIWYG/RTF applet that handles automatic image uploading... Dan G. Switzer, II wrote: Have you tried FCKEditor's Paste from Word functionality? It does a pretty good job of cleaning up the crappy HTML that word produces. As my original e-mail stated, products like FCKEditor, TinyMCE, KHTML, etc don't fit my requirement. Ah, sorry about that, I saw the discussin about XStandard and didn't realize that it did that, I thought xStandar was just another HTML editor... Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244299 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF Times Out - Going Crazy!
I am ready to scream about this. Some weeks a cfquery works great, other times, it craps out with this statement: The request has exceeded the allowable time limit Tag. What could be some causes? I've fought with this for several months off and on - no one's made changes to the code. It's a simple plain text email sendout with 3,000 subscribers. Email address are repeatedly verified before putting into the queue. Time out is set at 20 minutes. Normally the process only takes about 45-60 seconds. Worked great last week, died this week. 2GB ram on the dedicated box. Plenty of horsepower. Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244306 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Times Out - Going Crazy!
With or without disk spooling? So how would I check that? I'm using win2003, iis6. The outbound mail is going into a spool. I've experienced this problem with both the CFMail tag and Coolfusion's CFX_iMSMail Tag. I also just tried again to send out the mail. Worked fine this time (took about 37 seconds to push the mail out to the spool). Can you see how responsive your DNS is? Is there a special method to do this? Thanks, Mark -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 20, 2006 5:34 PM To: CF-Talk Subject: Re: CF Times Out - Going Crazy! Mark Leder wrote: I am ready to scream about this. Some weeks a cfquery works great, other times, it craps out with this statement: The request has exceeded the allowable time limit Tag. What could be some causes? I've fought with this for several months off and on - no one's made changes to the code. It's a simple plain text email sendout with 3,000 subscribers. Email address are repeatedly verified before putting into the queue. Time out is set at 20 minutes. Normally the process only takes about 45-60 seconds. Worked great last week, died this week. 2GB ram on the dedicated box. Plenty of horsepower. With or without disk spooling? Can you see how responsive your DNS is? Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244317 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Times Out - Going Crazy!
For the spooling, the setting in the CFAdministrator, I think, is what is being spoke of (Disk or Memory). I'll give that a try. Could it be the content of the emails by any chance? I reran the exact email message again that that client had used, and the second time it went out, no problem. What I don't understand is why the network would cause a problem during a CFMail or CFX_iMSMail tag call. The creating and queue up of the messages would all be done on the server. That's why I can't figure out this intermittent timeout issue. However, come to think of it, wonder if there's a hangup between CF7 and MS-SQL where the records are being pulled. On the CFAdmin db page, I changed the login timeout from 30 sec to 60 sec. In the general settings, I upped the timeout requests from 60 sec to 120 sec. Yes, wrapping a try/catch block around a couple of processes would be a good idea. Thanks, Mark -Original Message- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 20, 2006 10:15 PM To: CF-Talk Subject: Re: CF Times Out - Going Crazy! On 6/20/06, Mark Leder [EMAIL PROTECTED] wrote: Can you see how responsive your DNS is? Is there a special method to do this? traceroute? Not sure, but I think that's it. On linux at least. Maybe. Watch that first hop, I'd figure, but maybe all of it is important. Maybe a ping, one with an IP, another with DNS? For the spooling, the setting in the CFAdministrator, I think, is what is being spoke of (Disk or Memory). Could it be the content of the emails by any chance? Network related is a good guess tho. Any ways of wrapping it with a cftry and capturing some more data? What was being sent out, how long a ping (using DNS) took, etc.? /me whistles a little ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244344 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Deleting a FILE structure
How would I delete an entire FILE structure (which is generated from a CFFile Tag)? Maybe modify the example below somehow (the phrase fullPath is irrelevant)? cfscript if (IsDefined(SESSION.fullPath)) { StructDelete(SESSION fullPath); } /cfscript Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242585 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Deleting a FILE structure
No - what I'm looking for is, immediately after a file upload is completed, using Cffile, that the resultant structure generated by cffile be deleted, not the file itself. I have to do this because of addditional processing further down the page. Thanks, Mark -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 12:07 PM To: CF-Talk Subject: RE: Deleting a FILE structure Have you tried using CFDirectory with action = delete and recurse = true? I have not tried it, but in theory should work. Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com Some people call me the space cowboy. Some people call me the gangster of love. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 10:52 AM To: CF-Talk Subject: Deleting a FILE structure How would I delete an entire FILE structure (which is generated from a CFFile Tag)? Maybe modify the example below somehow (the phrase fullPath is irrelevant)? cfscript if (IsDefined(SESSION.fullPath)) { StructDelete(SESSION fullPath); } /cfscript Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242610 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Deleting a FILE structure
Sure. cffile action=upload filefield=/locationA/ ... Do something with the 1st set of variables presented. #file.serverfile# ... On the same page, upload a second file. cffile action=upload filefield=/locationB/ ... Do something with the second set of variables presented. #file.serverfile# I want to make sure that the 1st set of vars do not get mixed in with the 2nd set. So, I wanted to make sure, by clearing out the 1st set. Thanks, Mark -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 1:22 PM To: CF-Talk Subject: Re: Deleting a FILE structure Can you explain why though? Why does your code break if CFFILE already exists? You shouldn't be making your own variables with that name since, obviously, CF uses it. You could try this: cfset structDelete, variables, CFFILE) but again, I think you have something else wrong, or something to be concerned about. On 6/6/06, Mark Leder [EMAIL PROTECTED] wrote: No - what I'm looking for is, immediately after a file upload is completed, using Cffile, that the resultant structure generated by cffile be deleted, not the file itself. I have to do this because of addditional processing further down the page. Thanks, Mark -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 12:07 PM To: CF-Talk Subject: RE: Deleting a FILE structure Have you tried using CFDirectory with action = delete and recurse = true? I have not tried it, but in theory should work. Ben Nadel Web Developer Nylon Technology 350 7th Avenue Floor 10 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com Some people call me the space cowboy. Some people call me the gangster of love. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 10:52 AM To: CF-Talk Subject: Deleting a FILE structure How would I delete an entire FILE structure (which is generated from a CFFile Tag)? Maybe modify the example below somehow (the phrase fullPath is irrelevant)? cfscript if (IsDefined(SESSION.fullPath)) { StructDelete(SESSION fullPath); } /cfscript Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Deleting a FILE structure
OK, thanks. Thanks, Mark -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 1:54 PM To: CF-Talk Subject: Re: Deleting a FILE structure Ah, then I'd use the result attribute (as I think someone else mentioned in this thread). On 6/6/06, Mark Leder [EMAIL PROTECTED] wrote: Sure. cffile action=upload filefield=/locationA/ ... Do something with the 1st set of variables presented. #file.serverfile# ... On the same page, upload a second file. cffile action=upload filefield=/locationB/ ... Do something with the second set of variables presented. #file.serverfile# I want to make sure that the 1st set of vars do not get mixed in with the 2nd set. So, I wanted to make sure, by clearing out the 1st set. Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242622 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Passing Java Applet vars back to CF
Hi all, Using CFMX7 on Win2003. I have a java applet embedded in a CF page (page1.cfm) (using object/embed tags) which performs a file upload. Upon successful upload (no errors thrown), I redirect to a second CF page (page2.cfm) to perform additional routines on the FORM vars which should be passed. However, no vars are being passed (the cfdump shows nothing). I suspect that the session is being dropped, so that the java applet doesn't know where to return the form vars to. In the java applet I can set the form action = page2.cfm?sesID=#SESSION.sessionID#. However, on page2.cfm, how do I retrieve the correct sessionID, so I can get at the form vars? Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Passing Java Applet vars back to CF
The java applet logic passes back form params. The form method is already set to post. The form params are vanishing after the file is uploaded to CF's temp directory. What I want to know is how does one make java applet form vars get passed back to the correct session (using the URL.sessionID that is passed in the string). Thanks, Mark -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 17, 2006 11:36 AM To: CF-Talk Subject: RE: Passing Java Applet vars back to CF Mark, Using CFMX7 on Win2003. I have a java applet embedded in a CF page (page1.cfm) (using object/embed tags) which performs a file upload. Upon successful upload (no errors thrown), I redirect to a second CF page (page2.cfm) to perform additional routines on the FORM vars which should be passed. However, no vars are being passed (the cfdump shows nothing). I suspect that the session is being dropped, so that the java applet doesn't know where to return the form vars to. In the java applet I can set the form action = page2.cfm?sesID=#SESSION.sessionID#. However, on page2.cfm, how do I retrieve the correct sessionID, so I can get at the form vars? The sesID variable would be in the URL scope--not the FORM scope. Also, makes sure that you've specified method=POST on you form / tag. If not, it'll default to a GET operation, which means the variables will be in the URL scope, not the FORM scope. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240785 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Passing Java Applet vars back to CF
Thank you Denny, I will continue to experiment. Thanks, Mark -Original Message- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 17, 2006 7:59 PM To: CF-Talk Subject: Re: Passing Java Applet vars back to CF Here is some crappy code that lets you pass a CF session around, sorta, by using the cftoken, cfid, and application name. cfset tracker = createObject(java, coldfusion.runtime.SessionTracker ) cfset sessions = tracker.getSessionCollection(appName) cftry cfset thisSesh = sessions[#appName#_#acfid#_#acftoken#] cfset thisGrid = thisSesh[livegrid_#livegridname#] cfloop list=#structKeyList(thisGrid)# index=sv cfset arguments[sv] = thisGrid[sv] /cfloop The above example is a snippet from my livegrid experiment. Thus the grabbing of the passed session's [livegrid_##] var. I ran into this problem because I'm a bad coder, as in I couldn't figure out how to have a cfc that isn't part of any particular application have access to the calling page's application and session vars. Some of the stuff spans requests, so I couldn't just slap them in the request scope. Eh. If it's any clearer, I'd still like to know what best practice would be for this scenario, but I fear that it's going to be write better code. =-] As for the actual question, you don't need a session to pass form vars around. Or you shouldn't, AFAIC. I assume you could always include the cfid and cftoken in the URL, and that should preserve the session, depending on the setup, but that might be what you mean by url.sessionID, I'm not sure. Sorry no real solution to your problem, but I'm still a little fuzzy as to what the scenario is, funny as that sounds. This little snippit has power though. Thanks Snake! :-) :deN On 5/17/06, Mark Leder [EMAIL PROTECTED] wrote: The java applet logic passes back form params. The form method is already set to post. The form params are vanishing after the file is uploaded to CF's temp directory. What I want to know is how does one make java applet form vars get passed back to the correct session (using the URL.sessionID that is passed in the string). Thanks, Mark -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 17, 2006 11:36 AM To: CF-Talk Subject: RE: Passing Java Applet vars back to CF Mark, Using CFMX7 on Win2003. I have a java applet embedded in a CF page (page1.cfm) (using object/embed tags) which performs a file upload. Upon successful upload (no errors thrown), I redirect to a second CF page (page2.cfm) to perform additional routines on the FORM vars which should be passed. However, no vars are being passed (the cfdump shows nothing). I suspect that the session is being dropped, so that the java applet doesn't know where to return the form vars to. In the java applet I can set the form action = page2.cfm?sesID=#SESSION.sessionID#. However, on page2.cfm, how do I retrieve the correct sessionID, so I can get at the form vars? The sesID variable would be in the URL scope--not the FORM scope. Also, makes sure that you've specified method=POST on you form / tag. If not, it'll default to a GET operation, which means the variables will be in the URL scope, not the FORM scope. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240868 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Uploading multiple files - not necessarily CF
www.aurigma.com Awesome Java tag - some of the best documentation I've seen anywhere. Thanks, Mark -Original Message- From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 3:05 PM To: CF-Talk Subject: RE: Uploading multiple files - not necessarily CF Alas, I spoke too soon. No, that's not going to work for me. The upload multiple files is simply 20 HTML file fields. No good. I might be able to use it for something else, but not for this project. -Original Message- From: Everett, Al (NIH/NIGMS) [C] Sent: Tuesday, April 25, 2006 3:00 PM To: CF-Talk Subject: RE: Uploading multiple files - not necessarily CF Looks promising, but may be more than I need/want. I certainly don't want the end users able to delete files or directories on the server. But I've just glanced at it. Thanks for the tip. -Original Message- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 2:37 PM To: CF-Talk Subject: Re: Uploading multiple files - not necessarily CF Checkout the CFFM (CF file Manager) by Rick root I think. Russ -Original Message- From: Rob Wilkerson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Date: Tue, 25 Apr 2006 14:19:22 -0400 Subject: Re: Uploading multiple files - not necessarily CF What about using DHTML? Take a look at something like this: http://the-stickman.com/web-development/javascript/upload-multiple-fil e s-with-a-single-file-element/ I've played with it a little bit and it looks pretty nice. I have not used it in production, though, so it will require some testing. On 4/25/06, Everett, Al (NIH/NIGMS) [C] [EMAIL PROTECTED] wrote: I'm looking for a solution to this problem: For an intranet site, the end user should be able to select multiple files (or even a directory) located on his/her local machine, and press a single button to upload them to the server. We're a CF shop and I don't see a CF solution for this piece, but it needs to work with CF. Perhaps a Java applet? Maybe Flash? We'll certainly be using CF for the back-end processing of the files, but what is not desired is having the multiple html file form fields. This is for an intranet application with VERY tightly controlled browser and OS environments. Downloading a separate application is pretty much a non-starter; it needs to work in the browser window. Any pointers you can offer would be appreciated. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238718 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Uploading multiple files - not necessarily CF
The java app I mentioned will fit directly into your html, and will accept images, docs, etc, fully configurable. Also has CF examples. Thanks, Mark -Original Message- From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 4:09 PM To: CF-Talk Subject: RE: Uploading multiple files - not necessarily CF I've been told that whatever solution we go with has to work in the current application flow. In other words, we need to be able to seamlessly slot the solution into our current web application. Sending the users to a separate application is a non-starter. I need something that, ideally, can fit into an existing HTML form. I'm not optimistic. -Original Message- From: Everett, Al (NIH/NIGMS) [C] Sent: Tuesday, April 25, 2006 2:06 PM To: CF-Talk Subject: Uploading multiple files - not necessarily CF I'm looking for a solution to this problem: For an intranet site, the end user should be able to select multiple files (or even a directory) located on his/her local machine, and press a single button to upload them to the server. We're a CF shop and I don't see a CF solution for this piece, but it needs to work with CF. Perhaps a Java applet? Maybe Flash? We'll certainly be using CF for the back-end processing of the files, but what is not desired is having the multiple html file form fields. This is for an intranet application with VERY tightly controlled browser and OS environments. Downloading a separate application is pretty much a non-starter; it needs to work in the browser window. Any pointers you can offer would be appreciated. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238729 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFDirectory
Hi all, Trying to get a file listing from a directory, but only capturing the files that are older than 7 days previous to today (using the cfdirectory datelastmodified var). I'm able to retrieve the listing of all files, but I can't seem to get only the ones older than 7 days - throws an error. Can the filter var in cfdirectory be used, so I can eliminate the second query? Or should the second query be structured differently? cfdirectory action=list directory=c:\smarterstatsdomainlogs\somewebsite\W3SVC515241625\ name=statsLevel3 recurse=no listInfo=yes cfoutput query=statsLevel3 #NAME# - #datelastmodified#br / /cfoutput cfset VARIABLES.dateRange = CreateODBCDateTime(Now() - 7) cfset VARIABLES.dateRange = DateFormat(VARIABLES.dateRange, 'mm/dd/') !--- cfset VARIABLES.dateRange = DateFormat(VARIABLES.dateRange, 'mm/dd/') br / cfoutput#VARIABLES.dateRange#/cfoutput --- br / cfquery dbtype=query name=getSource SELECT * FROM statsLevel3 WHERE #statsLevel3.datelastmodified# = #VARIABLES.dateRange# /cfquery Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238144 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFDirectory
Just that simple! Thanks, that worked. Thanks, Mark -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 1:14 PM To: CF-Talk Subject: RE: CFDirectory Don't use the ## in the Where clause: cfquery dbtype=query name=getSource SELECT * FROM statsLevel3 WHERE dateLastModified = cfqueryparam value=#VARIABLES.dateRange# cfsqltype=CF_SQL_TIMESTAMP / /cfquery Ben Nadel www.bennadel.com -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 1:09 PM To: CF-Talk Subject: CFDirectory Hi all, Trying to get a file listing from a directory, but only capturing the files that are older than 7 days previous to today (using the cfdirectory datelastmodified var). I'm able to retrieve the listing of all files, but I can't seem to get only the ones older than 7 days - throws an error. Can the filter var in cfdirectory be used, so I can eliminate the second query? Or should the second query be structured differently? cfdirectory action=list directory=c:\smarterstatsdomainlogs\somewebsite\W3SVC515241625\ name=statsLevel3 recurse=no listInfo=yes cfoutput query=statsLevel3 #NAME# - #datelastmodified#br / /cfoutput cfset VARIABLES.dateRange = CreateODBCDateTime(Now() - 7) cfset VARIABLES.dateRange = DateFormat(VARIABLES.dateRange, 'mm/dd/') !--- cfset VARIABLES.dateRange = DateFormat(VARIABLES.dateRange, 'mm/dd/') br / cfoutput#VARIABLES.dateRange#/cfoutput --- br / cfquery dbtype=query name=getSource SELECT * FROM statsLevel3 WHERE #statsLevel3.datelastmodified# = #VARIABLES.dateRange# /cfquery Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238157 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ListServ Software
Any recommendations for listserv software? Doesn't have to be CF, but preferred. My only real criteria is that it can connect to a SQL db so that I can restrict subscribers to those listed in the db (this is for a paid membership only listserv). Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237344 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Anyone have experience getting jUpload to work in CF?
Can't seem to get the files to load to the server. Using the commercial version at jupload.biz Contact me off-list. Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236393 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Updating JRE on MX701
Can't find any good docs on how to do this at Adobe. I checked out Forta's blog, but it didn't make much sense. I'm not running JRUN, just a standalone standard edition. Links? Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235857 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dynamic Form Selects and Posting Troubles
Well we're warm: The qPermissionsCount has the moduleID's, in this case 133, 141, 151. The permissionID should be numeric from 1-5 for each ARGUMENT that is passed in, which would be A133, A141, A151. So, thisID needs to refer to each ARGUMENTS.A(x) in turn. cfloop index=i from=1 to=#qPermissionCount.recordcount# cfset thisId = A#i# cfquery name=updOBJ2 datasource=#REQUEST.dsnSQL# username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD# UPDATE #SESSION.companyInfo.companyTablePrefix#_Users_List_UserModulesPermissions SET permissionID = cfqueryparam cfsqltype=cf_sql_integer value=#thisId# WHERE userID = cfqueryparam cfsqltype=cf_sql_char value=#ARGUMENTS.userID# AND moduleID = cfqueryparam cfsqltype=cf_sql_integer value=#qPermissionCount.moduleID# /cfquery /cfloop Thanks, Mark -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, March 16, 2006 10:28 AM To: CF-Talk Subject: RE: Dynamic Form Selects and Posting Troubles Here's something that works in my environment: cfloop index=i from=1 to=3 cfset thisId = A#i# cfquery name=PayPeriods datasource=Budgets select id from payrollfactors where id = cfqueryparam cfsqltype=cf_sql_integer value=#thisId# /cfquery /cfloop I believe you could also just put the A#i# into your value of the cfqueryparam (instead of cfsetting it separately). Of course, you'll have to change this to use the value from your DB instead of the index counter in my example. Your loop will be a loop over the items in your first query. [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235537 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54