Re: CF 8 Shared hosting w/o Java 6 Class Loader bug
Took this from a Transfer post: -- It's scheduled to come out with 6u10, according to this: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6566201 It's out in beta, but not expected for full release until 3rd quarter 08. https://jdk6.dev.java.net/6u10ea.html How it was considered a priority 3 (medium) is beyond me. -- So now you know as much as I do. Mark On Wed, Apr 23, 2008 at 3:00 PM, Matthew Levine [EMAIL PROTECTED] wrote: Just out of curiosity, but what sort of time is your app taking to load up? The main issue is at start up, it can take up to two minutes. However, once it's up and running you can reload it rather quickly, around 5 seconds, which is about what it takes on CF 7 and Railo 2. Are you finding you are getting random slowdowns at all, during the app lifecycle? Yes, once it's up it does have random slow downs that are not associated with the app instantiation. I think that they may be associated to inactive periods on the site, but I did some testing and the app is definitely not rebuilding itself. I'm pretty darn sure that it's all due to the dreaded java 6 class loading bottle neck. I'm also pretty sure that no host will will do anything about it because downgrading the jvm will also downgrade some of the performance gains that non-framework based apps are currently experiencing on the same shared servers. It's just disappointing. Matt ~| 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:304045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cfdocument and CF8.0.1 (64bit on XServe)
My server stopped generating pdf's when I clean installed CF8.0.1 Below is the stack trace. Hoping someone can help. Thanks in advance! Aaron Stack Trace at cfbuildPDF2ecfm1760911841. runPage(/Library/WebServer/Documents/standardadmin/buildPDF.cfm:63) at cfbuildPDF2ecfm1760911841. runPage(/Library/WebServer/Documents/standardadmin/buildPDF.cfm:63) java.lang.NullPointerException at javax.swing.MultiUIDefaults.getUIError(MultiUIDefaults.java:117) at javax.swing.UIDefaults.getUI(UIDefaults.java:721) at javax.swing.UIManager.getUI(UIManager.java:868) at javax.swing.JPanel.updateUI(JPanel.java:104) at javax.swing.JPanel.init(JPanel.java:64) at javax.swing.JPanel.init(JPanel.java:87) at javax.swing.JPanel.init(JPanel.java:95) at coldfusion.document.DocumentFrame.init(DocumentFrame.java:42) at coldfusion.document.DocumentProcessor$DocumentViewportCallback. createTopLevelContainer(DocumentProcessor.java:400) at ice.storm.CallbackAdapter$BoxedCallback.run(CallbackAdapter. java:231) at ice.util.security.jdk12.SecurityKit_jdk12. doPrivilegedImpl(SecurityKit_jdk12.java:87) at ice.util.security.SecurityKit.doPrivileged(SecurityKit.java:71) at ice.storm.StormBase.configureViewport(StormBase.java:1473) at ice.storm.StormBase.newTopLevelViewport(StormBase.java:1073) at ice.storm.StormBase.prepare_viewport(StormBase.java:1117) at ice.storm.StormBase.renderContent(StormBase.java:907) at coldfusion.document.DocumentProcessor. processContent(DocumentProcessor.java:251) at coldfusion.document.DocumentProcessor. processContent(DocumentProcessor.java:163) at coldfusion.tagext.lang.DocumentSectionTag. processContent(DocumentSectionTag.java:510) at coldfusion.tagext.lang.DocumentSectionTag. _processContent(DocumentSectionTag.java:455) at coldfusion.tagext.lang.DocumentSectionTag. doAfterBody(DocumentSectionTag.java:428) at cfbuildPDF2ecfm1760911841. runPage(/Library/WebServer/Documents/standardadmin/buildPDF.cfm:63) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter. java:279) 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.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.filter.RequestThrottleFilter. invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:175) 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) ~| 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:304046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with cfdocument and CF8.0.1 (64bit on XServe)
My server stopped generating pdf's when I clean installed CF8.0.1 Below is the stack trace. Hoping someone can help. Thanks in advance! Aaron Stack Trace at cfbuildPDF2ecfm1760911841. runPage(/Library/WebServer/Documents/standardadmin/buildPDF.cfm:63) at cfbuildPDF2ecfm1760911841. runPage(/Library/WebServer/Documents/standardadmin/buildPDF.cfm:63) java.lang.NullPointerException at javax.swing.MultiUIDefaults.getUIError(MultiUIDefaults.java:117) at javax.swing.UIDefaults.getUI(UIDefaults.java:721) at javax.swing.UIManager.getUI(UIManager.java:868) at javax.swing.JPanel.updateUI(JPanel.java:104) at javax.swing.JPanel.init(JPanel.java:64) at javax.swing.JPanel.init(JPanel.java:87) at javax.swing.JPanel.init(JPanel.java:95) at coldfusion.document.DocumentFrame.init(DocumentFrame.java:42) at coldfusion.document.DocumentProcessor$DocumentViewportCallback. createTopLevelContainer(DocumentProcessor.java:400) at ice.storm.CallbackAdapter$BoxedCallback.run(CallbackAdapter. java:231) at ice.util.security.jdk12.SecurityKit_jdk12. doPrivilegedImpl(SecurityKit_jdk12.java:87) at ice.util.security.SecurityKit.doPrivileged(SecurityKit.java:71) at ice.storm.StormBase.configureViewport(StormBase.java:1473) at ice.storm.StormBase.newTopLevelViewport(StormBase.java:1073) at ice.storm.StormBase.prepare_viewport(StormBase.java:1117) at ice.storm.StormBase.renderContent(StormBase.java:907) at coldfusion.document.DocumentProcessor. processContent(DocumentProcessor.java:251) at coldfusion.document.DocumentProcessor. processContent(DocumentProcessor.java:163) at coldfusion.tagext.lang.DocumentSectionTag. processContent(DocumentSectionTag.java:510) at coldfusion.tagext.lang.DocumentSectionTag. _processContent(DocumentSectionTag.java:455) at coldfusion.tagext.lang.DocumentSectionTag. doAfterBody(DocumentSectionTag.java:428) at cfbuildPDF2ecfm1760911841. runPage(/Library/WebServer/Documents/standardadmin/buildPDF.cfm:63) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter. java:279) 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.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.filter.RequestThrottleFilter. invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:175) 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) Aaron, Install X11 on xserve and then try. ~D ~| 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:304047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cfdocument and CF8.0.1 (64bit on XServe)
Try installing X11 on xserve and see if it works. ~D ~| 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:304048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problem with passing variables to action template
Hi every body have this problem and couldn't find the solution have one table to update with data from another table have two templates the first has two queries which are cfquery name=get datasource=source select tid, name FROM info WHERE 1id=10 /cfquery CFQUERY NAME=Check datasource=source SELECT 1id, 2id FROM tb2 WHERE Nome LIKE '%#RECORD#%' /CFQUERY on the second template I have this update query but data should be coming from the first template how could I pass the values of 1id and 2 id to update it on the info table? will i use cfparam for it UPDATE info SET 1ID=#url.id1# WHERE tid=#url.tid# AND 2ID=#url.id2# WHERE tid=#url.tid# thanks ~| 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:304049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
problem with passing variables to action template
Hi every body have this problem and couldn't find the solution have one table to update with data from another table have two templates the first has two queries which are cfquery name=get datasource=source select tid, name FROM info WHERE 1id=10 /cfquery CFQUERY NAME=Check datasource=source SELECT 1id, 2id FROM tb2 WHERE Nome LIKE '%#RECORD#%' /CFQUERY on the second template I have this update query but data should be coming from the first template how could I pass the values of 1id and 2 id to update it on the info table? will i use cfparam for it UPDATE info SET 1ID=#url.id1# WHERE tid=#url.tid# AND 2ID=#url.id2# WHERE tid=#url.tid# thanks ~| 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:304050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - what is this? st1:City
Yes, it's just Xml, as you know, that won't be displayed by a browser but can be translated into meaning by another client - in this case Microsoft Office. Try copying and pasting a chunk of text with those tags into MS Word and see what happens (select 'Keep source formatting' when pasting into word). Hopefully that will reveal something useful! HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| 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:304051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some advice on speeding up query...
Hey there, Not sure if this input will alleviate your issues more than the methods mentioned previously but i had a similar problem polling the gracenote db for a massive number of matching records. The method i used was to run the SQL Analyzer tool primarily to streamline my query but also only retrieving from the DB the records that i was displaying. I.E generate the record numbers you should retrieve by using the page number and records by page value. I.E. Page 1 1 - 20 Page 2 21 - 40 Page 3 41 - 60 Etc. This way you are only ever retrieving 20 records at a time. You can use SELECT TOP #X# FROM TABLE_Y process by building the SQL Script dynamically... Hope this input might help just a little... Hi, all... Up till now, my db's have been relatively small and fairly quick when being queried. I've never had to bother with indexes or other methods of optimizing queries. However, I've now got a db of about 6400 real estate properties. I've put together a Browse Properties page, which returns 20 records at a time and displays pagination. The query is pretty slow. Would indexes or perhaps another approach to this query make it quicker? Here's the code that pulls together records from the tables containing the various property types... cfquery name=get_properties datasource=#dsn# select sa.street_number as prop_street_number, sa.street_name as prop_street_name, sa.city as prop_city, sa.public_remarks_01 as prop_public_remarks_01, sa.public_remarks_02 as prop_public_remarks_02, sa.list_price as prop_list_price, (select sap.photo_filename from smlc_acr_photos sap where sap. photo_mls_number = sa.mls_number limit 1) as prop_photo_filename from smlc_acr sa union select sc.street_number as prop_street_number, sc.street_name as prop_street_name, sc.city as prop_city, sc.public_remarks_01 as prop_public_remarks_01, sc.public_remarks_02 as prop_public_remarks_02, sc.list_price as prop_list_price, (select scp.photo_filename from smlc_com_photos scp where scp. photo_mls_number = sc.mls_number limit 1) as prop_photo_filename from smlc_com sc union select sl.street_number as prop_street_number, sl.street_name as prop_street_name, sl.city as prop_city, sl.public_remarks_01 as prop_public_remarks_01, sl.public_remarks_02 as prop_public_remarks_02, sl.list_price as prop_list_price, (select slp.photo_filename from smlc_lot_photos slp where slp. photo_mls_number = sl.mls_number limit 1) as prop_photo_filename from smlc_lots sl union select sr.street_number as prop_street_number, sr.street_name as prop_street_name, sr.city as prop_city, sr.public_remarks_01 as prop_public_remarks_01, sr.public_remarks_02 as prop_public_remarks_02, sr.list_price as prop_list_price, (select srp.photo_filename from smlc_ren_photos srp where srp. photo_mls_number = sr.mls_number limit 1) as prop_photo_filename from smlc_ren sr union select sres.street_number as prop_street_number, sres.street_name as prop_street_name, sres.city as prop_city, sres.public_remarks_01 as prop_public_remarks_01, sres.public_remarks_02 as prop_public_remarks_02, sres.list_price as prop_list_price, (select sresp.photo_filename from smlc_res_photos sresp where sresp. photo_mls_number = sres.mls_number limit 1) as prop_photo_filename from smlc_res sres /cfquery ~| 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:304052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: problem with passing variables to action template
How are you getting from page one to page two? You're using URL vars in the second page so I'm guessing a link of some sort? Page 1: QUERY HERE cfloop query=yourQuery a href=page2.cfm?tid=#yourQuery.tid#Do something/abr / /cfloop If that's not enough, supply more info about your problem. Adrian -Original Message- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: 23 April 2008 09:42 To: CF-Talk Subject: problem with passing variables to action template Hi every body have this problem and couldn't find the solution have one table to update with data from another table have two templates the first has two queries which are cfquery name=get datasource=source select tid, name FROM info WHERE 1id=10 /cfquery CFQUERY NAME=Check datasource=source SELECT 1id, 2id FROM tb2 WHERE Nome LIKE '%#RECORD#%' /CFQUERY on the second template I have this update query but data should be coming from the first template how could I pass the values of 1id and 2 id to update it on the info table? will i use cfparam for it UPDATE info SET 1ID=#url.id1# WHERE tid=#url.tid# AND 2ID=#url.id2# WHERE tid=#url.tid# ~| 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:304053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some advice on speeding up query...
Just a note on indexes - every one of your tables should have at least one unique constraint or index *other* than the primary key. This way, the primary key is not what makes a row in your table unique - it just identifies it for relationship purposes. This helps to avoid duplicate data and helps speed up query performance as you have found :) HTH Dominic On 23/04/2008, James Holmes [EMAIL PROTECTED] wrote: Did you try the UNION ALL as suggested by Rizal? This might make it a little quicker as the DB won't have to scan for duplicates. On Wed, Apr 23, 2008 at 11:03 AM, Rick Faircloth [EMAIL PROTECTED] wrote: If I had set up the original db that's providing the data, it would have definitely been set up differently. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| 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:304054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with passing variables to action template
How are you getting from page one to page two? You're using URL vars in the second page so I'm guessing a link of some sort? Page 1: QUERY HERE cfloop query=yourQuery a href=page2.cfm?tid=#yourQuery.tid#Do something/abr / /cfloop If that's not enough, supply more info about your problem. Adrian that solved it thanks Hi every body have this problem and couldn't find the solution have one table to update with data from another table have two templates the first has two queries which are cfquery name=get datasource=source select tid, name FROM info WHERE 1id=10 /cfquery CFQUERY NAME=Check datasource=source SELECT 1id, 2id FROM tb2 WHERE Nome LIKE '%#RECORD#%' /CFQUERY on the second template I have this update query but data should be coming from the first template how could I pass the values of 1id and 2 id to update it on the info table? will i use cfparam for it UPDATE info SET 1ID=#url.id1# WHERE tid=#url.tid# AND 2ID=#url.id2# WHERE tid=#url.tid# ~| 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:304055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problem with form field undefined
HI everybody below is the error which Coldfusion gives me: Element PID is undefined in TESTFORM. (this is the error that coldfusion gives me as soon as I press the ok button that should update the info table) action.cfm The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 2 : UPDATE info 3 : SET 4 : pID = #form.PID#, 5 : sID = #form.SID# 6 : WHERE id=#form.ID# I have this form on the first template that calls the action.cfm it gets it's data from a query named check cfoutput CFFORM ACTION=action.cfm format=xml skin=lightgray width=500 preservedata=yes METHOD=Post !--- cfinput type=hidden name=Tab value=1 --- cfinput type=text name=PID value=#check.PID# cfinput type=text name=SID value=#check.SID# cfinput type=text name=ID value=#check.ID# cfinput type=submit name=Submit value= ok /cfform /cfoutput I don't know what's getting this error since PID is defined in the form please help ~| 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:304056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URLs being appended to query string
On Tuesday 22 Apr 2008, Paul Vernon wrote: You aren't alone. We're seeing exactly the same and have been for a couple of months. Not sure what the purpose of it is. The ones I see appear to be attempts to trigger some vulnerability or other. The page pointed to by the paramater often includes PHP code. -- Tom Chiverton Helping to proactively harness 24/7 experiences on: http://thefalken.livejournal.com 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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
problem with form field undefined
HI everybody below is the error which Coldfusion gives me: Element PID is undefined in TESTFORM. (this is the error that coldfusion gives me as soon as I press the ok button that should update the info table) action.cfm The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 2 : UPDATE info 3 : SET 4 : pID = #form.PID#, 5 : sID = #form.SID# 6 : WHERE id=#form.ID# I have this form on the first template that calls the action.cfm it gets it's data from a query named check cfoutput CFFORM ACTION=action.cfm format=xml skin=lightgray width=500 preservedata=yes METHOD=Post !--- cfinput type=hidden name=Tab value=1 --- cfinput type=text name=PID value=#check.PID# cfinput type=text name=SID value=#check.SID# cfinput type=text name=ID value=#check.ID# cfinput type=submit name=Submit value= ok /cfform /cfoutput I don't know what's getting this error since PID is defined in the form please help ~| 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:304058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need some advice on speeding up query...
Yes, I'm using union all, too. Thanks... Rick -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 22, 2008 11:18 PM To: CF-Talk Subject: Re: Need some advice on speeding up query... Did you try the UNION ALL as suggested by Rizal? This might make it a little quicker as the DB won't have to scan for duplicates. On Wed, Apr 23, 2008 at 11:03 AM, Rick Faircloth [EMAIL PROTECTED] wrote: If I had set up the original db that's providing the data, it would have definitely been set up differently. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| 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:304059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need some advice on speeding up query...
Hi, Jarlath, and thanks for the reply... I thought about working directly with the SQL to limit the number of records retrieved, but I wasn't sure how to work that in conjunction with the paginationCFC, plus, I wasn't sure how the limit and offset really worked, so I just decided to take the safe route. I checked out the MySQL docs, but didn't get enough info to understand how it really worked with pagination. I guess, as you said, the top or limit or offset would have to be set dyanamically, according to my pagination settings. Any other thoughts on this? (Especially good examples/tutorials of this usage?) Thanks, Rick -Original Message- From: Jarlath Gallagher [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 6:29 AM To: CF-Talk Subject: Re: Need some advice on speeding up query... Hey there, Not sure if this input will alleviate your issues more than the methods mentioned previously but i had a similar problem polling the gracenote db for a massive number of matching records. The method i used was to run the SQL Analyzer tool primarily to streamline my query but also only retrieving from the DB the records that i was displaying. I.E generate the record numbers you should retrieve by using the page number and records by page value. I.E. Page 1 1 - 20 Page 2 21 - 40 Page 3 41 - 60 Etc. This way you are only ever retrieving 20 records at a time. You can use SELECT TOP #X# FROM TABLE_Y process by building the SQL Script dynamically... Hope this input might help just a little... Hi, all... Up till now, my db's have been relatively small and fairly quick when being queried. I've never had to bother with indexes or other methods of optimizing queries. However, I've now got a db of about 6400 real estate properties. I've put together a Browse Properties page, which returns 20 records at a time and displays pagination. The query is pretty slow. Would indexes or perhaps another approach to this query make it quicker? Here's the code that pulls together records from the tables containing the various property types... cfquery name=get_properties datasource=#dsn# select sa.street_number as prop_street_number, sa.street_name as prop_street_name, sa.city as prop_city, sa.public_remarks_01 as prop_public_remarks_01, sa.public_remarks_02 as prop_public_remarks_02, sa.list_price as prop_list_price, (select sap.photo_filename from smlc_acr_photos sap where sap. photo_mls_number = sa.mls_number limit 1) as prop_photo_filename from smlc_acr sa union select sc.street_number as prop_street_number, sc.street_name as prop_street_name, sc.city as prop_city, sc.public_remarks_01 as prop_public_remarks_01, sc.public_remarks_02 as prop_public_remarks_02, sc.list_price as prop_list_price, (select scp.photo_filename from smlc_com_photos scp where scp. photo_mls_number = sc.mls_number limit 1) as prop_photo_filename from smlc_com sc union select sl.street_number as prop_street_number, sl.street_name as prop_street_name, sl.city as prop_city, sl.public_remarks_01 as prop_public_remarks_01, sl.public_remarks_02 as prop_public_remarks_02, sl.list_price as prop_list_price, (select slp.photo_filename from smlc_lot_photos slp where slp. photo_mls_number = sl.mls_number limit 1) as prop_photo_filename from smlc_lots sl union select sr.street_number as prop_street_number, sr.street_name as prop_street_name, sr.city as prop_city, sr.public_remarks_01 as prop_public_remarks_01, sr.public_remarks_02 as prop_public_remarks_02, sr.list_price as prop_list_price, (select srp.photo_filename from smlc_ren_photos srp where srp. photo_mls_number = sr.mls_number limit 1) as prop_photo_filename from smlc_ren sr union select sres.street_number as prop_street_number, sres.street_name as prop_street_name, sres.city as prop_city, sres.public_remarks_01 as prop_public_remarks_01, sres.public_remarks_02 as prop_public_remarks_02, sres.list_price as prop_list_price, (select sresp.photo_filename from smlc_res_photos sresp where sresp. photo_mls_number = sres.mls_number limit 1) as prop_photo_filename from smlc_res sres /cfquery ~| 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:304060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JavaScript cftextarea with rich text
Steve: The rich text editor that CF8 uses is FCKEditor. You should read up on the JavaScript API to determine how to get the value located here: http://docs.fckeditor.net/FCKeditor_2.x/Developers_Guide/JavaScript_API You will of course first need to obtain the underlying FCKEditor instance using ColdFusion.RichText.getEditorObject(textareaname). I am pretty sure this was added in CF 8.0.1, so you will most likely need to have the update to use this. Brian I am trying to check whether or not a rich text textarea has a value in JavaScript. On a normal textarea box I can just use the elementname. value == '' but that is not working when I have rich text turned on. Anyone have any ideas how to check it when rich text is on? Thanks! ~| 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:304061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need some advice on speeding up query...
Well... in this case, all of the properties have a unique mls_number, so that would work for the property tables. I did have a normal index on the mls_number, but I can see how unique would be better. Thanks for the help! Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 3:43 AM To: CF-Talk Subject: Re: Need some advice on speeding up query... Just a note on indexes - every one of your tables should have at least one unique constraint or index *other* than the primary key. This way, the primary key is not what makes a row in your table unique - it just identifies it for relationship purposes. This helps to avoid duplicate data and helps speed up query performance as you have found :) HTH Dominic On 23/04/2008, James Holmes [EMAIL PROTECTED] wrote: Did you try the UNION ALL as suggested by Rizal? This might make it a little quicker as the DB won't have to scan for duplicates. On Wed, Apr 23, 2008 at 11:03 AM, Rick Faircloth [EMAIL PROTECTED] wrote: If I had set up the original db that's providing the data, it would have definitely been set up differently. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| 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:304062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JavaScript cftextarea with rich text
Hi, If you use the javascript API @ http://docs.fckeditor.net/FCKeditor_2.x/Developers_Guide/JavaScript_API#FCKeditor_JavaScript_API you can use a method called editorinstancename.GetHtml(); this will give you the inner html from the editor. you can write this to a variable and check the length of that from there... hope this helps I am trying to check whether or not a rich text textarea has a value in JavaScript. On a normal textarea box I can just use the elementname. value == '' but that is not working when I have rich text turned on. Anyone have any ideas how to check it when rich text is on? Thanks! ~| 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:304063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Download File Filter Question
When you are using enctype=multipart/form-data to create a browse field for file selection, is there any way to define a default file type filter for the browse/select window? Right now it come up with the filter *.*. How could I make it come up with say, *.gif or *.jpg? This has always bothered me. Anyone know? Thanks Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:304064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: problem with form field undefined
To see what's in the FORM scope, add this above the point it errors. cfdump var=#FORM# cfabort See what that shows you. Adrian http://www.adrianlynch.co.uk/ -Original Message- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: 23 April 2008 13:56 To: CF-Talk Subject: problem with form field undefined HI everybody below is the error which Coldfusion gives me: Element PID is undefined in TESTFORM. (this is the error that coldfusion gives me as soon as I press the ok button that should update the info table) action.cfm The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 2 : UPDATE info 3 : SET 4 : pID = #form.PID#, 5 : sID = #form.SID# 6 : WHERE id=#form.ID# I have this form on the first template that calls the action.cfm it gets it's data from a query named check cfoutput CFFORM ACTION=action.cfm format=xml skin=lightgray width=500 preservedata=yes METHOD=Post !--- cfinput type=hidden name=Tab value=1 --- cfinput type=text name=PID value=#check.PID# cfinput type=text name=SID value=#check.SID# cfinput type=text name=ID value=#check.ID# cfinput type=submit name=Submit value= ok /cfform /cfoutput I don't know what's getting this error since PID is defined in the form please help ~| 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:304065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some advice on speeding up query...
I did have a normal index on the mls_number, but I can see how unique would be better. Yeh, if you can physically define what makes a row unique, do it (if you can't define what makes a row unique, theres something wrong with the table)! Let the database enforce that basic database rule - saves your ass from duplicates down the line too :) Dom On 23/04/2008, Rick Faircloth [EMAIL PROTECTED] wrote: Well... in this case, all of the properties have a unique mls_number, so that would work for the property tables. I did have a normal index on the mls_number, but I can see how unique would be better. Thanks for the help! Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 3:43 AM To: CF-Talk Subject: Re: Need some advice on speeding up query... Just a note on indexes - every one of your tables should have at least one unique constraint or index *other* than the primary key. This way, the primary key is not what makes a row in your table unique - it just identifies it for relationship purposes. This helps to avoid duplicate data and helps speed up query performance as you have found :) HTH Dominic On 23/04/2008, James Holmes [EMAIL PROTECTED] wrote: Did you try the UNION ALL as suggested by Rizal? This might make it a little quicker as the DB won't have to scan for duplicates. On Wed, Apr 23, 2008 at 11:03 AM, Rick Faircloth [EMAIL PROTECTED] wrote: If I had set up the original db that's providing the data, it would have definitely been set up differently. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| 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:304066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Download File Filter Question
You mean you are using input type=file?? -- am i correct in assumin this?? If so you can add accept=[MIME-type]... Replace [MIME-type] with your chosen file type definition... When you are using enctype=multipart/form-data to create a browse field for file selection, is there any way to define a default file type filter for the browse/select window? Right now it come up with the filter *.*. How could I make it come up with say, *.gif or *.jpg? This has always bothered me. Anyone know? Thanks Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:304067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
Hi Adrian with that cfdump it gives me this struct struct FIELDNAMES SUBMIT,PID,SID,ID INFID 18276 PID 17047 SID 17734 SUBMIT associate all of it is defined but still it gets the undefined error on the form thanks To see what's in the FORM scope, add this above the point it errors. cfdump var=#FORM# cfabort See what that shows you. Adrian http://www.adrianlynch.co.uk/ HI everybody below is the error which Coldfusion gives me: Element PID is undefined in TESTFORM. (this is the error that coldfusion gives me as soon as I press the ok button that should update the info table) action.cfm The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 2 : UPDATE info 3 : SET 4 : pID = #form.PID#, 5 : sID = #form.SID# 6 : WHERE id=#form.ID# I have this form on the first template that calls the action.cfm it gets it's data from a query named check cfoutput CFFORM ACTION=action.cfm format=xml skin=lightgray width=500 preservedata=yes METHOD=Post !--- cfinput type=hidden name=Tab value=1 --- cfinput type=text name=PID value=#check.PID# cfinput type=text name=SID value=#check.SID# cfinput type=text name=ID value=#check.ID# cfinput type=submit name=Submit value= ok /cfform /cfoutput I don't know what's getting this error since PID is defined in the form please help ~| 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:304068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
Your error is Element PID is undefined in TESTFORM, meaning you are referenceing Testform.PID somewhere. That reference isn't in your posted code, so you'll need to check your pages and see where that is coming from. ~| 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:304069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 8 Shared hosting w/o Java 6 Class Loader bug
Thanks! ~| 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:304070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
What is odd is that the message says '... is undefined in TESTFORM' as opposed to '... is undefined in FORM'. Are you using 'testForm' anywhere where you should be using just 'form' (I realise the error is being generated at line 4 but that message is odd)? Dominic On 23/04/2008, alex poyaoan [EMAIL PROTECTED] wrote: Hi Adrian with that cfdump it gives me this struct struct FIELDNAMES SUBMIT,PID,SID,ID INFID 18276 PID 17047 SID 17734 SUBMIT associate all of it is defined but still it gets the undefined error on the form thanks To see what's in the FORM scope, add this above the point it errors. cfdump var=#FORM# cfabort See what that shows you. Adrian http://www.adrianlynch.co.uk/ HI everybody below is the error which Coldfusion gives me: Element PID is undefined in TESTFORM. (this is the error that coldfusion gives me as soon as I press the ok button that should update the info table) action.cfm The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 2 : UPDATE info 3 : SET 4 : pID = #form.PID#, 5 : sID = #form.SID# 6 : WHERE id=#form.ID# I have this form on the first template that calls the action.cfm it gets it's data from a query named check cfoutput CFFORM ACTION=action.cfm format=xml skin=lightgray width=500 preservedata=yes METHOD=Post !--- cfinput type=hidden name=Tab value=1 --- cfinput type=text name=PID value=#check.PID# cfinput type=text name=SID value=#check.SID# cfinput type=text name=ID value=#check.ID# cfinput type=submit name=Submit value= ok /cfform /cfoutput I don't know what's getting this error since PID is defined in the form please help ~| 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:304071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: problem with form field undefined
The error is saying PID is undefined in TESTFORM. Do you have TESTFORM.pid anywhere? Adrian -Original Message- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: 23 April 2008 15:23 To: CF-Talk Subject: Re: problem with form field undefined Hi Adrian with that cfdump it gives me this struct struct FIELDNAMES SUBMIT,PID,SID,ID INFID 18276 PID 17047 SID 17734 SUBMIT associate all of it is defined but still it gets the undefined error on the form thanks To see what's in the FORM scope, add this above the point it errors. cfdump var=#FORM# cfabort See what that shows you. Adrian http://www.adrianlynch.co.uk/ HI everybody below is the error which Coldfusion gives me: Element PID is undefined in TESTFORM. (this is the error that coldfusion gives me as soon as I press the ok button that should update the info table) action.cfm The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 2 : UPDATE info 3 : SET 4 : pID = #form.PID#, 5 : sID = #form.SID# 6 : WHERE id=#form.ID# I have this form on the first template that calls the action.cfm it gets it's data from a query named check cfoutput CFFORM ACTION=action.cfm format=xml skin=lightgray width=500 preservedata=yes METHOD=Post !--- cfinput type=hidden name=Tab value=1 --- cfinput type=text name=PID value=#check.PID# cfinput type=text name=SID value=#check.SID# cfinput type=text name=ID value=#check.ID# cfinput type=submit name=Submit value= ok /cfform /cfoutput I don't know what's getting this error since PID is defined in the form please help ~| 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:304072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
Your error is Element PID is undefined in TESTFORM, meaning you are referenceing Testform.PID somewhere. That reference isn't in your posted code, so you'll need to check your pages and see where that is coming from. SORRY FOR THAT because I named the form testform and it still gives me that error and eliminating the name of the form Element PID is undefined in FORM and in fact with cfdump var='#FORM#' it gives me all the values and I couldn't find anything from the cfquery ~| 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:304073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
What is odd is that the message says '... is undefined in TESTFORM' as opposed to '... is undefined in FORM'. Are you using 'testForm' anywhere where you should be using just 'form' (I realise the error is being generated at line 4 but that message is odd)? Dominic Hi sorry for that .. the error for pid is undefined on testform came when i named the form testform but deleting the name of the form . is undefined in the form came up thanks ~| 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:304074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Download File Filter Question
You mean you are using input type=file?? -- am i correct in assumin this?? If so you can add accept=[MIME-type]... Replace [MIME-type] with your chosen file type definition... Yes, that is correct. But that did not do what I wanted. When the browse window comes up it comes up looking at all file types (filter *.*). I'd like to make the browse window open with the filter set to show only the correct file type (e.g., filer= Pictures (*.gif, *.jpg, etc). Anyone know how to do this? 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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
how handle emails not exists or inactive before sending out
how handle emails not exists or inactive before sending out We have a notification application sending email to users , we use the email validation in the form , but we still received a lot of undelivered emails . how to handle it? thnkas ~| 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:304076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem with form field undefined
Ok, so it was debug text...I'll ignore that part then, no problem. The next thing I see is that the error is in template db\db1.cfm, which is not the action page of the form (which is action.cfm). The question now is, how are you getting to db1.cfm? Is it a UDF call, a cfinclude, or maybe even a cflocation? From the error, it appears that however you're getting there, you're not propagating the form structure. On Wed, Apr 23, 2008 at 9:41 AM, alex poyaoan [EMAIL PROTECTED] wrote: Your error is Element PID is undefined in TESTFORM, meaning you are referenceing Testform.PID somewhere. That reference isn't in your posted code, so you'll need to check your pages and see where that is coming from. SORRY FOR THAT because I named the form testform and it still gives me that error and eliminating the name of the form Element PID is undefined in FORM and in fact with cfdump var='#FORM#' it gives me all the values and I couldn't find anything from the cfquery ~| 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:304077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem with form field undefined
HI as quoted that error came when i named the cfform testform and also deleting the name it gives me now the PID is undefined in FORM and with the cfdump all of the variables is displayed and defined thanks again The error is saying PID is undefined in TESTFORM. Do you have TESTFORM.pid anywhere? Adrian Hi Adrian with that cfdump it gives me this struct struct FIELDNAMES SUBMIT,PID,SID,ID INFID 18276 PID17047 SID17734 SUBMIT associate all of it is defined but still it gets the undefined error on the form thanks table) ~| 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:304078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem with form field undefined
1) the error refers to TESTFORM... which page has #TESTFORM.PID# in it? 2) in your posted code the ACTION attrib of your cfform tag is set to 'action.cfm'... the error states it occurred in page 'db1.cfm'... some template confusion going on? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: Hi Adrian with that cfdump it gives me this struct struct FIELDNAMESSUBMIT,PID,SID,ID INFID 18276 PID 17047 SID 17734 SUBMITassociate all of it is defined but still it gets the undefined error on the form thanks To see what's in the FORM scope, add this above the point it errors. cfdump var=#FORM# cfabort See what that shows you. Adrian http://www.adrianlynch.co.uk/ HI everybody below is the error which Coldfusion gives me: Element PID is undefined in TESTFORM. (this is the error that coldfusion gives me as soon as I press the ok button that should update the info table) action.cfm The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 2 : UPDATE info 3 : SET 4 : pID = #form.PID#, 5 : sID = #form.SID# 6 : WHERE id=#form.ID# I have this form on the first template that calls the action.cfm it gets it's data from a query named check cfoutput CFFORM ACTION=action.cfm format=xml skin=lightgray width=500 preservedata=yes METHOD=Post !--- cfinput type=hidden name=Tab value=1 --- cfinput type=text name=PID value=#check.PID# cfinput type=text name=SID value=#check.SID# cfinput type=text name=ID value=#check.ID# cfinput type=submit name=Submit value= ok /cfform /cfoutput I don't know what's getting this error since PID is defined in the form please help ~| 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:304079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
yes the error occurs in action.cfm but if you cfdump form all of the required variables has values as what i posted earlier 1) the error refers to TESTFORM... which page has #TESTFORM.PID# in it? 2) in your posted code the ACTION attrib of your cfform tag is set to 'action.cfm'... the error states it occurred in page 'db1.cfm'... some template confusion going on? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ alex poyaoan wrote: ~| 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:304080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
alex poyaoan wrote: Hi sorry for that .. the error for pid is undefined on testform came when i named the form testform but deleting the name of the form . is undefined in the form came up thanks Yes, the name of the form is only relevant in the client browser and the DOM. Once the form is submitted to the server the form data is simply a collection of name - value pairs with no name. On the server it is always just the form scope for data submitted with the 'post' method or the url scope for the 'get' method. ~| 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:304081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problem with form field undefined
On Wed, Apr 23, 2008 at 10:02 AM, alex poyaoan [EMAIL PROTECTED] wrote: yes the error occurs in action.cfm but if you cfdump form all of the required variables has values as what i posted earlier From your first post: The error occurred in C:\CFusionMX7\wwwroot\db\db1.cfm: line 4 So the error isn't in action.cfm, but in db1.cfm. If you cfdump the form scope in db1.cfm, what do you get? ~| 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:304082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: how handle emails not exists or inactive before sending out
You could set the bounce back address to an address used only for the purpose of collecting the bounced emails. Then cfpop the address, use a regex to pull out the emails and remove them from the database. I'd personally add a 'numberOfBounces' numeric column to your database and instead of deleting the record when the address bounces, increment the 'numberOfBounces' for that address. Once it hits a specific bounce count, then delete it. Bounces don't always mean the address is bad, the next one could go through. I see it occasionally. The chances of 2 email addresses being found in the body of the bounced email is pretty high as well. The address it was sent from and the address it was sent to. Just make sure that the address you send FROM doesn't need to be subscribed to your mailing list. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: shen wang [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 10:54 AM To: CF-Talk Subject: how handle emails not exists or inactive before sending out how handle emails not exists or inactive before sending out We have a notification application sending email to users , we use the email validation in the form , but we still received a lot of undelivered emails . how to handle it? thnkas ~| 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:304083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF 8 Shared hosting w/o Java 6 Class Loader bug
My goodness, look at one of the comments left at the bottom of Sun's bug report page: Our Webstart consumer app takes ten times to load (50 instead of 5 seconds on a really powerfull machine, 2 minutes on an average machine). How can this go through unnoticed in times where Webstart applications should stand strong against Flex and other wannabe RIA architectures? Please fix this ASAP unless Java gets the reputation of being slow! Notice how they pile Flex in with other wannabe RIA architectures. Lol ~Brad -Original Message- From: Mark Mandel [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 1:27 AM To: CF-Talk Subject: Re: CF 8 Shared hosting w/o Java 6 Class Loader bug Took this from a Transfer post: -- It's scheduled to come out with 6u10, according to this: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6566201 ~| 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:304084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Problem with cfdocument and CF8.0.1 (64bit on XServe)
Try installing X11 on xserve and see if it works. ~D I'll give it a try this evening... Is this a known issue? Aaron ~| 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:304085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: how handle emails not exists or inactive before sending out
Probably a noob question. :) How do you set a bounce back address in cfmail? I mean, seperate from the From field. Is there a setting that allows for a Bounced field or something? On Wed, Apr 23, 2008 at 8:33 AM, Bobby Hartsfield [EMAIL PROTECTED] wrote: You could set the bounce back address to an address used only for the purpose of collecting the bounced emails. Then cfpop the address, use a regex to pull out the emails and remove them from the database. I'd personally add a 'numberOfBounces' numeric column to your database and instead of deleting the record when the address bounces, increment the 'numberOfBounces' for that address. Once it hits a specific bounce count, then delete it. Bounces don't always mean the address is bad, the next one could go through. I see it occasionally. The chances of 2 email addresses being found in the body of the bounced email is pretty high as well. The address it was sent from and the address it was sent to. Just make sure that the address you send FROM doesn't need to be subscribed to your mailing list. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: shen wang [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 10:54 AM To: CF-Talk Subject: how handle emails not exists or inactive before sending out how handle emails not exists or inactive before sending out We have a notification application sending email to users , we use the email validation in the form , but we still received a lot of undelivered emails . how to handle it? thnkas ~| 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:304086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfinput autosuggest css errors
I am new to cfinput autosuggest=... feature of CF8/Ajax. I get lots of CSS error from the CF8/Yahoo library. See examples below. Please advise how these CSS errors can be avoided. Many thanks. Kamru CF Code: cfform name=formtest action=#cgi.script_name# method=post h1CFINPUT Test/h1 cfinput type=Text name=fruit autosuggest=apple, banana, orange, pear input type=Submit name=submit value=Update /cfform CSS Errors (lots of similar erros): Warning: Unknown property 'zoom'. Declaration dropped. Source File: http://devservc/CFIDE/scripts/ajax/resources/yui/yui.css Line: 133 ~| 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:304087 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: how handle emails not exists or inactive before sending out
You can set a failto attribute. Some mail servers choose to bounce to the from, however. On Wed, Apr 23, 2008 at 10:37 AM, Phillip Vector [EMAIL PROTECTED] wrote: Probably a noob question. :) How do you set a bounce back address in cfmail? I mean, seperate from the From field. Is there a setting that allows for a Bounced field or something? On Wed, Apr 23, 2008 at 8:33 AM, Bobby Hartsfield [EMAIL PROTECTED] wrote: You could set the bounce back address to an address used only for the purpose of collecting the bounced emails. Then cfpop the address, use a regex to pull out the emails and remove them from the database. I'd personally add a 'numberOfBounces' numeric column to your database and instead of deleting the record when the address bounces, increment the 'numberOfBounces' for that address. Once it hits a specific bounce count, then delete it. Bounces don't always mean the address is bad, the next one could go through. I see it occasionally. The chances of 2 email addresses being found in the body of the bounced email is pretty high as well. The address it was sent from and the address it was sent to. Just make sure that the address you send FROM doesn't need to be subscribed to your mailing list. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: shen wang [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 10:54 AM To: CF-Talk Subject: how handle emails not exists or inactive before sending out how handle emails not exists or inactive before sending out We have a notification application sending email to users , we use the email validation in the form , but we still received a lot of undelivered emails . how to handle it? thnkas ~| 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:304088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: how handle emails not exists or inactive before sending out
I'm pretty sure that parameter should be failto. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| 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:304089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: how handle emails not exists or inactive before sending out
It's the failto attribute in the cfmail tag. You get different types of bounces - soft and hard. Soft bounces could be temporary, hard bounces permanent. So you could have some code checking the bounces to see which are hard and removing them only. HTH. Will -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: 23 April 2008 16:37 To: CF-Talk Subject: Re: how handle emails not exists or inactive before sending out Probably a noob question. :) How do you set a bounce back address in cfmail? I mean, seperate from the From field. Is there a setting that allows for a Bounced field or something? On Wed, Apr 23, 2008 at 8:33 AM, Bobby Hartsfield [EMAIL PROTECTED] wrote: You could set the bounce back address to an address used only for the purpose of collecting the bounced emails. Then cfpop the address, use a regex to pull out the emails and remove them from the database. I'd personally add a 'numberOfBounces' numeric column to your database and instead of deleting the record when the address bounces, increment the 'numberOfBounces' for that address. Once it hits a specific bounce count, then delete it. Bounces don't always mean the address is bad, the next one could go through. I see it occasionally. The chances of 2 email addresses being found in the body of the bounced email is pretty high as well. The address it was sent from and the address it was sent to. Just make sure that the address you send FROM doesn't need to be subscribed to your mailing list. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: shen wang [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 10:54 AM To: CF-Talk Subject: how handle emails not exists or inactive before sending out how handle emails not exists or inactive before sending out We have a notification application sending email to users , we use the email validation in the form , but we still received a lot of undelivered emails .. how to handle it? thnkas ~| 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:304090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: how handle emails not exists or inactive before sending out
Use the failto attribute ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 11:37 AM To: CF-Talk Subject: Re: how handle emails not exists or inactive before sending out Probably a noob question. :) How do you set a bounce back address in cfmail? I mean, seperate from the From field. Is there a setting that allows for a Bounced field or something? On Wed, Apr 23, 2008 at 8:33 AM, Bobby Hartsfield [EMAIL PROTECTED] wrote: You could set the bounce back address to an address used only for the purpose of collecting the bounced emails. Then cfpop the address, use a regex to pull out the emails and remove them from the database. I'd personally add a 'numberOfBounces' numeric column to your database and instead of deleting the record when the address bounces, increment the 'numberOfBounces' for that address. Once it hits a specific bounce count, then delete it. Bounces don't always mean the address is bad, the next one could go through. I see it occasionally. The chances of 2 email addresses being found in the body of the bounced email is pretty high as well. The address it was sent from and the address it was sent to. Just make sure that the address you send FROM doesn't need to be subscribed to your mailing list. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: shen wang [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 10:54 AM To: CF-Talk Subject: how handle emails not exists or inactive before sending out how handle emails not exists or inactive before sending out We have a notification application sending email to users , we use the email validation in the form , but we still received a lot of undelivered emails .. how to handle it? thnkas ~| 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:304091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cf8 query weirdness
I found this thread on HoF. I'm running into the same issue, I'm doing an INSERT INTO SELECT and no resultset is available from the query. Was there any word on whether this was a bug or not? Thanks. Adrian http://www.adrianlynch.co.uk/ -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 15 February 2008 23:01 To: CF-Talk Subject: RE: cf8 query weirdness It is a bug because it works differently from cf7. And the issue seems to be not that cf is returning the wrong resultset (ie rowcount instead of the identity), it's that it's not returning any resultset at all. If rowcounts cause these kinds of issues, wouldn't we have issues with pretty much every query? Russ -Original Message- From: C S [mailto:[EMAIL PROTECTED] Sent: Friday, February 15, 2008 5:07 PM To: CF-Talk Subject: Re: cf8 query weirdness What is this nocount and why do I have to use it. Also can we confirm that this is a cf8 bug? Drivers process the results of each statement. Including those that only return a rowcount like updates or inserts: ie (1) row inserted. Cfquery is only supposed to return one resultset. Rowcounts can interfere with that. Using set nocount avoids that problem. That is not a bug IMO. ~| 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:304092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
More cfdocument trouble
I have one server that just doesn't seem to like cfdocument. I've taken out all of the potential image/stylesheet/ssl issues by putting a cfm in an unsecured website on the server with the following code: cfdocument format=pdf htmlheadtitletest/title/headbodytest/body/html /cfdocument Server is Win2k running CF 7,0,2,142559 Enterprise with latest cumulative hot fix (chf7020003.jar) in single server configuration. (Although the same was happening before upgrading from CF 7.0.1 .) After a reboot with the CF service set to start automatically, everything runs fine including cfdocument. After restarting the CF service, everything runs fine EXCEPT all calls to cfdocument. The first call to cfdocument times out after 30 seconds (default timeout set in CF Admin) and I get a Document has no pages error in my browser. Subsequent calls to cfdocument don't timeout -- they just hang. I've tried running the CF service under different user accounts including Local System -- all have the same problem. I've tried setting the CF service to start manually -- after reboot, cfdocument doesn't work even on the initial manual start of the CF service. I thought that I would start CF from the command line (i.e., using ...CFusionMX7/bincfstart) so that I could get a thread dump. When CF is started from the command line instead of as a service cfdocument works just fine. I have other servers that (I believe) have identical configurations where cfdocument is running fine. Any ideas? Thanks in advance for any suggestions! ~| 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:304093 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfpdf text extraction problems
I am having trouble extracting text from a pdf. Specifically, I have found that when the text is extracted there are spaces inserted into random places. For example: This sample text will be extracted as: Th is s a mpl e te x t Problem is that it seems to happen in random places in the text so I have been unable to grab a clean version. I've tried changing the encoding but have been unable to get to the root of this problem. Is this a cfpdf issue? Or does it have something to do with the source file? ~| 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:304094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JavaScript cftextarea with rich text
This was covered on the list recently. For the whole thread, search
cftextarea: how to count characters
Reprise relevant js:
var oEditor = FCKeditorAPI.GetInstance('theBody');
var theBodyTest = oEditor.GetXHTML(true);
if (theBodyTest.length==0) {
alert('You need to enter something for the body of your story.');
return false;
}
Cheers,
Kris
I am trying to check whether or not a rich text textarea has a value in
JavaScript. On a normal textarea box I can just use the elementname.value ==
'' but that is not working when I have rich text turned on.
~|
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:304095
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
My query is returning nothing and/or erroring out
I don't have to play with ColdFusion enough so I may be missing something pretty simple... The full page can be found at www.bctarizona.com/searchML.txt cfquery name=lookup datasource=AR SELECT acct_id, date_ascii, invoice_num, order_num, item_code, stock_code, main_line, qty, ink_1, ink_2, ink_3, ink_4 FROM QInvHisDetail WHERE main_line CONTAINS '#cookiemainline#' ORDER BY date_ascii DESC /cfquery The above give me the following error: Syntax Error: SELECT acct_id, date_ascii, invoice_num, order_num, item_code, stock_code, main_line, qty, ink_1, ink_2, ink_3, ink_4 FROM QInvHisDetail WHERE main_line CONTAINS ??? 'Mike' ORDER BY date_ascii DESC If I change CONTAINS to LIKE it does not error out but it produces no output other than the table row of headers. Now that I'm thinking about it it could be the output loop but I copied and pasted the whole thing from another page that works. The only thing I changed was the query name from Recordset1 to lookup and I changed it everywhere else on the page. Anyone see my problem? Thanks, Mike ~| 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:304096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: My query is returning nothing and/or erroring out
On Wed, Apr 23, 2008 at 11:57 AM, Michael Stevens [EMAIL PROTECTED] wrote: I don't have to play with ColdFusion enough so I may be missing something pretty simple... The full page can be found at www.bctarizona.com/searchML.txt cfquery name=lookup datasource=AR SELECT acct_id, date_ascii, invoice_num, order_num, item_code, stock_code, main_line, qty, ink_1, ink_2, ink_3, ink_4 FROM QInvHisDetail WHERE main_line CONTAINS '#cookiemainline#' ORDER BY date_ascii DESC /cfquery The above give me the following error: Syntax Error: SELECT acct_id, date_ascii, invoice_num, order_num, item_code, stock_code, main_line, qty, ink_1, ink_2, ink_3, ink_4 FROM QInvHisDetail WHERE main_line CONTAINS ??? 'Mike' ORDER BY date_ascii DESC If I change CONTAINS to LIKE it does not error out but it produces no output other than the table row of headers. Now that I'm thinking about it it could be the output loop but I copied and pasted the whole thing from another page that works. The only thing I changed was the query name from Recordset1 to lookup and I changed it everywhere else on the page. Anyone see my problem? WHERE main_line LIKE '%#cookiemainline#%' the % is a wildcard character, so that line will find anything where main_line contains the value of 'cookiemainline' (whatever it may be). -- Evelyn the dog, having undergone further modification pondered the significance of short-person behaviour in pedal depressed, pan-chromatic resonance, and other highly ambient domains. Arf, she said. ~| 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:304097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: My query is returning nothing and/or erroring out
cfset #cookiemainline# = 'X' WTH? maybe you mean cfset cookiemainline = 'X' you're assigning the value to what CF translates cookiemainline into.. Most of the time, you don't need #'s in CF functions so, you dont need cfif #myValue#.. just do a cfif myValue to test the query results.. dump the query.. cfdump var=#lookup# / After that.. try placing some cfoutput's in there to test.. E.G. CFCOOKIE NAME=mainline VALUE=#FORM.mainline# cfif COOKIE.mainline NEQ cfset cookiemainline = COOKIE.mainline cfelse cfset cookiemainline = 'X' /cfif cfoutput#cookiemainline#/cfoutput See if it's what it's suppose to be On Wed, Apr 23, 2008 at 1:57 PM, Michael Stevens [EMAIL PROTECTED] wrote: I don't have to play with ColdFusion enough so I may be missing something pretty simple... The full page can be found at www.bctarizona.com/searchML.txt cfquery name=lookup datasource=AR SELECT acct_id, date_ascii, invoice_num, order_num, item_code, stock_code, main_line, qty, ink_1, ink_2, ink_3, ink_4 FROM QInvHisDetail WHERE main_line CONTAINS '#cookiemainline#' ORDER BY date_ascii DESC /cfquery The above give me the following error: Syntax Error: SELECT acct_id, date_ascii, invoice_num, order_num, item_code, stock_code, main_line, qty, ink_1, ink_2, ink_3, ink_4 FROM QInvHisDetail WHERE main_line CONTAINS ??? 'Mike' ORDER BY date_ascii DESC If I change CONTAINS to LIKE it does not error out but it produces no output other than the table row of headers. Now that I'm thinking about it it could be the output loop but I copied and pasted the whole thing from another page that works. The only thing I changed was the query name from Recordset1 to lookup and I changed it everywhere else on the page. Anyone see my problem? Thanks, Mike ~| 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:304098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
List Question
I used to see CF Jobs on this list but haven't seen that in awhile. Am I allow to send out a CF job notice on the list or is that verboten now? 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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: My query is returning nothing and/or erroring out
Michael Stevens wrote: The above give me the following error: Syntax Error: SELECT acct_id, date_ascii, invoice_num, order_num, item_code, stock_code, main_line, qty, ink_1, ink_2, ink_3, ink_4 FROM QInvHisDetail WHERE main_line CONTAINS ??? 'Mike' ORDER BY date_ascii DESC If I change CONTAINS to LIKE it does not error out but it produces no output other than the table row of headers. CONTAINS may be a Database Management Specific SQL command and is sounds like your current database does not support it. When you change it to the more universal LIKE you no longer have a syntax error but you now have a logic error because you do not have any wild card characters in your string for LIKE to work with. Give this a try: WHERE main_line LIKE '%#cookiemainline#%'. I would think that is relativily equivalent to the CONTAINS logic. ~| 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:304100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: List Question
http://www.houseoffusion.com/groups/cf-jobs/ ;) Dominic On 23/04/2008, Robert Harrison [EMAIL PROTECTED] wrote: I used to see CF Jobs on this list but haven't seen that in awhile. Am I allow to send out a CF job notice on the list or is that verboten now? 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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: List Question
there's the CF-Jobs list... bunch of peeps there On Wed, Apr 23, 2008 at 2:13 PM, Robert Harrison [EMAIL PROTECTED] wrote: I used to see CF Jobs on this list but haven't seen that in awhile. Am I allow to send out a CF job notice on the list or is that verboten now? 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;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: webservice over SSL error - javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated error
I too am having the same issue. It seems to only be a CF issue though. I also test my services using the SoapUI tool (http://www.soapui.org/). Its a free java stand alone tool that also comes as an Eclipse plugin. Its great for testing Web services. In this situation, the SoapUI tool is correctly returning data from my service over SSL, while CF8 is throwing the error, javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated. ~| 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:304103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Store Locator - Exporting Importing data - best methods ???
Hi All, I've built a store location and an admin tool to maintain the store data. But now the folks in Marketing want to export the data and then import it back into the database. I planned on just exporting the data to a xls file and then import the same xls after it's been updated at a csv. I just get nervous when there's too much exporting and importing. Does anyone have any other ideas that they themselves have successfully implemented? Thanks D ~| 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:304104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfdocument to pdf fillinallow. cannot generate fillin pdf form. help?
I have a template that generates a detailed information for my clients that want the information emailed to them. not a big problem until we got into them wanting to modify the document sent to them and return it for processing. i am not locked into using cfdocument or even pdf format. in fact i was looking at excel format first, but since i have more pdf format experience i thought it would be quicker - so far not the case. any guidance? ~| 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:304105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Store Locator - Exporting Importing data - best methods ???
But now the folks in Marketing want to export the data and then import it back into the database. That sounds dangerous. ;) I had a (somewhat) similar request a while back. Where a company wanted to generate sales reports from the DB. So instead of giving them data dumps, I used Access as a front end to the (Mysql) DB using MyODBC. So they could run reports all day long on the live data and not bother me. It was read only btw. You might export it to a holding table while they edit the data and then rename the tables when they are done. I know that you can use access as a front end for MSSQL as well. Just a suggestion. G On Wed, Apr 23, 2008 at 4:08 PM, [EMAIL PROTECTED] wrote: Hi All, I've built a store location and an admin tool to maintain the store data. But now the folks in Marketing want to export the data and then import it back into the database. I planned on just exporting the data to a xls file and then import the same xls after it's been updated at a csv. I just get nervous when there's too much exporting and importing. Does anyone have any other ideas that they themselves have successfully implemented? Thanks D ~| 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:304106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: List Question
The old CF-Talk was split a while ago into CF-Talk for technical, CF-Community for off topic community BS, and CF-Jobs for job posts and requests. Since then other lists have spawned off including a CF-OT list for those who want to post OT content but do not want to join the general mayhem of CF-Community (a watercooler, let off steam type list). All of the lists are archived at http://www.houseoffusion.com/groups On Wed, Apr 23, 2008 at 3:13 PM, Robert Harrison [EMAIL PROTECTED] wrote: I used to see CF Jobs on this list but haven't seen that in awhile. Am I allow to send out a CF job notice on the list or is that verboten now? ~| 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:304107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Store Locator - Exporting Importing data - best methods ???
I planned on just exporting the data to a xls file and then import the same xls after it's been updated at a csv. I just get nervous when there's too much exporting and importing. Does anyone have any other ideas that they themselves have successfully implemented? I guess you'd have to consider how you'd handle updating existing records. Would you expose the primary key ID (or UID if you're using that) in the xls file? I'd think you would have to. Then there'd be the possiblity that they'd change that ID data inadvertently, and so violate the data integrity. If you're talking about just dumping the table, and then on import clearing the table and just using the edited xls file as the new data, that could really be a nightmare. Also, if they add a column or something, and you were using a cfhttp call to turn the xls file into a query, the import would fail. Sounds like there are a lot of challenges involved. Maybe you could create a multi-row edit form for them instead, that would mimic what they want to do with the spreadsheet. I've done something like this in javascript using jQuery and a plugin called jEditable that creates an Excel-like environment. -- Josh ~| 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:304108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Is this Application.cfm abuse?
I'm working on a project and when I dumped the application scope there were over 25,000 lines of variables and struct items. When I saved all of this it was over 500k. Does this seem unusual? ~| 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:304110 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion 8 hosting
Has anyone used hostingatoz's coldfusion hosting service and your experience? Thanks. ~| 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:304111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: webservice over SSL error - javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated error
You may need this fix... http://www.coldfusionmuse.com/index.cfm/2005/01/29/keystore Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Phillip Molaro [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 2:31 PM To: CF-Talk Subject: Re: webservice over SSL error - javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated error I too am having the same issue. It seems to only be a CF issue though. I also test my services using the SoapUI tool (http://www.soapui.org/). Its a free java stand alone tool that also comes as an Eclipse plugin. Its great for testing Web services. In this situation, the SoapUI tool is correctly returning data from my service over SSL, while CF8 is throwing the error, javax.net.ssl.SSLPeerUnverifiedException: peer not authenticated. ~| 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:304112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Store Locator - Exporting Importing data - best methods ???
I have built many of these for my backend. I do not do the work so i have created templates that allow the modification of information. this is your best avenue. having said that, you have several other issues to deal with. who is going to modify the information (create security logins to the template)? what is the q/c level and issues? If q/c is high then create another table where they can create updates that will be posted after they are checked for quality and accuracy. in any case there are policy issues in regards to the data that should be implimented. i have outside vendors that i send them requests and they send them back. before i release this information to my clients i have the information looked at prior to updating my client side tables. a good policy for any core information. ~| 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:304109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is this Application.cfm abuse?
I'm working on a project and when I dumped the application scope there were over 25,000 lines of variables and struct items. When I saved all of this it was over 500k. Does this seem unusual? That seems pretty excessive. Do you mean there were 25K lines in Application.cfm, or there were 25K variables in the Application scope, or some combination thereof? -- Josh ~| 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:304113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is this Application.cfm abuse?
Hmm, it depends. 500k of application memory doesn't really sound bad - how much memory does the server have - I'm sure 500kb doesn't really matter. As far as abusing the application scope - is the data well organized? Are the variables logically named? Are they correctly scoped? They should not be related to any clients using the system, but are indeed application configuration settings. Are they values that are better left in a stylesheet or on a page-configuration level as opposed to an application configuration level? If the data is a lot of manually cached queries or data, this, too, would make sense, though it might be better to make a reusable caching service. The newer way of handling application configuration settings is probably something more along the lines of hiding a lot of the configuration through a CFC or CFCs and make the application configuration a managed data process. One of the best things I've seen is putting many of these settings in a coldspring services.xml file and providing settings where they are needed instead of globally to the entire application. YMMV (Your Mileage May Vary) and it really depends on the application and the implementation. -- nathan strutz http://www.dopefly.com/ On Wed, Apr 23, 2008 at 2:16 PM, John Engstrom [EMAIL PROTECTED] wrote: I'm working on a project and when I dumped the application scope there were over 25,000 lines of variables and struct items. When I saved all of this it was over 500k. Does this seem unusual? ~| 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:304114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfpdf text extraction problems
Greg, How are you pulling your text out? The technique I used is referenced in the below link, and it worked great for me: http://blog.cutterscrossing.com/index.cfm/2007/12/3/CF8-PDF-Manipulation-Pulling-Text-Out Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Greg Giotopoulos wrote: I am having trouble extracting text from a pdf. Specifically, I have found that when the text is extracted there are spaces inserted into random places. For example: This sample text will be extracted as: Th is s a mpl e te x t Problem is that it seems to happen in random places in the text so I have been unable to grab a clean version. I've tried changing the encoding but have been unable to get to the root of this problem. Is this a cfpdf issue? Or does it have something to do with the source file? ~| 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:304115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT : Check boxes in coldext grid
I have a coldext grid that I am using to update bit fields and I was wondering if anyone had been able to incorporate check boxes. I have the select box working but I know what the powers that be will want check boxes. I have contacted the author, Justin Carter, about this and he pointed me toward a work around that I have not been able to get to work. I email him about it but he hasn't gotten back to me. I was wondering if the collective wisdom here had encountered a way to to do this. We are on CF 7 here. TIA, G -- The pursuit of truth and beauty is a sphere of activity in which we are permitted to remain children all our lives. - Albert Einstein ~| 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:304116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JavaScript cftextarea with rich text
Thanks guys for all the help.
I ended up getting it to work with a combination of responses. Here is the code:
function check()
{
var text1 = ColdFusion.RichText.getEditorObject('theBody');
var text2 = text1.GetXHTML(true);
if (text2==0)
{
alert('Body is required');
}
}
Works like a champ. Thanks again!
I am trying to check whether or not a rich text textarea has a value
in JavaScript. On a normal textarea box I can just use the elementname.
value == '' but that is not working when I have rich text turned on.
Anyone have any ideas how to check it when rich text is on?
Thanks!
~|
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:304117
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfgrid / cfgirdcolumn selectmode=edit checkbox
i'm dealing with the same problem mate, ive got a cfgrid type java applet and select mode single, coz i use href attribute for some columns, but i can't then edit the checkboxes, they r not clickable. if i change the select mode to edit, the checkboxes work but the hrefkey then becomes the value of the whole row and i can't use it in the next page. plz help me out with this... what i would love to know is how to get both the checkbox selectability and the href attribute working in the same cfgrid?? thanks Ok. so ive made some headway. Apparently, the functionality I was looking for was CFGRIDUPDATE. Now Im able to manipulate the values for the checked box to true or false in the table for each specific ID selected. My question now is there functionality to update session variables as opposed to table rows with CFGRIDUPDATE? ~| 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:304118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfexecute - at my wits end!
Hi all, I am trying to combine two wav files from the command prompt using coldfusion and sox (http://sox.sourceforge.net/). I am using cfexecute. I can output my 'name' and 'arguments' attribute for cfexecute to the screen, copy and paste them to the command prompt and the program executes perfectly. However, when I run the cfexecute, the program apparently does not execute. I'm on a windows system, with MX 7. I can't explain why. I've tried using the output variable and I just get an empty text file. Does anyone have any ideas? If you know of any other COM object or library I could use instead, that would be fine too. I'm just needing to combine wave files from within my CF app. Thanks, Dave ~| 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:304119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute - at my wits end!
Have you got your ColdFusion Service running with a user account? If not, try using the same account that you use to log onto the server with. On Thu, Apr 24, 2008 at 8:54 AM, Dave Phillips [EMAIL PROTECTED] wrote: Hi all, I am trying to combine two wav files from the command prompt using coldfusion and sox (http://sox.sourceforge.net/). I am using cfexecute. I can output my 'name' and 'arguments' attribute for cfexecute to the screen, copy and paste them to the command prompt and the program executes perfectly. However, when I run the cfexecute, the program apparently does not execute. I'm on a windows system, with MX 7. I can't explain why. I've tried using the output variable and I just get an empty text file. Does anyone have any ideas? If you know of any other COM object or library I could use instead, that would be fine too. I'm just needing to combine wave files from within my CF app. Thanks, Dave ~| 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:304120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfexecute - at my wits end!
Do you have quoted values in your arguments? CFEXECUTE won't handle those correctly. However, you can pass an array of arguments (instead of a string), and those should work. That being said, I usually go to an intermediary shell script (or BAT file) when I have to shell out from CF. That gives me better control over the execution. cheers, barneyb On Wed, Apr 23, 2008 at 5:54 PM, Dave Phillips [EMAIL PROTECTED] wrote: Hi all, I am trying to combine two wav files from the command prompt using coldfusion and sox (http://sox.sourceforge.net/). I am using cfexecute. I can output my 'name' and 'arguments' attribute for cfexecute to the screen, copy and paste them to the command prompt and the program executes perfectly. However, when I run the cfexecute, the program apparently does not execute. I'm on a windows system, with MX 7. I can't explain why. I've tried using the output variable and I just get an empty text file. Does anyone have any ideas? If you know of any other COM object or library I could use instead, that would be fine too. I'm just needing to combine wave files from within my CF app. Thanks, Dave -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| 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:304121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is this Application.cfm abuse?
John, It depends on the application, though I don't think 500k is particularly high. The apps I have built using FarCry seem to use about 375-400kb on app init - before any queries are cached (those are on 3.5 so much has probably changed in 4.0 and the new release upcoming). Between query and object caching, I think if the way the application is used and the server can justify the memory usage it's not too much of a concern. The biggest application scope abuse I've seen is using it to store data that should be maintained in session, client, or even request. This results in a ton of updating of application variables and excessive locking in some cases. It might be bad form to use an excessive amount of memory on shared hosting, though. Jon On Apr 23, 2008, at 5:16 PM, John Engstrom wrote: I'm working on a project and when I dumped the application scope there were over 25,000 lines of variables and struct items. When I saved all of this it was over 500k. Does this seem unusual? ~| 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:304122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgrid / cfgirdcolumn selectmode=edit checkbox
Good Evening, This is a problem that I had some time ago. I wanted to have a check all box to for the check boxes in the cfgrid, and I had to create a cfsavecontent to do that. IF you want that info, let me know. As for updating only the selected rows in a grid based on the check box, I use the following: cfloop index = Counter from = 1 to = #arraylen(Form.gridname.rowstatus.action)# ** the array that i am getting the length from comes from the grid cfif Form.gridname.rowstatus.action[counter] is U if you just dump your Form.gridname.rowstatus.action, you will see the ones that have been updated. This is all handled by CF. Technically I don't think the check box actually matters, more that you have 'changed' that row. My meaning is that if you have a comment field that is editable, someone can just change that and not touch the check box, and that row will still be updated. I probably need another check to see if the checkbox, called checked has a value or not for the row where the status is U (meaning update) I then nest the Update queries inside the if structure, and my database has all the desired results. This took me a few days to figure out. :) Hope that this directs you a little... Rob On Wed, Apr 23, 2008 at 8:52 PM, shakti misra [EMAIL PROTECTED] wrote: i'm dealing with the same problem mate, ive got a cfgrid type java applet and select mode single, coz i use href attribute for some columns, but i can't then edit the checkboxes, they r not clickable. if i change the select mode to edit, the checkboxes work but the hrefkey then becomes the value of the whole row and i can't use it in the next page. plz help me out with this... what i would love to know is how to get both the checkbox selectability and the href attribute working in the same cfgrid?? thanks Ok. so ive made some headway. Apparently, the functionality I was looking for was CFGRIDUPDATE. Now Im able to manipulate the values for the checked box to true or false in the table for each specific ID selected. My question now is there functionality to update session variables as opposed to table rows with CFGRIDUPDATE? ~| 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:304123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need some advice on speeding up query...
Now's here's a new problem I haven't encountered. How do I use a url variable to link to a property details page when the properties are in 8 different tables? The issue really isn't the variable, since I can use the aliased variable property_id (once I add it to the query). I know I could use property_details.cfm?property_id=cfoutput#get_properties.property_id#/cfoutput, however, on the details page, I would need to search all eight property tables for the correct property id. Is this the method I'm stuck with because all the properties aren't in a single table? Pass the aliased variable property_id and search all 8 tables for it? Perhaps I should just put them all into one big property table instead of keeping them separate as the data vender has them... Thoughts? Thanks, Rick Here's the current state of my union all query with all the property tables finally in play: cfquery name=get_properties datasource=#dsn# select sa.street_number as prop_street_number, sa.street_name as prop_street_name, sa.city as prop_city, sa.public_remarks_01 as prop_public_remarks_01, sa.public_remarks_02 as prop_public_remarks_02, sa.list_price as prop_list_price, (select sap.photo_filename from smlc_acr_photos sap where sap.photo_mls_number = sa.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sa.listing_office) as prop_listing_office from smlc_acr sa union all select sc.street_number as prop_street_number, sc.street_name as prop_street_name, sc.city as prop_city, sc.public_remarks_01 as prop_public_remarks_01, sc.public_remarks_02 as prop_public_remarks_02, sc.list_price as prop_list_price, (select scp.photo_filename from smlc_com_photos scp where scp.photo_mls_number = sc.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sc.listing_office) as prop_listing_office from smlc_com sc union all select sl.street_number as prop_street_number, sl.street_name as prop_street_name, sl.city as prop_city, sl.public_remarks_01 as prop_public_remarks_01, sl.public_remarks_02 as prop_public_remarks_02, sl.list_price as prop_list_price, (select slp.photo_filename from smlc_lot_photos slp where slp.photo_mls_number = sl.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sl.listing_office) as prop_listing_office from smlc_lots sl union all select sr.street_number as prop_street_number, sr.street_name as prop_street_name, sr.city as prop_city, sr.public_remarks_01 as prop_public_remarks_01, sr.public_remarks_02 as prop_public_remarks_02, sr.list_price as prop_list_price, (select srp.photo_filename from smlc_ren_photos srp where srp.photo_mls_number = sr.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sr.listing_office) as prop_listing_office from smlc_ren sr union all select sres.street_number as prop_street_number, sres.street_name as prop_street_name, sres.city as prop_city, sres.public_remarks_01 as prop_public_remarks_01, sres.public_remarks_02 as prop_public_remarks_02, sres.list_price as prop_list_price, (select sresp.photo_filename from smlc_res_photos sresp where sresp.photo_mls_number = sres.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sres.listing_office) as prop_listing_office from smlc_res sres union all select smul.street_number as prop_street_number, smul.street_name as prop_street_name, smul.city as prop_city, smul.public_remarks_01 as prop_public_remarks_01, smul.public_remarks_02 as prop_public_remarks_02, smul.list_price as prop_list_price, (select smulp.photo_filename from smlc_mul_photos smulp where smulp.photo_mls_number = smul.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = smul.listing_office) as prop_listing_office from smlc_mul smul /cfquery ~| 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:304124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How do I select multiple fields as multiple aliases?
Would this work? select sap.photo_filename from smlc_acr_photos sap where sap.photo_mls_number = sa.mls_number limit 3 as prop_photo_filename_01, prop_photo_filename_02, prop_photo_filename_03 ??? Rick ~| 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:304125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need some advice on speeding up query...
How do I use a url variable to link to a property details page when the properties are in 8 different tables? The issue really isn't the variable, since I can use the aliased variable property_id (once I add it to the query). I know I could use property_details.cfm?property_id=cfoutput#get_properties.pro perty_id#/cfoutput, however, on the details page, I would need to search all eight property tables for the correct property id. Is this the method I'm stuck with because all the properties aren't in a single table? Pass the aliased variable property_id and search all 8 tables for it? Perhaps I should just put them all into one big property table instead of keeping them separate as the data vender has them... Are all these tables identically constructed? That's what it looks like from the query. If so, I can't imagine why the vendor would tell you to do that. Did the vendor explain this to you? What database server are you using? How many records are we talking about? Are the tables properly indexed? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| 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:304126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some advice on speeding up query...
Rick, Based on what I can see, it appears that the tables are separated by property type (commercial, residential, lot, multiunit, etc.). You would need to add a column in the table to identify that type, but it seems to me - as long as they are identical in structure as it seems - that merging them into a single table would make life easier in many ways. Correct me if I'm wrong, but it would seem like property data would be low-write/high-read tables so as long as you merge them you could avoid the overhead of the UNION ALLs and then could index them heavily(MLS#, Property Type ZIP,etc.). Then, depending on your DBMS type, you could create additional create views and caches at the DBMS level to further optimize query speed. Writes are much slower on heavily large, heavily indexed tables since the indexes have to be recreated or appended but I imagine, for this type of data, that the agents could wait a tiny bit longer for their entries if their records were retrieved exponentially faster. HTH, Jon On Apr 23, 2008, at 10:29 PM, Rick Faircloth wrote: Now's here's a new problem I haven't encountered. How do I use a url variable to link to a property details page when the properties are in 8 different tables? The issue really isn't the variable, since I can use the aliased variable property_id (once I add it to the query). I know I could use property_details.cfm? property_id=cfoutput#get_properties.property_id#/cfoutput, however, on the details page, I would need to search all eight property tables for the correct property id. Is this the method I'm stuck with because all the properties aren't in a single table? Pass the aliased variable property_id and search all 8 tables for it? Perhaps I should just put them all into one big property table instead of keeping them separate as the data vender has them... Thoughts? Thanks, Rick Here's the current state of my union all query with all the property tables finally in play: cfquery name=get_properties datasource=#dsn# select sa.street_number as prop_street_number, sa.street_name as prop_street_name, sa.city as prop_city, sa.public_remarks_01 as prop_public_remarks_01, sa.public_remarks_02 as prop_public_remarks_02, sa.list_price as prop_list_price, (select sap.photo_filename from smlc_acr_photos sap where sap.photo_mls_number = sa.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sa.listing_office) as prop_listing_office from smlc_acr sa union all select sc.street_number as prop_street_number, sc.street_name as prop_street_name, sc.city as prop_city, sc.public_remarks_01 as prop_public_remarks_01, sc.public_remarks_02 as prop_public_remarks_02, sc.list_price as prop_list_price, (select scp.photo_filename from smlc_com_photos scp where scp.photo_mls_number = sc.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sc.listing_office) as prop_listing_office from smlc_com sc union all select sl.street_number as prop_street_number, sl.street_name as prop_street_name, sl.city as prop_city, sl.public_remarks_01 as prop_public_remarks_01, sl.public_remarks_02 as prop_public_remarks_02, sl.list_price as prop_list_price, (select slp.photo_filename from smlc_lot_photos slp where slp.photo_mls_number = sl.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sl.listing_office) as prop_listing_office from smlc_lots sl union all select sr.street_number as prop_street_number, sr.street_name as prop_street_name, sr.city as prop_city, sr.public_remarks_01 as prop_public_remarks_01, sr.public_remarks_02 as prop_public_remarks_02, sr.list_price as prop_list_price, (select srp.photo_filename from smlc_ren_photos srp where srp.photo_mls_number = sr.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sr.listing_office) as prop_listing_office from smlc_ren sr union all select sres.street_number as prop_street_number, sres.street_name as prop_street_name, sres.city as prop_city, sres.public_remarks_01 as prop_public_remarks_01, sres.public_remarks_02 as prop_public_remarks_02, sres.list_price as prop_list_price, (select sresp.photo_filename from smlc_res_photos sresp where sresp.photo_mls_number = sres.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sres.listing_office) as prop_listing_office from smlc_res
RE: Need some advice on speeding up query...
Unfortunately, the database vendor has been unreachable during the process of trying to figure out how the constructed their database, why they did it that way, and why their schema for the tables doesn't match the delimited data files I had to import. There are about 8,000 properties currently. No, none of the tables are alike. They do share some fields, but there is a lot different about each one. I'm using MySQL 5. I've got proper indexing on the tables now (as far as I know) based on other's advice, which has greatly sped up my queries. It looks as if I'm going to have to run through queries on each property table to see if I can find a match to the property id - query the acreage table, if no match, - query the lot table, if no match, - query the rental table, etc. until a match is found. Really can't see another way of doing it with the properties spread out between tables. Is there some conditional code I can use in a single query that allows me to search for a property id in multiple tables? Thanks for the feedback. Rick -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, April 24, 2008 12:06 AM To: CF-Talk Subject: RE: Need some advice on speeding up query... How do I use a url variable to link to a property details page when the properties are in 8 different tables? The issue really isn't the variable, since I can use the aliased variable property_id (once I add it to the query). I know I could use property_details.cfm?property_id=cfoutput#get_properties.pro perty_id#/cfoutput, however, on the details page, I would need to search all eight property tables for the correct property id. Is this the method I'm stuck with because all the properties aren't in a single table? Pass the aliased variable property_id and search all 8 tables for it? Perhaps I should just put them all into one big property table instead of keeping them separate as the data vender has them... Are all these tables identically constructed? That's what it looks like from the query. If so, I can't imagine why the vendor would tell you to do that. Did the vendor explain this to you? What database server are you using? How many records are we talking about? Are the tables properly indexed? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| 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:304128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need some advice on speeding up query...
Yes, the tables are separated by property type, but no, they don't have the same fields. They're all different. And, yes, these would be, by far, heavy on the read side and light on the write side. I guess I could create one massive table, encompassing all the various fields for all the property types. I'd have to check into that. Once I get this process of importing delimited text data into my MySQL db tables as temp tables, then importing that data into a permanent table with a auto-incrementing, primary key property_id field added *and* processing batches of photos by reading their filenames in the various directories, parsing the MSL number for each photo, and storing that in a corresponding photo table... Once all that is complete, as I've now done it all manually, I have to automate the process, because all the data and photos have to be updated daily. I pretty much worked that out, too. Scheduled tasks will take care of the automation. And once I get this all figured out and implemented for the Savannah MLS's data, I get to add in the Hinesville MLS's data... I should be getting paid more... Rick -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Thursday, April 24, 2008 12:28 AM To: CF-Talk Subject: Re: Need some advice on speeding up query... Rick, Based on what I can see, it appears that the tables are separated by property type (commercial, residential, lot, multiunit, etc.). You would need to add a column in the table to identify that type, but it seems to me - as long as they are identical in structure as it seems - that merging them into a single table would make life easier in many ways. Correct me if I'm wrong, but it would seem like property data would be low-write/high-read tables so as long as you merge them you could avoid the overhead of the UNION ALLs and then could index them heavily(MLS#, Property Type ZIP,etc.). Then, depending on your DBMS type, you could create additional create views and caches at the DBMS level to further optimize query speed. Writes are much slower on heavily large, heavily indexed tables since the indexes have to be recreated or appended but I imagine, for this type of data, that the agents could wait a tiny bit longer for their entries if their records were retrieved exponentially faster. HTH, Jon On Apr 23, 2008, at 10:29 PM, Rick Faircloth wrote: Now's here's a new problem I haven't encountered. How do I use a url variable to link to a property details page when the properties are in 8 different tables? The issue really isn't the variable, since I can use the aliased variable property_id (once I add it to the query). I know I could use property_details.cfm? property_id=cfoutput#get_properties.property_id#/cfoutput, however, on the details page, I would need to search all eight property tables for the correct property id. Is this the method I'm stuck with because all the properties aren't in a single table? Pass the aliased variable property_id and search all 8 tables for it? Perhaps I should just put them all into one big property table instead of keeping them separate as the data vender has them... Thoughts? Thanks, Rick Here's the current state of my union all query with all the property tables finally in play: cfquery name=get_properties datasource=#dsn# select sa.street_number as prop_street_number, sa.street_name as prop_street_name, sa.city as prop_city, sa.public_remarks_01 as prop_public_remarks_01, sa.public_remarks_02 as prop_public_remarks_02, sa.list_price as prop_list_price, (select sap.photo_filename from smlc_acr_photos sap where sap.photo_mls_number = sa.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sa.listing_office) as prop_listing_office from smlc_acr sa union all select sc.street_number as prop_street_number, sc.street_name as prop_street_name, sc.city as prop_city, sc.public_remarks_01 as prop_public_remarks_01, sc.public_remarks_02 as prop_public_remarks_02, sc.list_price as prop_list_price, (select scp.photo_filename from smlc_com_photos scp where scp.photo_mls_number = sc.mls_number limit 1) as prop_photo_filename, (select so.office_name from smlc_off so where so.office_code = sc.listing_office) as prop_listing_office from smlc_com sc union all select sl.street_number as prop_street_number, sl.street_name as prop_street_name, sl.city as prop_city, sl.public_remarks_01 as prop_public_remarks_01, sl.public_remarks_02 as prop_public_remarks_02, sl.list_price as prop_list_price, (select slp.photo_filename from smlc_lot_photos slp where slp.photo_mls_number = sl.mls_number limit 1) as prop_photo_filename,
Jacksonville - Orange Park CF Developer needed ASAP
Well funded, profitable company is looking for a local developer with a good attitude and desire to learn and work at our growing company. We need a full time (sorry no telecommuters)in house CF developer. Should be familiar with CF7 and CF8 as well as MS SQL. JavaScript, AJAX, GUI design a plus. Competitive Salary - based on experience. Incredible opportunity for developers with only a few years of experience to work and learn. Looking for someone immediately. Good benefits, great working environment. Will pay WoW Monthly fee if you come to our server ;) Probably the best job you will ever have. Send resume to [EMAIL PROTECTED] ~| 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-Jobs-Talk/message.cfm/messageid:3741 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
