cfcache problem
The first line of code in my cfm page is cfcache timespan=1 This works most of the time, but occasionally I get an error. Failed to add HTML header. What am I missing here? Thanks in advance. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cfcalendar - 410 error
bump -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 2:27 PM To: CF-Talk Subject: Cfcalendar - 410 error Hey there all... I am using the cfcalendar command and am having some trouble with using it on the godaddy hosting services. The error I get says: JRun Servlet Error410 Unknown Unknown I have uploaded the cfide folder at the root with a different name. I have the cfcalendar code generated into a cfsavecontent tag and am changing all /cfide/ calls to the new location on the local root. Then outputing the code to the page. Now I have 2 avenues I would like to pursue. 1. If this can be 'fixed', please let me know what the workaround is. 2. If this can't be 'fixed' easily, I am looking for a CF7 compatible calendar display that allows me to set-up 'links' for the dates and change the color of the dates, based on the events on that date. Any help would be appreciated. William -- William Seiter [EMAIL PROTECTED] Web Developer Database Developer FileMaker7 amp; FileMaker8 Certified Discover How a Bankrupt School Teacher From Toronto Accidentally Stumbled Up on an Amazing Secret That Will Instantly Supercharge Your Business, Your Wea lth, and Your Life! http://www.WealthCreatorSource.com/r.php/1050 or a href=http://www.WealthCreatorSource.com/r.php/1050;Click Here/a ~| 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:289069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple .NET Class
quote... ~| 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:289070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Numberformat and cfgrid
Hi Steve, I also have a post about cell renderers you can see it here http://www.garyrgilbert.com/blog/index.cfm/2007/8/24/CFGRID-Cell-Renderer-Revisited -- Gary Gilbert http://www.garyrgilbert.com/blog ~| 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:289071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Forums?
NUGROHO NOTO wrote: Yes, but development has stopped years ago when we were unable to get clarification from Macromedia on the exact terms of the license and the possibility of relicensing under an OSI approved Open Source license. Thanks Jochem. Hmm... does it mean... we can / or cannot use this forum script for free ? I don't know. Only Adobe can clarify the licensing terms of the original source code. Jochem ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Facebook apps wont run on CF8
Anthony Webb wrote: Hi all, been banging my head against the wall getting a simple hello world app running on CF8. Apparently there is some issues with the form field validator in CF8? At any rate more details are here: http://www.facebook.com/topic.php?uid=2205007948topic=9278post=69186#post69186 All I get is a login screen. At any rate it does seem as though this is a new problem introduced in CF8 because the app runs fine when hosted from CF7. Does it work if you downgrade to an older Java version? Jochem ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8: Why would I be getting an access error with this query?
Not to discount a sandboxing issue, I've had the same error before and it was down to incorrect user permissions on the database. The problem came about on a dedicated box, though we used Plesk to manage everything. After creating the database (MySQL) via Plesk and apparently assigning the user to the database with the necessary permissions, we created our datasource in the CFAdmin (worked fine), but it was when we ran some code we got the problem. To fix it I had to do a GRANT ALL ... on the database to fix it. Andy On 20/09/2007, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for the affirmation, Jayesh! Rick -Original Message- From: Jayesh Viradiya [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 2:55 PM To: CF-Talk Subject: RE: CF8: Why would I be getting an access error with this query? Hi Rick, This definitely seems to be a SandBox security restriction for the Datasource access. Make sure that you have enough access for the required resources. Thanks Jayesh Viradiya Adobe CF Team -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 4:08 AM To: CF-Talk Subject: RE: CF8: Why would I be getting an access error with this query? Yes, that's my thinking, too, Andy. But for some reason, when I try to use the Manage Users function in Navicat on the MySQL 5 server at CrystalTech, I get the error, 1044-Access denied for user ''@'%' to database 'mysql'. And the xxx's in my line above are my correct username... Like I mentioned to Williams, the reference to a database 'mysql' must be to the server software, because I don't have a database named 'mysql'. Thanks, Rick -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 6:37 AM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with this query? Looks like your user hasn't been specifically granted the appropriate rights to your database. Andy On 20/09/2007, Rick Faircloth [EMAIL PROTECTED] wrote: This is on a remote shared server, so I only have access through an access panel. I can log into everything there without problem. However, when I try to use Manage Users in Navicat to check my permissions, I get this error: 1044 - Access denied for user ''@'%' to database 'mysql'. I'm not sure why it reference database 'mysql'... unless it's referencing the mysql server. That's not the name of the database I'm accessing. Ideas? Rick -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 19, 2007 11:39 PM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with this query? I'm getting an access denied error because of line 36 (middle line) in this query: cfquery name=get_user datasource=#dsn# password=#password# username=#username# select * from users where user_email = '#trim(form.user_email)#' and user_password = '#trim(form.user_password)#' /cfquery For CF 8, does anyone see anything wrong with the syntax? I would first try running the query manually by logging in from the server using the username and password set in the variables. ~| 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:289074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Facebook apps wont run on CF8
Aye, you have to be a member of the facebook ColdFusion Group to see it ;) The most simple solution to this would be to turn off CF server side form validation if that is possible. Is it? The problem is not in the java code as such, just the way in which coldfusion is calling the code. I really hope there is a way of turning it off as it is one of the most blinkered things I have seen in ColdFusion, highlighted by the problem that Facebook developers are experiencing. Dom On 21/09/2007, James Holmes [EMAIL PROTECTED] wrote: I logged in and still couldn't get the forum. On 9/21/07, Jochem van Dieten [EMAIL PROTECTED] wrote: Anthony Webb wrote: Hi all, been banging my head against the wall getting a simple hello world app running on CF8. Apparently there is some issues with the form field validator in CF8? At any rate more details are here: http://www.facebook.com/topic.php?uid=2205007948topic=9278post=69186#post69186 All I get is a login screen. At any rate it does seem as though this is a new problem introduced in CF8 because the app runs fine when hosted from CF7. Does it work if you downgrade to an older Java version? Jochem ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8: Why would I be getting an access error with this query?
Thanks for the feedback, Andy... Rick -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 6:41 AM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with this query? Not to discount a sandboxing issue, I've had the same error before and it was down to incorrect user permissions on the database. The problem came about on a dedicated box, though we used Plesk to manage everything. After creating the database (MySQL) via Plesk and apparently assigning the user to the database with the necessary permissions, we created our datasource in the CFAdmin (worked fine), but it was when we ran some code we got the problem. To fix it I had to do a GRANT ALL ... on the database to fix it. Andy On 20/09/2007, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for the affirmation, Jayesh! Rick -Original Message- From: Jayesh Viradiya [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 2:55 PM To: CF-Talk Subject: RE: CF8: Why would I be getting an access error with this query? Hi Rick, This definitely seems to be a SandBox security restriction for the Datasource access. Make sure that you have enough access for the required resources. Thanks Jayesh Viradiya Adobe CF Team -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 4:08 AM To: CF-Talk Subject: RE: CF8: Why would I be getting an access error with this query? Yes, that's my thinking, too, Andy. But for some reason, when I try to use the Manage Users function in Navicat on the MySQL 5 server at CrystalTech, I get the error, 1044-Access denied for user ''@'%' to database 'mysql'. And the xxx's in my line above are my correct username... Like I mentioned to Williams, the reference to a database 'mysql' must be to the server software, because I don't have a database named 'mysql'. Thanks, Rick -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 6:37 AM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with this query? Looks like your user hasn't been specifically granted the appropriate rights to your database. Andy On 20/09/2007, Rick Faircloth [EMAIL PROTECTED] wrote: This is on a remote shared server, so I only have access through an access panel. I can log into everything there without problem. However, when I try to use Manage Users in Navicat to check my permissions, I get this error: 1044 - Access denied for user ''@'%' to database 'mysql'. I'm not sure why it reference database 'mysql'... unless it's referencing the mysql server. That's not the name of the database I'm accessing. Ideas? Rick -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 19, 2007 11:39 PM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with this query? I'm getting an access denied error because of line 36 (middle line) in this query: cfquery name=get_user datasource=#dsn# password=#password# username=#username# select * from users where user_email = '#trim(form.user_email)#' and user_password = '#trim(form.user_password)#' /cfquery For CF 8, does anyone see anything wrong with the syntax? I would first try running the query manually by logging in from the server using the username and password set in the variables. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Facebook apps wont run on CF8
I logged in and still couldn't get the forum. On 9/21/07, Jochem van Dieten [EMAIL PROTECTED] wrote: Anthony Webb wrote: Hi all, been banging my head against the wall getting a simple hello world app running on CF8. Apparently there is some issues with the form field validator in CF8? At any rate more details are here: http://www.facebook.com/topic.php?uid=2205007948topic=9278post=69186#post69186 All I get is a login screen. At any rate it does seem as though this is a new problem introduced in CF8 because the app runs fine when hosted from CF7. Does it work if you downgrade to an older Java version? Jochem ~| 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:289075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Simple .NET Class
Having same problem on multiple computers. We must be missing something really obvious I think. It seems not many people have tried this. Regards Dale Fraser http://learncf.com -Original Message- From: Davide Campo [mailto:[EMAIL PROTECTED] Sent: Friday, 21 September 2007 1:45 AM To: CF-Talk Subject: Re: Simple .NET Class Then: - i haven't .NET stuff installed (what is it?) - i have only .net 2.0 installed - i tried to stop cf .net service, delete paste dll, restart cf .net service, execute the sample again --- guess what? NOTHING, same error only one word: help! tnk u all ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Darn syntax
I bet if we put our heads together we could come up with an even more complicated solution that makes us look really smrt. -Original Message- From: Wil Genovese [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 4:29 PM To: CF-Talk Subject: Re: Darn syntax you need a variable for each portion of the createtimespan function. cachedwithin=#CreateTimeSpan(cache_time_day,cache_time_hour,cache_time_minu te,cache_time_sec)# -- Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. Robert Harrison wrote: Let's try this again. the list seems to be funky. I've got the table driven system with all these profile reads. The profiles don't change often so I want to cache unless I'm testing. If I'm live I want my cache time at several days. So I set: cfset cache_time=2, 0, 0, 0 OR cfset cache_time=0, 0, 0, 0 Now on my profile query statement, instead of saying cachedwithin=#CreateTimeSpan(2, 0, 0, 0)# I want to say cachedwithin=#CreateTimeSpan(#cache_time#)# But it don't like that. I've tried various combos using and not using EVALUATE, etc. but it just doesn't want to obey me. Anyone see the correct syntax. I'm sure this is nothing more than a syntax problem but I'm not seeing it right now. Thanks, Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple .NET Class
Dale Are you able to connect to standard Windows dlls? eg, can you run this snippet: cfobject type=.NET name=test class=System.Environment cfdump var=#test# cfdump var=#test.Get_Version().ToString()# !--- 2.0.50727.1318 on WinXp Sp2 for me; 2.0.50727.312 on vista for me --- also, what account are your CF services running under? permissions okay? On 9/21/07, Dale Fraser [EMAIL PROTECTED] wrote: Having same problem on multiple computers. We must be missing something really obvious I think. It seems not many people have tried this. Regards Dale Fraser http://learncf.com -Original Message- From: Davide Campo [mailto:[EMAIL PROTECTED] Sent: Friday, 21 September 2007 1:45 AM To: CF-Talk Subject: Re: Simple .NET Class Then: - i haven't .NET stuff installed (what is it?) - i have only .net 2.0 installed - i tried to stop cf .net service, delete paste dll, restart cf .net service, execute the sample again --- guess what? NOTHING, same error only one word: help! tnk u all ~| 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:289080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Dynamic Select Text Box
Hi, I am having a quandry of a moment. I have a dynamic select box, which populates with an address (or addresses). Below that, I have text boxes for fields such as city, state, and zip. I need to see if I can get some assistance on the population of those text boxes if the address changes in the select. The coding is listed below, and any and all assistance is welcome. Code: cfselect name=SShip class=style1 style=background-color:CC cfloop query=GetSomeMore option value=#Address1##Address1# /cfloop /cfselect br cfinput type=text name=SAddress2 class=style1 style=background-color:CC br cfif #Address3# Contains cfinput type=text name=SAddress3 class=style1 style=background-color:CC value=#Address3# br /cfif cfinput type=text name=SCity class=style1 style=background-color:CC value=#City# nbsp;nbsp; cfinput type=text name=SState class=style1 style=background-color:CC value=#State# size=1 maxlength=2 nbsp;nbsp; cfinput type=text name=SPostal_Code class=style1 style=background-color:CC value=#Postal_Code# size=3 ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic Select Text Box
What Version of CF are you running? Chris John Eubanks wrote: Hi, I am having a quandry of a moment. I have a dynamic select box, which populates with an address (or addresses). Below that, I have text boxes for fields such as city, state, and zip. I need to see if I can get some assistance on the population of those text boxes if the address changes in the select. The coding is listed below, and any and all assistance is welcome. Code: cfselect name=SShip class=style1 style=background-color:CC cfloop query=GetSomeMore option value=#Address1##Address1# /cfloop /cfselect br cfinput type=text name=SAddress2 class=style1 style=background-color:CC br cfif #Address3# Contains cfinput type=text name=SAddress3 class=style1 style=background-color:CC value=#Address3# br /cfif cfinput type=text name=SCity class=style1 style=background-color:CC value=#City# nbsp;nbsp; cfinput type=text name=SState class=style1 style=background-color:CC value=#State# size=1 maxlength=2 nbsp;nbsp; cfinput type=text name=SPostal_Code class=style1 style=background-color:CC value=#Postal_Code# size=3 ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic Select amp; Text Box
Hi, I am having a quandry of a moment. I have a dynamic select box, which populates with an address (or addresses). Below that, I have text boxes for fields such as city, state, and zip. I need to see if I can get some assistance on the population of those text boxes if the address changes in the select. The coding is listed below, and any and all assistance is welcome. Code: cfselect name=SShip class=style1 style=background-color:CC cfloop query=GetSomeMore option value=#Address1##Address1# /cfloop /cfselect br cfinput type=text name=SAddress2 class=style1 style=background-color:CC br cfif #Address3# Contains cfinput type=text name=SAddress3 class=style1 style=background-color:CC value=#Address3# br /cfif cfinput type=text name=SCity class=style1 style=background-color:CC value=#City# nbsp;nbsp; cfinput type=text name=SState class=style1 style=background-color:CC value=#State# size=1 maxlength=2 nbsp;nbsp; cfinput type=text name=SPostal_Code class=style1 style=background-color:CC value=#Postal_Code# size=3 Chris, I am running CF 7 Enterprise ~| 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:289083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Windows Event Log
I don't know of a way to get it to have the application natively write to the windows event log. But you could write a simple VBS file that reads in the log files from CF and then posts the information into the windows event log using the LogEvent method in WSH. http://www.microsoft.com/technet/scriptcenter/guide/sas_log_akqy.mspx?mfr=true On 9/20/07, Joseph Swenson [EMAIL PROTECTED] wrote: We are working on a unified logging server which traps syslogs and reads windows event viewer via DCOM. The problem we are facing is that we want to have our Coldfusion applications inside of our log. The nitty gritty is this: How do we get Coldfusion to post events and logs to the Windows Event Log (new or same) instead of (or in additional to) its own internal logging. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Simple .NET Class
This works for me, but damn! It takes almost 30 seconds for the first request to complete. After that, it's pretty speedy. 2.0.50727.42 on Win Server 2003. M!ke -Original Message- From: Antony Sideropoulos [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 8:04 AM To: CF-Talk Subject: Re: Simple .NET Class Dale Are you able to connect to standard Windows dlls? eg, can you run this snippet: cfobject type=.NET name=test class=System.Environment cfdump var=#test# cfdump var=#test.Get_Version().ToString()# !--- 2.0.50727.1318 on WinXp Sp2 for me; 2.0.50727.312 on vista for me --- also, what account are your CF services running under? permissions okay? ~| 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:289085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recursion problem
This little factorial function will show you that limit in a hurry IMO, with a factorial function, you will hit a numeric overflow far before any limit in recursion level. I have some recursive functions, got them loop to infinity while debugging, and like in most languages, the only limit I got with CF was memory. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recursion problem
The recordset is not returning the heirarchy correctly however. Please define not correctly -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:289087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamic Select amp; Text Box
Give this a shot if your using an HTML form.
Chris Martin
SCRIPT LANGUAGE=JavaScript
!--
var url
function changepage(formObject)
{
url = formObject.options[formObject.options.selectedIndex].value;
if(url != empty)
{
window.location = url;
url = ;
}
}
//--
/SCRIPT
select onChange=changepage(this)
cfloop query=GetSomeMore
option value=#cgi.SCRIPT_NAME#?Address1=#Address1##Address1#
/select
cfif isDefined(url.Address1)
br
cfinput type=text name=SAddress2 class=style1
style=background-color:CC
br
cfif #Address3# Contains
cfinput type=text name=SAddress3 class=style1
style=background-color:CC value=#Address3#
br
/cfif
cfinput type=text name=SCity class=style1
style=background-color:CC value=#City#
nbsp;nbsp;
cfinput type=text name=SState class=style1
style=background-color:CC value=#State# size=1
maxlength=2
nbsp;nbsp;
cfinput type=text name=SPostal_Code class=style1
style=background-color:CC value=#Postal_Code# size=3
/cfif
John Eubanks wrote:
Hi, I am having a quandry of a moment. I have a dynamic select box,
which populates with an address (or addresses). Below that, I have
text boxes for fields such as city, state, and zip. I need to see if
I can get some assistance on the population of those text boxes if the
address changes in the select. The coding is listed below, and any
and all assistance is welcome.
Code:
cfselect name=SShip class=style1
style=background-color:CC
cfloop query=GetSomeMore
option value=#Address1##Address1#
/cfloop
/cfselect
br
cfinput type=text name=SAddress2 class=style1
style=background-color:CC
br
cfif #Address3# Contains
cfinput type=text name=SAddress3 class=style1
style=background-color:CC value=#Address3#
br
/cfif
cfinput type=text name=SCity class=style1
style=background-color:CC value=#City#
nbsp;nbsp;
cfinput type=text name=SState class=style1
style=background-color:CC value=#State# size=1
maxlength=2
nbsp;nbsp;
cfinput type=text name=SPostal_Code class=style1
style=background-color:CC value=#Postal_Code# size=3
Chris,
I am running CF 7 Enterprise
~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289088
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Text Editor Preferences?
On 9/20/07, Chris Martin [EMAIL PROTECTED] wrote: I've been using TextPad since 1998...haven't seen any reason to switch, but am curious to see what everyone else is using for a text editor out there. TextMate, but it costs about $1000 for you PC folks (you'll need a Mac). Lots of the PC folks salivating for TextMate for Windows (mostly Rails developers in corp environments) look at the e text editor. In the PC world, I'd think Notepad++ if a fine solution unless you've already bought TextPad. I liked TextPad's regex search/replace better and writing the macros. And if you're on Linux, I'll let you fight it out between vi and emacs :) -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:289089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Instantiating all objects within Application.cfm
They can't, and I'm 99% sure they never have been. The only code that can read an application variable is code that lives under a directory where the cfapplication tag with that application name. Many people store this info in an application-scoped Config CFC and pass that into whatever other CFCs need it. On 9/21/07, Andrew Grosset [EMAIL PROTECTED] wrote: I use the request scope for database name, username password for cfqueries since I believe application variables can be read by all on a shared server - not sure if this is still the case though. Andrew. I store settings such as the applications database name in the application scope since it is global to all requests and does not change for the app. ~| 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:289090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfcache problem
I'm not sure, but if I recall correctly CFCACHE still writes temp files to the file system and reads them back each time, which doesn't perform very well under load. Have a look at Ray's scopecache custom tag. I looked around for it and the only link I could find was in the SVN repo for Blog CFC. Ray, if you see this, any chance you'll set up a separate RIAForge project just for this? http://svn.riaforge.org/blogcfc/client/tags/scopecache.cfm On 9/21/07, Richard Steele [EMAIL PROTECTED] wrote: The first line of code in my cfm page is cfcache timespan=1 This works most of the time, but occasionally I get an error. Failed to add HTML header. What am I missing here? Thanks in advance. ~| 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:289091 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 problem
run it and find out. It is not a memory issue. -- Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. Claude Schneegans wrote: This little factorial function will show you that limit in a hurry IMO, with a factorial function, you will hit a numeric overflow far before any limit in recursion level. I have some recursive functions, got them loop to infinity while debugging, and like in most languages, the only limit I got with CF was memory. ~| 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:289092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Windows Event Log
Log4j has a NTEventLogAppender class. http://logging.apache.org/log4j/docs/api/org/apache/log4j/nt/NTEventLogA ppender.html I don't know if this is usable via coldfusion. The NTEventLogAppender class uses a DLL to call the Windows API, the dll is distributed with log4j. If coldfusion has the dll, you might be in luck. -- Andrew -Original Message- From: Joseph Swenson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 2:09 PM To: CF-Talk Subject: Windows Event Log We are working on a unified logging server which traps syslogs and reads windows event viewer via DCOM. The problem we are facing is that we want to have our Coldfusion applications inside of our log. The nitty gritty is this: How do we get Coldfusion to post events and logs to the Windows Event Log (new or same) instead of (or in additional to) its own internal logging. ~| 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:289093 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: webservice
Who died and made you forum master of questions asking? I think it was Matt Liotta. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion hosting question.
My server (coldfusion 5) is hosted at a hosting company in California. recently (from last week) every night time from 7pm to morning 5am (japan time), my server is very slow (ping statistic showing 729ms) What makes me confused... If I type tracert www.ilovesmart.com (tracert to my website)... why does the results... shows other's website and NOT mine ? is this normal ? ... or something wrong behind ? Sorry if I ask this in the wrong forum... I can't find the answer else. Thank you. ~| 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:289095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic Select amp; Text Box
What Version of CF are you running? Chris John Eubanks wrote: Chris, Tried what you sent, and didn't work. ~| 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:289096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Text Editor Preferences?
I still miss the Turbo Pascal editor. And I miss Brief (by UnderWare) every day. I don't use a plain text-editor very often, as homesite+ is still working well for those files, but I do still find occasion to use a hex editor. What does everyone use for that? On 9/21/07, John Paul Ashenfelter [EMAIL PROTECTED] wrote: On 9/20/07, Chris Martin [EMAIL PROTECTED] wrote: I've been using TextPad since 1998...haven't seen any reason to switch, but am curious to see what everyone else is using for a text editor out there. TextMate, but it costs about $1000 for you PC folks (you'll need a Mac). Lots of the PC folks salivating for TextMate for Windows (mostly Rails developers in corp environments) look at the e text editor. In the PC world, I'd think Notepad++ if a fine solution unless you've already bought TextPad. I liked TextPad's regex search/replace better and writing the macros. And if you're on Linux, I'll let you fight it out between vi and emacs :) ~| 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:289097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion hosting question.
Sounds like their using host headers, which would redirect to a directory based on the domain passed in the host header. This allows for multiple domains on the same IP -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: NUGROHO NOTO [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 12:28 PM To: CF-Talk Subject: Coldfusion hosting question. My server (coldfusion 5) is hosted at a hosting company in California. recently (from last week) every night time from 7pm to morning 5am (japan time), my server is very slow (ping statistic showing 729ms) What makes me confused... If I type tracert www.ilovesmart.com (tracert to my website)... why does the results... shows other's website and NOT mine ? is this normal ? ... or something wrong behind ? Sorry if I ask this in the wrong forum... I can't find the answer else. Thank you. ~| 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:289098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF-happy CAPTCHA recommendations?
I've been using CF_CAPTCHA for a while now, and it's old enough that the spambots have 'cracked the code', so to speak, and is nigh useless. Anyone out there have any recommendations on a good, CF-based (or non CF-based, but can be easily used from within CF) CAPTCHA solution that's a bit tougher to break? --Scott ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion hosting question.
Thanks. Are these USING HOST HEADERS are common practice as a hosting company ? My server is dedicated server...not shared hosting. Are these host headers caused the slowness ? If yes.. then...what should I complain to the hosting company ? Thanks again for explaining to me. Sounds like their using host headers, which would redirect to a directory based on the domain passed in the host header. This allows for multiple domains on the same IP ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Headline: Senate defeats bid to bring back troops
OK, so I know what the anti-war establishment is trying to do. They are betting the farm that if they continually present resolution after resolution regarding ending (surrendering) the war soon, then next year when the elections are in full swing; they can use that as their platform. Which leads me to ponder a couple of things: 1. Does this mean that this_is_all we are going to hear about next year? Hearing Sen. Clinton, Sen. Obama and the others say Look at my record last year! I voted against the war. I presented legislation to try and end (surrender) the war! Vote for me! 2. Since this is the only thing that they can talk about now, what is happening to all of the other issues that they should be talking about? I mean, this is a pretty dynamic country. There is other equally or more pressing issues going on I think. Just because there is an unpopular war being waged, does that mean we have to forget everything else that is happening in the country and focus only on that? Do they think we are that stupid that we should forget everything else? I don't know about you guys, but the last thing that I am going to look at when it is time to vote next year is how many times they wasted their time and ours with all the in-fighting about one issue. I am surely going to look at their voting records on other equally or more important issues (assuming that they are debating other issues). Oh, and I am NOT discounting the importance of the war in Iraq. I - as well as a few others on this list who have actually been there - know the importance of it. I just want to make sure that whoever is running the country starting Jan '09 is actually going to spend their time debating all the issues, not just one. As usual, I am interested in hearing what you have to say. I find this group of developers very interesting and everyone's points are well taken very interesting as well, whether I agree with them or not. Bruce ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Text Editor Preferences?
http://www.e-texteditor.com/ On 9/21/07, Jerry Johnson [EMAIL PROTECTED] wrote: I still miss the Turbo Pascal editor. And I miss Brief (by UnderWare) every day. I don't use a plain text-editor very often, as homesite+ is still working well for those files, but I do still find occasion to use a hex editor. What does everyone use for that? On 9/21/07, John Paul Ashenfelter [EMAIL PROTECTED] wrote: On 9/20/07, Chris Martin [EMAIL PROTECTED] wrote: I've been using TextPad since 1998...haven't seen any reason to switch, but am curious to see what everyone else is using for a text editor out there. TextMate, but it costs about $1000 for you PC folks (you'll need a Mac). Lots of the PC folks salivating for TextMate for Windows (mostly Rails developers in corp environments) look at the e text editor. In the PC world, I'd think Notepad++ if a fine solution unless you've already bought TextPad. I liked TextPad's regex search/replace better and writing the macros. And if you're on Linux, I'll let you fight it out between vi and emacs :) ~| 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:289102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Headline: Senate defeats bid to bring back troops
Bruce Sorge wrote: OK, so I know what the anti-war establishment is trying to do. They are you do? that's nice, perhaps you can tell us all what this has to do/w coldfusion? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Headline: Senate defeats bid to bring back troops
Crap! Did it again. Sorry for the OT post. (slinks away in shame.) Moving it to the more appropriate list. Bruce Paul Hastings wrote: you do? that's nice, perhaps you can tell us all what this has to do/w coldfusion? ~| 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:289106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Text Editor Preferences?
Sorry, I meant to reply to Chris's message. I was using PrimalScript for hex editing, but it is very pricey, unfortunately. -- v/r, Jeff Fleitz ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Headline: Senate defeats bid to bring back troops
Uwrong list?? I mean, this is a pretty dynamic country. There is other equally or more pressing issues going on I think. Just because there is an unpopular war being waged, does that mean we have to forget everything else that is happening in the country and focus only on that? Do they think we are that stupid that we should forget everything else? Yes they think the American public is that stupidand yes many do not realize what else is going on because all they rely on is American media which is of course full of nothing but Iraq...and certainly void of anything else truly important. No you don't have to forget about everything elsebut that's what they are banking on. I for one certainly hope that more Americans ask the questions you are Bruce...they are VERY important. It must be a shocker to see the Canadian dollar at par with the green back!! .h...I wonder why ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recursion problem
run it and find out. It is not a memory issue. Of course it is not. Recursing to a level of 1000 is not a problem. As I said, with a factorial function, you will hit an overflow before any limit of recursion or any memory limit. Can ou imagine how large is 1000! ? At a certain point, you hit an infinite value, and this brakes the returntype=numeric condition. This is what caused the error. The limit is the size of a numeric value that CF can handle, nothing to do with a limit with recursive functions. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:289107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Coldfusion hosting question.
There's a lot that goes into it, that someone who's a network admin may be able to explain better but You may have a dedicated virtual server which uses something like VMWare to create virtual boxes, isolated instances of the operating system, on the same machine. Each network card can support up to 5 ip's and the physical box can support up to 5 network cards (this is all according to Micro$oft, Linux may be different. There's a ceiling on how many virtual instances you can create based on the amount of memory in the box. As this ceiling gets close performance can degrade. Hope this helps -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: NUGROHO NOTO [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 12:51 PM To: CF-Talk Subject: Re: Coldfusion hosting question. Thanks. Are these USING HOST HEADERS are common practice as a hosting company ? My server is dedicated server...not shared hosting. Are these host headers caused the slowness ? If yes.. then...what should I complain to the hosting company ? Thanks again for explaining to me. Sounds like their using host headers, which would redirect to a directory based on the domain passed in the host header. This allows for multiple domains on the same IP ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: webservice
OT, but, btw, where has Matt been? Haven't heard for him in awhile... Rick -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 11:28 AM To: CF-Talk Subject: Re: webservice Who died and made you forum master of questions asking? I think it was Matt Liotta. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
table union
I am trying to create a report that will show me all the checks I have written on my system in numerical order, the problem is I have my checks stored in two different tables in the database. These two tables split up expense checks and client checks, both tables have quite different data, however they do share some common data (check_Num), Ammount, and a date drafted, the other data isn't the same data types because I use a customer ID(number) to pull the name of the client for the check and I just type the name of the recipient(text) for the expense checks. Right now I am able to get all the checks in order with the following query. --- cfquery name=rsGetPayments datasource=# dsn# SELECTCheck_Num, CheckAmount, expen_Date FROM tbl_Expenses WHERE expen_Date BETWEEN #CreateODBCDateTime(cFullStartDate)# AND #CreateODBCDateTime(cFullEndDate)# UNION SELECTCheck_Num, pur_Amount, pur_Date_Purchased FROM tbl_HCFA_Purchase_Transactions WHERE pur_Date_Purchased BETWEEN #CreateODBCDateTime(cFullStartDate)# AND #CreateODBCDateTime(cFullEndDate)# ORDER BY Check_Num /cfquery This gets me a unioned list sorted by check number in a date range supplied by a form. My question, is there a better way to union this data together because right now after I run this query I am going to have to run two separate queries in each table to get who the check was made out to and what the expense code was for the check. Right now this one query takes about 50 seconds to run and I imagine will only get longer with how many checks I write. Thanks in advance, Mallek ~| 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:289110 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: table union
Depending on your DBMS, I would suggest declaring a temp table or table variable (depending on how many records you are expecting). Do two separate inserts into the temp table. Then update any additional info you need into the table if applicable, (This allows you to have a smaller, better performing initial select). Then select out the final records from the temp table. If it takes you 50 seconds to run that select, you probably have some DB tuning to do. Are there indexes on the expen_Date and pur_Date_Purchased columns. ~Brad -Original Message- From: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 12:01 PM To: CF-Talk Subject: table union I am trying to create a report that will show me all the checks I have written on my system in numerical order, the problem is I have my checks stored in two different tables in the database. These two tables split up expense checks and client checks, both tables have quite different data, however they do share some common data (check_Num), Ammount, and a date drafted, the other data isn't the same data types because I use a customer ID(number) to pull the name of the client for the check and I just type the name of the recipient(text) for the expense checks. Right now I am able to get all the checks in order with the following query. --- cfquery name=rsGetPayments datasource=# dsn# SELECTCheck_Num, CheckAmount, expen_Date FROM tbl_Expenses WHERE expen_Date BETWEEN #CreateODBCDateTime(cFullStartDate)# AND #CreateODBCDateTime(cFullEndDate)# UNION SELECTCheck_Num, pur_Amount, pur_Date_Purchased FROM tbl_HCFA_Purchase_Transactions WHERE pur_Date_Purchased BETWEEN #CreateODBCDateTime(cFullStartDate)# AND #CreateODBCDateTime(cFullEndDate)# ORDER BY Check_Num /cfquery This gets me a unioned list sorted by check number in a date range supplied by a form. My question, is there a better way to union this data together because right now after I run this query I am going to have to run two separate queries in each table to get who the check was made out to and what the expense code was for the check. Right now this one query takes about 50 seconds to run and I imagine will only get longer with how many checks I write. Thanks in advance, Mallek ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289111 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-happy CAPTCHA recommendations?
Hey there Scott, Have your tried CFFormProtect? http://cfformprotect.riaforge.org/ Its not the traditional Captcha since it does not ask the user to type in the obscured string of characters prior to the form submission. It works by systematically observing the users' activities, that only humans would do like mouse movements, user latency, etc. It can even check spam-ish posts, in case it is an actual human that is maliciously using the form. Check it out, ...would be great to know your evaluation. Kudos goes to Jacob Munson. Michael -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 8:48 AM To: CF-Talk Subject: CF-happy CAPTCHA recommendations? I've been using CF_CAPTCHA for a while now, and it's old enough that the spambots have 'cracked the code', so to speak, and is nigh useless. Anyone out there have any recommendations on a good, CF-based (or non CF-based, but can be easily used from within CF) CAPTCHA solution that's a bit tougher to break? --Scott ~| 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:289112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
javascript and redirect
I am trying to show the alert saying that the session is expired and redirect
then to home page. I got this working except I do not see the alert
cfif not isDefined(session.appfee)
script type=text/javascript runat=server
alert ('your session has expired');
cflocation url=http://olympus.scs.jhu.edu/#session.url#/admissions/;
addtoken=no
/script
cfabort
/cfif
~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289113
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Catching CFHTTP errors when a PC is off.
Looking for the best way to catch errors when making a CFHTTP call and looking for a failsafe if the remote PC is off. Is there anything better than using a try/catch and then writing conditional logic based on if the cfcatch.message is defined and = The request has exceeded the allowable time limit Tag: cfhttp? Thanks, Che ~| 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:289115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: table union
I am using an access database, I could create a temp table inside the database run the select's run the inserts, then delete all info from the table, is that what you are suggesting? I did index the date fields and got the original union query down to 30 seconds. Travis Haley Haley Computer Solutions 2749 E. Nichols Cir Centennial, CO 80122 P: (303) 694-8050 F: (303) 779-0335 -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 11:10 AM To: CF-Talk Subject: RE: table union Depending on your DBMS, I would suggest declaring a temp table or table variable (depending on how many records you are expecting). Do two separate inserts into the temp table. Then update any additional info you need into the table if applicable, (This allows you to have a smaller, better performing initial select). Then select out the final records from the temp table. If it takes you 50 seconds to run that select, you probably have some DB tuning to do. Are there indexes on the expen_Date and pur_Date_Purchased columns. ~Brad -Original Message- From: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 12:01 PM To: CF-Talk Subject: table union I am trying to create a report that will show me all the checks I have written on my system in numerical order, the problem is I have my checks stored in two different tables in the database. These two tables split up expense checks and client checks, both tables have quite different data, however they do share some common data (check_Num), Ammount, and a date drafted, the other data isn't the same data types because I use a customer ID(number) to pull the name of the client for the check and I just type the name of the recipient(text) for the expense checks. Right now I am able to get all the checks in order with the following query. --- cfquery name=rsGetPayments datasource=# dsn# SELECTCheck_Num, CheckAmount, expen_Date FROM tbl_Expenses WHERE expen_Date BETWEEN #CreateODBCDateTime(cFullStartDate)# AND #CreateODBCDateTime(cFullEndDate)# UNION SELECTCheck_Num, pur_Amount, pur_Date_Purchased FROM tbl_HCFA_Purchase_Transactions WHERE pur_Date_Purchased BETWEEN #CreateODBCDateTime(cFullStartDate)# AND #CreateODBCDateTime(cFullEndDate)# ORDER BY Check_Num /cfquery This gets me a unioned list sorted by check number in a date range supplied by a form. My question, is there a better way to union this data together because right now after I run this query I am going to have to run two separate queries in each table to get who the check was made out to and what the expense code was for the check. Right now this one query takes about 50 seconds to run and I imagine will only get longer with how many checks I write. Thanks in advance, Mallek ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289114 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-happy CAPTCHA recommendations?
Michael E. Carluen wrote: Have your tried CFFormProtect? http://cfformprotect.riaforge.org/ Looks neat - I'll give it a looksee. Thanks Michael! ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
doubble post
Sorry about the double post I don't know how that happened Travis Haley Haley Computer Solutions 2749 E. Nichols Cir Centennial, CO 80122 P: (303) 694-8050 F: (303) 779-0335 ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: javascript and redirect
the cflocation will preclude any client side code (HTML or JS) from displaying.
use a JavaScript redirect.
cfif NOT structKeyExists(session, 'appfee')
script type=text/javascript
alert('your session has expired');
cfoutputlocation.href=http://olympus.scs.jhu.edu/#session.URL#/admissions/;;/cfoutput
/script
cfabort /
/cfif
On 9/21/07, erik tsomik [EMAIL PROTECTED] wrote:
I am trying to show the alert saying that the session is expired and redirect
then to home page. I got this working except I do not see the alert
cfif not isDefined(session.appfee)
script type=text/javascript runat=server
alert ('your session has expired');
cflocation url=http://olympus.scs.jhu.edu/#session.url#/admissions/;
addtoken=no
/script
cfabort
/cfif
~|
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:289118
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: javascript and redirect
Try this:
cfif not isDefined(session.appfee)
cfoutput
script type=text/javascript runat=server
alert ('your session has expired');
window.location =
http://olympus.scs.jhu.edu/#Session.URL#/admissions/;;
/script
/cfoutput
cfabort
/cfif
erik tsomik wrote:
I am trying to show the alert saying that the session is expired and redirect
then to home page. I got this working except I do not see the alert
cfif not isDefined(session.appfee)
script type=text/javascript runat=server
alert ('your session has expired');
cflocation url=http://olympus.scs.jhu.edu/#session.url#/admissions/;
addtoken=no
/script
cfabort
/cfif
~|
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:289117
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: javascript and redirect
the cflocation will preclude any client side code (HTML or JS) from
displaying.
use a JavaScript redirect.
cfif NOT structKeyExists(session, 'appfee')
script type=text/javascript
alert('your session has expired');
cfoutputlocation.href=http://olympus.scs.jhu.edu/#session.
URL#/admissions/;/cfoutput
/script
cfabort /
/cfif
On 9/21/07, erik tsomik [EMAIL PROTECTED] wrote:
I am trying to show the alert saying that the session is expired and
redirect then to home page. I got this working except I do not see the
alert
cfif not isDefined(session.appfee)
script type=text/javascript runat=server
alert ('your session has expired');
cflocation url=http://olympus.scs.jhu.edu/#session.
url#/admissions/ addtoken=no
/script
cfabort
/cfif
The code eis working. Thanks a lot. I was just wondering is that possible to
display a message saying that session is expired and you will be redirecting in
5 sec
~|
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:289120
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: table union
I'm not sure about temp tables in access. If my temp table you really just mean creating a regular table which you will drop when you are done that would not allow for concurrent executions of your code since they would be using the same table. (temp tables in SQL Server are connection specific I believe) There are ways around that, like having a unique number per process, but you are kind of defeating part of you purpose at that time. How many records are you dealing with? ~Brad -Original Message- From: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 12:33 PM To: CF-Talk Subject: RE: table union I am using an access database, I could create a temp table inside the database run the select's run the inserts, then delete all info from the table, is that what you are suggesting? I did index the date fields and got the original union query down to 30 seconds. Travis Haley Haley Computer Solutions 2749 E. Nichols Cir Centennial, CO 80122 P: (303) 694-8050 F: (303) 779-0335 -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 11:10 AM To: CF-Talk Subject: RE: table union Depending on your DBMS, I would suggest declaring a temp table or table variable (depending on how many records you are expecting). Do two separate inserts into the temp table. Then update any additional info you need into the table if applicable, (This allows you to have a smaller, better performing initial select). Then select out the final records from the temp table. If it takes you 50 seconds to run that select, you probably have some DB tuning to do. Are there indexes on the expen_Date and pur_Date_Purchased columns. ~Brad -Original Message- From: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 12:01 PM To: CF-Talk Subject: table union I am trying to create a report that will show me all the checks I have written on my system in numerical order, the problem is I have my checks stored in two different tables in the database. These two tables split up expense checks and client checks, both tables have quite different data, however they do share some common data (check_Num), Ammount, and a date drafted, the other data isn't the same data types because I use a customer ID(number) to pull the name of the client for the check and I just type the name of the recipient(text) for the expense checks. Right now I am able to get all the checks in order with the following query. --- cfquery name=rsGetPayments datasource=# dsn# SELECTCheck_Num, CheckAmount, expen_Date FROM tbl_Expenses WHERE expen_Date BETWEEN #CreateODBCDateTime(cFullStartDate)# AND #CreateODBCDateTime(cFullEndDate)# UNION SELECTCheck_Num, pur_Amount, pur_Date_Purchased FROM tbl_HCFA_Purchase_Transactions WHERE pur_Date_Purchased BETWEEN #CreateODBCDateTime(cFullStartDate)# AND #CreateODBCDateTime(cFullEndDate)# ORDER BY Check_Num /cfquery This gets me a unioned list sorted by check number in a date range supplied by a form. My question, is there a better way to union this data together because right now after I run this query I am going to have to run two separate queries in each table to get who the check was made out to and what the expense code was for the check. Right now this one query takes about 50 seconds to run and I imagine will only get longer with how many checks I write. Thanks in advance, Mallek ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfcache problem
I'm not sure, but if I recall correctly CFCACHE still writes temp files to the file system and reads them back each time, which doesn't perform very well under load. Actually, reading the files from disk does perform quite well under load. It's creating the files in the first place which is the problem, since this is done by running CFHTTP to request the file. In effect, the first request takes twice as long as it otherwise would. Have a look at Ray's scopecache custom tag. I haven't used Ray's tag, but in a similar vein I'd strongly recommend Brandon Purcell's CF_ACCELERATE custom tag: http://www.bpurcell.org/blog/index.cfm?entry=963mode=entry Instead of writing to the filesystem, it stores entries in memory. 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! ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: javascript and redirect
How can I integrate this solution into session expired cfoutput meta http-equiv=refresh content=5;url=http://olympus.scs.jhu.edu/#session.URL#/admissions/; Your session has expired. You will be redirect in 5 seconds. a href=http://olympus.scs.jhu.edu/#session.URL#/admissions/;click here/a if you are not automatically redirected. /cfoutput ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion hosting question.
Are these USING HOST HEADERS are common practice as a hosting company ? It's common to use host headers with web servers in general, as it allows you to map multiple names to a single IP address. Are these host headers caused the slowness ? I don't see why they would. 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! ~| 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:289124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: javascript and redirect
cfoutput
meta http-equiv=refresh
content=5;url=http://olympus.scs.jhu.edu/#session.URL#/admissions/;
Your session has expired. You will be redirect in 5 seconds.
a href=http://olympus.scs.jhu.edu/#session.URL#/admissions/;click
here/a if you are not automatically redirected.
/cfoutput
On 9/21/07, erik tsomik [EMAIL PROTECTED] wrote:
the cflocation will preclude any client side code (HTML or JS) from
displaying.
use a JavaScript redirect.
cfif NOT structKeyExists(session, 'appfee')
script type=text/javascript
alert('your session has expired');
cfoutputlocation.href=http://olympus.scs.jhu.edu/#session.
URL#/admissions/;/cfoutput
/script
cfabort /
/cfif
On 9/21/07, erik tsomik [EMAIL PROTECTED] wrote:
I am trying to show the alert saying that the session is expired and
redirect then to home page. I got this working except I do not see the
alert
cfif not isDefined(session.appfee)
script type=text/javascript runat=server
alert ('your session has expired');
cflocation url=http://olympus.scs.jhu.edu/#session.
url#/admissions/ addtoken=no
/script
cfabort
/cfif
The code eis working. Thanks a lot. I was just wondering is that possible to
display a message saying that session is expired and you will be redirecting
in 5 sec
~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289122
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: table union
There are 4000 entries currently and growing every check we write go's into one of the two tables. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 12:09 PM To: CF-Talk Subject: RE: table union I'm not sure about temp tables in access. If my temp table you really just mean creating a regular table which you will drop when you are done that would not allow for concurrent executions of your code since they would be using the same table. (temp tables in SQL Server are connection specific I believe) There are ways around that, like having a unique number per process, but you are kind of defeating part of you purpose at that time. How many records are you dealing with? ~Brad ion.com/cf_lists/unsubscribe.cfm?user=30316.21480.4 ~| 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:289125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Catching CFHTTP errors when a PC is off.
Looking for the best way to catch errors when making a CFHTTP call and looking for a failsafe if the remote PC is off. Is there anything better than using a try/catch and then writing conditional logic based on if the cfcatch.message is defined and = The request has exceeded the allowable time limit Tag: cfhttp? How could you possibly know that the remote PC is off? If you don't get a response, there could be many reasons - networking problems at the client, networking problems along the route, networking problems at the server, for example. 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! ~| 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:289129 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-happy CAPTCHA recommendations?
Michael E. Carluen wrote: Have your tried CFFormProtect? http://cfformprotect.riaforge.org/ Looks neat - I'll give it a looksee. Thanks Michael! +1 on cfformprotect. works like a champ! Will ~| 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:289128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion 8 memory usage
Ok, we have ColdFusion 8 installed on several development machines. They all have the same JVM version 1.6.0_02, two are Vista and two are on XP. On my Vista machine, the task manager shows jrun.exe using right around 500,000K of memory. Another Vista machine shows it using closer to 100,000k. Both were installed with the same options. Both have a maximum JVM heap size of 512 which appears to be the default. However, when I drop mine to 64, my memory usage in the task manager for JRUN drops considerably to about 125,000k. The other Visa machine actually went up to about 125,000k when it had the heap set to 64. This is even weirder though. When my machine goes back to 512 for the heap, my memory goes back up to 500,000K. The other Vista machine does as well until you reboot it. Then it goes back to the 100,000K that it is normally at. Rebooting mine seems to do nothing, it always goes right back to using 500,000K. I have the exact same thing happening on two XP machines. One has a normal memory usage of about 100,000k, the other is 500,000K. Has anyone run into anything like this? The ColdFusion service was restarted between all chances of the heap size. Dan ~| 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:289130 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Catching CFHTTP errors when a PC is off.
True... Bad example on my part. Let me rephrase then, what is the best way to catch cfhttp errors then when a connection, for whatever cannot be established? Perhaps cfif NOT isdefined(cfcatch.type) or cfif cfcatch.type NEQ COM.Allaire.ColdFusion.HTTPFailure I just want to be sure I am not missing something obvious. Thanks, Che -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 3:11 PM To: CF-Talk Subject: RE: Catching CFHTTP errors when a PC is off. Looking for the best way to catch errors when making a CFHTTP call and looking for a failsafe if the remote PC is off. Is there anything better than using a try/catch and then writing conditional logic based on if the cfcatch.message is defined and = The request has exceeded the allowable time limit Tag: cfhttp? How could you possibly know that the remote PC is off? If you don't get a response, there could be many reasons - networking problems at the client, networking problems along the route, networking problems at the server, for example. 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! ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289133 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-happy CAPTCHA recommendations?
Will Tomlinson wrote: +1 on cfformprotect. works like a champ! That said, what's the peanut gallery's opinion on ditching CAPTCHA in favor of CFFP, or using both in conjunction? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: table union
I think all the time is in the UNION statement because running these queries without the union I get about 23ms to run the whole page. The test server I am running this on is local SATA with the Server (witch I have not tested this on yet) is Raid 1. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 1:15 PM To: CF-Talk Subject: RE: table union Hmmm, 4000 records really isn't that much-- even for Access. I can't imagine it taking 30 seconds to only retrieve 4000 rows. Maybe someone with some more Access database work can speak up here. Have you tried the compact and repair option in case the database file has gotten extremely fragmented? What kind of server is your database running on? Local IDE drives? Network SCSI RAID? ~Brad ~| 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:289134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: javascript and redirect
well, one issue you're going to run into off the bat is that if the
session is expired, the #session.URL# variable will be undefined. so
you'll have to address that.
but it's no different than the logic you used in your initial post.
cfif NOT isDefined('session.appfee')
the code i provided goes here
/cfif
On 9/21/07, erik tsomik [EMAIL PROTECTED] wrote:
How can I integrate this solution into session expired
cfoutput
meta http-equiv=refresh
content=5;url=http://olympus.scs.jhu.edu/#session.URL#/admissions/;
Your session has expired. You will be redirect in 5 seconds.
a href=http://olympus.scs.jhu.edu/#session.URL#/admissions/;click
here/a if you are not automatically redirected.
/cfoutput
~|
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:289127
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: table union
Hmmm, 4000 records really isn't that much-- even for Access. I can't imagine it taking 30 seconds to only retrieve 4000 rows. Maybe someone with some more Access database work can speak up here. Have you tried the compact and repair option in case the database file has gotten extremely fragmented? What kind of server is your database running on? Local IDE drives? Network SCSI RAID? ~Brad -Original Message- From: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 1:48 PM To: CF-Talk Subject: RE: table union There are 4000 entries currently and growing every check we write go's into one of the two tables. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 12:09 PM To: CF-Talk Subject: RE: table union I'm not sure about temp tables in access. If my temp table you really just mean creating a regular table which you will drop when you are done that would not allow for concurrent executions of your code since they would be using the same table. (temp tables in SQL Server are connection specific I believe) There are ways around that, like having a unique number per process, but you are kind of defeating part of you purpose at that time. How many records are you dealing with? ~Brad ion.com/cf_lists/unsubscribe.cfm?user=30316.21480.4 ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289131 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: javascript and redirect
I tried this code but it saying that the session does not exist
cfif NOT structKeyExists(session, 'appfee')
cfoutput
meta http-equiv=refresh
content=5;url=http://olympus.scs.jhu.edu/#session.URL#/admissions/;;Your
session has expired. You will be redirect in 5 seconds.
a href=http://olympus.scs.jhu.edu/#session.URL#/admissions/;click
here/a if you are not automatically redirected.
/cfoutput
/cfif
well, one issue you're going to run into off the bat is that if the
session is expired, the #session.URL# variable will be undefined. so
you'll have to address that.
but it's no different than the logic you used in your initial post.
cfif NOT isDefined('session.appfee')
the code i provided goes here
/cfif
~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289135
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfcache problem
Yes, Ray's tag also stores things in memory (in fact I think CFACCELERATE was based on Ray's tag). What I meant to say regarding performance was that when Brandon (and Ray as well I beleive) testing their in-memory caching against CFCACHE, the difference in speed was measured in orders of magnitude. So basically, cache to memory as much as you can. (Obviously, use your head and don't kill your server though.) On 9/21/07, Dave Watts [EMAIL PROTECTED] wrote: I'm not sure, but if I recall correctly CFCACHE still writes temp files to the file system and reads them back each time, which doesn't perform very well under load. Actually, reading the files from disk does perform quite well under load. It's creating the files in the first place which is the problem, since this is done by running CFHTTP to request the file. In effect, the first request takes twice as long as it otherwise would. Have a look at Ray's scopecache custom tag. I haven't used Ray's tag, but in a similar vein I'd strongly recommend Brandon Purcell's CF_ACCELERATE custom tag: http://www.bpurcell.org/blog/index.cfm?entry=963mode=entry Instead of writing to the filesystem, it stores entries in memory. 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! ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: table union
23ms to run the whole page -- Wow-- does Access support UNION ALL Be default union usually eliminates duplicate records returning you a distinct list. The overhead might be in the comparison of each record. Once again I don't know if that applies to Access. Either way, using some sort of temp table to select into would eliminate the union all together. You could combine the results in CF, but it is probably best to let the DB do that kind of work in theory. ~Brad ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Catching CFHTTP errors when a PC is off.
I'm not sure I see why it matters why the connection failed. If it failed, you have to respond. You can certainly catch specific types of errors, but unless you're doing something different depending on the error (and in this case I'm not sure what that would be since you really have no idea why the connection failed or if/when it might be back up), I'd think a general catch would be fine. On 9/21/07, Che Vilnonis [EMAIL PROTECTED] wrote: True... Bad example on my part. Let me rephrase then, what is the best way to catch cfhttp errors then when a connection, for whatever cannot be established? Perhaps cfif NOT isdefined(cfcatch.type) or cfif cfcatch.type NEQ COM.Allaire.ColdFusion.HTTPFailure I just want to be sure I am not missing something obvious. Thanks, Che ~| 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:289139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: javascript and redirect
Your outputting the data to the client from within a CF page, so why not just use CF to change the location? Instead of outputting a script or meta refresh, why not just CFLOCATION? cflocation url=http:www.gohere.com addToken=no The only reason I could see using script on the client side would be to break out of frames or something. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: javascript and redirect
this might be an example of isDefined() being preferred over structKeyExists().
cfif NOT isDefined('session.appfee')
the code i provided goes here
/cfif
On 9/21/07, erik tsomik [EMAIL PROTECTED] wrote:
I tried this code but it saying that the session does not exist
cfif NOT structKeyExists(session, 'appfee')
cfoutput
meta http-equiv=refresh
content=5;url=http://olympus.scs.jhu.edu/#session.URL#/admissions/;;Your
session has expired. You will be redirect in 5 seconds.
a href=http://olympus.scs.jhu.edu/#session.URL#/admissions/;click
here/a if you are not automatically redirected.
/cfoutput
/cfif
well, one issue you're going to run into off the bat is that if the
session is expired, the #session.URL# variable will be undefined. so
you'll have to address that.
but it's no different than the logic you used in your initial post.
cfif NOT isDefined('session.appfee')
the code i provided goes here
/cfif
~|
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:289138
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Archiving SQL table data
In general when using a relational database for client data storage, is it a good idea to archive data older than a certain date (like say 2 years) or just let good indexes take care of data growth? For example, we would move all data out of certain tables that grow very large (approx. 20K - 40K records, growing by 10K / yr.) to tables that aren't used often. This theoretically would speed up queries on those often used tables. The downside of course is writing new queries that use the archived tables to get old data when needed. So my question is: What is the standard practice for this issue? Archive or not? James Davis Software Engineer Kaleida Systems, Inc. ~| 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:289141 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Catching CFHTTP errors when a PC is off.
True... Bad example on my part. Let me rephrase then, what is the best way to catch cfhttp errors then when a connection, for whatever cannot be established? Perhaps cfif NOT isdefined(cfcatch.type) or cfif cfcatch.type NEQ COM.Allaire.ColdFusion.HTTPFailure I just want to be sure I am not missing something obvious. I have no idea offhand what specific exception type is thrown when you have a connection failure. You can find out by simply trying to connect to some machine that's not running an HTTP server, catching and finally displaying the exception type. 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! ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289143 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: javascript and redirect
Because cflocation will preclide javascript and I will not see the alert message. So I need to see some kinda message which will redirect in approximately 5 sec to a different page Your outputting the data to the client from within a CF page, so why not just use CF to change the location? Instead of outputting a script or meta refresh, why not just CFLOCATION? cflocation url=http:www.gohere.com addToken=no The only reason I could see using script on the client side would be to break out of frames or something. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:289142 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Archiving SQL table data
40k records is nothing. I think you only need to be concerned when you actually see a performance decrease. You are correct in that the proper indexes will certainly increase performance. I'd rather deal with one huge table, and the proper indexes, than several smaller tables and have to join them together. If you don't need online access to the data, then you can archive it. M!ke -Original Message- From: James Davis [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 3:00 PM To: CF-Talk Subject: Archiving SQL table data In general when using a relational database for client data storage, is it a good idea to archive data older than a certain date (like say 2 years) or just let good indexes take care of data growth? For example, we would move all data out of certain tables that grow very large (approx. 20K - 40K records, growing by 10K / yr.) to tables that aren't used often. This theoretically would speed up queries on those often used tables. The downside of course is writing new queries that use the archived tables to get old data when needed. So my question is: What is the standard practice for this issue? Archive or not? James Davis Software Engineer Kaleida Systems, Inc. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Archiving SQL table data
What database are you using? Any enterprise DBMS is built to handle millions of records. If its running on decent hardware there should be no problem. Given your scenario, there seems to be no reason to worry about archiving your data into other tables. 20k-40k records is nothing. Steve -Original Message- From: James Davis [EMAIL PROTECTED] Sent 9/21/2007 4:00:26 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Archiving SQL table dataIn general when using a relational database for client data storage, is it a good idea to archive data older than a certain date (like say 2 years) or just let good indexes take care of data growth? For example, we would move all data out of certain tables that grow very large (approx. 20K - 40K records, growing by 10K / yr.) to tables that aren't used often. This theoretically would speed up queries on those often used tables. The downside of course is writing new queries that use the archived tables to get old data when needed. So my question is: What is the standard practice for this issue? Archive or not? James Davis Software Engineer Kaleida Systems, Inc. ~| 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:289144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 configuration issues in a VM environment
I'm running CF8 developer edition on XP in a VMWare virtual machine on top of OS X Tiger. My goal is to use the XP virtual machine as my development enviroment for IIS,CF8 and SQL Server, and ideally have all cf files in a shared directory, so I can access and edit those files from within OS X. I have IIS configured so that its home directory is a Samba share I set up on the OS X side and then can access from the PC side. I am able to browse to standard HTML documents in a browser both from the OS X side and the XP side. So, I'm fairly confident that IIS is configured properly. After getting IIS to work, I installed CF8 as a standalone install, and had it configured to run on top of all IIS websites. I am now having two problems. I have no idea if either can be solved, but I was hoping somebody may have a few pointers. Problem 1 I created a simple index.cfm file that contains the following code: cfset test = hicfoutput#test#/cfoutput When I navigate to that URL on either the OSX or XP side, I see a CF missing page error. Why index.html would work, but index.cfm in the exact same directory would *not* work is beyond me. Problem 2 I would like to create a custom tags path mapping to either the SMB share or a mapped drive on the OS X side. However, every time I attempt that, Cold fusion shows the error Unable to add custom tag path [mypath]. For example, X:\customtags\, where X:\ is a folder within a shared VMWare shared folder. I realize what I want to do is kind of convoluted, but it frankly all seems reasonably straightforward, so I'm not sure what the stumbling block is. Any pointers or advice is appreciated. Thanks. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Archiving SQL table data
We're using SQL Server 2000 on a Quad Xeon 3.2 Ghz Processor w/3 GB RAM. I always lean towards proper indexing, however I'm looking to convince the higher-ups that this Archive Solution is not necessary and won't have a positive impact on performance. James Davis Software Engineer Kaleida Systems, Inc. -Original Message- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 4:10 PM To: CF-Talk Subject: Re: Archiving SQL table data What database are you using? Any enterprise DBMS is built to handle millions of records. If its running on decent hardware there should be no problem. Given your scenario, there seems to be no reason to worry about archiving your data into other tables. 20k-40k records is nothing. Steve -Original Message- From: James Davis [EMAIL PROTECTED] Sent 9/21/2007 4:00:26 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Archiving SQL table dataIn general when using a relational database for client data storage, is it a good idea to archive data older than a certain date (like say 2 years) or just let good indexes take care of data growth? For example, we would move all data out of certain tables that grow very large (approx. 20K - 40K records, growing by 10K / yr.) to tables that aren't used often. This theoretically would speed up queries on those often used tables. The downside of course is writing new queries that use the archived tables to get old data when needed. So my question is: What is the standard practice for this issue? Archive or not? James Davis Software Engineer Kaleida Systems, Inc. ~| 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:289147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: javascript and redirect
I found this script on the internet. So i wondering if it possible to integrate
this script into 1 I alredy have . I mean when session does not exist show
progress bar and then redirect
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN
http://www.w3.org/TR/html4/strict.dtd;
html
head
titleTest page/title
style
* { font-family: Arial, sans-serif; }
#wrap { margin-top: 50px;text-align: center; }
#barwrap {
position: relative; /* to contain outer */
margin: 0 auto; /* to centre */
width: 250px;height: 20px; /* size of our bar - required */
text-align: left;
font-weight: bold;
border: 1px solid black;
}
#barwrap P { /* to contain text */
margin: 0; /* FF needs this or text drops below bar */
width: 250px; /* use this node to position text */
text-align: center;
}
#barwrap #outer { /* bar 'background' */
position: absolute;
width: 100%; height: 100%; /* match parent size */
background: lightgreen;
color: green; /* original colour of text */
}
#barwrap #inner {
position: relative; /* otherwise outer hides us */
width: 0; height: 100%; /* match parent */
overflow: hidden; /* to hide new text/prevent it wrapping */
background: green;
color: lightgreen; /* colour of changed text */
}
/style
script
var time = 1; // 10 secs
var steps = 50; // Five per second
var step = 1;
function progress() {
var bar = document.getElementById( barwrap);
var aStep = (bar.offsetWidth -2) /steps;// 2px border removed from width
var x = Math.round( aStep *step);
var outer = document.getElementById( outer);
var inner = document.getElementById( inner);
// Work out seconds based on % progress from current step
var secs = (( time /1000) -Math.floor( ( step /steps) *10));
inner.style.width = x +px;
step++;
// If 0 seconds, display waiting message instead
outer.firstChild.innerHTML = ( secs? secs + seconds...: Please Wait...);
// Match text
inner.firstChild.innerHTML = outer.firstChild.innerHTML;
if( step steps) redir();
else setTimeout( progress();, time /steps);
}
function redir() {
alert( Redirecting now!);
}
/script
/head
body
div id='wrap'
progress:
div id='barwrap' !-- P wrappers for text positioning --
div id='outer'p/p/div !-- original colour/text --
div id='inner'p/p/div !-- new colour/text --
/div
br
a href='#' onClick='progress();'Click here to start bar (only once please,
you'll break it)/a
/div
/body
/html
the cflocation will preclude any client side code (HTML or JS) from
displaying.
use a JavaScript redirect.
cfif NOT structKeyExists(session, 'appfee')
script type=text/javascript
alert('your session has expired');
cfoutputlocation.href=http://olympus.scs.jhu.edu/#session.
URL#/admissions/;/cfoutput
/script
cfabort /
/cfif
On 9/21/07, erik tsomik [EMAIL PROTECTED] wrote:
I am trying to show the alert saying that the session is expired and
redirect then to home page. I got this working except I do not see the
alert
cfif not isDefined(session.appfee)
script type=text/javascript runat=server
alert ('your session has expired');
cflocation url=http://olympus.scs.jhu.edu/#session.
url#/admissions/ addtoken=no
/script
cfabort
/cfif
~|
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:289148
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: javascript and redirect
i'm sure it is
On 9/21/07, erik tsomik [EMAIL PROTECTED] wrote:
I found this script on the internet. So i wondering if it possible to
integrate this script into 1 I alredy have . I mean when session does not
exist show progress bar and then redirect
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN
http://www.w3.org/TR/html4/strict.dtd;
html
head
titleTest page/title
style
* { font-family: Arial, sans-serif; }
#wrap { margin-top: 50px;text-align: center; }
#barwrap {
position: relative; /* to contain outer */
margin: 0 auto; /* to centre */
width: 250px;height: 20px; /* size of our bar - required */
text-align: left;
font-weight: bold;
border: 1px solid black;
}
#barwrap P { /* to contain text */
margin: 0; /* FF needs this or text drops below bar */
width: 250px; /* use this node to position text */
text-align: center;
}
#barwrap #outer { /* bar 'background' */
position: absolute;
width: 100%; height: 100%; /* match parent size */
background: lightgreen;
color: green; /* original colour of text */
}
#barwrap #inner {
position: relative; /* otherwise outer hides us */
width: 0; height: 100%; /* match parent */
overflow: hidden; /* to hide new text/prevent it wrapping */
background: green;
color: lightgreen; /* colour of changed text */
}
/style
script
var time = 1; // 10 secs
var steps = 50; // Five per second
var step = 1;
function progress() {
var bar = document.getElementById( barwrap);
var aStep = (bar.offsetWidth -2) /steps;// 2px border removed from width
var x = Math.round( aStep *step);
var outer = document.getElementById( outer);
var inner = document.getElementById( inner);
// Work out seconds based on % progress from current step
var secs = (( time /1000) -Math.floor( ( step /steps) *10));
inner.style.width = x +px;
step++;
// If 0 seconds, display waiting message instead
outer.firstChild.innerHTML = ( secs? secs + seconds...: Please Wait...);
// Match text
inner.firstChild.innerHTML = outer.firstChild.innerHTML;
if( step steps) redir();
else setTimeout( progress();, time /steps);
}
function redir() {
alert( Redirecting now!);
}
/script
/head
body
div id='wrap'
progress:
div id='barwrap' !-- P wrappers for text positioning --
div id='outer'p/p/div !-- original colour/text --
div id='inner'p/p/div !-- new colour/text --
/div
br
a href='#' onClick='progress();'Click here to start bar (only once please,
you'll break it)/a
/div
/body
/html
the cflocation will preclude any client side code (HTML or JS) from
displaying.
use a JavaScript redirect.
cfif NOT structKeyExists(session, 'appfee')
script type=text/javascript
alert('your session has expired');
cfoutputlocation.href=http://olympus.scs.jhu.edu/#session.
URL#/admissions/;/cfoutput
/script
cfabort /
/cfif
On 9/21/07, erik tsomik [EMAIL PROTECTED] wrote:
I am trying to show the alert saying that the session is expired and
redirect then to home page. I got this working except I do not see the
alert
cfif not isDefined(session.appfee)
script type=text/javascript runat=server
alert ('your session has expired');
cflocation url=http://olympus.scs.jhu.edu/#session.
url#/admissions/ addtoken=no
/script
cfabort
/cfif
~|
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:289149
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: javascript and redirect
I found this script on the internet. So i wondering if it possible to integrate
this script into 1 I alredy have . I mean when session does not exist show
progress bar and then redirect
style
* { font-family: Arial, sans-serif; }
#wrap { margin-top: 50px;text-align: center; }
#barwrap {
position: relative; /* to contain outer */
margin: 0 auto; /* to centre */
width: 250px;height: 20px; /* size of our bar - required */
text-align: left;
font-weight: bold;
border: 1px solid black;
}
#barwrap P { /* to contain text */
margin: 0; /* FF needs this or text drops below bar */
width: 250px; /* use this node to position text */
text-align: center;
}
#barwrap #outer { /* bar 'background' */
position: absolute;
width: 100%; height: 100%; /* match parent size */
background: lightgreen;
color: green; /* original colour of text */
}
#barwrap #inner {
position: relative; /* otherwise outer hides us */
width: 0; height: 100%; /* match parent */
overflow: hidden; /* to hide new text/prevent it wrapping */
background: green;
color: lightgreen; /* colour of changed text */
}
/style
script
var time = 1; // 10 secs
var steps = 50; // Five per second
var step = 1;
function progress() {
var bar = document.getElementById( barwrap);
var aStep = (bar.offsetWidth -2) /steps;// 2px border removed from width
var x = Math.round( aStep *step);
var outer = document.getElementById( outer);
var inner = document.getElementById( inner);
// Work out seconds based on % progress from current step
var secs = (( time /1000) -Math.floor( ( step /steps) *10));
inner.style.width = x +px;
step++;
// If 0 seconds, display waiting message instead
outer.firstChild.innerHTML = ( secs? secs + seconds...: Please Wait...);
// Match text
inner.firstChild.innerHTML = outer.firstChild.innerHTML;
if( step steps) redir();
else setTimeout( progress();, time /steps);
}
function redir() {
alert( Redirecting now!);
}
/script
/head
body
div id='wrap'
progress:
div id='barwrap' !-- P wrappers for text positioning --
div id='outer'p/p/div !-- original
colour/text --
div id='inner'p/p/div !-- new colour/text
--
/div
br
a href='#' onClick='progress();'Click here to start bar (only once
please, you'll break it)/a
/div
/body
~|
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:289150
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 configuration issues in a VM environment
Replying to my own thread... I've bailed on trying to get IIS and CF on XP to recognize files that live on the OS X side and are accessed via shares; at least for now. Instead, the home directory for all my CF files will be on the XP box, and I'll share those folders and then read the shares from the OS X side via Samba. I suspect that should work reasonably well. I'm running CF8 developer edition on XP in a VMWare virtual machine on top of OS X Tiger. My goal is to use the XP virtual machine as my development enviroment for IIS,CF8 and SQL Server, and ideally have all cf files in a shared directory, so I can access and edit those files from within OS X. ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 configuration issues in a VM environment
Could this be a permission thing? I know to do something similar to what you are describing with multiple computers on a network rather then multiple virtual systems on the same computer, would require some modification of from the default CF setup on windows. By default, CF runs under a 'localsystem' account and has no access to any network resources. I can imagine that this restrict the CF service to the local 'virtual' system locking it out of other 'networked' virtual systems. If so, it should just be a matter of creating a user of the CF service that has the required permissions to all the pieces. ~| 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:289152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 configuration issues in a VM environment
Ian, I bet you're absolutely right, and I should have thought of that myself. I'll test your theory over the weekend. Thanks very much for the advice. Could this be a permission thing? I know to do something similar to what you are describing with multiple computers on a network rather then multiple virtual systems on the same computer, would require some modification of from the default CF setup on windows. By default, CF runs under a 'localsystem' account and has no access to any network resources. I can imagine that this restrict the CF service to the local 'virtual' system locking it out of other 'networked' virtual systems. If so, it should just be a matter of creating a user of the CF service that has the required permissions to all the pieces. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: table union
Changed it to a UNION ALL and still taking 32 seconds. By letting CF combine the data you mean drop the two queries into an array? Would this be a good time to switch to a full SQL server, if so any suggestions I use access because it is easy to use. Travis Haley Haley Computer Solutions 2749 E. Nichols Cir Centennial, CO 80122 P: (303) 694-8050 F: (303) 779-0335 -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 1:34 PM To: CF-Talk Subject: RE: table union 23ms to run the whole page -- Wow-- does Access support UNION ALL Be default union usually eliminates duplicate records returning you a distinct list. The overhead might be in the comparison of each record. Once again I don't know if that applies to Access. Either way, using some sort of temp table to select into would eliminate the union all together. You could combine the results in CF, but it is probably best to let the DB do that kind of work in theory. ~Brad ~| 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:289154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: table union
No arrays necessary. You should be able to union the two result sets with a query of queries after running them separately. The database _should_ always be the fastest way to do that, but obviously there are some other factors at work here and I don't know how to trouble shoot them... If you have SQL server sitting around and you are just waiting to use it-- heck go for it. It's always harder to switch later. I don't know that I would spend the money just for the heck of it unless you definitely need some of its functionality or you are planning on having a pretty big database by the time you are done with app. I used to do all my personal stuff in Access because it was all I had. I've worked for 3 1/2 years with MS SQL 2000 and 2005 now and I don't think I could go back now that I am used to it. ~Brad -Original Message- From: Travis Haley [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 5:10 PM To: CF-Talk Subject: RE: table union Changed it to a UNION ALL and still taking 32 seconds. By letting CF combine the data you mean drop the two queries into an array? Would this be a good time to switch to a full SQL server, if so any suggestions I use access because it is easy to use. ~| 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:289155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Catching CFHTTP errors when a PC is off.
Another option if you need more granular control is to take a look at CFX_HTTP5. It is wicked fast and has an extremely deep feature set. It's pretty easy to catch errors like these with CFX_HTTP5. Todd -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 3:11 PM To: CF-Talk Subject: RE: Catching CFHTTP errors when a PC is off. True... Bad example on my part. Let me rephrase then, what is the best way to catch cfhttp errors then when a connection, for whatever cannot be established? Perhaps cfif NOT isdefined(cfcatch.type) or cfif cfcatch.type NEQ COM.Allaire.ColdFusion.HTTPFailure I just want to be sure I am not missing something obvious. I have no idea offhand what specific exception type is thrown when you have a connection failure. You can find out by simply trying to connect to some machine that's not running an HTTP server, catching and finally displaying the exception type. 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! ~| 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:289156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Performance Tuning CF?
It seems that a while back there were a couple of whitepapers and/or recommended best practice write-ups concerning performance tuning CF and the JVM details. Does anyone know where these might be found and if they've been re-visited very recently? It would be great to find something with CF 8 specific details but I'm sure that is wishful thinking. Thanks for the suggestions ahead of time. Todd ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Open Source CF Survey Application
Does anyone have experience with any CF open source survey application? Feel free to share good and bad experiences. The only one I've looked at so far is Soundings (http://soundings.riaforge.org/). I hate to reinvent the wheel and start from scratch if there is something robust already out there. Thanks, Jonathan B. Davis Systems Manager Mercer University - Walter F. George School of Law www.law.mercer.edu [EMAIL PROTECTED] (478) 301-2181 ~| 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:289158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: table union
I get about the same time using the QoQ... you would not think it was this hard to join two tables together lol Would making an additional table to keep all the info in and writing each check transaction to both tables Then pull the report off the master table? -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 4:31 PM To: CF-Talk Subject: RE: table union No arrays necessary. You should be able to union the two result sets with a query of queries after running them separately. The database _should_ always be the fastest way to do that, but obviously there are some other factors at work here and I don't know how to trouble shoot them... If you have SQL server sitting around and you are just waiting to use it-- heck go for it. It's always harder to switch later. I don't know that I would spend the money just for the heck of it unless you definitely need some of its functionality or you are planning on having a pretty big database by the time you are done with app. I used to do all my personal stuff in Access because it was all I had. I've worked for 3 1/2 years with MS SQL 2000 and 2005 now and I don't think I could go back now that I am used to it. ~Brad ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open Source CF Survey Application
If Soundings isn't robust enough, you could always contribute to the wheel instead of reinventing a whole new one :) On 9/21/07, Jonathan B. Davis [EMAIL PROTECTED] wrote: Does anyone have experience with any CF open source survey application? Feel free to share good and bad experiences. The only one I've looked at so far is Soundings (http://soundings.riaforge.org/). I hate to reinvent the wheel and start from scratch if there is something robust already out there. Thanks, Jonathan B. Davis Systems Manager Mercer University - Walter F. George School of Law www.law.mercer.edu [EMAIL PROTECTED] (478) 301-2181 ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
one for the SQL gurus
I've got a query issue that's driving me crazy
Here's the query, actually it's a SQL server view
SELECT TOP (100) PERCENT LEFT(PublicationYear, 4) AS Year, COUNT(PBID) AS
BookCount,Category
FROM dbo.PsycBOOKS
WHERE (IsNumeric(PublicationYear) = 1)
AND (Active = 1)
GROUP BY LEFT(PublicationYear, 4), Category
ORDER BY Year DESC
What this returns is
2007 | 14 | C
2007 | 2| A
What I need is
2007 | 16 |
If I pull category out of the group by it errors out.
I can't remove the Category because of this:
cfquery name=qryGetYear datasource=#request.site.dsn#
SELECT LEFT(PublicationYear, 4) AS Year, PBID, Category
FROM dbo.PsycBOOKS
WHERE (IsNumeric(PublicationYear) = 1)
AND (Active = 1)
cfif categories is not
and Category in ('0'
cfloop list=#categories#
index=x
,'#x#'
/cfloop
)
/cfif
Order By Year desc
/cfquery
The category is passed to the query from a form. It can be a,c or e or any
combination
Any ideas?
Thanks
sas
--
Scott Stewart
ColdFusion Developer
SSTWebworks
4405 Oakshyre Way
Raleigh, NC. 27616
(703) 220-2835
http://www.sstwebworks.com
http://www.linkedin.com/in/sstwebworks
http://www.linkedin.com/in/sstwebworks
~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289161
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple .NET Class
It's a good snippet to test that the .net bridge is working properly with 'real' dlls before trying to get your own ones working. Hopefully Dale and David will chime in with their results. On 9/21/07, Dawson, Michael [EMAIL PROTECTED] wrote: This works for me, but damn! It takes almost 30 seconds for the first request to complete. After that, it's pretty speedy. 2.0.50727.42 on Win Server 2003. M!ke -Original Message- From: Antony Sideropoulos [mailto:[EMAIL PROTECTED] Sent: Friday, September 21, 2007 8:04 AM To: CF-Talk Subject: Re: Simple .NET Class Dale Are you able to connect to standard Windows dlls? eg, can you run this snippet: cfobject type=.NET name=test class=System.Environment cfdump var=#test# cfdump var=#test.Get_Version().ToString()# !--- 2.0.50727.1318 on WinXp Sp2 for me; 2.0.50727.312 on vista for me --- also, what account are your CF services running under? permissions okay? ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Simple .NET Class
All CF services are running as Local System Should they be something else? Administrator? Regards Dale Fraser http://learncf.com -Original Message- From: Antony Sideropoulos [mailto:[EMAIL PROTECTED] Sent: Friday, 21 September 2007 11:04 PM To: CF-Talk Subject: Re: Simple .NET Class Dale Are you able to connect to standard Windows dlls? eg, can you run this snippet: cfobject type=.NET name=test class=System.Environment cfdump var=#test# cfdump var=#test.Get_Version().ToString()# !--- 2.0.50727.1318 on WinXp Sp2 for me; 2.0.50727.312 on vista for me --- also, what account are your CF services running under? permissions okay? On 9/21/07, Dale Fraser [EMAIL PROTECTED] wrote: Having same problem on multiple computers. We must be missing something really obvious I think. It seems not many people have tried this. Regards Dale Fraser http://learncf.com -Original Message- From: Davide Campo [mailto:[EMAIL PROTECTED] Sent: Friday, 21 September 2007 1:45 AM To: CF-Talk Subject: Re: Simple .NET Class Then: - i haven't .NET stuff installed (what is it?) - i have only .net 2.0 installed - i tried to stop cf .net service, delete paste dll, restart cf .net service, execute the sample again --- guess what? NOTHING, same error only one word: help! tnk u all ~| 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:289165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Performance Tuning CF?
Would this be it? http://livedocs.adobe.com/wtg/public/coding_standards/performance.html Dominic On 22/09/2007, Todd Mathews [EMAIL PROTECTED] wrote: It seems that a while back there were a couple of whitepapers and/or recommended best practice write-ups concerning performance tuning CF and the JVM details. Does anyone know where these might be found and if they've been re-visited very recently? It would be great to find something with CF 8 specific details but I'm sure that is wishful thinking. Thanks for the suggestions ahead of time. Todd ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Simple .NET Class
Restarting the .NET service made no difference. Regards Dale Fraser http://learncf.com -Original Message- From: Dale Fraser [mailto:[EMAIL PROTECTED] Sent: Saturday, 22 September 2007 10:47 AM To: CF-Talk Subject: RE: Simple .NET Class All CF services are running as Local System Should they be something else? Administrator? Regards Dale Fraser http://learncf.com -Original Message- From: Antony Sideropoulos [mailto:[EMAIL PROTECTED] Sent: Friday, 21 September 2007 11:04 PM To: CF-Talk Subject: Re: Simple .NET Class Dale Are you able to connect to standard Windows dlls? eg, can you run this snippet: cfobject type=.NET name=test class=System.Environment cfdump var=#test# cfdump var=#test.Get_Version().ToString()# !--- 2.0.50727.1318 on WinXp Sp2 for me; 2.0.50727.312 on vista for me --- also, what account are your CF services running under? permissions okay? On 9/21/07, Dale Fraser [EMAIL PROTECTED] wrote: Having same problem on multiple computers. We must be missing something really obvious I think. It seems not many people have tried this. Regards Dale Fraser http://learncf.com -Original Message- From: Davide Campo [mailto:[EMAIL PROTECTED] Sent: Friday, 21 September 2007 1:45 AM To: CF-Talk Subject: Re: Simple .NET Class Then: - i haven't .NET stuff installed (what is it?) - i have only .net 2.0 installed - i tried to stop cf .net service, delete paste dll, restart cf .net service, execute the sample again --- guess what? NOTHING, same error only one word: help! tnk u all ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Performance Tuning CF?
With the massive performance improvements in CF8, it's likely that info is now partially irrelevant. As CF8 now ships with Java 6, tuning that JVM may also be a little different than for CF6 or 7, e.g.: http://blogs.sun.com/dagastine/entry/java_6_leads_out_of http://java.sun.com/javase/technologies/hotspot/gc/gc_tuning_6.html On 9/22/07, Dominic Watson wrote: Would this be it? http://livedocs.adobe.com/wtg/public/coding_standards/performance.html -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Open Source CF Survey Application
Heh, I don't think he was saying that - but rather asking if anyone had opinions of it - or any other OS Survey app. That being said - JD - if you end up using Soundings and have feedback - let me know. On 9/21/07, Charlie Griefer [EMAIL PROTECTED] wrote: If Soundings isn't robust enough, you could always contribute to the wheel instead of reinventing a whole new one :) On 9/21/07, Jonathan B. Davis [EMAIL PROTECTED] wrote: Does anyone have experience with any CF open source survey application? Feel free to share good and bad experiences. The only one I've looked at so far is Soundings (http://soundings.riaforge.org/). I hate to reinvent the wheel and start from scratch if there is something robust already out there. Thanks, Jonathan B. Davis Systems Manager Mercer University - Walter F. George School of Law www.law.mercer.edu [EMAIL PROTECTED] (478) 301-2181 ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
