Fw: Odd cf7 sandbox issue
Now that I look closer at the issue, it seems to be a casing issue in the path trying to be accessed. Now to find out how the case is changing on a template call. so it seems: success \\apfs\projects\web\production\inetpub\myapplication\my_template.cfm failure \\apfs\projects\web\production\inetpub\MYAPPLICATION\my_template.cfm Computer Sciences Corporation Registered Office: 3170 Fairview Park Drive, Falls Church, Virginia 22042, USA Registered in Nevada, USA No: C-489-59 - This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. - - Forwarded by Casey C Cook/GTS/CSC on 08/01/2008 10:52 AM - Casey C Cook/GTS/[EMAIL PROTECTED] 08/01/2008 10:19 AM Please respond to cf-talk@houseoffusion.com To CF-Talk cc Subject Odd cf7 sandbox issue We have been able to isolate the issue to a specific server, then rebuild the sandbox to correct the issue. The problem is we dont know what is causing the issue, once it starts all users are affected until we rebuild the sandbox or the coldfusion service is restarted. Im going to start googling for answers, just thought I would touch base here as well. access denied (java.io.FilePermission \\apfs\projects\web\production\inetpub\myapplication\my_template.cfm execute) null Computer Sciences Corporation Registered Office: 3170 Fairview Park Drive, Falls Church, Virginia 22042, USA Registered in Nevada, USA No: C-489-59 - This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. - ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Odd cf7 sandbox issue
We have been able to isolate the issue to a specific server, then rebuild the sandbox to correct the issue. The problem is we dont know what is causing the issue, once it starts all users are affected until we rebuild the sandbox or the coldfusion service is restarted. Im going to start googling for answers, just thought I would touch base here as well. access denied (java.io.FilePermission \\apfs\projects\web\production\inetpub\myapplication\my_template.cfm execute) null Computer Sciences Corporation Registered Office: 3170 Fairview Park Drive, Falls Church, Virginia 22042, USA Registered in Nevada, USA No: C-489-59 - This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. - ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMX7
Are you using stored procedures? Thanks, CC Computer Sciences Corporation Registered Office: 2100 East Grand Avenue, El Segundo California 90245, USA Registered in USA No: C-489-59 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Brent Nicholas" <[EMAIL PROTECTED]> 01/07/2008 08:59 AM Please respond to cf-talk@houseoffusion.com To CF-Talk cc Subject Re: CFMX7 Any other thoughts on this from anyone? Thanks, BN > >Also, check out this blog: > > > >http://www.talkingtree.com/blog/index. > cfm?mode=entry&entry=40F4C7EA-45A6 > >-2844-7D0C4841EA190125 > > > >~Brad > > Brad, > > The link you provided was first on a google search, also yes I I > checked all of the CF admin setting and they are the same. > > I'm still reading over the TalkingTree.com article, that's where I > learned about the new drivers. I'm just loath to patch one box, but > not need to patch another. Breaking the prod box would not make my day > at all.. ;) (I'm hell bent on keeping the boxes as close to the same > as possible.) > > I've determined I need to put CFMX7-SP2 on the dev server as well as > prod, so I'm going to take a shot in the dark on that one. > > Thanks for your thoughts, > > BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Kind of OT: CF staff learning Java - need advice
Currently we have a staff of 8 coldfusion developers and there is a new need from our customer to start supporting Java applications. For those of you that have coldfusion experience and then moved to Java which of the following 2 scenarios would you find to be most productive during the SECOND week of java development. 1) 1 week of Java training from a vendor 2) 1 week of on the job training, a book of your choice and assigned a java mentor to ask any questions Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| 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:286485 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe Nails ColdFusion Cofin
"working w/the government here, i hear a lot of really dumb ideas." Where are my tax dollars going. Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Paul Hastings <[EMAIL PROTECTED]> 07/30/2007 08:36 PM Please respond to cf-talk@houseoffusion.com To CF-Talk cc Subject Re: Adobe Nails ColdFusion Cofin Charles E. Heizer1 wrote: > to pay twice that just to do supported Oracle connectivity. We are an > enterprise and when I discussed this with management they came back and said > we should just invest our time in ASP.NET. We can retrain our developers, and > not worry about buying upgrades and we'll get new features as they come out. your "enterprise" shop will pay to re-train developers but not an extra $2000 for their app server? geez, that's the stupidest thing i've heard in a long while and working w/the government here, i hear a lot of really dumb ideas. ~| 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:284949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Fw: Error parsing the form under encoding - UTF-8 - resolved
If anyone wants to know what was causing the issue it was this set of code: Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. - Forwarded by Casey C Cook/GTS/CSC on 07/16/2007 03:39 PM - Casey C Cook/GTS/CSC 07/13/2007 04:02 PM To CF-Talk cc Subject Error parsing the form under encoding - UTF-8 - still stumped It appears the debug template is having issues? [0]coldfusion.runtime.CFPage$FormParsingIOException: Error parsing the form under encoding - UTF-8. at coldfusion.runtime.CFPage.SetEncoding(CFPage.java:887) at cfclassic2ecfm1115156690._factor18(C:\CFusionMX7\wwwroot\WEB-INF\debug\classic.cfm:17) at cfclassic2ecfm1115156690._factor26(C:\CFusionMX7\wwwroot\WEB-INF\debug\classic.cfm:10) at cfclassic2ecfm1115156690.runPage(C:\CFusionMX7\wwwroot\WEB-INF\debug\classic.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:72) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. - Forwarded by Casey C Cook/GTS/CSC on 07/13/2007 04:01 PM - Casey C Cook/GTS/CSC 07/12/2007 12:05 PM To CF-Talk cc Subject Error parsing the form under encoding - UTF-8 I ran into an error on cf 6.1 identified below, and it was corrected by adding the following to the form tag. Now we have migrated to cf7 and the error has resurfaced. There was suppose to be a hotfix which addressed this issue, but we applied it to the dev server with no success. One of my co-workers stated the error went away when debug was turned off (unverified). Any thoughts on this subject? Error in cf7: 500 Error parsing the form under encoding - UTF-8. Error parsing the form under encoding - UTF-8. Fix in cf 6.1: added the following to the form tag enctype="multipart/form-data" Thanks,
Error parsing the form under encoding - UTF-8 - still stumped
It appears the debug template is having issues? [0]coldfusion.runtime.CFPage$FormParsingIOException: Error parsing the form under encoding - UTF-8. at coldfusion.runtime.CFPage.SetEncoding(CFPage.java:887) at cfclassic2ecfm1115156690._factor18(C:\CFusionMX7\wwwroot\WEB-INF\debug\classic.cfm:17) at cfclassic2ecfm1115156690._factor26(C:\CFusionMX7\wwwroot\WEB-INF\debug\classic.cfm:10) at cfclassic2ecfm1115156690.runPage(C:\CFusionMX7\wwwroot\WEB-INF\debug\classic.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:72) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. - Forwarded by Casey C Cook/GTS/CSC on 07/13/2007 04:01 PM - Casey C Cook/GTS/CSC 07/12/2007 12:05 PM To CF-Talk cc Subject Error parsing the form under encoding - UTF-8 I ran into an error on cf 6.1 identified below, and it was corrected by adding the following to the form tag. Now we have migrated to cf7 and the error has resurfaced. There was suppose to be a hotfix which addressed this issue, but we applied it to the dev server with no success. One of my co-workers stated the error went away when debug was turned off (unverified). Any thoughts on this subject? Error in cf7: 500 Error parsing the form under encoding - UTF-8. Error parsing the form under encoding - UTF-8. Fix in cf 6.1: added the following to the form tag enctype="multipart/form-data" Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283700 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Error parsing the form under encoding - UTF-8
I ran into an error on cf 6.1 identified below, and it was corrected by adding the following to the form tag. Now we have migrated to cf7 and the error has resurfaced. There was suppose to be a hotfix which addressed this issue, but we applied it to the dev server with no success. One of my co-workers stated the error went away when debug was turned off (unverified). Any thoughts on this subject? Error in cf7: 500 Error parsing the form under encoding - UTF-8. Error parsing the form under encoding - UTF-8. Fix in cf 6.1: added the following to the form tag enctype="multipart/form-data" Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283608 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Annoying Dreamweaver error
I have seen this error, in our case it seems to hang on index.cfm for some of our older applications. Im not sure if its related to file size, or the fact that the person tried to mimic fusebox in a non fusebox app and its trying something in the background to do something with all the files it has references to. Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Billy Cox" <[EMAIL PROTECTED]> 05/08/2007 06:44 AM Please respond to cf-talk@houseoffusion.com To CF-Talk cc Subject Annoying Dreamweaver error When saving a file, Dreamweaver sometimes churns for a while and then gives the following error message: "A script in file c:\Program Files\Macromedia\DreamweaverMX\Configuration\Translators\TMCallback.js has been running for a long time. Do you want to continue?" Has anyone seen this error and/or know the fix? I didn't find anything meaningful on Google. I am using Dreamweaver 8 with validator set to HTML 4.0 and CFMX 7. ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277669 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cflogin issue with cf7
When using the cflogin tag on MX 7 we have to use the following code, otherwise, we throw a "String index out of range: -1" error. Anyone have any insight on this ? The error does not appear if we disable netegrity siteminder rules, which basically say prompt on any folder you hit. Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF7 / oracle 10g migration woes
Some more information on 2) When a folder is protected by netegrity - siteminder, the cflogin tag throws the "String index out of range: -1". If we remove protection on the folder then the cflogin tag works fine. What gives? What does the cflogin tag do that could be causing a failure when protected by netegrity siteminder? Ive read a lot of infromation about how there are now some functions that are no longer usable because MX doesnt have a built in licensed copy of siteminder, but even if your not using those functions, the cflogin tag is blowing up. Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. - Forwarded by Casey C Cook/GTS/CSC on 02/14/2007 04:34 PM ----- Casey C Cook/GTS/CSC 02/12/2007 05:45 PM To cf-talk@houseoffusion.com cc Subject CF7 / oracle 10g migration woes I have two scenario's, one we have figured out, one we havent. 1) Figured out: When using the cfstoredproc tag and doing a select query in a package/procedure which returns more than 46 columns, the CF 7 server spins off into never never land. If you push it by hitting the URL several times, you can crash the server. If you use cfquery everything works fine, so our immediate solution was to re-write these into coldfusion templates. Has anyone else seen this issue? test cases: cf6 and oracle 9 - all good cf6 and oracle 10g - I forget cf7 and oracle 9 - off to never never land cf7 and oracle 10g - off to never never land So we concluded, it was most likely the cf7 server and NOT the oracle 10g. 2) Currently trying to figure out: when using the cflogin tag in CF6 everything works fine, in CF7 Im getting "String index out of range: -1". The cflogin tag just doesnt work. Any ideas ? Server Product ColdFusion MX Version 7,0,2,142559 Edition Enterprise Operating System Windows 2003 OS Version 5.2 Thanks, Casey Cook This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF7 / oracle 10g migration woes
Im using an oracle datasource. macromedia.jdbc.oracle.OracleDriver is 3.50 macromedia.jdbc.db2.DB2Driver is 3.50 macromedia.jdbc.informix.InformixDriver is 3.50 macromedia.jdbc.sequelink.SequeLinkDriver is 5.4 macromedia.jdbc.sqlserver.SQLServerDriver is 3.50 macromedia.jdbc.sybase.SybaseDriver is 3.50 Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Mark Mandel" <[EMAIL PROTECTED]> 02/12/2007 10:00 PM Please respond to cf-talk@houseoffusion.com To CF-Talk cc Subject Re: CF7 / oracle 10g migration woes Casey - what driver are you using? Mark On 2/13/07, Casey C Cook <[EMAIL PROTECTED]> wrote: > I have two scenario's, one we have figured out, one we havent. > > 1) Figured out: When using the cfstoredproc tag and doing a select query > in a package/procedure which returns more than 46 columns, the CF 7 server > spins off into never never land. If you push it by hitting the URL several > times, you can crash the server. If you use cfquery everything works fine, > so our immediate solution was to re-write these into coldfusion templates. > Has anyone else seen this issue? > > test cases: > cf6 and oracle 9 - all good > cf6 and oracle 10g - I forget > cf7 and oracle 9 - off to never never land > cf7 and oracle 10g - off to never never land > > So we concluded, it was most likely the cf7 server and NOT the oracle 10g. > > 2) Currently trying to figure out: when using the cflogin tag in CF6 > everything works fine, in CF7 Im getting "String index out of range: -1". > The cflogin tag just doesnt work. Any ideas ? > > Server Product ColdFusion MX > Version 7,0,2,142559 > Edition Enterprise > Operating System Windows 2003 > OS Version 5.2 > > Thanks, > Casey Cook > > > This is a PRIVATE message. If you are not the intended recipient, please > delete without copying and kindly advise us by e-mail of the mistake in > delivery. NOTE: Regardless of content, this e-mail shall not operate to > bind CSC to any order or other contract unless pursuant to explicit > written agreement or government initiative expressly permitting the use of > e-mail for such purpose. > > > > ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269643 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF7 / oracle 10g migration woes
I have two scenario's, one we have figured out, one we havent. 1) Figured out: When using the cfstoredproc tag and doing a select query in a package/procedure which returns more than 46 columns, the CF 7 server spins off into never never land. If you push it by hitting the URL several times, you can crash the server. If you use cfquery everything works fine, so our immediate solution was to re-write these into coldfusion templates. Has anyone else seen this issue? test cases: cf6 and oracle 9 - all good cf6 and oracle 10g - I forget cf7 and oracle 9 - off to never never land cf7 and oracle 10g - off to never never land So we concluded, it was most likely the cf7 server and NOT the oracle 10g. 2) Currently trying to figure out: when using the cflogin tag in CF6 everything works fine, in CF7 Im getting "String index out of range: -1". The cflogin tag just doesnt work. Any ideas ? Server Product ColdFusion MX Version 7,0,2,142559 Edition Enterprise Operating System Windows 2003 OS Version 5.2 Thanks, Casey Cook This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269596 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
File attachment after user error
Once again Ive run into one of those "seems so easy, yet its so hard" situations. Basically, a user has the ability to attach up to 3 files on a form . If the user throws an error, such as forgetting to input a required field, the form will submit and go through validation.cfm since they didnt pass the validation they will come back to the submission screen. The problem is, I know the user has input/attached a file, but browser security prevents me from populating the input field with the previous entry. Does anyone know a good way around this? I want to keep all the same logic in place, just be able to somehow recognize the user has already made the effort to attach the file and be able to submit that information after they correct their error. So far we have discussed many other solutions which will work, but require a coding effort greater than what should seem so easy - populate the freaking value the user has entered previously. Seems like I run across one of these scenario's once every six months and just wonder why things seem so easy when talking about it, but next to impossible in practice. Ive spent way too much time on this, any input would be greately appreciated. Thanks, Casey Cook This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Invalid Sessions - Baffled
Thanks for the feedback everyone. Dave, I will pass this on to the server admins. /salute Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246470 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Invalid Sessions - Baffled
For the past 4 months we have been experiencing dozens of "invalid session" errors per day. (and just recently reported by users!!!??!!) Ive been doing some reading and one solution was setting a web.xml setting to number equal to some timeout, however, I was told our "server setup" does not use a web.xml file. Other people have posted coding solutions, but outfitting dozens of applications with a piece of code to account for this issue really isnt an option being considered at this point. Some of the posts I was reading are 5 months old of people reporting the same issue, my questions are: 1) Has a hotfix or other permanent solution been found to this problem? 2) What is the definitive cause of this issue? Environment stuff: We are currently running CF Version: 6,1,0,63958 Windows and unix environments Currently J2EE session variables is checked / are being used The error suddenly appeared in the logs on Feb 22nd of 2006 and not a day has gone by without the error since. Sample error from the application log: "Error","jrpp-145","07/13/06","08:22:56","myapp","Session is invalid The specific sequence of files included or processed is: E:\inetpub\myapp\index.cfm " Thanks, Casey Cook This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246457 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam: cf_sql_time vs. cf_sql_timestamp - Pretty much Solved
"CF Ent and CF Std servers are probably using different drivers or versions of the drivers to talk to the Oracle server. If TIMESTAMP works in both then just use it in both." Enterprise (networked environment) is using coldfusion drivers, standard (standalone enviroment) is using oracle drivers is what I was told, so there was a difference. Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223999 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfqueryparam: cf_sql_time vs. cf_sql_timestamp
"CF_SQL_TIME is for temporal data (times), CF_SQL_DATE is for dates, and CF_SQL_TIMESTAMP is for timestamps (datetimes). cheers, barneyb" Thanks for the reply, Im just at a loss as to why CF_SQL_TIME can be used in one environment and it passes in the date/time correctly but in another environment its only passing in the time and uses the date Jan 1, 1900. For a fix I will be using the CF_SQL_TIMESTAMP but having two enviroments act differently with the same code is throwing me off. Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223961 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
cfqueryparam: cf_sql_time vs. cf_sql_timestamp
Hi - Does anyone know the difference between CF_SQL_TIME and CF_SQL_TIMESTAMP when using cfqueryparam on a table insert? We have a situation where we use CF_SQL_TIME and its works fine in one environment, but we migrate to another environment and in order to get the insert to work correctly I have to use CF_SQL_TIMESTAMP. The coldfusion server version seem to be same MX 6.1 except for one is enterprise version and one is not. Im not certain about oracle database versions. Heres the code in question: select sysdate now from dual Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223894 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Any Interest in a Completely Free CFML Calendar?
"It makes me wonder how some of the great open-source projects got started and became popular." Maybe because there were no strings attached. If someone has to think twice about something, you probably already lost most of them. Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Jordan Michaels 10/14/2005 03:28 PM Please respond to cf-talk To: CF-Talk cc: Subject:Re: Any Interest in a Completely Free CFML Calendar? This was our thought as well, and the reason we decided to even attempt this project. The current version of the calendar is installable, and has some really neat features. however, there are a few bugs that need to be fixed and the documentation still needs to be written for it. All in all, a few hundred dollars worth of man-hours still need to be put into it before it's ready to go. That's the difficult part, and the reason we're attempting to determine interest in it. What about the modified MIT license we're thinking about releasing it under? With the addition of the third paragraph, we've essentially made the calendar linkware. Is this too much? We're not asking users to link to the main vivio site or anything commercial. We're simply asking for a link back to the main calendar site. Is this sort of licensing too restrictive to the very liberal MIT license to be useful? As developers, would would this requirement cause you to think twice before using it? The reason we added the third paragraph was because we wanted the effort to grow, but perhaps there's a better way to do this? It makes me wonder how some of the great open-source projects got started and became popular. Thank you all for your input. =) We really appreciate it and please keep it coming! Warm regards, Jordan Michaels Vivio Technologies Andy Matthews wrote: >I would say that there would definitely be interest for something like that. >My thoughts are that CF won't be "more" popular than it currently is until >there's a larger base of "free scripts" out there for people to use. > >andy matthews >web developer >ICGLink, Inc. >[EMAIL PROTECTED] >615.370.1530 x737 >--//-> > >-Original Message- >From: Jordan Michaels [mailto:[EMAIL PROTECTED] >Sent: Friday, October 14, 2005 4:29 PM >To: CF-Talk >Subject: Any Interest in a Completely Free CFML Calendar? > > >For some time now, Vivio Technologies has been debating whether or not >to put forth the effort to complete the development of a completely >free, (under a modified open-source MIT license) CFML calendar >application. The idea was to develop a calendar application that anyone >could do anything they want with, and help support the Cold Fusion >community as a whole. Companies who develop in CFML would have the >ability to -re-design, re-code, -re-brand, re-sell, or whatever else >they wanted to do with the calendar application. The calendar would be >able to run under BlueDragon FREE edition, and use open-source databases >like PostgreSQL and MySQL. That way, no user anywhere would need to pay >for anything more then the cost of hosting in order to deploy the calendar. > >Our question is simple: Would there be any interest in something like this? > >If there is significant interest, Vivio Technologies will make the >investment to complete the project and deliver the calendar. If there is >only a small amount of interest, then we'll quit wasting our time >debating over this project and move on to projects which are of more >value to us and/or the community. > >Please take a moment to visit our current calendar site located at the >following URL: > >http://calendar.viviotech.net/ > >Please understand that the calendar project isn't *quite* finished, but >if there is interest we'll be more then happy to put the finishing >touches (the spit and polish - if you will) on the calendar and make it >available, completely free of charge, to the community. > >We welcome any comments you may have - good or bad. Thank you for >helping us in this decision. > >-- >Warm regards, >Jordan Michaels >Vivio Technologies >http://www.viviotech.net/ >[EMAIL PROTECTED] > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion
Re: Why doesn't this query return more than 1 record?
Our oracle databases are case sensitive, make sure the values are EXACT matches on case and no trailing spaces, etc. When in doubt you can trim and upper to ensure exact matches. Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Ken Ferguson 10/03/2005 10:57 AM Please respond to cf-talk To: CF-Talk cc: Subject:Re: Why doesn't this query return more than 1 record? Sorry, that last one was bad: Select c.*, fg.* From clients c inner join family_groups fg on c.client_family_id = fg.group_id Where c.family_group_id = ( select family_group_id from clients where client_id = #url.client_id# ) Rick Faircloth wrote: >Ok... > >Clients Table >-- >Client_ID >Client_Family_ID (FK for Family_Groups Table) >etc... > >Family_Groups Table >-- >Group_ID > > >There are 4 records in the Clients table...all have >the same Client_Family_ID, which is "1"... > >There is 1 record in the Family_Groups table, >which has the Family_Group_ID of "1"... > >Link is clicked, sending "Client_ID = 1"...(that client >has a Client_Family_ID FK that = "1" > >So, give me all the records where the Family_Group_ID = Client_Family_ID >and the Client_ID = 1 ('#URL.Client_ID#')... > >I think that "Client_ID = '#URL.Client_ID#' is going to >limit the records to 1... > >But how do I get all Clients that have Family_Group_ID's >that match the Family_Group_ID of the Client specified by the >'#URL.Client_ID#' ??? > >I know I've been away from coding for a couple of months...but sheesh! > >Rick > > > > > > > > > >>-Original Message- >>From: Ken Ferguson [mailto:[EMAIL PROTECTED] >>Sent: Monday, October 03, 2005 1:02 PM >>To: CF-Talk >>Subject: Re: Why doesn't this query return more than 1 record? >> >> >>How many records are in each table and what do they look like (just the >>columns in question). The only way I'd see you getting more than one >>record back is if there are several different records in the clients >>table with the same client_id. I'm guessing the tables look >>similar to this: >> >>CLIENTS: >>client_id >>1 >>2 >>3 >> >>client_family_id >>123 >>456 >>789 >> >>FAMILY_GROUPS >>group_id >>123 >>456 >>789 >>group_name >>smith >>james >>johnson >> >>So, when your url.client_id variable equals 1, you're going to get >> >>client_id = 1, fg.group_id = 123, fg.group_name = smith >> >>Am I missing something here >> >> >> >> >> Select FG.Group_ID, FG.Group_Name, >> C.Client_ID, >> C.Client_First_Name, C.Client_Middle_Name, >> >> >> >> >C.Client_Last_Name > > > > >> from Family_Groups FG, Clients C >>where FG.Group_ID = C.Client_Family_ID >> and C.Client_ID = '#URL.Client_ID#' >> >>Rick >> >> >> >> >> >> >> >> > > >>> >>> >> >> > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219946 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Quick easy custom tag question
Thanks for the responses! Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "S. Isaac Dealey" 08/04/2005 09:32 PM Please respond to cf-talk To: CF-Talk cc: Subject:Re: Quick easy custom tag question > If a custom tag has been changed and deployed to a > production enviroment > but has the old version cached is there a way to force it > to recognize the > new version without restarting the server to clear cache? Hi Casey. If it's a CFML tag, check the ColdFusion directories for a directory containing a bunch of .class files which resemble the names of the templates in your application. One of those files is generated from your custom tag. You can delete just the tag you're having a problem with, if you can isolate it by name, but I generally just delete them all -- they're all created when the CFML file is compiled anyway. I never had a problem with this until recently -- the servers at my day job have had this problem a couple times. Of course, this may not be your problem, but it's a possibility. Apparently sometimes CF gets confused and doesn't see that there's a newer version of the CFML template, so it doesn't delete and recreate the class file. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213914 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Quick easy custom tag question
If a custom tag has been changed and deployed to a production enviroment but has the old version cached is there a way to force it to recognize the new version without restarting the server to clear cache? Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213800 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: anyone bored?
http://www.charliesflybox.com/flybox/detail.cfm?parentID=90 Came up perfectly in about 1 second. Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203079 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: anyone bored?
"has anyone gone to a page on there where there is a flash form like http://www.charliesflybox.com/contact/index.cfm and if so do you see it ok?" Mine came up perfectly in about 2-3 seconds. Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203078 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Ideas - Your Help Needed
We had a situation where a manager would enter a pay increase for employee A but it would save the record into employee B record. Basically what was happening is they would enter employee B make some changes to the form, change their mind, click the back button a couple times to employee A record and hit submit. Well, the session information from employee B was still hanging around and was insert into employee A record. Maybe something like this could have occurred, he entered a different name, changed his mind went to a different screen and saved some form contents and it saved the bogus name. Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Gavin Brook" 03/18/2005 08:59 AM Please respond to cf-talk To: CF-Talk cc: Subject:RE: Ideas - Your Help Needed No, the key is unique and not editable. The transactions are all complete. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 March 2005 15:37 To: CF-Talk Subject: RE: Ideas - Your Help Needed Just as a check I may have misunderstood but are you allowing end users to update the key in the database? Also is everything that needs to be in a transaction definitely in a transaction? Kola > -Original Message- > From: Gavin Brook [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 13:08 > To: CF-Talk > Subject: RE: Ideas - Your Help Needed > > Definitely. I have reviewed my code and had other developers review it > too, just to be sure. > > Is there any possibility of CFMX or SQL doing this?? I've searched and > cannot find anything. > > -Original Message- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 13:03 > To: CF-Talk > Subject: RE: Ideas - Your Help Needed > > > Stay away from accusations, say that all the evidence points to a > mistake on their part.This way they may be less defensive. Also double > check that your > code is solid. > > Ade > > -Original Message- > From: Michael Traher [mailto:[EMAIL PROTECTED] > Sent: 18 March 2005 12:52 > To: CF-Talk > Subject: Re: Ideas - Your Help Needed > > > If your client contact is non technical, you may just need to talk > them through the evidence very carefully so they can understand the > sequence of events as you do. > > Maybe you could should them as example of entering data and changing > data and then show them the log records that are created from the > example. > > Mike > > > On Fri, 18 Mar 2005 12:42:01 -, Gavin Brook > <[EMAIL PROTECTED]> > wrote: > > Hi All, > > > > I've got a little bit of a problem and I hope that you guys would > > be able to give me advice or shed a little light on a situation I > > have > > > > The Setup > > 1xApplication Server > > - Windows 2003 Web Edition > > - CFMX 6.1 Standard, all patches > > > > 1xDatabase Server > > - Windows 2003 Standard Edition > > - SQL Server 2000 SP3a > > > > This setup is running an application that our company wrote to store > > data relating people. This information is entered through a dynamic > > form which > is > > configured through an admin interface. The whole application has > > been developed using Mach-II. The system has been live for a year > > now and was thouroughly tested by all parties before go live. There > > have been a couple of bugs since, but the code has been unchanged > > and stable for at 8months now. > > > > The problem is this. We have been getting reports of "data > > corruption" on > a > > very small number of forms. I have investigated this "corruption". > > The system logs who made what changes to the system to provide an > > audit trail for each form. The audit trail shows users have made the > > "corrupt" changes to the form and I presented this to the client. > > They will not accept this response. I'll give you an example, a name > > had been changed from one to another. I checked the live database > > and a backup and they both show that > a > > user changed the name. The user insists that he did not change the > > name. > > > > I cannot see in light of this evidence and problem with my code or > > the system. My question to the forum is basically, is there anything > > I'm missing? > > > > Sorry for the longwinded explanation, but I feel like I'm banging my > > head against a wall! Any ideas you might will be greatly > > appreciated. > > > > Thanks in advance, > > > > Gavin > > > > > > > > > >
Re: Okay, I've never quite run into this before...
I just wanted to mention one other thing. Statements like the below dont fly. You either need to have the customer define the requirements or you come up with a list of solutions and have them pick the best option or a combo of the options, but if you do not get buy-off on the customer expectations of what they will be receiving your setting yourself up for many headaches. For the customer to say do it and make it work leaves the door wide open for them to come back and say they dont like what you gave them and do it all over, or as they see you heading down a path they can change directions on you. ""whatever it needs to do or however it needs to work, I just wanna be able to do that..." Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Jeff Small" 01/20/2005 08:47 AM Please respond to cf-talk To: CF-Talk cc: Subject:Okay, I've never quite run into this before... It's not an odd request, just something that seems probably a little more complex than it initially appears, and I just want to make sure I'm heading in the right direction, design-wise. Client has an events calendar, dates, events, details (text), possibly an image all kept in the appropriate tables in the database. Client also has a table that keeps track of artists (It's a little local pro-bono arts council) with information about the artist, their gallery, contact info, etc...point being, VERY different data than the events. Client wants an area on the home page for featured events OR artist. In other words, when there's nothing important going on, swap an artist's info there, with links to some images of their work, etc. I've got the isFeatured flags in each table, one in the artists table, and one in the events table, so an event or an artist could be flagged, but it brings up a lot of questions. Like, where does the integrity reside for making sure that there can only be one event OR one artist that's flagged as currently active? Do you want to have to UNflag an event or artist before you can flag another one? Does the flagging of an event as "featured" automatically unflag an artist? The client says, "whatever it needs to do or however it needs to work, I just wanna be able to do that..." I'm doing this whole thing with CFCs, so the solution is obviously to write a CFC or series of CFCs to handle it all, but I was wondering what my pitfalls were and what was a good way to handle different types of results coming back for what's essentially a query that says, "give me this, if it's an event and it's active, or give me this if it's an artist and it's active, and it'll be different data depending on which one it is"? I was thinking, "return a struct from the CFC, and use a variable in the struct that's set in the CFC to determine what kind of data the struct is returning"...something along the lines of (pseudo): "It's an artist, display their info" "It's not an artist, it's an event, display that info" And have all the checking done in the CFC by querying the tables to see which one contains an active "featured" event or artist. Does this make sense? Is it a lot easier than I'm thinking? I've just never run into the "only one set of data from a possible query of two different places" scenario... ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191219 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Okay, I've never quite run into this before...
Does the customer want a maintenance task of updating flags? If not then they could determine up front a date range for which the event will be shown on the homepage and lets say you can have up to 5 slots. The homepage will show all events which are in the valid date range compared to todays date and if any slots are left over it then checks the artists table for flagged artists info and date ranges. In the rare case that more than 5 events are active at more than one time you could have priorities assigned to events or just randomly select 5 events to display each time the homepage is hit. The path I try to take is to have the customer enter the data one time and then forget about it. If they need control on a daily basis of whats displayed and in what order etc, then it sounds like you are going down the right path. The user would have to check x flags for the events and the remaining y flags for the artists such that all 5 slots will be displayed. Thanks, CC x56927 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Jeff Small" 01/20/2005 08:47 AM Please respond to cf-talk To: CF-Talk cc: Subject:Okay, I've never quite run into this before... It's not an odd request, just something that seems probably a little more complex than it initially appears, and I just want to make sure I'm heading in the right direction, design-wise. Client has an events calendar, dates, events, details (text), possibly an image all kept in the appropriate tables in the database. Client also has a table that keeps track of artists (It's a little local pro-bono arts council) with information about the artist, their gallery, contact info, etc...point being, VERY different data than the events. Client wants an area on the home page for featured events OR artist. In other words, when there's nothing important going on, swap an artist's info there, with links to some images of their work, etc. I've got the isFeatured flags in each table, one in the artists table, and one in the events table, so an event or an artist could be flagged, but it brings up a lot of questions. Like, where does the integrity reside for making sure that there can only be one event OR one artist that's flagged as currently active? Do you want to have to UNflag an event or artist before you can flag another one? Does the flagging of an event as "featured" automatically unflag an artist? The client says, "whatever it needs to do or however it needs to work, I just wanna be able to do that..." I'm doing this whole thing with CFCs, so the solution is obviously to write a CFC or series of CFCs to handle it all, but I was wondering what my pitfalls were and what was a good way to handle different types of results coming back for what's essentially a query that says, "give me this, if it's an event and it's active, or give me this if it's an artist and it's active, and it'll be different data depending on which one it is"? I was thinking, "return a struct from the CFC, and use a variable in the struct that's set in the CFC to determine what kind of data the struct is returning"...something along the lines of (pseudo): "It's an artist, display their info" "It's not an artist, it's an event, display that info" And have all the checking done in the CFC by querying the tables to see which one contains an active "featured" event or artist. Does this make sense? Is it a lot easier than I'm thinking? I've just never run into the "only one set of data from a possible query of two different places" scenario... ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191218 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Browser Stats (stirring the pot)
"I install firefox on almost everyones computer that I have to run spybot on (non-techies). Then I change the Icon to the "E" and they are none the wiser." Thats classic, gave me a good chuckle on a Monday morning. Thanks, CC x56927 ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186324 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT? Passing comma delimited list to where clause in stored procedure
I have a comma delimited list returned from a multi select field on my input form. I then take the list and use the following code: ListQualify(#form.TypeofPets#,"'",",","ALL") which gets the user selected result set such as the following: 'Dogs','Cats','Horses' I then pass this variable into a stored procedure: The stored procedure query looks like the following: select pet_stuff1, pet_stuff2 from mypettable where pet_type in (inTypeOfPets) The problem is even though my input string looks like 'Dogs','Cats','Horses' the ticks are getting stripped out of the variable (Dogs,Cats,Horses), how do I retain the ticks? inTypeOfPets is defined as a varchar2. Im using CF MX and oracle 9.2. Thanks in advance for your help. Thanks again, Casey Cook ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182894 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF developer numbers
"a good one its like when i am trying to get the flashblog moved over too cfm too try and help our community and nobody helps out. It aint just gunna happen, get behind it and inform ppl" mm hmm CC ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182107 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF developer numbers
What kind of response is that? "Rey, What are you doing to better the situation near you? ~Simon Simon Horwith Member of Team Macromedia Macromedia Certified Master Instructor Editor-in-Chief, ColdFusion Developers Journal Blog - http://www.horwith.com CC ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182100 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: why can't they log in?
Are you saying you can log into the application from your PC using their username and password, but the user cant log in from their location? Thanks, CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Comparing a list against an 2 element array? - Update
Ok, so I can write a union statement to get unique violation combinations, now the only piece I lack is to be able to pass in a list of values to a function or something and get returned all the unique combinations. Then I can compare the unique combinations to the union query results and find my violations. Anyone know where I can find a function to pass in a comma delimited string of values and get all the unique combinations returned? Thanks for listening. Casey Cook --- This request has blown me away, I cant get my hands around it. The current user roles lists all the roles the user is in. The 2 element array is combinations of roles which are not allowed. The end result is the user will be removed from the roles which conflict. I dont really know where to start on this one. Has anyone done anything like this or know where to look? please see below. Current User roles 1 2 4 6 7 Invalid Combinations Element1Element2 1 2 2 1 3 3 7 5 9 6 4 6 So, if I look at the data the user is currently in 3 invalid combinations of roles. (1 and 2) (2 and 1) and (4 and 6) Thanks, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Comparing a list against an 2 element array?
This request has blown me away, I cant get my hands around it. The current user roles lists all the roles the user is in. The 2 element array is combinations of roles which are not allowed. The end result is the user will be removed from the roles which conflict. I dont really know where to start on this one. Has anyone done anything like this or know where to look? please see below. Current User roles 1 2 4 6 9 Invalid Combinations Element1Element2 1 2 2 1 3 3 4 6 5 7 9 8 So, if I look at the data the user is currently in 3 invalid combinations of roles. (1 and 2) (2 and 1) and (4 and 6) Thanks, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ;amp in my URL's?
--- AAARGH! That foul beast dares rear its head again!?!! (read with pirate voice and one eye squinted shut) I had/have this exact same problem. The site I work on has two sides: one that I manage, using CF, and the other that someone else manages, using any number of technologies, including Lotus Notes. The sign-in/registration system that I designed runs over the entire site, so the two sides have to play nice together. Because the other side doesn't use CF, I had to do some trickery. This trickery involves (among other things) _javascript_ code that sits on that other side, and which bounces users who aren't signed in over to my side. Of course, in doing this, I want to be sure that I can route users to their desired location after the sign-in. To do this, I place their desired URL into a URL variable. Here's where things fall apart. I can't remember exactly which part causes the error, but the idea is that some bit of it all (the browser, the _javascript_ code, something) converts those nice & characters to their HTML equivalents (&) and all hell breaks loose. As I remember it, the problem was even more complicated in that even if I got it through the first step, it might get fouled up at the second step (when I send the user back). Bottom line (ugly bottom line): my solution was to stop trusting the various bits that were converting the ampersand character into its equivalent and back. At the very start of the process, I replace all ampersands with the lovely string QQQampQQQ. At the very end of the process, I reverse the process, replacing QQQampQQQ with ampersands, and redirect to that address. I readily admit that there must be a better way. That said, I caution you against spending too much time finding it. As I remember it, the reason I went this way was that--while I could get it to work in one scenario--the various possible cases got rapidly complicated, and it was much easier to convert the string immediately into something that would be preserved regardless of which automatic conversion it was going through. All that said, can I help you at all? I would make sure I know the process from end to end: where does the URL begin its life as a variable, and where does it end that life. If you can't figure out an easy way to fix it, do the ugly trick above. HTH, Matthieu -- Thanks for the responses, we are still looking into the issue. So far we have potentially found a workaround with the code below. In the event I cant find the exact cause the work around should work, I guess I will find out soon enough. Hopefully the error reports disappear when I come in tomorrow morning. I still have some users to talk to tomorrow, hopefully our discussions narrow the search. url[urlField]> Thanks, CC x56927 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ;amp in my URL's?
This is a link clicked from lotus notes, the URL string is the link itself in the email. (there is not a cflocation) Also, its not a spider, these are actual users I talked to on the phone and walked through all the steps to reproduce the error. They throw the error when clicking the link and I do not. There is something different about their browser settings or computer settings that places the ;amp in the URL string, Im not sure what it could be. Thanks, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
;amp in my URL's?
Im trapping a few errors per day which means probably 1-1000 users (or more) is experiencing this problem, and not sure what could be causing it. Basically if I look at the cgi.query_string it shows fuseaction=DisplayNews&ContextID=MSA&ID=4324&GBT=Main vs. what it should be fuseaction=DisplayNews&ContextID=MSA&ID=4324&GBT=Main What would be placing amp; in my URL strings? I simulated the exact steps as the user but did not throw an error message. We are both clicking the link from same version of lotus notes, launching the same version internet explorer external from lotus notes. Im almost sure this is some sort of setting in the broswer or on the computer, unrelated to the application itself. Any insight would be appreciated. Thanks, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Completely baffled...
Im struggling to remember, but I think when I saw this error I had different tables structures between development and production. I think at the time I was doing an insert and 2 fields were swapped so I was throwing that error. Thanks, CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Brain Fart...GetTemplatePath(), I don't want it *all*
CGI.Script_name ? Thanks, CC x56927 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Kill a Session when User Leaves
Here is the code I use, no reports of errors as of yet. Thanks, CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Date, Ignore time
Or maybe Left(Getdate(),11) Thanks, CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Date, Ignore time
trunc ? Thanks, CC x56927 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfloginuser not logging in user
I thought I read another thread that said the getauthuser() is not "defined" until you exit cflogin. Thanks, CC x56927 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Exactly *how* smart are we?
and common sense. >and experience! >Surely it would be interesting to know how one stands against their peers. >Frankly though, I couldn't be bothered to take the test because it seems >like an annoying and tedious task. Besides, I figure there are plenty of >people more intelligent than me. Of course, I am not sure intelligence >beyond a certain point it all that valuable. Beyond a certainly level of >intelligence it seems like other attributes become more important such as >hard work, cleverness, and knowledge. > >-Matt > >> Thanks, CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Can't Update more than 13 records - Datatype Mismatch Error - HELP!
You forgot a , (comma) after this entry terminationdesc = '#Form.terminationdesc#' Thanks, CC x56927 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
java.lang.NullPointerException ???
Hello, I have a stored procedure which runs fine, however, when I change returncode from "no" to "yes" I get the following error message: "java.lang.NullPointerException" returncode="YES"> Basically I wanted to try see if any errors were going to be thrown with the stored procdure call, and if not, run another set of code. A coworker recommended I use cfcatch and cftry, well I tried that and the code seems to execute but the stored procedure does not update the database. Any ideas? Thanks, CC x56927 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: HELP! Forgot cfadmin password
I forgot the administrator password on my local machine and deleted the coldfusionmx/lib/password.properties file and it reset the password to "admin". Im not sure if this will work in all cases but it worked for me. Thanks, CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: locking user out after 3 incorrect attempts to log in
As log as it just kicks the user off the login screen I wouldnt mind. What I really dislike is 3 failed attempts and you have to call a helpdesk or send e-mail or whatever to have your account "reactivated" such that you can try to login again. Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Netegrity/Siteminder
Does anyone know why when siteminder intercepts a URL that it would be putting a $SM$ after the target= These extra characters $SM$ are causing the template not to be found. I can remove those characters from the URL and hits the site fine. TARGET=$SM$http%3a%2f%2fmy%2eurl%2eintranet%2ecom%2fmy%2ffolder%2findex%2ecfm%3ffuseaction%3dMyHome Thanks, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Javacript Onclick Question - closing it
Thanks for the replies Barney. Im not getting this code to work, but then again Im just kindof hacking at the _javascript_. I think you got me 90 percent of the way there, I know what your trying to do with the code below, but just not sure how exactly to implement it. I appreciate your help. =) "This code will do it for you. You can obviously change the function definition to whatever you need. for(i=0;i if (document.links[i].href.indexOf("fuseaction=LogOff") >= 0) { document.links[i]. { return confirm("are you sure you want to log off?"); } } }" Thanks, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Javacript Onclick Question - Getting Closer
I found some code that identifies the links in my document. function describeLinks(){ outputWindow.document.write("Links") outputWindow.document.write("This document contains "+document.links.length+" links:") for(i=0;i outputWindow.document.write(document.links[i].href+"") Using this code identified the following link: http://myserver:myport/test/index.cfm?fuseaction=LogOff Now, how might I write the code to for the following logic. If you find the link text "fuseaction=LogOff" then onclick "pop up a confirmation window". Looks like were headed down the right path. Thanks! Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: Javacript Onclick Question
I would like to know if this is possible, I know very little about _javascript_, but if if someone could point me in the right direction I can do the research. Heres what Im trying to do. I have my main display page which calls a custom header. This custom header has an link that logs the user off when clicked. What I want to do now is to add a pop-up box that prompts the user to confirm that they are logging off. Heres the kicker, I cant modify the customer header, so how do I write _javascript_ from my main display page to add the pop-up box on the link in the custom header? Thanks for you help! Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: World Wide Web Publishing Service - Solved Somewhat
We changed the service recovery first and second failure to "restart the service" and this seems to have corrected the situation, although I will probably never know the real reason this was happening. The other option which we did not use was to find a way to set dependencies for the WWWPS so that it would not start until coldfusion services had started. I installed my Macromedia Coldfusion MX on my local machine yesterday after IIS. (Windows 2000 professional) The coldfusion administrator worked fine yesterday and when I logged in today the administrator quit working. A co-worker of mine suggested I make the service World Wide Web Publishing Service "manual" and to reboot then go into services and "start" it up. Well, it worked, the administrator is back, so my question is why cant the World Wide Web Publishing Service not be left on "automatic" ? Has anyone else seen this type of behavior ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
World Wide Web Publishing Service
I installed my Macromedia Coldfusion MX on my local machine yesterday after IIS. (Windows 2000 professional) The coldfusion administrator worked fine yesterday and when I logged in today the administrator quit working. A co-worker of mine suggested I make the service World Wide Web Publishing Service "manual" and to reboot then go into services and "start" it up. Well, it worked, the administrator is back, so my question is why cant the World Wide Web Publishing Service not be left on "automatic" ? Has anyone else seen this type of behavior ? Macromedia Coldfusion MX Thanks, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Spam Farmers have arrived
This happened to me many months ago (and continues), unfortunately the e-mail address I use for cf-talk is my work e-mail, its probably to late to change it to make any real difference now in spam traffic. CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Query
Why index on integer fields and date fields only ? CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Embedding an image in cfmail
Using CFMX currently. So what Im hearing is use and its possible. We have been unable to get it to work as of yet. Thanks for the responses. CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Embedding an image in cfmail
Heres the source code which is using the but the image does not come back. FROM="#ENUM_THIS_REPORTER.REPORTER_EMAIL#" SUBJECT="#ENUM_CONTEXT.CONTEXT_ID# Daily News Summary text"> Read 7C252360672B03A0BAD013A5 Content-Type: image/gif; name="#ContextID#test.gif" Content-Transfer-Encoding: base64 Content-ID: <[EMAIL PROTECTED]> file="#expandpath("emailImages\")##ContextID#test.gif" variable="charData"> #data64# 7C252360672B03A0BAD013A5-- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Embedding an image in cfmail
Does anyone have a quick example of code that will embed an image in a cfmail ? I want the output to look something like My cruise pics See this nice image! (IMAGE1) See this nice image! (IMAGE2) See this nice image! (IMAGE3) Thanks for your assistance, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: SQL HELP
The ID your using have permissions on the table? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Fw:Why woudl I receive this message? Profanity? WTF?
Probably because your e-mail address contains the word "lick". (<[EMAIL PROTECTED]>) LOL. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Access to SQL
Ensure proper size/length of the destination field. If both data elements are treated as strings at source and destination and the destination length is sufficient, Im not sure what the cause may be. CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Fancy a ColdFusion Challenge?
Im not that creative, I give up, lol ! CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Fancy a ColdFusion Challenge?
I figured someone would post this response. Typically I just need a place to start, this doesnt take any creativity out of it, is just starts the process of creative thinking. Ever ask consult a coworker about a problem you've run into with code, not expecting them to have the answer, but something that you can take away from the conversation that will help your thinking arrive at a solution? CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Fancy a ColdFusion Challenge?
I second this. Any samples available? CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MS-SQL 2000 NULL Problem
Try <> "" CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Fusebox - whats the big deal anyway?
If your not going to answer the question, feel free not to respond. I too am interested in the "why". CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ot: requirements for cf projects
I dont have outside clients, but have internal clients that pose questions during requirements meetings like "How long will this take". I have learned a standard response to any question I am not willing (willing meaning I dont have enough information to respond accurately) to respond to at the moment is "Anything is possible with enough time and money, but let me go back and anlyze what you have asked for and come up with what approaches we can choose from and how much each approach will cost in time/labor." This way I am not committing myself to some verbal estimate given in a meeting/phone call with 5 seconds to think about all the angles of the requirements. As far as the sales person calling, I dont think its the best approach to use, but it wont matter that he calls if you use a standard reponse. About the only information I give out "on the spot" is "It sounds doable" then respond with "standard response". This is how I have learned to deal with those situations and keep myself out of hot water. I have been burned a few times by the customer calling directly and then quoting my responses to my management, so I no longer give out any information until I have done proper analysis. In summary: If your the type of person who feels compelled to give a detailed answer (and possibly held to those details) when put on the spot, then absolutely the sales person did the wrong thing and that sales person should be asked not to call you during development hours for "on the spot" answers. The chain of events should be as you described, sales gather requirements, you analyze requirements, sales informs customer of your findings. If your the type of person, like me, who uses a standard response when asked "on the spot" questions which may lead to unintentional financial/time commitments, then it doesnt matter of the sales person calls once per hour. The chain of events will still be as you described, sales gather requirements, you analyze requirements, sales informs customer of your findings. This is only my opinion. Thanks, CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Dumb Question
Probably something like 'contact'> Thanks, CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Symbolic links treated differently? - SOLVED
Thanks for the reply Barney. Its nice to know the source of the issue. Thanks, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Symbolic links treated differently?
Hello - Just a quick question regarding cf_template_path and path_translated variables in CF 4.5 vs MX 6.1. We currently have both CF versions running on the same web server (Solaris 2.7 UNIX) but the values returned in the variables mentioned above is different, even though the "environment" and database has not been changed. Does MX somehow treat symbolic links differently and yield different values in the cf_template_path and path_translated variables? Is there a setting that might have been missed in the MX 6.1 set-up (doubtful, but possible) ? Im submitting this question for a co-worker, if you need more information i can provide it. Thanks much, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Puzzle?
You might need to you the AS SELECT A.COMPANY_ID, A.COUNT(APPLICANT_ID) AS APPCOUNT,B.COUNT(DEAL_ID) AS DEALCOUNT FROM APPLICANTS A, DEALS B WHERE A.COMPANY_ID = B.COMPANY_ID GROUP BY A.COMPANY_ID CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Puzzle?
Does this work? SELECT A.COMPANY_ID, A.COUNT(APPLICANT_ID),B.COUNT(DEAL_ID) FROM APPLICANTS A, DEALS B WHERE A.COMPANY_ID = B.COMPANY_ID GROUP BY A.COMPANY_ID [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: sql question pt 2
I have never been able to reference a name I have assigned to a column in the where clause. Also, In an SQL book I have it says "The use of a HAVING clause without a corresponding GROUP BY clause is almost never seen in practice". (LAN TIMES Guide to SQL) I would agree with J E VanOver with the following: SELECT count(tony) as tonysCount, sum(jayme) as jaymesCount from orders WHERE Abs((count(tony)-sum(jayme))/count(tony)) > 0 Thanks, CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Computer Desk for Multiple Monitors...
I dont see that desk anywhere on the site, can you link it? Not listed in master products list that I can find http://www.ikea-usa.com/webapp/wcs/stores/servlet/ProductsAZView?storeId=12&catalogId=10101&langId=-1&letter=E CC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Mail spooling issue
FYI - we can start with finding the offending process which locks the file, then go from there. This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. - Forwarded by Casey C Cook/ASD/CSC on 09/18/2003 09:15 AM - Chuck Stenson /GIS/CSC 09/18/2003 06:15 AM To: Casey C Cook/ASD/[EMAIL PROTECTED] cc: Elvia Casarez/ASD/[EMAIL PROTECTED] Subject:RE: Mail spooling issue Thanks Casey I use a program called Handleex to find and stop the process that is holding the file, to prevent a reboot. Chuck Stenson Computer Sciences Corp. Sr. Member Resource Mgmt. Technical Staff This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Casey C Cook /ASD/CSC 09/17/2003 04:27 PM To: Chuck Stenson/GIS/[EMAIL PROTECTED] cc: Elvia Casarez/ASD/[EMAIL PROTECTED] Subject:RE: Mail spooling issue This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. - Forwarded by Casey C Cook/ASD/CSC on 09/17/2003 02:27 PM - Tom Jordahl 09/17/2003 08:53 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: Mail spooling issue I would encourage *anyone* who is doing email application that need to handle volume to upgrade to CFMX 6.1 Enterprise. This kind of use case is specifically what we targeted the enhancements for. As to the CF5 spool file locking problem, you can certainly fix this by switching to a Unix based operating system. :-( The problem is that windows will not let you move/delete a file being touched by some other 'process'. Have you investigated if there is a Windows patch that fixes problems with this kind of file locking happening 'randomly'? I can certainly believe there is a bug in the CF5 C++ implementation that would possibly not release a file handle properly, but if it only happens every *month* or two, I am not sure how we could have coded something so clever if we had wanted to -- Tom Jordahl Macromedia Server Development -Original Message- From: Michael Wolfe [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 2:44 AM To: CF-Talk Subject: RE: Mail spooling issue > -Original Message- > From: Casey C Cook [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 16, 2003 2:53 PM > To: CF-Talk > Subject: RE: Mail spooling issue > > > > You saw it pop up from time to time, was an effort made come > up with some > sort of prevention? Can it be prevented at the application > level vs the > core CF level. > Any thoughts would be appreciated. > Casey, I used to work for a company that sends approximately 1 billion (yes, billion) emails a month (and yes, they are spammers). The emails are created via a CF application run from the command line that spools the emails to a database. The outbound spooling is handled through a separate application on the mail servers that pulls the emails from the database and fires them out through Sendmail. We learned long ago about the spooling bug in CF5, and also that CF5 is not at all suited to operate as a high-volume mail server. If you continue to experience this bug, my advice to you is to implement a solution such as I have described. You don't have to use Sendmail. There are plenty of small, cheap (or free) mail servers available. My personal favorite is ArgoSoft Mai
RE: Date problem with CFMX and Oracle
Elements plural. Something like: UPDATE myschema.BookInventory SET myschema.Status = 'Checked Out', myschema.CheckedTo = 'rayb', myschema.ChgDate = {ts '2003-09-16 16:08:22'} WHERE myschema.id = 2043 CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ---- Casey C Cook/ASD/CSC @CSC 09/16/2003 04:56 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: Date problem with CFMX and Oracle Try prefixing your query element with the schema name. CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Ray Bujarski" 09/16/2003 04:19 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: Date problem with CFMX and Oracle As mentioned before, I never had a problem b4 I upgraded. But also, my editor doesn't highlight it as it does other reserved words. -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 4:17 PM To: CF-Talk Subject: RE: Date problem with CFMX and Oracle Mm..is Status a reserved word? -Gel -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED] I am trying to do an update to my DB: UPDATE BookInventory SET Status = 'Checked Out', CheckedTo = 'rayb', ChgDate = {ts '2003-09-16 16:08:22'} WHERE id = 2043 This worked fine before, I updated my CFMX server to 6.01 and my JDBC drivers to 1.4, and am now getting column doesn't exist! Does anyone know why this no longer works? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Date problem with CFMX and Oracle
Try prefixing your query element with the schema name. CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Ray Bujarski" 09/16/2003 04:19 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: Date problem with CFMX and Oracle As mentioned before, I never had a problem b4 I upgraded. But also, my editor doesn't highlight it as it does other reserved words. -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 4:17 PM To: CF-Talk Subject: RE: Date problem with CFMX and Oracle Mm..is Status a reserved word? -Gel -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED] I am trying to do an update to my DB: UPDATE BookInventory SET Status = 'Checked Out', CheckedTo = 'rayb', ChgDate = {ts '2003-09-16 16:08:22'} WHERE id = 2043 This worked fine before, I updated my CFMX server to 6.01 and my JDBC drivers to 1.4, and am now getting column doesn't exist! Does anyone know why this no longer works? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Mail spooling issue
You saw it pop up from time to time, was an effort made come up with some sort of prevention? Can it be prevented at the application level vs the core CF level. Any thoughts would be appreciated. Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Dan Phillips \(CFXHosting.com\)" 09/16/2003 02:24 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: Mail spooling issue >From my experience, this was never fixed until 6.1. In 3 1/2 years of working with hundreds of 4, 4.5, and 5.0 servers, I've always seen this pop up from time to time. Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 5:14 PM To: CF-Talk Subject: Re: Mail spooling issue Yes, a restart fixed it, but what caused it? So far I have been reading this is a "known issue" and should just be dealt with as it arises. If there is a known cause then we can find a work-around until Macromedia fixes it. (or use the work around until we upgrade, given I dont think CF 4.5 is supported anymore) Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Howie Hamlin" 09/16/2003 02:02 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Re: Mail spooling issue Looks like the file is locked but is still being sent. A restart of CF might fix it. Good luck, Regards, Howie - Original Message - From: "Casey C Cook" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 16, 2003 4:45 PM Subject: Re: Mail spooling issue > Here is the mail error message, there are thousands of entries in the log > file, so the problem seems to be with coldfusion. > > "Warning","TID=972","09/16/03","08:45:37","Unable to move the spooled mail > file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file > because it is being used by another process.." > "Warning","TID=972","09/16/03","08:45:38","Unable to move the spooled mail > file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file > because it is being used by another process.." > "Warning","TID=972","09/16/03","08:45:39","Unable to move the spooled mail > file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file > because it is being used by another process.." > "Warning","TID=972","09/16/03","08:45:40","Unable to move the spooled mail > file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file > because it is being used by another process.." > > Thanks, > CC > > This is a PRIVATE message. If you are not the intended recipient, > please > delete without copying and kindly advise us by e-mail of the mistake > in > delivery. NOTE: Regardless of content, this e-mail shall not operate to > bind CSC to any order or other contract unless pursuant to explicit > written agreement or government initiative expressly permitting the use of > e-mail for such purpose. > > > > > > > info > @turnkey.to > 09/16/2003 01:44 PM > Please respond to cf-talk > > > To: CF-Talk <[EMAIL PROTECTED]> > cc: > Subject: Re: Mail spooling issue > > > Assuming they're both running the same ver
Re: Mail spooling issue
Yes, a restart fixed it, but what caused it? So far I have been reading this is a "known issue" and should just be dealt with as it arises. If there is a known cause then we can find a work-around until Macromedia fixes it. (or use the work around until we upgrade, given I dont think CF 4.5 is supported anymore) Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Howie Hamlin" 09/16/2003 02:02 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Re: Mail spooling issue Looks like the file is locked but is still being sent. A restart of CF might fix it. Good luck, Regards, Howie - Original Message - From: "Casey C Cook" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 16, 2003 4:45 PM Subject: Re: Mail spooling issue > Here is the mail error message, there are thousands of entries in the log > file, so the problem seems to be with coldfusion. > > "Warning","TID=972","09/16/03","08:45:37","Unable to move the spooled mail > file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file > because it is being used by another process.." > "Warning","TID=972","09/16/03","08:45:38","Unable to move the spooled mail > file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file > because it is being used by another process.." > "Warning","TID=972","09/16/03","08:45:39","Unable to move the spooled mail > file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file > because it is being used by another process.." > "Warning","TID=972","09/16/03","08:45:40","Unable to move the spooled mail > file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file > because it is being used by another process.." > > Thanks, > CC > > This is a PRIVATE message. If you are not the intended recipient, please > delete without copying and kindly advise us by e-mail of the mistake in > delivery. NOTE: Regardless of content, this e-mail shall not operate to > bind CSC to any order or other contract unless pursuant to explicit > written agreement or government initiative expressly permitting the use of > e-mail for such purpose. > > > > > > > info > @turnkey.to > 09/16/2003 01:44 PM > Please respond to cf-talk > > > To: CF-Talk <[EMAIL PROTECTED]> > cc: > Subject:Re: Mail spooling issue > > > Assuming they're both running the same version of CF I'd reinstall the one > that's having the problem... If you're running CFMX and haven't upgraded > to 6.1 (Red Sky) yet, I'd definately try that first. ... unfortunately I > don't have any suggestions to get around having to wait a month to see if > it's working. > > ike > > -- Original Message -- > From: Casey C Cook <[EMAIL PROTECTED]> > To: CF-Talk <[EMAIL PROTECTED]> > Sent: Sep 16, 2003 01:09 PM > Subject: Re: Mail spooling issue > > >Has anyone experienced the mail spooler sending out like 14,000 emails, > >even though the CF statement only sends 1 e-mail to the > >spooler?...Bascially the same e-mail is being sent over and over and over > >quickly. We only have the administrator set to check for new e-mails > >every 60 seconds. What would cause it to rapid fire out 14k e-mails > >before we catch it? It only has done this 2 times over the past 2 months > >and the application has been on-line for a year and a half. This only > >seems to be happening on the US server and has not impacted the UK > servers > >running the same application. Any thoughts? > > > >Thanks much, > >CC > > > >This
Re: Mail spooling issue
Here is the mail error message, there are thousands of entries in the log file, so the problem seems to be with coldfusion. "Warning","TID=972","09/16/03","08:45:37","Unable to move the spooled mail file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file because it is being used by another process.." "Warning","TID=972","09/16/03","08:45:38","Unable to move the spooled mail file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file because it is being used by another process.." "Warning","TID=972","09/16/03","08:45:39","Unable to move the spooled mail file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file because it is being used by another process.." "Warning","TID=972","09/16/03","08:45:40","Unable to move the spooled mail file, d:\CFUSION\MAIL\spool\88.cfmail. The process cannot access the file because it is being used by another process.." Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. info @turnkey.to 09/16/2003 01:44 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Re: Mail spooling issue Assuming they're both running the same version of CF I'd reinstall the one that's having the problem... If you're running CFMX and haven't upgraded to 6.1 (Red Sky) yet, I'd definately try that first. ... unfortunately I don't have any suggestions to get around having to wait a month to see if it's working. ike -- Original Message -- From: Casey C Cook <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Sep 16, 2003 01:09 PM Subject: Re: Mail spooling issue >Has anyone experienced the mail spooler sending out like 14,000 emails, >even though the CF statement only sends 1 e-mail to the >spooler?...Bascially the same e-mail is being sent over and over and over >quickly. We only have the administrator set to check for new e-mails >every 60 seconds. What would cause it to rapid fire out 14k e-mails >before we catch it? It only has done this 2 times over the past 2 months >and the application has been on-line for a year and a half. This only >seems to be happening on the US server and has not impacted the UK servers >running the same application. Any thoughts? > >Thanks much, >CC > >This is a PRIVATE message. If you are not the intended recipient, please >delete without copying and kindly advise us by e-mail of the mistake in >delivery. NOTE: Regardless of content, this e-mail shall not operate to >bind CSC to any order or other contract unless pursuant to explicit >written agreement or government initiative expressly permitting the use of >e-mail for such purpose. > > > > > > >"Andy Ousterhout" @omygoodness.com> >09/16/2003 01:01 PM >Please respond to cf-talk > > >To: CF-Talk <[EMAIL PROTECTED]> >cc: >Subject:RE: problem > > >http:// > >-Original Message- >From: J E VanOver [mailto:[EMAIL PROTECTED] >Sent: Tuesday, September 16, 2003 2:53 PM >To: CF-Talk >Subject: RE: problem > > >Is that a proper url? Shouldn't it start with http:// or file: ?? > >-Original Message- >From: AKERS,BRET (HP-SanDiego,ex1) [mailto:[EMAIL PROTECTED] >Sent: Tuesday, September 16, 2003 12:39 PM >To: CF-Talk >Subject: problem > > >Hi All, > >I've got a crazy problem with the tag. When using it to >redirect to network locations, i.e. url="\\machine\share\directory\" addtoken="no">, I get the "Page cannot be >displayed" error unless I disable the "Show friendly http error messages" >checkbox in Internet explorer". Any idea of what's going on here? Running >CFMX 6 on a W2K server. > >Thanks. > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Mail spooling issue
1) It actually sends out the e-mail. 2) The code has been unchanged for the 1 and 1/2 years the program has been running. I dont know enough about what happens to the e-mail once it leaves the spool folder and enters the e-mail system flow. Perhaps something is going screwy after it leaves coldfusions hands. Thanks. CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Kevin Graeme" 09/16/2003 01:19 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Re: Mail spooling issue Is it actually sending the mail or is it just spooling them? There is a bug that we've run into where if the developer forgets to set a TO or FROM address, the spooler fills up with duplicates as it fails to send the message and retries. This is on CF<=5 for us. I don't know about MX. -Kevin - Original Message - From: "Casey C Cook" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 16, 2003 3:09 PM Subject: Mail spooling issue > Has anyone experienced the mail spooler sending out like 14,000 emails, > even though the CF statement only sends 1 e-mail to the > spooler?...Bascially the same e-mail is being sent over and over and over > quickly. We only have the administrator set to check for new e-mails > every 60 seconds. What would cause it to rapid fire out 14k e-mails > before we catch it? It only has done this 2 times over the past 2 months > and the application has been on-line for a year and a half. This only > seems to be happening on the US server and has not impacted the UK servers > running the same application. Any thoughts? > > Thanks much, > CC > -- -- > This is a PRIVATE message. If you are not the intended recipient, please > delete without copying and kindly advise us by e-mail of the mistake in > delivery. NOTE: Regardless of content, this e-mail shall not operate to > bind CSC to any order or other contract unless pursuant to explicit > written agreement or government initiative expressly permitting the use of > e-mail for such purpose. > -- -- > > > > > > "Andy Ousterhout" @omygoodness.com> > 09/16/2003 01:01 PM > Please respond to cf-talk > > > To: CF-Talk <[EMAIL PROTECTED]> > cc: > Subject:RE: problem > > > http:// > > -Original Message- > From: J E VanOver [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 16, 2003 2:53 PM > To: CF-Talk > Subject: RE: problem > > > Is that a proper url? Shouldn't it start with http:// or file: ?? > > -Original Message- > From: AKERS,BRET (HP-SanDiego,ex1) [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 16, 2003 12:39 PM > To: CF-Talk > Subject: problem > > > Hi All, > > I've got a crazy problem with the tag. When using it to > redirect to network locations, i.e. url="\\machine\share\directory\" addtoken="no">, I get the "Page cannot be > displayed" error unless I disable the "Show friendly http error messages" > checkbox in Internet explorer". Any idea of what's going on here? Running > CFMX 6 on a W2K server. > > Thanks. > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Mail spooling issue
Has anyone experienced the mail spooler sending out like 14,000 emails, even though the CF statement only sends 1 e-mail to the spooler?...Bascially the same e-mail is being sent over and over and over quickly. We only have the administrator set to check for new e-mails every 60 seconds. What would cause it to rapid fire out 14k e-mails before we catch it? It only has done this 2 times over the past 2 months and the application has been on-line for a year and a half. This only seems to be happening on the US server and has not impacted the UK servers running the same application. Any thoughts? Thanks much, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Andy Ousterhout" 09/16/2003 01:01 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: problem http:// -Original Message- From: J E VanOver [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 2:53 PM To: CF-Talk Subject: RE: problem Is that a proper url? Shouldn't it start with http:// or file: ?? -Original Message- From: AKERS,BRET (HP-SanDiego,ex1) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 12:39 PM To: CF-Talk Subject: problem Hi All, I've got a crazy problem with the tag. When using it to redirect to network locations, i.e. , I get the "Page cannot be displayed" error unless I disable the "Show friendly http error messages" checkbox in Internet explorer". Any idea of what's going on here? Running CFMX 6 on a W2K server. Thanks. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: SQL help
Or try (datepart(MM,work_day), something like that. Basically your syntax is a bit off. CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Bruce, Rodney S HQISEC/Veridian IT Services" 07/22/2003 12:10 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:SQL help Hi all We are finally tring to upgrate from Access to SQL 2000. I am working on making the necessary changes to the queries. One I am having a problem with is were the WHERE statement is: WHERE (proj_name = '#Qgetinfo.proj_name# ') and(datepart('M',work_day) =#m#) m=number for the month: m=5. work_day is the field in the db table. this works fine with Access(data type date/time), but with SQL I get the error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid parameter 1 specified for datepart when the data type is smalldatetime and if I change it to timestamp, no error but no records are returned either. This is used to create a report based on the project selected and the month. THanks Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL help
Format: DATEPART(MONTH, '1/1/2003') *note the word MONTH is literally the word month, not a numeric equivalent. In your case the 1/1/2003 may be your coldfusion variable. CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Bruce, Rodney S HQISEC/Veridian IT Services" 07/22/2003 12:10 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:SQL help Hi all We are finally tring to upgrate from Access to SQL 2000. I am working on making the necessary changes to the queries. One I am having a problem with is were the WHERE statement is: WHERE (proj_name = '#Qgetinfo.proj_name# ') and(datepart('M',work_day) =#m#) m=number for the month: m=5. work_day is the field in the db table. this works fine with Access(data type date/time), but with SQL I get the error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid parameter 1 specified for datepart when the data type is smalldatetime and if I change it to timestamp, no error but no records are returned either. This is used to create a report based on the project selected and the month. THanks Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Think you are a SQL GURU? Try figuring this one out.
Well, here is an interesting select statement to give you the values you want. select name, length(name), instr(name,' ',1), instr(name,' ',1,2), substr(name,1,instr(name,' ',1)-1), substr(name,instr(name,' ',1)+1,(length(name)-instr(name,' ',1,1))-2), substr(name,instr(name,' ',1,2)+1) from name_test This assume that all middle initials will be 1 defined character (otherwise logic fails) and that no names will contain spaces, such as Mac Donald. The logic looks for blank spaces and then counts strings from those spaces. You get the idea of where to go from here, if not, give me all the rules for the names and we can try to come up with something more interesting. This is a select statement, but can easily be turned into an insert statement. CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. -------- Casey C Cook/ASD/CSC @CSC 07/17/2003 04:46 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Re: OT: Think you are a SQL GURU? Try figuring this one out. If you always know that the names are in that format, then couldnt you do something like the following very psuedo code. This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Wjatscheslaw Kravtchenko 07/17/2003 04:25 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:OT: Think you are a SQL GURU? Try figuring this one out. SQL or Oracle syntax? CC Hey Eric, It's not SQL it's more for PERL and Regular Expressions. I am not too familiar with regular expressions in ColdFusion but I'm sure that they are no RegEx in SQL. Another thing what could do it would be kdb from KX Systems but again you need to learn k. If you can drop me the csv file (please not more than 3 mb). I can have a look. SL >Here is the challenge. > >Have a table with a column called NAME and the column contains both >names of businesses and individuals. Business names are stored as is , >example ABC Company. Individuals are stored as last name first name >middle initial, example Public John Q. I need to get this information >into another table where the biz name can be stored in the first name >field no problem but I need to parse and individuals name so I can put >the individual's first name in the first name column and their last >name in the last name column. > >Figure it out and I will send you a prize. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Think you are a SQL GURU? Try figuring this one out.
If you always know that the names are in that format, then couldnt you do something like the following very psuedo code. This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Wjatscheslaw Kravtchenko 07/17/2003 04:25 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:OT: Think you are a SQL GURU? Try figuring this one out. SQL or Oracle syntax? CC Hey Eric, It's not SQL it's more for PERL and Regular Expressions. I am not too familiar with regular expressions in ColdFusion but I'm sure that they are no RegEx in SQL. Another thing what could do it would be kdb from KX Systems but again you need to learn k. If you can drop me the csv file (please not more than 3 mb). I can have a look. SL >Here is the challenge. > >Have a table with a column called NAME and the column contains both >names of businesses and individuals. Business names are stored as is , >example ABC Company. Individuals are stored as last name first name >middle initial, example Public John Q. I need to get this information >into another table where the biz name can be stored in the first name >field no problem but I need to parse and individuals name so I can put >the individual's first name in the first name column and their last >name in the last name column. > >Figure it out and I will send you a prize. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Array vs. temp table
Under what circumstances would you use an array vs. a temp table in a programming language such as PL\SQL. is there really a difference? CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
WAY OT: SPAM E-mails
Im trying to figure out the source for these spam emails, has anyone else on this list received this e-mail? Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. - Forwarded by Casey C Cook/ASD/CSC on 06/25/2003 02:43 PM - BPhosting @hotmail.com 06/25/2003 07:06 AM To: Casey C Cook/ASD/[EMAIL PROTECTED] cc: Subject:Bullet Proof web hosting ... Free Trial... Bullet Proof Bulk Email Friendly Web Hosting If you want to promote your web site via commercial email, bullet proof web hosting is a must! As you may already know, many web hosting companies have Terms of Service (TOS) or Acceptable Use Policies (AUP) against the delivery of emails advertising or promoting your web site. If your web site host receives complaints or discovers that your web site has been advertised in email broadcasts, they may disconnect your account and shut down your web site. We offer reliable bulk email friendly web hosting services. You can now have the peace of mind knowing that your web site is secure during your email marketing campaigns. Bullet Proof Web Hosting 100% Guaranteed! This means you can send bulk email with your website address in it, and your website will not get shut down! I'm sure you've had a website shut down because you listed it in your bulk emails. For more information, please Email us at [EMAIL PROTECTED] and [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL conversion question for SQL Guru
OMG, I cant type. If the date portion of the string is always in the same position within the main string then use the substring command. I feel much better. CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. Casey C Cook/ASD/CSC @CSC 06/12/2003 04:54 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: SQL conversion question for SQL Guru If the date fields are always in the same position within the string then use the subtring command. CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Eric Creese" 06/12/2003 02:45 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: SQL conversion question for SQL Guru The field actually holds different kids of data based on the record type. I am only select records that will contain a date -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 4:44 PM To: CF-Talk Subject: Re: SQL conversion question for SQL Guru Eric Creese wrote: > I have a query I am trying to run to get a particular record out of the database. The problem is that one of the fields is > a varchar 255 field that houses a date. Only a date, or other information as well? > I want to convert the date so I can find out if it is greater than getdate(). I run the following > code and generate this conversion error message: > > Server: Msg 241, Level 16, State 1, Line 1 > Syntax error converting datetime from character string. > > > select distinct personid > from persondemographic > where demographicgroupid =4 > and demographicitemid =4 > and convert(datetime, demographicvaluedesc) > getdate() Which DBMS? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL conversion question for SQL Guru
If the date fields are always in the same position within the string then use the subtring command. CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Eric Creese" 06/12/2003 02:45 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: SQL conversion question for SQL Guru The field actually holds different kids of data based on the record type. I am only select records that will contain a date -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 4:44 PM To: CF-Talk Subject: Re: SQL conversion question for SQL Guru Eric Creese wrote: > I have a query I am trying to run to get a particular record out of the database. The problem is that one of the fields is > a varchar 255 field that houses a date. Only a date, or other information as well? > I want to convert the date so I can find out if it is greater than getdate(). I run the following > code and generate this conversion error message: > > Server: Msg 241, Level 16, State 1, Line 1 > Syntax error converting datetime from character string. > > > select distinct personid > from persondemographic > where demographicgroupid =4 > and demographicitemid =4 > and convert(datetime, demographicvaluedesc) > getdate() Which DBMS? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query question
We have watched the web-server spike up to 100 percent utilization on cumbersome queries before (afterward the page was modified to reduce the number of results returned). Im not sure if this is supposed to happen but it did. Casey Cook This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Robert Shaw" 06/11/2003 04:39 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:query question Hi All, It appears a certain query of mine is causing our CPU to spike. We're working on the query but what is strange is that it will hose CF. It was my uderstanding that CF passes the connection off so I would think it would be normal for the database server's CPU to spike but not for CF to cause the webserver CPU to spike. If we kill the query it immediately goes back down. Does this sound right? I have not seen this happen before and am questioning if my logic is off. TIA, Rob _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Custom Oracle Functions
Hi all - Does anyone know of a good source/web-site for custom Oracle PL/SQL functions, I dont want to invent the wheel if I dont have to. Thanks much in advance. Casey Cook This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: i will sell domain cftop.com
I got a good laugh from this topic, thanks much for the humor. This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "Eric Creese" 06/06/2003 01:56 PM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: i will sell domain cftop.com foohie -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 3:54 PM To: CF-Talk Subject: RE: i will sell domain cftop.com I believe 100,00 means $100.00 Not all countries use the same decimal delimiter... > I could not help but I had to reply this one. > > $100,000. That's huge. I will sell cftopsucks.com for a fraction of cftop.com's price for $10 just for General Purposes! > > -Original Message- > From: Blood Python [mailto:[EMAIL PROTECTED] > Sent: Friday, June 06, 2003 3:32 PM > To: CF-Talk > Subject: i will sell domain cftop.com > > > I dont know if this is allowed in cftalk, but it is related to coldfusion =) > > I had the domain "cftop.com" since 99... i guess, I bought it when i start > coding many projects in cf. It was used mainly for e-mail proposes. Maybe > some of you guys can make a better use of it. > > Domain name expires in june 14 (in 8 days) and i dont want to renew it. I'm > asking usd 100,00 for it but i will sell for less if i do not get a good > offer. > > If anyone is interested, drop me an e-mail [EMAIL PROTECTED] or ICQ: > 198810. > > Thanks > > BP. > > _ > The new MSN 8: smart spam protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Table indexes
Oracle 8.1.7 and on another server Oracle 9.2 Thanks, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ksuh @shaw.ca 06/04/2003 09:42 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:Re: OT: Table indexes It depends in the DB you're using. - Original Message - From: Casey C Cook <[EMAIL PROTECTED]> Date: Wednesday, June 4, 2003 10:38 am Subject: OT: Table indexes > Hello - > > Is this a true statment? > > There was an index on SFC_PART_SERIAL_REFERENCE(PART_NO) so I > dropped it > and added the index on SFC_PART_SERIAL_REFERENCE(PART_NO, > SERIAL_NO). Any > query that was using the old index should be able to use the high > order > portion of the new index. > > If I run a query on PART_NO alone, will it use the > part_no/serial_no > index, I didnt think that was the way indexes worked, but I have > been > wrong many times. Is there a good reference to read exactly how > indexes > work? > > Thanks for your input, > CC > --- > - > This is a PRIVATE message. If you are not the intended recipient, > please > delete without copying and kindly advise us by e-mail of the > mistake in > delivery. NOTE: Regardless of content, this e-mail shall not > operate to > bind CSC to any order or other contract unless pursuant to > explicit > written agreement or government initiative expressly permitting > the use of > e-mail for such purpose. > --- > - > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Table indexes
Hello - Is this a true statment? There was an index on SFC_PART_SERIAL_REFERENCE(PART_NO) so I dropped it and added the index on SFC_PART_SERIAL_REFERENCE(PART_NO, SERIAL_NO). Any query that was using the old index should be able to use the high order portion of the new index. If I run a query on PART_NO alone, will it use the part_no/serial_no index, I didnt think that was the way indexes worked, but I have been wrong many times. Is there a good reference to read exactly how indexes work? Thanks for your input, CC This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Template not executing in Scheduler
Hello - Does anyone know why a task would not execute a template from the scheduler when you slick the "run" button on the scheduled tasks screen in the coldfusion administrator. The template executes perfectly from the browser, sends an e-mail and deletes a specified file. Whats the difference between running it from the scheduled task screen and the browser? Thanks all, Casey Cook This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: i think im gettin hacked
When it starts to go off, kick the hell out of the machine and see if it stops. C "Tony Weeg" 04/03/2003 08:49 AM Please respond to cf-talk To: CF-Talk <[EMAIL PROTECTED]> cc: Subject:RE: i think im gettin hacked it's a siren. its not a sound that I have ever heard...and all processes seem/appear to be normal in my task manager. and I don't see a process that is getting any cpu time at all...im tellin you, this is freaky ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 10:44 AM To: CF-Talk Subject: RE: i think im gettin hacked Get pstools from www.sysinternals.com, and see what owns the process. Chould be a outlook meeting alert ? WG -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 03 April 2003 16:27 To: CF-Talk Subject: RE: i think im gettin hacked by the way... if I restart the machine...and do not login...it happens if I restart the machine...and login...it happens if I restart the machine...and login as a different user...it happens speakers on/speakers off, system down, system updoes this sound like a virus? or really can a bios or mboard or cpu problem, trigger a siren from my speakers? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 10:08 AM To: CF-Talk Subject: RE: i think im gettin hacked that's the thing, they arent, I can play music all day long on them, I can play music fine for like 1-3 minutes, and then the freakin siren.no mic either :) ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 10:05 AM To: CF-Talk Subject: RE: i think im gettin hacked Tony - your speakers could be fried. Or, if you have a microphone attached, make sure it isn't near the speakers (maybe it's feed back). -mk -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 8:44 AM To: CF-Talk Subject: RE: i think im gettin hacked not coming from the box, the sound...that is... its coming from my speakers? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping & reporting www.navtrak.net 410.548.2337 -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:39 AM To: CF-Talk Subject: RE: i think im gettin hacked Sounds like it could be a heat issue. Pop the case off and check your fans. Most motherboards will start doing this if the CPU fan stops spinning. Dan Phillips www.CFXHosting.com 1-866-239-4678 x105 [EMAIL PROTECTED] -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:41 AM To: CF-Talk Subject: RE: i think im gettin hacked Tony, I'd be looking at a hardware failure point if I were you - check the bios for alarms and warnings and look a the Mboard documentation. -mk -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 9:23 PM To: CF-Talk Subject: RE: i think im gettin hacked i know it...but comcast also tells me that they have a lot of protection before my connection gets here...not too sure i believe that one...but i do netstat, and dont see anything connected to my machine? WTF? tw -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 10:20 PM To: CF-Talk Subject: Re: i think im gettin hacked tony, are you spending too much time in the half pipe? lol btw~ the xp firewall is well. microsoft;) not to secure dave - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 02, 2003 10:14 PM Subject: sot: i think im gettin hacked > can anyone please tell me if you have > ever had a strange siren sound off on your > machine, outta nowhere...even after a restart...i dont > have lockdown or anything like that running, i do have > xp, and i do have my xp firewall enabled... > > thanks! > > tony > > tony weeg > [EMAIL PROTECTED] > www.revolutionwebdesign.com > rEvOlUtIoN wEb DeSiGn > 410.334.6331 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm
WOT: Oracle Discoverer
Hello all - Does anyone use the Oracle Discoverer tool, Im new to the tool and would like to know if this forum can be used on occassion to ask questions. I have subscribed to the oracle technical network forum on Discoverer, but no one seems to reply there. Does anyone know a better forum or mailing list like this one for Oracle Discoverer? Thanks for your input. Casey Cook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4