RE: Updater Problem - Please help
Yes! I forgot about that... good tip. I need to write that up. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, February 22, 2010 5:28 PM To: cf-talk Subject: Re: Updater Problem - Please help > I updated ColdFusion 8.0 enterprise to 8.01 with the updater on the adobe website. Now, I get the following error for all of my > coldfusion requests -- any ideas appreciated: > > 500 jrun servlet error > ROOT CAUSE: > java.lang.NoClassDefFoundError: coldfusion/runtime/QueryTableWrapper Delete your cached class files in \coldfusion8\wwwroot\WEB-INF\cfclasses and restart the server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Updater Problem - Please help
> I updated ColdFusion 8.0 enterprise to 8.01 with the updater on the adobe > website. Now, I get the following error for all of my > coldfusion requests -- any ideas appreciated: > > 500 jrun servlet error > ROOT CAUSE: > java.lang.NoClassDefFoundError: coldfusion/runtime/QueryTableWrapper Delete your cached class files in \coldfusion8\wwwroot\WEB-INF\cfclasses and restart the server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Updater Problem - Please help
Based on your stack trace I would also examine the page in question... I wonder if you don't have an 'undocumented' method call there Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: E Cohen [mailto:cft...@longmeadcrossing.com] Sent: Monday, February 22, 2010 5:11 PM To: cf-talk Subject: Updater Problem - Please help Hello, I updated ColdFusion 8.0 enterprise to 8.01 with the updater on the adobe website. Now, I get the following error for all of my coldfusion requests -- any ideas appreciated: 500 jrun servlet error ROOT CAUSE: java.lang.NoClassDefFoundError: coldfusion/runtime/QueryTableWrapper at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389) at java.lang.Class.getConstructor0(Class.java:2699) at java.lang.Class.newInstance0(Class.java:326) at java.lang.Class.newInstance(Class.java:308) at coldfusion.sql.QueryTable.getShallowCopy(QueryTable.java:2784) at coldfusion.tagext.QueryLoop.setQuery(QueryLoop.java:62) at cfact_get_today_tomorrow_sales_install_lineup2ecfm414023595._factor40(C:\Ine tpub\wwwroot\Clients\CraftsmanWindows.com\Admin829\act_get_today_tomorrow_sa les_install_lineup.cfm:312) at cfact_get_today_tomorrow_sales_install_lineup2ecfm414023595.runPage(C:\Inetp ub\wwwroot\Clients\CraftsmanWindows.com\Admin829\act_get_today_tomorrow_sale s_install_lineup.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:483) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfindex2ecfm1155640945._factor7(C:\Inetpub\wwwroot\Clients\CraftsmanWindows. com\Admin829\index.cfm:163) at cfindex2ecfm1155640945.runPage(C:\Inetpub\wwwroot\Clients\CraftsmanWindows.c om\Admin829\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:483) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:288) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:198) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletF ilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26 6) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.lang.ClassNotFoundException: coldfusion.runtime.QueryTableWrapper at coldfusion.bootstrap.BootstrapClassLoader.loadClass(BootstrapClassLoader.jav a:235) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) ... 44 more javax.servlet.ServletException: ROOT CAUSE: java.lang.NoClassDefFoundError: coldfusion/runtime/QueryTableWrapper at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2
RE: Updater Problem - Please help
Look in the /runtime/log directory for the "out" log (it can be in different places based on your config) and find the start up routine... you will probably get a clue there. -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: E Cohen [mailto:cft...@longmeadcrossing.com] Sent: Monday, February 22, 2010 5:11 PM To: cf-talk Subject: Updater Problem - Please help Hello, I updated ColdFusion 8.0 enterprise to 8.01 with the updater on the adobe website. Now, I get the following error for all of my coldfusion requests -- any ideas appreciated: 500 jrun servlet error ROOT CAUSE: java.lang.NoClassDefFoundError: coldfusion/runtime/QueryTableWrapper at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389) at java.lang.Class.getConstructor0(Class.java:2699) at java.lang.Class.newInstance0(Class.java:326) at java.lang.Class.newInstance(Class.java:308) at coldfusion.sql.QueryTable.getShallowCopy(QueryTable.java:2784) at coldfusion.tagext.QueryLoop.setQuery(QueryLoop.java:62) at cfact_get_today_tomorrow_sales_install_lineup2ecfm414023595._factor40(C:\Ine tpub\wwwroot\Clients\CraftsmanWindows.com\Admin829\act_get_today_tomorrow_sa les_install_lineup.cfm:312) at cfact_get_today_tomorrow_sales_install_lineup2ecfm414023595.runPage(C:\Inetp ub\wwwroot\Clients\CraftsmanWindows.com\Admin829\act_get_today_tomorrow_sale s_install_lineup.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:483) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfindex2ecfm1155640945._factor7(C:\Inetpub\wwwroot\Clients\CraftsmanWindows. com\Admin829\index.cfm:163) at cfindex2ecfm1155640945.runPage(C:\Inetpub\wwwroot\Clients\CraftsmanWindows.c om\Admin829\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:483) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:288) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:198) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletF ilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26 6) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.lang.ClassNotFoundException: coldfusion.runtime.QueryTableWrapper at coldfusion.bootstrap.BootstrapClassLoader.loadClass(BootstrapClassLoader.jav a:235) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) ... 44 more javax.servlet.ServletException: ROOT CAUSE: java.lang.NoClassDefFoundError: coldfusion/runtime/QueryTableWrapper at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredCo
Updater Problem - Please help
Hello, I updated ColdFusion 8.0 enterprise to 8.01 with the updater on the adobe website. Now, I get the following error for all of my coldfusion requests -- any ideas appreciated: 500 jrun servlet error ROOT CAUSE: java.lang.NoClassDefFoundError: coldfusion/runtime/QueryTableWrapper at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389) at java.lang.Class.getConstructor0(Class.java:2699) at java.lang.Class.newInstance0(Class.java:326) at java.lang.Class.newInstance(Class.java:308) at coldfusion.sql.QueryTable.getShallowCopy(QueryTable.java:2784) at coldfusion.tagext.QueryLoop.setQuery(QueryLoop.java:62) at cfact_get_today_tomorrow_sales_install_lineup2ecfm414023595._factor40(C:\Inetpub\wwwroot\Clients\CraftsmanWindows.com\Admin829\act_get_today_tomorrow_sales_install_lineup.cfm:312) at cfact_get_today_tomorrow_sales_install_lineup2ecfm414023595.runPage(C:\Inetpub\wwwroot\Clients\CraftsmanWindows.com\Admin829\act_get_today_tomorrow_sales_install_lineup.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:483) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfindex2ecfm1155640945._factor7(C:\Inetpub\wwwroot\Clients\CraftsmanWindows.com\Admin829\index.cfm:163) at cfindex2ecfm1155640945.runPage(C:\Inetpub\wwwroot\Clients\CraftsmanWindows.com\Admin829\index.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:483) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:288) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:198) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.lang.ClassNotFoundException: coldfusion.runtime.QueryTableWrapper at coldfusion.bootstrap.BootstrapClassLoader.loadClass(BootstrapClassLoader.java:235) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) ... 44 more javax.servlet.ServletException: ROOT CAUSE: java.lang.NoClassDefFoundError: coldfusion/runtime/QueryTableWrapper at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389) at java.lang.Class.getConstructor0(Class.java:2699) at java.lang.Class.newInstance0(Class.java:326) at java.lang.Class.newInstance(Class.java:308) at coldfusion.sql.QueryTable.getShallowCopy(QueryTable.java:2784) at coldfusion.tagext.QueryLoop.setQuery(QueryLoop.java:62) at cfact_get_today_tomorrow_sales_install_lineup2ecfm414023595._factor40(C:\Inetpub\wwwroot\Clients\CraftsmanWindows.com\Admin829
cfdocument putting part of the row on the bottom of page 1 and the other on the top of page 2. Please help!
Hello everybody, I'm new to cfdocument. I'm using it to create pdf documents from data returned by a query with ColdFusion8. The problem is that cfdocument is putting part of the data contained in the table row at the bottom of page 1 and the other on the top of page 2. I know that there is a cfdocumentitem tpye pagebreak attribute () which I could use but how do I know when to use this given that the data is dynamic. Can anyone help? Regards, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Please Help..Confused
Unless you want to add up the number of days from a specific date, this is not logical, as days in years and months can vary. If it's from a date like today, then: http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Please Help..Confused
>>I need to convert those values to days and add them up. Ok, but to add them up to WHICH date ? Or do you consider every month to be 30 days and every year to be 365 days in general? If yes, then just use dateAdd ("d", form.years*365 + form.months*30 + form.days, dateToBeAdded) ~| 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:311942 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Please Help..Confused
> No, what I need is for example, when if a user selects > 2 years (from the years dropdown box) 2 months ( 2 days > from the months dropdown box) and 2 days (from the days > dropdown box then I need to convert those values to days > and add them up. Then that added value will be used with > another dropdown that the user selects from (1-90)to > determine how many days they have left until their > certificate expires. Any suggestions?? Sorry if this is > confusing I'm not sure what you're asking on the second part, but if you're asking for a time period and need to convert that to a date... targetDate = dateAdd("", url.numYears, now()); targetDate = dateAdd("m", url.numMonths, targetDate); targetDate = dateAdd("d", url.numDays, targetDate); #targetDate# I'm not sure what you're talking about with the 1-90 selection though. -Justin Scott - blog: http://www.tlson.com/ ~| 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:311939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Please Help..Confused
Whoops... correction... only the first data is NOW... the others are NEWDATE... it's cumulative. Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2008 3:07 PM To: CF-Talk Subject: RE: Please Help..Confused If you mean X years, Y months, and Z days from NOW: This will give you a new date that is x years, Y months, and Z days in the future from now. If you're calculating from a different date, change Now() to the start date. If you're subtracting to find a past date, change the values to negative. That will do it. Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. ~| 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:311938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Please Help..Confused
If you mean X years, Y months, and Z days from NOW: This will give you a new date that is x years, Y months, and Z days in the future from now. If you're calculating from a different date, change Now() to the start date. If you're subtracting to find a past date, change the values to negative. That will do it. Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. ~| 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:311936 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Please Help..Confused
>>I should have clarified that I am not passing a date such as mm/dd/. The year dropdown contains the values 1-5 that the user can select, the month is 1-11, and the days are 1-30. What I am trying to do is for example, when if a user selects 2 years 2 months 2 days then I need to convert those values to days. Then use CreateDate(year, month, day) to create a date object For the year, I suppose 1-5 stands for 2008-2013? Then use CreateDate(year+2007, month, day) ~| 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:311934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Please Help..Confused
In order to get the number of days in (for example) 2 years, 2 months and 2 days, you can do one of the following. 1. Assume a year has 365 days & a month has 30 (It doesn't and this will not work correctly for your situation) 2. Use a start date. This is preferable since years, months and days are measures of time. Without 2 reference points (Start and either time or end date), you can't measure correctly. For example, tell me the miles between Chicago and some other city that is unspecified. You can't because to measure something (distance, time, etc), you need 2 points. Start and End (or one of those with the distance between one or the other). If you are good at math, it's like me asking you to find for x in the following problem.. x=y+? See our point? :) Laurie Smith wrote: > No, what I need is for example, when if a user selects > 2 years (from the years dropdown box) 2 months ( 2 days from the months > dropdown box) and 2 days (from the days dropdown box then I need to convert > those values to days and add them up. Then that added value will be used with > another dropdown that the user selects from (1-90)to determine how many days > they have left until their certificate expires. Any suggestions?? Sorry if > this is confusing ~| 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:311933 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Please Help..Confused
>On Tue, Sep 2, 2008 at 11:29 AM, Laurie Smith <[EMAIL PROTECTED]>wrote: > > > >but... but... some months have a different number of days than others :) > >if that's your desired result, you'll really need to capture a start date >(and an end date) > >-- >A byte walks into a bar and orders a pint. Bartender asks him "What's >wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought >you looked a bit off." For my example of: What I am trying to do is for example, when if a user selects 2 years 2 months 2 days then I need to convert those values to days. Do you recommend using the DateDiff? ~| 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:311924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Please Help..Confused
On Tue, Sep 2, 2008 at 11:37 AM, Laurie Smith <[EMAIL PROTECTED]>wrote: > >On Tue, Sep 2, 2008 at 11:29 AM, Laurie Smith <[EMAIL PROTECTED] > >wrote: > > > > > > > >but... but... some months have a different number of days than others :) > > > >if that's your desired result, you'll really need to capture a start date > >(and an end date) > > > >-- > >A byte walks into a bar and orders a pint. Bartender asks him "What's > >wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought > >you looked a bit off." > > > > For my example of: What I am trying to do is for example, when if a user > selects > 2 years 2 months 2 days then I need to convert those values to days. Do you > recommend using the DateDiff? > which 2 months tho? if it's february and march, those will have different # of days than, say july and august. and february and march of a leap year will have a different # of days than february and march of a non-leap year. what's the context in which the user is selecting these values? if you need a dateDiff() then ideally you need an actual start date and an actual end date. -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~| 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:311931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Please Help..Confused
>Can you explain to goal a little bit... I can see a few uses for such data. > >For example, is the goal of the date input something like, "I need to rent a >house for... 2 years, 3 months and 11 days" > >And then you need to calculate what the end date would be starting at Now()? > > >=] > > >-- >Alan Rother >Adobe Certified Advanced ColdFusion MX 7 Developer >Manager, Phoenix Cold Fusion User Group, AZCFUG.org No, what I need is for example, when if a user selects 2 years (from the years dropdown box) 2 months ( 2 days from the months dropdown box) and 2 days (from the days dropdown box then I need to convert those values to days and add them up. Then that added value will be used with another dropdown that the user selects from (1-90)to determine how many days they have left until their certificate expires. Any suggestions?? Sorry if this is confusing ~| 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:311927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Please Help..Confused
If you want the current date to be your starting point, and you want them to select a date in the future using your dropdowns, you'd do this: Essentially, if the user selected 2 years, 3 months and 15 days, the newDate would be 12/17/2010 which is 836 days away. Hope that helps. If not, please clarify your goal a little more. Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 Laurie Smith wrote: >> I have 3 drop-down boxes for: >> Years >> Months >> Days >> >> I need to combine the values for all 3 and convert to days so I can >> use the total number of days with DateDiff...Any suggestions would be >> greatly appreciated. Thanks >> > > I should have clarified that I am not passing a date such as mm/dd/. The > year dropdown contains the values 1-5 that the user can select, the month is > 1-11, and the days are 1-30. What I am trying to do is for example, when if a > user selects 2 years 2 months 2 days then I need to convert those values to > days. > > ~| 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:311925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Please Help..Confused
Can you explain to goal a little bit... I can see a few uses for such data. For example, is the goal of the date input something like, "I need to rent a house for... 2 years, 3 months and 11 days" And then you need to calculate what the end date would be starting at Now()? =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:311923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Please Help..Confused
On Tue, Sep 2, 2008 at 11:29 AM, Laurie Smith <[EMAIL PROTECTED]>wrote: > > I have 3 drop-down boxes for: > > Years > > Months > > Days > > > > I need to combine the values for all 3 and convert to days so I can > > use the total number of days with DateDiff...Any suggestions would be > > greatly appreciated. Thanks > > I should have clarified that I am not passing a date such as mm/dd/. > The year dropdown contains the values 1-5 that the user can select, the > month is 1-11, and the days are 1-30. What I am trying to do is for example, > when if a user selects 2 years 2 months 2 days then I need to convert those > values to days. > but... but... some months have a different number of days than others :) if that's your desired result, you'll really need to capture a start date (and an end date) -- A byte walks into a bar and orders a pint. Bartender asks him "What's wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I thought you looked a bit off." ~| 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:311922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Please Help..Confused
> I have 3 drop-down boxes for: > Years > Months > Days > > I need to combine the values for all 3 and convert to days so I can > use the total number of days with DateDiff...Any suggestions would be > greatly appreciated. Thanks I should have clarified that I am not passing a date such as mm/dd/. The year dropdown contains the values 1-5 that the user can select, the month is 1-11, and the days are 1-30. What I am trying to do is for example, when if a user selects 2 years 2 months 2 days then I need to convert those values to days. ~| 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:311921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Please Help..Confused
One thing to add to William's code Check to make sure the value is a date first, or it'll throw an ugly exception. Datediff('d', '#form.month#/#form.day#/#form.year#', '[compared year]') The Form Value passed in was not a date On Tue, Sep 2, 2008 at 10:11 AM, William Seiter <[EMAIL PROTECTED]> wrote: > Datediff('d', '#form.month#/#form.day#/#form.year#', '[compared year]') > > Put your form field names in place of the 'form.' Values. Then put the > date > that you are comparing them to in the [compared year] spot. > > The 'd' indicates to return the difference in 'days'. > > -- > William Seiter > ColdFusion Web Developer / Consultant > http://william.seiter.com > > Free Website Trade Publication >> Website Magazine > http://www.websitemagazine.com/referrals/?id=51344&f=text2 > Don't forget to answer the survey questions, it's a 10 second task , > a very small request for access to this incredible resource. > > > ::-Original Message- > ::From: Laurie Smith [mailto:[EMAIL PROTECTED] > ::Sent: Tuesday, September 02, 2008 10:01 AM > ::To: CF-Talk > ::Subject: Please Help..Confused > :: > ::I have 3 drop-down boxes for: > ::Years > ::Months > ::Days > :: > ::I need to combine the values for all 3 and convert to days so I can use > ::the total number of days with DateDiff...Any suggestions would be greatly > ::appreciated. Thanks > :: > :: > > ~| 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:311914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Please Help..Confused
Datediff('d', '#form.month#/#form.day#/#form.year#', '[compared year]') Put your form field names in place of the 'form.' Values. Then put the date that you are comparing them to in the [compared year] spot. The 'd' indicates to return the difference in 'days'. -- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com Free Website Trade Publication >> Website Magazine http://www.websitemagazine.com/referrals/?id=51344&f=text2 Don't forget to answer the survey questions, it's a 10 second task , a very small request for access to this incredible resource. ::-Original Message- ::From: Laurie Smith [mailto:[EMAIL PROTECTED] ::Sent: Tuesday, September 02, 2008 10:01 AM ::To: CF-Talk ::Subject: Please Help..Confused :: ::I have 3 drop-down boxes for: ::Years ::Months ::Days :: ::I need to combine the values for all 3 and convert to days so I can use ::the total number of days with DateDiff...Any suggestions would be greatly ::appreciated. Thanks :: :: ~| 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:311913 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Please Help..Confused
I have 3 drop-down boxes for: Years Months Days I need to combine the values for all 3 and convert to days so I can use the total number of days with DateDiff...Any suggestions would be greatly appreciated. Thanks ~| 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:311912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC confusion. please help!
On Tuesday 24 Jun 2008, Brian Kotek wrote: > They "__type__" hack is only on the server side, to allow you to pass > structures to Flex and fool it into thinking it is a CFC, since CFC > creation is too slow when dealing with larger numbers of CFCs. On the Flex > side they convert to actual ActionScript classes so you still retain all > the code hinting, etc. in FlexBuilder. Of course, CF is dynamically typed, so it doesn't care than foo[i].property accesses an array of struct rather than an array of CFC, so CF code carries on regardless. CFEclipse doesn't do syntax insight so it's not a problem there. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:308051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC confusion. please help!
They "__type__" hack is only on the server side, to allow you to pass structures to Flex and fool it into thinking it is a CFC, since CFC creation is too slow when dealing with larger numbers of CFCs. On the Flex side they convert to actual ActionScript classes so you still retain all the code hinting, etc. in FlexBuilder. On Tue, Jun 24, 2008 at 6:40 AM, Dave Watts <[EMAIL PROTECTED]> wrote: > > Although with CF8 talking to Flex's RemoteObject, you can use > > an array of struct with a 'magic key' ('__type__') instead. > > But then, if you're using Flex Builder, you lose all the autocomplete > goodness that you get from having value objects, right? > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~| 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:308050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC confusion. please help!
On Tuesday 24 Jun 2008, Dave Watts wrote: > > an array of struct with a 'magic key' ('__type__') instead. > But then, if you're using Flex Builder, you lose all the autocomplete > goodness that you get from having value objects, right? Flex Builder keys off the ActionScript value objects, which remain strongly typed i.e. unchanged, including appropriate [RemoteClass] hints. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:308040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFC confusion. please help!
> Although with CF8 talking to Flex's RemoteObject, you can use > an array of struct with a 'magic key' ('__type__') instead. But then, if you're using Flex Builder, you lose all the autocomplete goodness that you get from having value objects, right? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:308034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC confusion. please help!
On Monday 23 Jun 2008, Matt Williams wrote: > One issue with returning an array of objects instead of a query is > that if you're talking about lots of records, creating all those > objects can become processing and memory intensive. Although with CF8 talking to Flex's RemoteObject, you can use an array of struct with a 'magic key' ('__type__') instead. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:308031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC confusion. please help!
One of the things that the other posters (particularly Matt) were getting at is that many times when you return a query object with a number of records, you're not looking to manipulate any of the records (yet). You're often listing records from the database so that one can be chosen for manipulation. And since in these cases, you generally need the ID of the record (so that you can choose it) and certain other fields (so the user can identify the record s/he wants), having something like an array of true objects is not really necessary. So the expense of all the object generation may not be justified. You and your boss might, however, want to look at one of the CF ORM frameworks, such as Transfer. Transfer mirrors some of the functionality that your boss might be familiar with in Hibernate (although Mark Mandel, the author, is very adamant about the fact that it is not a port of Hibernate). Although Transfer has methods that let you return traditional CF queries (listByQuery(), for instance), it mostly works with objects -- and often, arrays of objects (for instance, a Person object related to multiple Address objects). It also has caching mechanisms that help make working with those objects somewhat less expensive. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| 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:307970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC confusion. please help!
I'm definitely not the authority on ColdFusion and OO, however I have asked lots and lots of questions. The answer is almost always, 'it depends.' I return query objects all of the time. Sometimes I'll return a struct with a couple of variables and the query object inside. Do what makes sense for your situation. -Original Message- From: Lori Stone [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2008 8:36 AM To: CF-Talk Subject: CFC confusion. please help! We are starting to build a new application. We are having major confusion issues regarding the use of cfc's. My boss has a java background but not a coldfusion background. I have been using cfc's since mx came out but not to their full advantage. We have been reading about setter/getter beans, gateway objects, and dao, etc. We are trying to figure out the best way to set up this application for reusability and scaling. Can someone please explain the use of setter/getter, return types, and anything else you think would help with understanding the new use of cfc's. I have always returned query objects but apparently that is not the "best practice". I don't understand the problem with returning query objects. I would love to understand the reasoning and what the return type should be. ~| 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:307967 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC confusion. please help!
On Mon, Jun 23, 2008 at 8:36 AM, Lori Stone <[EMAIL PROTECTED]> wrote: > I have always returned query objects but apparently that is not the "best > practice". I don't understand the problem with returning query > objects. I would love to understand the reasoning and what the return type > should be. There is nothing wrong with returning queries. It really depends on your use case. Typically, if I'm needing one record, I return a simple object with getters/setters for each field. If I'm returning more than one record, I return a query. One issue with returning an array of objects instead of a query is that if you're talking about lots of records, creating all those objects can become processing and memory intensive. However, one potential way around this is to use Peter Bell's Iterating Business Object: http://ibo.riaforge.org/ -- Matt Williams "It's the question that drives us." ~| 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:307962 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC confusion. please help!
Lori, The reason that some people discourage the use of a query object as a return type is due to the fact that it binds whatever uses that query object directly to the database (more specifically, to the columns in the database). The use of setter/getter beans should be familiar to your boss; under the java design pattern "Transfer Object", and are used as a mechanism to transfer the data in an encapsulated fashion. Return types are used in CFCs to create a strongly typed system. There are many debates on strong typing variables within CF (see duck typing), so you will have decide what best fits your team and development style. "Gateway objects" refer to a design pattern that has grown within the CF community, and refers to an object that manages all aggregate database interaction, while a DAO (data access object) manages persisting a single object. Many of the problems that come up in traditional java OO application development apply directly to CF and many can be solved using the same solutions and design patterns. Conversly, there are also new prolbems that are introduced using CF that must be solved in much different ways. A concrete example would be in java it is typical to create large object graphs (nested sets of objects), where in CF you must limit the depth of the graph as there are high object instantiation costs. Good luck! Rich Kroll ~| 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:307956 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFC confusion. please help!
We are starting to build a new application. We are having major confusion issues regarding the use of cfc's. My boss has a java background but not a coldfusion background. I have been using cfc's since mx came out but not to their full advantage. We have been reading about setter/getter beans, gateway objects, and dao, etc. We are trying to figure out the best way to set up this application for reusability and scaling. Can someone please explain the use of setter/getter, return types, and anything else you think would help with understanding the new use of cfc's. I have always returned query objects but apparently that is not the "best practice". I don't understand the problem with returning query objects. I would love to understand the reasoning and what the return type should be. ~| 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:307955 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hello folks How to do paging on looping a list i was confused please help me
or indeed my custom tag cfMagicpager. http://www.stewart-web.co.uk/blog/index.cfm/2008/4/20/Cold It is a different take than Nathan's on pagination. Nathan Strutz wrote: > Shariff, > > I don't know exactly what you are attempting to do, but if you are looking > for a way to page your data, you may want to look into my Pagination.cfc > project. http://paginationcfc.riaforge.org/ > > If that's not it, perhaps you can elaborate your problem, with the overview, > what your goal is, what you have tried, what you get output from that code > and why it has failed? > > 1000 rows in a database table should not be a problem. I have had tables > with millions of rows. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303967 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: hello folks How to do paging on looping a list i was confused please help me
Shariff, I don't know exactly what you are attempting to do, but if you are looking for a way to page your data, you may want to look into my Pagination.cfc project. http://paginationcfc.riaforge.org/ If that's not it, perhaps you can elaborate your problem, with the overview, what your goal is, what you have tried, what you get output from that code and why it has failed? 1000 rows in a database table should not be a problem. I have had tables with millions of rows. -- nathan strutz http://www.dopefly.com/ On Mon, Apr 21, 2008 at 4:52 PM, shariff sml <[EMAIL PROTECTED]> wrote: > > > > > > > > > >thisemployeeid = listgetat(attributes.ids, thisplace); >thisperm = listgetat(attributes.perm, thisplace); > > template="#Request.CFRoot#/authentication/act_UserInfoFromEmpNumber.cfm" > employeeid="#ThisEmployeeID#"> > >if (len(lastname) AND QueryAddRow(adminQueryRaw)) { >QuerySetCell(adminQueryRaw, "empId", thisemployeeid); >QuerySetCell(adminQueryRaw, "lastname", LastName); >QuerySetCell(adminQueryRaw, "firstname", FirstName); >if (ThisPerm is 1) >QuerySetCell(adminQueryRaw, "status", "Full Administrator"); >else >QuerySetCell(adminQueryRaw, "status", "Reporting Only"); >} else { >badIDs = ListAppend(badIDs,"'#thisemployeeid#'"); >} > > > > > > how to do Pagging on this Code i know how to do if i loop over a query > > can any one help it out. this is because my data base i have over 1000 > records > and coldfusion server time out occures thanks you floks > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303955 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
hello folks How to do paging on looping a list i was confused please help me
thisemployeeid = listgetat(attributes.ids, thisplace); thisperm = listgetat(attributes.perm, thisplace); if (len(lastname) AND QueryAddRow(adminQueryRaw)) { QuerySetCell(adminQueryRaw, "empId", thisemployeeid); QuerySetCell(adminQueryRaw, "lastname", LastName); QuerySetCell(adminQueryRaw, "firstname", FirstName); if (ThisPerm is 1) QuerySetCell(adminQueryRaw, "status", "Full Administrator"); else QuerySetCell(adminQueryRaw, "status", "Reporting Only"); } else { badIDs = ListAppend(badIDs,"'#thisemployeeid#'"); } how to do Pagging on this Code i know how to do if i loop over a query can any one help it out. this is because my data base i have over 1000 records and coldfusion server time out occures thanks you floks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PDF creation in CF8 - not working...please help
Thanks Rupesh! I'll take a look at my code. I didn't realize I was using that, but sure enough, there it is. That makes perfect sense why the first section shows up, but the rest don't too! andy -Original Message- From: Rupesh Kumar [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 11, 2007 6:27 AM To: CF-Talk Subject: Re: PDF creation in CF8 - not working...please help Andy, It looks like the rendering engine for html/css in CF does not handle "overflow:auto". If you remove that from your style, the pdf will get created fine. Meanwhile we will investigate why "overflow:auto" style does not work. Thanks & Regards, Rupesh Adobe ColdFusion team. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294511 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PDF creation in CF8 - not working...please help
Well thank you very much. I'll def need to debug it. It's got to have something to do with the combo of the CSS and my HTML. I'll just have to figure it out. -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 8:42 PM To: CF-Talk Subject: Re: PDF creation in CF8 - not working...please help Andy, Obviously, I don't have enough work ;) or I just like to help. So I debugged a bit for you. If I include the CSS inside the cfdocument tag, I get the colors appropriately inside the PDF, but I get 15 pages, and only the first has data, the rest is blank, however, when I leave the css reference outside of the tag, I get six pages (yes, I am just working with a sample) but all the data is there. Basically, it seems that the second is doing something funky. I will save the PDFs I have generated if you want some samples of the results, plus the CFM (not pretty necessarily, but it does work). I do have an interest in learning CFDocument, but not necessarily a project to do it with, so *play* time is a good break from the day to day "when is it done yet" Let me know how you make out. Rob ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294509 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PDF creation in CF8 - not working...please help
Hey Rob... Last night I tried using an absolute path to the stylesheet, and that didn't work either. andy -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 2:47 PM To: CF-Talk Subject: Re: PDF creation in CF8 - not working...please help Andy, I just opened your source of your page above and copied a portion of it into a new document and wrapped it in a cfdocument, and it generated a PDF. Granted I don't have your stylesheet to use so none of the formatting came across the same, but text and images were there. Can you include the Stylesheet within the tag and see if that does anything? Rob ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294508 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PDF creation in CF8 - not working...please help
Andy, It looks like the rendering engine for html/css in CF does not handle "overflow:auto". If you remove that from your style, the pdf will get created fine. Meanwhile we will investigate why "overflow:auto" style does not work. Thanks & Regards, Rupesh Adobe ColdFusion team. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294506 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PDF creation in CF8 - not working...please help
Andy, It looks like the rendering engine for html/css in CF does not handle "overflow:auto". If you remove that from your style, the pdf will get created fine. Meanwhile we will investigate why "overflow:auto" style does not work. Thanks & Regards, Rupesh Adobe ColdFusion team. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PDF creation in CF8 - not working...please help
Andy, Obviously, I don't have enough work ;) or I just like to help. So I debugged a bit for you. If I include the CSS inside the cfdocument tag, I get the colors appropriately inside the PDF, but I get 15 pages, and only the first has data, the rest is blank, however, when I leave the css reference outside of the tag, I get six pages (yes, I am just working with a sample) but all the data is there. Basically, it seems that the second is doing something funky. I will save the PDFs I have generated if you want some samples of the results, plus the CFM (not pretty necessarily, but it does work). I do have an interest in learning CFDocument, but not necessarily a project to do it with, so *play* time is a good break from the day to day "when is it done yet" Let me know how you make out. Rob ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PDF creation in CF8 - not working...please help
I just realized I'm asking you to debug my code. Sorry about that. Thanks for the suggestion man. I'll check that out when I get home. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 4:11 PM To: CF-Talk Subject: RE: PDF creation in CF8 - not working...please help Hmmm... Can you try the same test, but use an absolute path to the CSS file? I wonder if I need to do that in my CSS generation, just like with images. -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 2:47 PM To: CF-Talk Subject: Re: PDF creation in CF8 - not working...please help Andy, I just opened your source of your page above and copied a portion of it into a new document and wrapped it in a cfdocument, and it generated a PDF. Granted I don't have your stylesheet to use so none of the formatting came across the same, but text and images were there. Can you include the Stylesheet within the tag and see if that does anything? Rob ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PDF creation in CF8 - not working...please help
Hmmm... Can you try the same test, but use an absolute path to the CSS file? I wonder if I need to do that in my CSS generation, just like with images. -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 2:47 PM To: CF-Talk Subject: Re: PDF creation in CF8 - not working...please help Andy, I just opened your source of your page above and copied a portion of it into a new document and wrapped it in a cfdocument, and it generated a PDF. Granted I don't have your stylesheet to use so none of the formatting came across the same, but text and images were there. Can you include the Stylesheet within the tag and see if that does anything? Rob ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294469 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PDF creation in CF8 - not working...please help
Andy, I just opened your source of your page above and copied a portion of it into a new document and wrapped it in a cfdocument, and it generated a PDF. Granted I don't have your stylesheet to use so none of the formatting came across the same, but text and images were there. Can you include the Stylesheet within the tag and see if that does anything? Rob ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PDF creation in CF8 - not working...please help
I was actually considering that. But the problem is that my CFC has code to do all of the conversion into DIVs. It just spits out a single variable for each distinct module. If it comes to that, that's what I'll do, but I'd rather avoid that if possible. It's got to have something to do with the CSS. I just don't know why. -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 9:21 AM To: CF-Talk Subject: Re: PDF creation in CF8 - not working...please help Andy, I guess that you could always design a high level CFR in report builder, and then pass the info that is generated for the proposals as a series of variables, but that seems messy. There is always something like ActivePDF which I was using (and still am on some sites still running 6) to create PDFs. I personally don't really like ActivePDF that much, just because, I didn't think that it ran as easily as I would've liked. You might have more success with the PDF creation if you take out the and use a table instead. I know that it is a pain, but I am sure that when I looked into my problem, there was something in the causing the error. Rob ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294457 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PDF creation in CF8 - not working...please help
Andy, I guess that you could always design a high level CFR in report builder, and then pass the info that is generated for the proposals as a series of variables, but that seems messy. There is always something like ActivePDF which I was using (and still am on some sites still running 6) to create PDFs. I personally don't really like ActivePDF that much, just because, I didn't think that it ran as easily as I would've liked. You might have more success with the PDF creation if you take out the and use a table instead. I know that it is a pain, but I am sure that when I looked into my problem, there was something in the causing the error. Rob ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294454 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PDF creation in CF8 - not working...please help
Thanks Rob...I'll give that a shot. As a followup question, assuming that I can't get this working with CFDocument, what are my options people? This is part of an app I'm building for a client. I promised them they could convert these proposals to PDF because I knew CF had that built in. Now it's not working and I'm left holding the bag. I'm sure it's got something to do with something in my CSS, because when I comment out the CSS include, everything displays. -Original Message- From: Rob Parkhill [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 8:08 AM To: CF-Talk Subject: Re: PDF creation in CF8 - not working...please help Andy, try changing your cfdocument tag to the following: I know that when I first started using cfdocument, I had to do this when using CSS on the page that was creating the PDF. Of course the resultant PDF doesn't have the same 'look', but you might find that it has something to do with Fontembed. HTH, Rob ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294452 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PDF creation in CF8 - not working...please help
Andy, try changing your cfdocument tag to the following: I know that when I first started using cfdocument, I had to do this when using CSS on the page that was creating the PDF. Of course the resultant PDF doesn't have the same 'look', but you might find that it has something to do with Fontembed. HTH, Rob ~| 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:294450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PDF creation in CF8 - not working...please help
Jochem... But the text doesn't display either. Nothing displays below the address information at the bottom of page 1. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 3:13 AM To: CF-Talk Subject: Re: PDF creation in CF8 - not working...please help Andy Matthews wrote: > I'm trying to create a PDF from a page and it's not working. The way I've read is that to do this, you simply wrap whatever content you have within cfdocument tags, with the type set to PDF. So that's what I've done, and it's not working correctly. > > Here's the actual page: > http://gaylordoprylandsales.com/prop/proposal.cfm?view=73534E3B54060A4 > C061052691D13 > > Here's the page when a PDF is trying to be generated: > http://gaylordoprylandsales.com/prop/proposal_pdf.cfm?view=73534E3B540 > 60A4C061052691D13 Change the HTML of the page so you don't refer to images by their relative path, but with a file:///d:/images... type URL and try again. Jochem ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PDF creation in CF8 - not working...please help
Andy Matthews wrote: > I'm trying to create a PDF from a page and it's not working. The way I've > read is that to do this, you simply wrap whatever content you have within > cfdocument tags, with the type set to PDF. So that's what I've done, and it's > not working correctly. > > Here's the actual page: > http://gaylordoprylandsales.com/prop/proposal.cfm?view=73534E3B54060A4C061052691D13 > > Here's the page when a PDF is trying to be generated: > http://gaylordoprylandsales.com/prop/proposal_pdf.cfm?view=73534E3B54060A4C061052691D13 Change the HTML of the page so you don't refer to images by their relative path, but with a file:///d:/images... type URL and try again. Jochem ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PDF creation in CF8 - not working...please help
Oh...one more thing. The code on the PDF page is identical (except for the cfdocument tag), which is set up like so: ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PDF creation in CF8 - not working...please help
Oh...one more thing. The code on the PDF page is identical (except for the cfdocument tag), which is set up like so: all code inside here ... ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294440 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
PDF creation in CF8 - not working...please help
I'm trying to create a PDF from a page and it's not working. The way I've read is that to do this, you simply wrap whatever content you have within cfdocument tags, with the type set to PDF. So that's what I've done, and it's not working correctly. Here's the actual page: http://gaylordoprylandsales.com/prop/proposal.cfm?view=73534E3B54060A4C061052691D13 Here's the page when a PDF is trying to be generated: http://gaylordoprylandsales.com/prop/proposal_pdf.cfm?view=73534E3B54060A4C061052691D13 You can see that the top portion of the proposal outputs just fine, but EVERYTHING ELSE is missing. It appears that the correct number of pages are there, so I can assume it's simply something with my HTML that's the problem, but I have no idea what it might be. It's not like you can debug this sort of thing. Does anyone have any idea why it might be doing this, and if so, what I can do to fix it? andy matthews ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Returns the value, "16,16"?? Please help!
On Thursday 11 Oct 2007, [EMAIL PROTECTED] wrote: > You'll get smarter answers if you say some words in your post. Sometimes I thing someone is testing a Turing entry... -- Tom Chiverton. Are you a great ColdFusion programmer, who knows Reactor and ColdSpring, and has done some Flex work ? Would you like to work for a top 30 law firm in Manchester, UK ? Are not an agency ? If yes, send email ! This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Returns the value, "16,16"?? Please help!
>You'll get smarter answers if you say some words in your post. While I have to agree, I suspect you problem is your form uses method="get" and you're appending #CGI.QUERY_STRING# to the action page. That will duplicate your parameter values. ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Returns the value, "16,16"?? Please help!
honestly, I haven't read the code posted, but I can say with certainty that you get a comma-delimited list in a single form field if you are submitting it twice. You'll get smarter answers if you say some words in your post. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Returns the value, "16,16"?? Please help!
#docTitle# #docTitle# (Secured Document) Date: #DateFormat(lastupdate, "MM/DD/YY")# Rev ##: Initial#revision# #docNumber# Summary: #Left(summary, 125)# (see more) ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: please help with CF8 install
> > I ran netstat and didnt see anything with port 2930. > > Giggity giggity!! > > Turning off the TCP/IP filtering fixed it. Thanks for the > help! Now I can sleep tonight. > > Giggity giggity!! I'm afraid to ask what you're doing with those ports, exactly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290777 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: please help with CF8 install
Giggity giggity!! Turning off the TCP/IP filtering fixed it. Thanks for the help! Now I can sleep tonight. Giggity giggity!! On 10/10/07, Phill B <[EMAIL PROTECTED]> wrote: > The CF8 Application Service is running. > > I ran netstat and didnt see anything with port 2930. I checked to see > if TCP/IP was filtering and it was so I have disabled that to see what > happens. > > The links you gave are for previous versions of CF. Will the info for > CF7 work for CF8 > > On 10/10/07, Asha K S <[EMAIL PROTECTED]> wrote: > > Hi, > > Can you check the following > > 1) Is the ColdFusion server running? > > 2) netstat -a can be used to confirm the port is actively being listened > > to on > > 4) If not, is a firewall blocking the port? Does wsconfig still fail > > when the firewall is off? > > 5)Is there any other program that might have been running and listening > > on port 2930? > > > > The following links could be helpful > > http://www.talkingtree.com/blog/index.cfm/2005/2/9/WsconfigRandPort > > http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19575&slice > > Id=1 > > http://kb.adobe.com/selfservice/viewContent.do?externalId=8a0aaf29&slice > > Id=2 > > > > > > Thanks, > > Asha. > > -Original Message- > > From: Andy Allan [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, October 10, 2007 1:43 PM > > To: CF-Talk > > Subject: Re: please help with CF8 install > > > > Did you try to hook up the Web Server during the install process? Or > > did you initially install with the built in web server and are now > > running wsconfig afterwards? > > > > Just looking to see if CF actually installed OK. > > > > Is there a firewall blocking port 2930? > > Is there something else already using port 2930? > > > > You can also bypass wsconfig and manually install the web server > > connection if it comes down to it. We typically do this when dealing > > with Distributed Mode installs (web and application tiers on different > > physical servers). > > > > Andy > > > > On 10/10/2007, Phill B <[EMAIL PROTECTED]> wrote: > > > I have been trying to get CF8 to install on a Win 2k3 server for two > > > nights now and with out success. I'm having the same problem that I've > > > had with CF 7 and the wsconfig. > > > > > > This is the error in the connectorinstall0.txt file > > > > > > could not connect to port 2930 on host 127.0.0.1 > > > javax.naming.ServiceUnavailableException: The connection to the remote > > > JNDI server on host 127.0.0.1 at port 2930 has failed (as have all > > > backup hosts listed, if any) - please verify that the server is > > > running and the NamingService is available > > > > > > I have tried the email help that Adobe offers for installations and > > > that didn't help much. Just got a link to this page but it doesnt tell > > > me how to fix my problem. > > > > > http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=webser > > vmgmt_5.html > > > > > > Any suggestions? I cant find any real help on the net for this and > > > I've been looking for two days now. > > > > > > -- > > > Phil > > > > > > > > > > > > > > ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290767 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: please help with CF8 install
The CF8 Application Service is running. I ran netstat and didnt see anything with port 2930. I checked to see if TCP/IP was filtering and it was so I have disabled that to see what happens. The links you gave are for previous versions of CF. Will the info for CF7 work for CF8 On 10/10/07, Asha K S <[EMAIL PROTECTED]> wrote: > Hi, > Can you check the following > 1) Is the ColdFusion server running? > 2) netstat -a can be used to confirm the port is actively being listened > to on > 4) If not, is a firewall blocking the port? Does wsconfig still fail > when the firewall is off? > 5)Is there any other program that might have been running and listening > on port 2930? > > The following links could be helpful > http://www.talkingtree.com/blog/index.cfm/2005/2/9/WsconfigRandPort > http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19575&slice > Id=1 > http://kb.adobe.com/selfservice/viewContent.do?externalId=8a0aaf29&slice > Id=2 > > > Thanks, > Asha. > -Original Message- > From: Andy Allan [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 10, 2007 1:43 PM > To: CF-Talk > Subject: Re: please help with CF8 install > > Did you try to hook up the Web Server during the install process? Or > did you initially install with the built in web server and are now > running wsconfig afterwards? > > Just looking to see if CF actually installed OK. > > Is there a firewall blocking port 2930? > Is there something else already using port 2930? > > You can also bypass wsconfig and manually install the web server > connection if it comes down to it. We typically do this when dealing > with Distributed Mode installs (web and application tiers on different > physical servers). > > Andy > > On 10/10/2007, Phill B <[EMAIL PROTECTED]> wrote: > > I have been trying to get CF8 to install on a Win 2k3 server for two > > nights now and with out success. I'm having the same problem that I've > > had with CF 7 and the wsconfig. > > > > This is the error in the connectorinstall0.txt file > > > > could not connect to port 2930 on host 127.0.0.1 > > javax.naming.ServiceUnavailableException: The connection to the remote > > JNDI server on host 127.0.0.1 at port 2930 has failed (as have all > > backup hosts listed, if any) - please verify that the server is > > running and the NamingService is available > > > > I have tried the email help that Adobe offers for installations and > > that didn't help much. Just got a link to this page but it doesnt tell > > me how to fix my problem. > > > http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=webser > vmgmt_5.html > > > > Any suggestions? I cant find any real help on the net for this and > > I've been looking for two days now. > > > > -- > > Phil > > > > > > > > ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290760 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: please help with CF8 install
Hi, Can you check the following 1) Is the ColdFusion server running? 2) netstat -a can be used to confirm the port is actively being listened to on 4) If not, is a firewall blocking the port? Does wsconfig still fail when the firewall is off? 5)Is there any other program that might have been running and listening on port 2930? The following links could be helpful http://www.talkingtree.com/blog/index.cfm/2005/2/9/WsconfigRandPort http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19575&slice Id=1 http://kb.adobe.com/selfservice/viewContent.do?externalId=8a0aaf29&slice Id=2 Thanks, Asha. -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 10, 2007 1:43 PM To: CF-Talk Subject: Re: please help with CF8 install Did you try to hook up the Web Server during the install process? Or did you initially install with the built in web server and are now running wsconfig afterwards? Just looking to see if CF actually installed OK. Is there a firewall blocking port 2930? Is there something else already using port 2930? You can also bypass wsconfig and manually install the web server connection if it comes down to it. We typically do this when dealing with Distributed Mode installs (web and application tiers on different physical servers). Andy On 10/10/2007, Phill B <[EMAIL PROTECTED]> wrote: > I have been trying to get CF8 to install on a Win 2k3 server for two > nights now and with out success. I'm having the same problem that I've > had with CF 7 and the wsconfig. > > This is the error in the connectorinstall0.txt file > > could not connect to port 2930 on host 127.0.0.1 > javax.naming.ServiceUnavailableException: The connection to the remote > JNDI server on host 127.0.0.1 at port 2930 has failed (as have all > backup hosts listed, if any) - please verify that the server is > running and the NamingService is available > > I have tried the email help that Adobe offers for installations and > that didn't help much. Just got a link to this page but it doesnt tell > me how to fix my problem. > http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=webser vmgmt_5.html > > Any suggestions? I cant find any real help on the net for this and > I've been looking for two days now. > > -- > Phil > > ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290725 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: please help with CF8 install
afaik, win 2k3 server disables port scanning, which is what cf installer does looking for port 2930. i have come across a blog post with solution on how to temporarily allow port scanning / run specific jndi init line, but can't recall on which blog now it could have been on adobe cf forums, too Azadi Phill B wrote: > I have been trying to get CF8 to install on a Win 2k3 server for two > nights now and with out success. I'm having the same problem that I've > had with CF 7 and the wsconfig. > > This is the error in the connectorinstall0.txt file > > could not connect to port 2930 on host 127.0.0.1 > javax.naming.ServiceUnavailableException: The connection to the remote > JNDI server on host 127.0.0.1 at port 2930 has failed (as have all > backup hosts listed, if any) - please verify that the server is > running and the NamingService is available > > I have tried the email help that Adobe offers for installations and > that didn't help much. Just got a link to this page but it doesnt tell > me how to fix my problem. > http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=webservmgmt_5.html > > Any suggestions? I cant find any real help on the net for this and > I've been looking for two days now. > > -- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: please help with CF8 install
Did you try to hook up the Web Server during the install process? Or did you initially install with the built in web server and are now running wsconfig afterwards? Just looking to see if CF actually installed OK. Is there a firewall blocking port 2930? Is there something else already using port 2930? You can also bypass wsconfig and manually install the web server connection if it comes down to it. We typically do this when dealing with Distributed Mode installs (web and application tiers on different physical servers). Andy On 10/10/2007, Phill B <[EMAIL PROTECTED]> wrote: > I have been trying to get CF8 to install on a Win 2k3 server for two > nights now and with out success. I'm having the same problem that I've > had with CF 7 and the wsconfig. > > This is the error in the connectorinstall0.txt file > > could not connect to port 2930 on host 127.0.0.1 > javax.naming.ServiceUnavailableException: The connection to the remote > JNDI server on host 127.0.0.1 at port 2930 has failed (as have all > backup hosts listed, if any) - please verify that the server is > running and the NamingService is available > > I have tried the email help that Adobe offers for installations and > that didn't help much. Just got a link to this page but it doesnt tell > me how to fix my problem. > http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=webservmgmt_5.html > > Any suggestions? I cant find any real help on the net for this and > I've been looking for two days now. > > -- > Phil > > ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
please help with CF8 install
I have been trying to get CF8 to install on a Win 2k3 server for two nights now and with out success. I'm having the same problem that I've had with CF 7 and the wsconfig. This is the error in the connectorinstall0.txt file could not connect to port 2930 on host 127.0.0.1 javax.naming.ServiceUnavailableException: The connection to the remote JNDI server on host 127.0.0.1 at port 2930 has failed (as have all backup hosts listed, if any) - please verify that the server is running and the NamingService is available I have tried the email help that Adobe offers for installations and that didn't help much. Just got a link to this page but it doesnt tell me how to fix my problem. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=webservmgmt_5.html Any suggestions? I cant find any real help on the net for this and I've been looking for two days now. -- Phil ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Please Help - deploying CF 7.2 enterprise on Jrun 4 / unix
Hi All I'm having some problems with an install of CF 7. I was running a deply script that had previously worked fine but this time it messed up CF server. When I opened a page it said: "There is no web application configured to service your request" When I look at the JRun Management Console Cold Fision is no longer listed for the site I am using. Before I have re-deployed CF which worked fine and maintained all of the settings. This time I am having to deploy it from scratch. I found an ear to use: /rootdirname/jrun4/servers/warsears/adobe/cf7_2.ear and it seemed to deploy fine. However when I try to load a file from the server it says it can't find the file. Cf is looking in /rootdirname/jrun4/servers/apt/cfflex-ear/cfflex-war instead of /rootdirname/jrun4/servers/apt/cfusion-ear/cfusion-war in Jrun ADmin I've noticed that all teh other sites have the root directory set to: file:/rootdirname/jrun4/servers//cfusion-ear/ but after I have deployed the new build it is: file:/rootdirname/jrun4/servers/warsears/adobe/cf7_2.ear I really jsut wnat to know how I can deploy it to the cfusion-war directory instead of the cfflex-war directory. Working out how to re-setup the directories will be the next challenge! I really hope someone can help. Thanks Giles. ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: reReplaceNoCase() problem from a newbie, please help
No you understood perferctly thanks very much. The second bit of your iteration actually saved the day as I was messing about with CFSavecontent. I've actually tweaked the code a bit because I am actually only after the file name. See below; ]*>", "hardcoded ", "all")> That's me done for now many thanks. Jide >Unless I misunderstand... > >rereplace(dataContent, "", "Href=""\1"">hardcoded FormalName=""hardcoded""/> />", "all") > >.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com > > >-Original Message- >From: Jide Aliu [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 14, 2007 10:44 AM >To: CF-Talk >Subject: Re: reReplaceNoCase() problem from a newbie, please help > >Thanks Bobby for taking time out for the solution, that did the trick. It's >the start of my problem on the solution though how would you go about >reReplacing the same item with the tags below in a body of text/string. Is >it at all possible or should I be looking at something different from Regex? > > >hardcoded FormalName="hard coded"/> > >So instead of isolating the the image name like I did below REReplaceNoCase(dataContent, >"]*>", "\4", "ALL")> >I want to take the image name and insert it into the Href="BlissStarWars_15.jpg"> with all the accompanying tags > > >> Try this one out. >> >> rereplace(dataContent, "", "\1", >> "all") >> >.. >Unless I misunderstand... > >rereplace(dataContent, "", "Href=""\1"">hardcoded FormalName=""hardcoded""/> />", "all") > >.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com > > >-Original Message- >From: Jide Aliu [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 14, 2007 10:44 AM >To: CF-Talk >Subject: Re: reReplaceNoCase() problem from a newbie, please help > >Thanks Bobby for taking time out for the solution, that did the trick. It's >the start of my problem on the solution though how would you go about >reReplacing the same item with the tags below in a body of text/string. Is >it at all possible or should I be looking at something different from Regex? > > >hardcoded FormalName="hard coded"/> > >So instead of isolating the the image name like I did below REReplaceNoCase(dataContent, >"]*>", "\4", "ALL")> >I want to take the image name and insert it into the Href="BlissStarWars_15.jpg"> with all the accompanying tags > > >> Try this one out. >> >> rereplace(dataContent, "", "\1", >> "all") >> >.. ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reReplaceNoCase() problem from a newbie, please help
No you understood perferctly thanks very much. The second bit of your iteration actually saved the day as I was messing about with CFSavecontent. I've actually tweaked the code a bit because I am actually only after the file name. See below; ]*>", "hardcoded ", "all")> That's me done for now many thanks. Jide >Unless I misunderstand... > >rereplace(dataContent, "", "Href=""\1"">hardcoded FormalName=""hardcoded""/> />", "all") > >.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com > > >-Original Message- >From: Jide Aliu [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 14, 2007 10:44 AM >To: CF-Talk >Subject: Re: reReplaceNoCase() problem from a newbie, please help > >Thanks Bobby for taking time out for the solution, that did the trick. It's >the start of my problem on the solution though how would you go about >reReplacing the same item with the tags below in a body of text/string. Is >it at all possible or should I be looking at something different from Regex? > > >hardcoded FormalName="hard coded"/> > >So instead of isolating the the image name like I did below REReplaceNoCase(dataContent, >"]*>", "\4", "ALL")> >I want to take the image name and insert it into the Href="BlissStarWars_15.jpg"> with all the accompanying tags > > >> Try this one out. >> >> rereplace(dataContent, "", "\1", >> "all") >> >.. ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: reReplaceNoCase() problem from a newbie, please help
Unless I misunderstand... rereplace(dataContent, "", "hardcoded ", "all") ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Jide Aliu [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 10:44 AM To: CF-Talk Subject: Re: reReplaceNoCase() problem from a newbie, please help Thanks Bobby for taking time out for the solution, that did the trick. It's the start of my problem on the solution though how would you go about reReplacing the same item with the tags below in a body of text/string. Is it at all possible or should I be looking at something different from Regex? hardcoded So instead of isolating the the image name like I did below ]*>", "\4", "ALL")> I want to take the image name and insert it into the with all the accompanying tags > Try this one out. > > rereplace(dataContent, "", "\1", > "all") > ... > :.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > -Original Message- > From: Jide Aliu [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 14, 2007 5:46 AM > To: CF-Talk > Subject: reReplaceNoCase() problem from a newbie, please help > > I have a body of text, in the body of text I want to replace all image > tags with the value of the src attribute, so for example below > > "This is the body it can be as long as 8,000 character but within the > body here is the image tag src="/uploads/allfiles/Image/BlissStarWars_15.jpg" width="200"/> and > here I go blah blah another image tag with a different value in the > src attribute src="/uploads/allfiles/Image/245.jpg" width="200"/>" > > All I want to do is to replace the tags with the src value which > is BlissStarWars_15.jpg for the first image tag encountered and 245. > jpg for the second image tag. I have tried using the code below > without any joy at all. > > *?)['|"].*?>','\1','ALL')> > ~| 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:281154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reReplaceNoCase() problem from a newbie, please help
Thanks Bobby for taking time out for the solution, that did the trick. It's the start of my problem on the solution though how would you go about reReplacing the same item with the tags below in a body of text/string. Is it at all possible or should I be looking at something different from Regex? hardcoded So instead of isolating the the image name like I did below ]*>", "\4", "ALL")> I want to take the image name and insert it into the with all the accompanying tags > Try this one out. > > rereplace(dataContent, "", "\1", > "all") > .. > :.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > -Original Message- > From: Jide Aliu [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 14, 2007 5:46 AM > To: CF-Talk > Subject: reReplaceNoCase() problem from a newbie, please help > > I have a body of text, in the body of text I want to replace all image > tags with the value of the src attribute, so for example below > > "This is the body it can be as long as 8,000 character but within the > body here is the image tag src="/uploads/allfiles/Image/BlissStarWars_15.jpg" width="200"/> and > here I go blah blah another image tag with a different value in the > src attribute src="/uploads/allfiles/Image/245.jpg" width="200"/>" > > All I want to do is to replace the tags with the src value which > is BlissStarWars_15.jpg for the first image tag encountered and 245. > jpg for the second image tag. I have tried using the code below > without any joy at all. > > *?)['|"].*?>','\1','ALL')> > ~| 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:281139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: reReplaceNoCase() problem from a newbie, please help
Try this one out. rereplace(dataContent, "", "\1", "all") ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Jide Aliu [mailto:[EMAIL PROTECTED] Sent: Thursday, June 14, 2007 5:46 AM To: CF-Talk Subject: reReplaceNoCase() problem from a newbie, please help I have a body of text, in the body of text I want to replace all image tags with the value of the src attribute, so for example below "This is the body it can be as long as 8,000 character but within the body here is the image tag and here I go blah blah another image tag with a different value in the src attribute " All I want to do is to replace the tags with the src value which is BlissStarWars_15.jpg for the first image tag encountered and 245.jpg for the second image tag. I have tried using the code below without any joy at all. ','\1','ALL')> ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
reReplaceNoCase() problem from a newbie, please help
I have a body of text, in the body of text I want to replace all image tags with the value of the src attribute, so for example below "This is the body it can be as long as 8,000 character but within the body here is the image tag and here I go blah blah another image tag with a different value in the src attribute " All I want to do is to replace the tags with the src value which is BlissStarWars_15.jpg for the first image tag encountered and 245.jpg for the second image tag. I have tried using the code below without any joy at all. ','\1','ALL')> ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Please Help! ORA-01704: string literal too long Error (CFMX)
Wow, haven't run into that one in a long time. Some of this is from the CF 5 days, but one or a combination of these should help. 1. Make sure there aren't any restrictions set on the datasource in the ColdFusion administrator ("Enable retrieval of long text" disabled, etc.) 2. Try a different driver - as Dave suggested, first make sure you have the most up-to-date CF drivers, and if that doesn't help, try an alternate JDBC driver, or even ODBC a shot. 3. Use CFQUERYPARAM. This one was generally the "magic bullet" for me in the past. Oracle just seems much happier getting long string data in a bind variable rather than as a literal. On 4/17/07, Brad Stone <[EMAIL PROTECTED]> wrote: > > All: > > I have a situation where well-formed INSERT or UPDATE pass-thru queries > fail through the native Oracle driver, but executes successfully in Toad or > SQL*Plus: > > [Macromedia][Oracle JDBC Driver][Oracle]ORA-01704: string literal too long > > I'm running CFMX 6.1 and Oracle 10G. I've verified this in three > Oracle/CF instances. There are no extended character sets (all one byte > characters.) Using default Oracle 10G character set. > > I am aware that this was an issue with versions of CF prior to version 5.0- > all the posts out there simply seem to interate this fact (but it doesn't > help in solving the problem.) Has there anybody out there dealt with this > problem, and found a fix (outside of using CLOBS?) > > Thanks! > > > > > > ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275597 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Please Help! ORA-01704: string literal too long Error (CFMX)
All: I have a situation where well-formed INSERT or UPDATE pass-thru queries fail through the native Oracle driver, but executes successfully in Toad or SQL*Plus: [Macromedia][Oracle JDBC Driver][Oracle]ORA-01704: string literal too long I'm running CFMX 6.1 and Oracle 10G. I've verified this in three Oracle/CF instances. There are no extended character sets (all one byte characters.) Using default Oracle 10G character set. I am aware that this was an issue with versions of CF prior to version 5.0 - all the posts out there simply seem to interate this fact (but it doesn't help in solving the problem.) Has there anybody out there dealt with this problem, and found a fix (outside of using CLOBS?) Thanks! ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275573 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Please Help! ORA-01704: string literal too long Error (CFMX)
> I have a situation where well-formed INSERT or UPDATE > pass-thru queries fail through the native Oracle driver, but > executes successfully in Toad or SQL*Plus: > > [Macromedia][Oracle JDBC Driver][Oracle]ORA-01704: string > literal too long > > I'm running CFMX 6.1 and Oracle 10G. I've verified this in > three Oracle/CF instances. There are no extended character > sets (all one byte characters.) Using default Oracle 10G > character set. > > I am aware that this was an issue with versions of CF prior > to version 5.0 - all the posts out there simply seem to > interate this fact (but it doesn't help in solving the > problem.) Has there anybody out there dealt with this > problem, and found a fix (outside of using CLOBS?) I have no idea how to fix your problem, but I thought these questions might be helpful. Have you downloaded the latest DataDirect JDBC drivers from the CF hotfix list? Are you using CFQUERYPARAM? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| 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:275574 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re[2]: please help me to debug this code... thanks
Friday, March 16, 2007 10:00:20 AM (PST) The problem is that authentication of the users is made from a table in access, and it doesn't connect (or I don't know how to make that) and it doesn't forward me to the mainpage, where I ave to type username/password. email me private vadrianc at gmail.com thanks. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Adrian C. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= __ "Have you ever had a dream, that you were so sure was real? What if you were unable to wake from that dream? How would you know the difference between the dream world and the real world?" - Morpheus from Matrix __ avoid using my email address on web sites. NO SPAM. __ Friday, March 16, 2007, 8:32:24 AM Adkins, Randy <[EMAIL PROTECTED]> wrote : > What is the problem? > I see that as long as your are running on PORT 80, you will get > redirected as indicated > > http://192.168.1.7";> > Are you expecting something else?? > -Original Message- > From: Adrian C. [mailto:[EMAIL PROTECTED] > Sent: Friday, March 16, 2007 12:20 PM > To: CF-Talk > Subject: please help me to debug this code... thanks > redirects me with : http://192.168.1.7/?CFID=500&CFTOKEN=80457585 > migrating from coldfusion 5 to mx 7. > the other intranet websites that I have, are working. > this site used to have an dns name, also this one used ssl certificate, > but I don't want to use it anymore. > code below. thanks. > a paypal donation for who is the "hero". > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > -=-=-= > name="aihssis" > clientmanagement="Yes" > sessionmanagement="Yes" > sessiontimeout=#createtimespan(0,0,10,0)# > applicationtimeout=#createtimespan(0,0,10,0)#> > > > > name="session.userid" default=''> > > > http://192.168.1.7";> > > > > > > > ---> > > > > > > > > > > > > (#cgi.script_name# neq "/flush.cfm") and > (#cgi.script_name# neq "/time.cfm") and > (#cgi.script_name# neq "/xerox.cfm") and > (#cgi.script_name# neq "/form_lookupCheckBox.cfm") and > (#cgi.script_name# neq "/act_lookupCheckBox.cfm") and > (#cgi.script_name# neq "/dsp_displayCheckBox.cfm") and > (#cgi.script_name# neq "/form_insertCheckBox.cfm") and > (#cgi.script_name# neq "/act_insertCheckBox.cfm") and > (#cgi.script_name# neq "/act_updateCheckBox.cfm") and > (#cgi.script_name# neq "/late.cfm") and > (#cgi.script_name# neq "/reports/report.cfm") and > (#cgi.script_name# neq "/dsp_countAbsences.cfm") and > (#cgi.script_name# neq "/dsp_mandatoryTutoring.cfm") and > (#cgi.script_name# neq "/students/act_doeditfachecklist.cfm") > and > (#cgi.script_name# neq "/dsp_perfectAttendance.cfm") and > (#cgi.script_name# neq > "/qry_currentptstudentsbyblock_attendance.cfm") and > (#cgi.script_name# neq "/pt.cfm") and > (#cgi.script_name# neq > "/qry_currentrmastudentsbyblock_attendance.cfm") and > (#cgi.script_name# neq "/rma.cfm") and > (#cgi.script_name# neq "/absences.cfm")> > > <!-- > alert("Invalid URL."); > self.location="/index.cfm"; > // --> > > > > > (#cgi.script_name# neq "/flush.cfm") and > (#cgi.script_name# neq "/time.cfm") and > (#cgi.script_name# neq "/xerox.cfm") and > (#cgi.script_name# neq "/absences.cfm") and > (#cgi.script_name# neq "/report.cfm") and > (session.loggedin is "no")> > gotourl="/index.cfm?fuseaction=relogon" > returnurl="#cgi.script_name#?#cgi.query_string#"> > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: please help me to debug this code... thanks
What is the problem? I see that as long as your are running on PORT 80, you will get redirected as indicated http://192.168.1.7";> Are you expecting something else?? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: please help me to debug this code... thanks
What is the problem? I see that as long as your are running on PORT 80, you will get redirected as indicated http://192.168.1.7";> Are you expecting something else?? -Original Message- From: Adrian C. [mailto:[EMAIL PROTECTED] Sent: Friday, March 16, 2007 12:20 PM To: CF-Talk Subject: please help me to debug this code... thanks redirects me with : http://192.168.1.7/?CFID=500&CFTOKEN=80457585 migrating from coldfusion 5 to mx 7. the other intranet websites that I have, are working. this site used to have an dns name, also this one used ssl certificate, but I don't want to use it anymore. code below. thanks. a paypal donation for who is the "hero". -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -=-=-= http://192.168.1.7";> ---> <!-- alert("Invalid URL."); self.location="/index.cfm"; // --> ~| 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:272847 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
please help me to debug this code
redirects me with : http://192.168.1.7/?CFID=500&CFTOKEN=80457585 migrating from coldfusion 5 to mx 7. the other intranet websites that I have, are working. this site used to have an dns name, also this one used ssl certificate, but I don't want to use it anymore. code below. thanks. a paypal donation for who is the "hero". -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://192.168.1.7";> ---> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Adrian C. [EMAIL PROTECTED] -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= __ "Have you ever had a dream, that you were so sure was real? What if you were unable to wake from that dream? How would you know the difference between the dream world and the real world?" - Morpheus from Matrix __ avoid using my email address on web sites. NO SPAM. __ ~| 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:272846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
please help me to debug this code... thanks
redirects me with : http://192.168.1.7/?CFID=500&CFTOKEN=80457585 migrating from coldfusion 5 to mx 7. the other intranet websites that I have, are working. this site used to have an dns name, also this one used ssl certificate, but I don't want to use it anymore. code below. thanks. a paypal donation for who is the "hero". -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://192.168.1.7";> ---> ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CALLING ALL SQL EXPERTS, Please help
GOT IT! THANKS TO MIKE KLOSTERMEYER FROM CFWEBTOOLS select v.itemid, v.title, e.datecreated, e.eventid from v_items v INNER Join Events e on v.itemid = e.itemid where e.eventid in ( select top 1 e2.eventid from events e2 where e2.itemid = v.itemid AND e.createdbyuserid = 92 order by e2.datecreated desc ) order by e.datecreated desc -Original Message- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 9:48 AM To: CF-Talk Subject: Re: CALLING ALL SQL EXPERTS, Please help Can you provide a sample of the table prior to your joins so that I may see your foreign keys. Teddy On 11/16/06, Axel Jensen <[EMAIL PROTECTED]> wrote: > > > > > > > I'm trying to create a "most recently updated" list of tracks that we > update, and track our bugs, and feature requests with. The list that I > want > will end up looking like this. (where the query ends up just grabbing the > most recent results, and doesn't duplicate. > > > > 921028 Northern Natural Gas Flash Quiz Review2006-11-15 > 15:46:53.280 > > 92975 New E-commerce Integration2006-11-10 17:19:59.450 > > 92974 Feedback Form 2006-11-10 17:12:29.703 > > 921044 SQL Changes and Calander Move 2006-11-08 08:30:46.357 > > 92897 web based problem log for nphl.org and reglab.org > 2006-11-06 > 16:42:19.153 > > > > > > > > I realize that the reason I'm getting the duplicates is because I'm trying > to get distinct values on the date created. therefor I'm getting all the > correct values. as far as sql goes. > > > > But I'm not sure how I would go about getting what I need. I know that if > I > cut the date out of the select statement, the query works, but then I > can't > sort by the most recently updated. so the list becomes rather useless to > us. > any help would be great > > > > > > > > SELECT DISTINCTe.createdByUserID,i.itemID, i.title, e.datecreated > > FROMevents e > > JOINv_items i ON e.itemID = i.itemID > > WHERE e.createdbyuserid = 92 > > ORDER BYe.datecreated desc > > > > Results: > > 921028 Northern Natural Gas Flash Quiz Review2006-11-15 > 15:46:53.280 > > 92975 New E-commerce Integration2006-11-10 17:19:59.450 > > 92974 Feedback Form 2006-11-10 17:12:29.703 > > 921045 Email latest cow report to new cow rpt > subscribers2006-11-09 > 15:03:38.140 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-09 > 10:39:28.483 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-09 > 08:31:58.840 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-08 > 16:30:32.343 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-08 > 11:51:49.967 > > 92975 New E-commerce Integration2006-11-08 10:55:34.903 > > 921044 SQL Changes and Calander Move 2006-11-08 08:30:46.357 > > 921044 SQL Changes and Calander Move 2006-11-07 16:34:47.810 > > 92975 New E-commerce Integration2006-11-06 16:44:33.983 > > 92897 web based problem log for nphl.org and reglab.org > 2006-11-06 > 16:42:19.153 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-06 > 16:40:46.700 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-06 > 11:14:32.670 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-06 > 11:06:30.793 > > > > > > Axel > > > > > > ~| 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:260675 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CALLING ALL SQL EXPERTS, Please help
Can you provide a sample of the table prior to your joins so that I may see your foreign keys. Teddy On 11/16/06, Axel Jensen <[EMAIL PROTECTED]> wrote: > > > > > > > I'm trying to create a "most recently updated" list of tracks that we > update, and track our bugs, and feature requests with. The list that I > want > will end up looking like this. (where the query ends up just grabbing the > most recent results, and doesn't duplicate. > > > > 921028 Northern Natural Gas Flash Quiz Review2006-11-15 > 15:46:53.280 > > 92975 New E-commerce Integration2006-11-10 17:19:59.450 > > 92974 Feedback Form 2006-11-10 17:12:29.703 > > 921044 SQL Changes and Calander Move 2006-11-08 08:30:46.357 > > 92897 web based problem log for nphl.org and reglab.org > 2006-11-06 > 16:42:19.153 > > > > > > > > I realize that the reason I'm getting the duplicates is because I'm trying > to get distinct values on the date created. therefor I'm getting all the > correct values. as far as sql goes. > > > > But I'm not sure how I would go about getting what I need. I know that if > I > cut the date out of the select statement, the query works, but then I > can't > sort by the most recently updated. so the list becomes rather useless to > us. > any help would be great > > > > > > > > SELECT DISTINCTe.createdByUserID,i.itemID, i.title, e.datecreated > > FROMevents e > > JOINv_items i ON e.itemID = i.itemID > > WHERE e.createdbyuserid = 92 > > ORDER BYe.datecreated desc > > > > Results: > > 921028 Northern Natural Gas Flash Quiz Review2006-11-15 > 15:46:53.280 > > 92975 New E-commerce Integration2006-11-10 17:19:59.450 > > 92974 Feedback Form 2006-11-10 17:12:29.703 > > 921045 Email latest cow report to new cow rpt > subscribers2006-11-09 > 15:03:38.140 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-09 > 10:39:28.483 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-09 > 08:31:58.840 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-08 > 16:30:32.343 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-08 > 11:51:49.967 > > 92975 New E-commerce Integration2006-11-08 10:55:34.903 > > 921044 SQL Changes and Calander Move 2006-11-08 08:30:46.357 > > 921044 SQL Changes and Calander Move 2006-11-07 16:34:47.810 > > 92975 New E-commerce Integration2006-11-06 16:44:33.983 > > 92897 web based problem log for nphl.org and reglab.org > 2006-11-06 > 16:42:19.153 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-06 > 16:40:46.700 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-06 > 11:14:32.670 > > 921028 Northern Natural Gas Flash Quiz Review2006-11-06 > 11:06:30.793 > > > > > > Axel > > > > > > ~| 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:260668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CALLING ALL SQL EXPERTS, Please help
I place my vote with Jim and Rick. They beat me to it. ~Brad -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 9:44 AM To: CF-Talk Subject: Re: CALLING ALL SQL EXPERTS, Please help You need a group by and an aggregate function: SELECT DISTINCTe.createdByUserID,i.itemID, i.title, max(e.datecreated) FROMevents e JOIN v_items i ON e.itemID = i.itemID WHERE e.createdbyuserid = 92 GROUP BYe.createdByUserID, i.itemID, i.title ORDER BYe.datecreated desc Rick ~| 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:260667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CALLING ALL SQL EXPERTS, Please help
(if I forgot to exclude it.. do NOT use the "distinct" in that query) ~| 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:260666 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CALLING ALL SQL EXPERTS, Please help
You need a group by and an aggregate function: SELECT DISTINCTe.createdByUserID,i.itemID, i.title, max(e.datecreated) FROMevents e JOIN v_items i ON e.itemID = i.itemID WHERE e.createdbyuserid = 92 GROUP BYe.createdByUserID, i.itemID, i.title ORDER BYe.datecreated desc Rick ~| 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:260665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CALLING ALL SQL EXPERTS, Please help
Axel Jensen wrote: > I'm trying to create a "most recently updated" list of tracks that we > update, and track our bugs, and feature requests with. > > SELECT DISTINCTe.createdByUserID,i.itemID, i.title, e.datecreated > FROMevents e > JOINv_items i ON e.itemID = i.itemID > WHERE e.createdbyuserid = 92 > ORDER BYe.datecreated desc > I think you want something more like: SELECT e.createdByUserID,i.itemID, i.title, MAX(e.datecreated) AS latestdate FROMevents e JOINv_items i ON e.itemID = i.itemID WHERE e.createdbyuserid = 92 GROUP BYe.createdByUserID,i.itemID, i.title ORDER BYlatestdate desc ~| 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:260664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CALLING ALL SQL EXPERTS, Please help
I'm trying to create a "most recently updated" list of tracks that we update, and track our bugs, and feature requests with. The list that I want will end up looking like this. (where the query ends up just grabbing the most recent results, and doesn't duplicate. 921028 Northern Natural Gas Flash Quiz Review2006-11-15 15:46:53.280 92975 New E-commerce Integration2006-11-10 17:19:59.450 92974 Feedback Form 2006-11-10 17:12:29.703 921044 SQL Changes and Calander Move 2006-11-08 08:30:46.357 92897 web based problem log for nphl.org and reglab.org 2006-11-06 16:42:19.153 I realize that the reason I'm getting the duplicates is because I'm trying to get distinct values on the date created. therefor I'm getting all the correct values. as far as sql goes. But I'm not sure how I would go about getting what I need. I know that if I cut the date out of the select statement, the query works, but then I can't sort by the most recently updated. so the list becomes rather useless to us. any help would be great SELECT DISTINCTe.createdByUserID,i.itemID, i.title, e.datecreated FROMevents e JOINv_items i ON e.itemID = i.itemID WHERE e.createdbyuserid = 92 ORDER BYe.datecreated desc Results: 921028 Northern Natural Gas Flash Quiz Review2006-11-15 15:46:53.280 92975 New E-commerce Integration2006-11-10 17:19:59.450 92974 Feedback Form 2006-11-10 17:12:29.703 921045 Email latest cow report to new cow rpt subscribers2006-11-09 15:03:38.140 921028 Northern Natural Gas Flash Quiz Review2006-11-09 10:39:28.483 921028 Northern Natural Gas Flash Quiz Review2006-11-09 08:31:58.840 921028 Northern Natural Gas Flash Quiz Review2006-11-08 16:30:32.343 921028 Northern Natural Gas Flash Quiz Review2006-11-08 11:51:49.967 92975 New E-commerce Integration2006-11-08 10:55:34.903 921044 SQL Changes and Calander Move 2006-11-08 08:30:46.357 921044 SQL Changes and Calander Move 2006-11-07 16:34:47.810 92975 New E-commerce Integration2006-11-06 16:44:33.983 92897 web based problem log for nphl.org and reglab.org 2006-11-06 16:42:19.153 921028 Northern Natural Gas Flash Quiz Review2006-11-06 16:40:46.700 921028 Northern Natural Gas Flash Quiz Review2006-11-06 11:14:32.670 921028 Northern Natural Gas Flash Quiz Review2006-11-06 11:06:30.793 Axel ~| 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:260663 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Dave, There is nothing else in the application happening, as far as I know. It's literally the Application.cfm file and the index file and all index is doing is dumping out APPLICATION. I just put a CFFILE/APPEND in every Application event handler and this is what I get: OnApplicationStart OnSessionStart OnRequestStart OnRequest OnRequestEnd OnSessionEnd : [ID - 43666] [TOKEN - 32723233] OnError : [Event Handler Exception. - Expression] An exception occurred when invoking a event handler method from Application.cfc The method name is: onSessionEnd. OnApplicationEnd : [NAME - App Event Testing] OnError : [Event Handler Exception. - Expression] An exception occurred when invoking a event handler method from Application.cfc The method name is: onApplicationEnd. As you can see, ALL of the events are firing. The OnsessionEnd fires and correctly references the Session scope info. The OnApplicationEnd fires and correctly references the Application scope info. But, both session and app end also generated an OnError event. Very strange. And still nothing showing up in the Application.log file or anything (even if I take out the OnError handler). .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:00 AM To: CF-Talk Subject: RE: PLEASE HELP! Why is this application.cfc erroring out? > I can't "Read" the OnError since it is firing for onSessionEnd and > OnApplicationEnd, which are not visible to the browser... However, I > have noticed that when I pull out the OnError method, nothing get's > written to the log files! > What's up with that??? Shouldn't that be showing up in the > Application.log? Do you have another error handler elsewhere that is catching things? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
> I can't "Read" the OnError since it is firing for > onSessionEnd and OnApplicationEnd, which are not visible to > the browser... However, I have noticed that when I pull out > the OnError method, nothing get's written to the log files! > What's up with that??? Shouldn't that be showing up in the > Application.log? Do you have another error handler elsewhere that is catching things? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257192 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Tom C., I can't "Read" the OnError since it is firing for onSessionEnd and OnApplicationEnd, which are not visible to the browser... However, I have noticed that when I pull out the OnError method, nothing get's written to the log files! What's up with that??? Shouldn't that be showing up in the Application.log? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 10:36 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? On Wednesday 18 October 2006 14:30, Ben Nadel wrote: > I can't tell what to remove. I can't remove the OnError method, > obviously, or I wouldn't be able to get at the errors. When I comment > out every method BUT the OnError method, get: If you take out onError, do you get an error you can read ? -- Tom Chiverton Helping to simultaneously transition strategic IPOs This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:257189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
On Wednesday 18 October 2006 14:30, Ben Nadel wrote: > I can't tell what to remove. I can't remove the OnError method, > obviously, or I wouldn't be able to get at the errors. When I comment > out every method BUT the OnError method, get: If you take out onError, do you get an error you can read ? -- Tom Chiverton Helping to simultaneously transition strategic IPOs This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:257186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Tom C., There is nothing to be done another way, as the application pretty much does nothing. All it does is define the Application events and writes errors to file. That's it. I can't tell what to remove. I can't remove the OnError method, obviously, or I wouldn't be able to get at the errors. When I comment out every method BUT the OnError method, get: An exception occurred when invoking a event handler method from Application.cfc The method name is: onSessionEnd. The method 'onSessionEnd' could not be found in component Exception Type: Application Then, I think , ok maybe it needs to have the method defined, so then I put back in JUST the onSessionEnd method and run again. I get the same error: An exception occurred when invoking a event handler method from Application.cfc The method name is: onSessionEnd. But this time the detailed message is "EMPTY STRING" AND, the exception type has changed from application: Exception Type: Expression After fooling around, it seems if OnApplicationEnd or OnSessionEnd is NOT defined, they throw erorrs of type APPLICATION. However, if they are defined, they are throwing errors of type EXPRESSION. No idea what is going on. .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:49 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? On Wednesday 18 October 2006 13:26, Ben Nadel wrote: > Can someone please help me out here. My Application.cfc is throwing > errors on OnApplicationEnd method. I am banging my head against the > wall here. No idea what is going on and the debugging is not useful at all. > The error get's written to the file error.htm. If anyone can lend a > hand, that would be AWESOME. Remove the offending method. What happens ? Could you do it another way ? -- Tom Chiverton Helping to heterogeneously drive professional markets ~| 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:257165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Just tried restarting the CF machine... Still same errors :( .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| 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:257168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Hmmm, good to know it works somewhere. Thanks for the help Tom. .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:16 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Nothing is being written to error.htm, and the application struct is being dumped into the page successfully. T ~| 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:257163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
Nothing is being written to error.htm, and the application struct is being dumped into the page successfully. T On 18 Oct 2006, at 14:11, Ben Nadel wrote: > Tom, > > Just to be clear, you cannot see the error on the page... It only > get's > written to that HTML file. Are you not seeing the error on page or > is it > not writing any HTML file? > > .. > Ben Nadel > Certified Advanced ColdFusion Developer > www.bennadel.com > > > -Original Message- > From: Tom King [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 9:06 AM > To: CF-Talk > Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? > > I've just run your application.cfc on my dev machine and can't get an > error > > just thought you'd like to know that it does work for some people! > > T > > > ~| 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:257162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
On Wednesday 18 October 2006 13:26, Ben Nadel wrote: > Can someone please help me out here. My Application.cfc is throwing > errors on OnApplicationEnd method. I am banging my head against the wall > here. No idea what is going on and the debugging is not useful at all. > The error get's written to the file error.htm. If anyone can lend a > hand, that would be AWESOME. Remove the offending method. What happens ? Could you do it another way ? -- Tom Chiverton Helping to heterogeneously drive professional markets This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:257161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Tom, Just to be clear, you cannot see the error on the page... It only get's written to that HTML file. Are you not seeing the error on page or is it not writing any HTML file? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:06 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? I've just run your application.cfc on my dev machine and can't get an error just thought you'd like to know that it does work for some people! T ~| 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:257160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
I've just run your application.cfc on my dev machine and can't get an error just thought you'd like to know that it does work for some people! T On 18 Oct 2006, at 13:56, Ben Nadel wrote: > Tom, > > I see what you are saying, but two issues: > > 1. My code does not have any CFAbort tags, just the Application.cfc > and > the index.cfm. > > 2. You are checking for the EventName in the OnError method, which > means > that the OnError event has already fired when you are performing the > check. I am not concerned with stuff inside the OnError method. I am > concerned as to why the OnError even is being fired in the first > place. > > > Thanks for the suggestions, > Ben > > .. > Ben Nadel > Certified Advanced ColdFusion Developer > www.bennadel.com > > > -Original Message- > From: Tom King [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 8:52 AM > To: CF-Talk > Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? > > Here is my error handling function: I think I'm right in saying that > without those additional lines, cfabort (if it's anywhere in your > script) will set off an error, and this way, ending the session or > application won't trigger said script either.. > T > ps - I'm a complete newbie, so I may be way off mark with this... > > > > > required="yes"/> > StructKeyExists(arguments.exception.RootCause,"type") AND > arguments.exception.RootCause.type EQ > "coldfusion.runtime.AbortException"> > > > EventName NEQ "onSessionEnd"> > from="Oxalto Error Handling" subject="Error: Brabant Ensemble" > type="html"> > IsDefined("variables.error")> label="Error > Variables"/> var="#arguments.exception#" label="Exception Variables"/> > label="CGI Variables"/> label="Application"> > > > > W3C// DTD > XHTML 1.0 Strict//EN" > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> > xmlns="http://www.w3.org/1999/xhtml"; lang="en"> > > content="text/html; charset=ISO-8859-1" /> > media="all"> > body {font:75%/140% > Arial, Helvetica, sans-serif;text-align:center;} > h1 {font- > weight:normal;} > a {color:##39c; > text-decoration:none;} > a:hover > {text-decoration:underline;} > ##container > {margin:20% > auto;width: 50%; text-align:left;} > > Fooe > > > > > > > > An > Error has Occured > > > > If > this > problem persists, please contact our href="mailto:[EMAIL PROTECTED]">Webmaster. > > > > > > > > On 18 Oct 2006, at 13:39, Ben Nadel wrote: > >> Maybe I do? Please explain? >> >> >> .. >> Ben Nadel >> Certified Advanced ColdFusion Developer www.bennadel.com >> >> >> -Original Message- >> From: Tom King [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, October 18, 2006 8:37 AM >> To: CF-Talk >> Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? >> >> Don'
RE: PLEASE HELP! Why is this application.cfc erroring out?
Tom, I see what you are saying, but two issues: 1. My code does not have any CFAbort tags, just the Application.cfc and the index.cfm. 2. You are checking for the EventName in the OnError method, which means that the OnError event has already fired when you are performing the check. I am not concerned with stuff inside the OnError method. I am concerned as to why the OnError even is being fired in the first place. Thanks for the suggestions, Ben ... Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| 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:257158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PLEASE HELP! Why is this application.cfc erroring out?
Tom, I see what you are saying, but two issues: 1. My code does not have any CFAbort tags, just the Application.cfc and the index.cfm. 2. You are checking for the EventName in the OnError method, which means that the OnError event has already fired when you are performing the check. I am not concerned with stuff inside the OnError method. I am concerned as to why the OnError even is being fired in the first place. Thanks for the suggestions, Ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:52 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Here is my error handling function: I think I'm right in saying that without those additional lines, cfabort (if it's anywhere in your script) will set off an error, and this way, ending the session or application won't trigger said script either.. T ps - I'm a complete newbie, so I may be way off mark with this... http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> http://www.w3.org/1999/xhtml"; lang="en"> body {font:75%/140% Arial, Helvetica, sans-serif;text-align:center;} h1 {font- weight:normal;} a {color:##39c; text-decoration:none;} a:hover {text-decoration:underline;} ##container {margin:20% auto;width: 50%; text-align:left;} Fooe An Error has Occured If this problem persists, please contact our mailto:[EMAIL PROTECTED]">Webmaster. On 18 Oct 2006, at 13:39, Ben Nadel wrote: > Maybe I do? Please explain? > > > .. > Ben Nadel > Certified Advanced ColdFusion Developer www.bennadel.com > > > -Original Message- > From: Tom King [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 18, 2006 8:37 AM > To: CF-Talk > Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? > > Don't you need > > "onSessionEnd"> > > in the OnError Function? > > T > On 18 Oct 2006, at 13:26, Ben Nadel wrote: > >> Can someone please help me out here. My Application.cfc is throwing >> errors on OnApplicationEnd method. I am banging my head against the >> wall here. No idea what is going on and the debugging is not >> useful at > >> all. >> The error get's written to the file error.htm. If anyone can lend a >> hand, that would be AWESOME. >> >> Code: >> http://bennadel.com/index.cfm?dax=blog:354.view >> >> Thanks so much! >> Ben >> >> .. >> Ben Nadel >> Certified Advanced ColdFusion Developer www.bennadel.com >> >> >> > > > > ~| 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:257157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4