Re: Cf9 tabbed layouts cflayout
I did see that after Ray's post about the release notes. I honestly hadn't seen the release notes before Ray's post. But, if my memory serves me correct it only mentiones it for firefox, and I did have the same problem with IE. On Wed, Oct 21, 2009 at 9:21 AM, Tom Chiverton tom.chiver...@halliwells.com wrote: On Wednesday 21 Oct 2009, David Mineer wrote: The temporary workaround that I found for this was to set a height value in the cflayout tag. You can see more details about how I fixed it in the comments on Sam's blog linked below. This is listed in the release notes isn't it ? -- Helping to carefully orchestrate visionary eye-catching clicks-and-mortar eigth-generation ROI as part of the IT team of the year, '09 and '08 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 together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. 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.co ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327488 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 to display LARGE amounts of Data in a Timely Fashion
They can't see that much on one screen anyway. So break it up and only give them 500 at a time. You can use startrow and maxrows for that. Or you can spit it out in a .csv file that will pop up in excel or openoffice. I did this all the time with CF8 and it is even easier now with cf9 because you can use cfspreadsheet. On Wed, Oct 21, 2009 at 9:22 PM, Rick Colman rcol...@cox.net wrote: I need to query, retrieve and display a large amount of data; i.e. 4100 rows by 50 columns of numerics, to the browser screen. It is really slow, and after some testing, the bottleneck seems to be on the page that displays the data. The query is OK and connection is ok. But, the user has to wait an unacceptably long time for the results to show. Ideally, I would like to break the returned data into about 10 spreadsheet-style grids, with one grid per tab. TABLES is way too slow. Any ideas on how to render the displayed data quickly would be appreciated. Rick. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327489 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 to display LARGE amounts of Data in a Timely Fashion
well, you can try using CFFLUSH in the end of your cfoutput query=myQuery block. -- From: David Mineer min...@gmail.com Sent: Thursday, October 22, 2009 12:37 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: How to display LARGE amounts of Data in a Timely Fashion They can't see that much on one screen anyway. So break it up and only give them 500 at a time. You can use startrow and maxrows for that. Or you can spit it out in a .csv file that will pop up in excel or openoffice. I did this all the time with CF8 and it is even easier now with cf9 because you can use cfspreadsheet. On Wed, Oct 21, 2009 at 9:22 PM, Rick Colman rcol...@cox.net wrote: I need to query, retrieve and display a large amount of data; i.e. 4100 rows by 50 columns of numerics, to the browser screen. It is really slow, and after some testing, the bottleneck seems to be on the page that displays the data. The query is OK and connection is ok. But, the user has to wait an unacceptably long time for the results to show. Ideally, I would like to break the returned data into about 10 spreadsheet-style grids, with one grid per tab. TABLES is way too slow. Any ideas on how to render the displayed data quickly would be appreciated. Rick. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: rotating cfchart
You are welcome :) -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327491 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 to side step a long running process
Yup, works a treat! On 21 Oct 2009, at 22:35, Stefan Richter wrote: Excellent, thanks, Dave. So I don't have to worry about merging threads back together or stuff like that? Because that scared me when I read up on it. But kicking off one thread looks doable even to me :-) Rick, I had your model in mind too but wanted to avoid any kind of polling if possible (got enough of that already for other parts of the app :-) Thanks all, I'll test cfthread tomorrow and report back with results (and also when the site is up). This list rocks. Cheers Stefan On 21 Oct 2009, at 14:50, Dave Watts wrote: How could I change this so that the response is sent first, and then the conversion kicked into life? The Flex client can later check the conversion status itself by polling the database. This is a perfect job for CFTHREAD. Put the PDF generation code within CFTHREAD. and simply return a job accepted message after launching the thread. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about cloud computing
On Wed, Oct 21, 2009 at 9:59 PM, Rick Root rick.r...@gmail.com wrote: On a side note, I have a cloud server now to play with... I was able to install Chrome, but after downloading Railo, I couldn't double click on the exe, I'd just get a Windows cannot access the device, path, or file... error, which I don't understand at all. Same thing with FileZilla Server. Apparently, I need to uninstall the internet explorer enhanced security package. Annoying. Ric ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327493 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 to display LARGE amounts of Data in a Timely Fashion
If you're putting the data on 10 different tabs, then only call or render the data for the first one and use DHTML / Ajax to load the each other tab only when a user clicks on it. Basically, it's slow right now simply because the size of the HTML document being returned to the user is probably over a MB of data ... simply takes time to stream it from the web server and assemble it on the desktop. If you only render 1/10 of the table (i.e., one tab), the overall file size will be much smaller and you should notice a significant improvement in speed. Then each tab click can just call an Ajax function to populate the new tab with the right data and the user will only have to wait for that 2nd 10th of data to be rendered. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327494 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 to display LARGE amounts of Data in a Timely Fashion
cache your query so u dont have to access the database each time Sincerely, Chuka I.W. Anene Chief Software Eng./CEO Quorium Solutions www.quorium.org 07029609185,07032696113 From: Rick Colman rcol...@cox.net To: cf-talk cf-talk@houseoffusion.com Sent: Thu, October 22, 2009 4:22:07 AM Subject: How to display LARGE amounts of Data in a Timely Fashion I need to query, retrieve and display a large amount of data; i.e. 4100 rows by 50 columns of numerics, to the browser screen. It is really slow, and after some testing, the bottleneck seems to be on the page that displays the data. The query is OK and connection is ok. But, the user has to wait an unacceptably long time for the results to show. Ideally, I would like to break the returned data into about 10 spreadsheet-style grids, with one grid per tab. TABLES is way too slow. Any ideas on how to render the displayed data quickly would be appreciated. Rick. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: REReplace Statment Help
This will replace everything that is not alphanumeric with a dash: ProductPageName = rereplace( Form.PageName , '\W' , '-' , 'All' ) However, the above will change this that to this---that, if you would prefer a single dash in situations like this, you can simply do this: ProductPageName = rereplace( Form.PageName , '\W+' , '-' , 'All' ) \W in that regex stands for non-word-character, equivalent in CF to [^a-zA-Z0-9_] ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfexecute running a batch file not return all the output
We are using cfexecute to run an ant script (the build file uses ant4cf, if that matters) via a batch file. If the build succeeds, we get all of the output returned (BUILD FILE SUCCESSFUL). However, if the build fails, we don't get BUILD FILE FAILED followed by the failure reason. I've verified that if we run the batch file directly (not using ColdFusion), the output does show up. Is there something we need to do to get the failure output to return? We'd like to store the failure reason when our builds run. Here's our batch file code: @ECHO OFF REM Create environment variables SET JAVA_HOME = C:\Program Files\Java\jdk1.6.0_16 SET ANT_HOME = C:\apache-ant-1.7.1 REM Run build.xml C:\apache-ant-1.7.1\bin\ant -buildfile d:\web_roots\ant4cf\builds\build.xml -quiet @ECHO ON Scott -- - Scott Brady http://www.scottbrady.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute running a batch file not return all the output
We are using cfexecute to run an ant script ... I am definitely not the one to advise you on ant ;-) But if it writes to stderr, you may want to try redirecting stderr in your cfexecute call. Just for grins. There were a few issues with that in earlier versions. Though I think that issue was corrected in one of the CF8 updates. http://www.forta.com/blog/index.cfm/2006/9/11/A-Couple-Of-CFEXECUTE-Gotchas -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute running a batch file not return all the output
On Thu, Oct 22, 2009 at 6:57 AM, Leigh cfsearch...@yahoo.com wrote: I am definitely not the one to advise you on ant ;-) But if it writes to stderr, you may want to try redirecting stderr in your cfexecute call. Just for grins. There were a few issues with that in earlier versions. Though I think that issue was corrected in one of the CF8 updates. http://www.forta.com/blog/index.cfm/2006/9/11/A-Couple-Of-CFEXECUTE-Gotchas Yep, that was the fix. I didn't realize the error output and standard output is virtually identical to the eye or that cfexecute doesn't read error output. Redirecting it to stdout did the trick. Thanks! Scott -- - Scott Brady http://www.scottbrady.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute running a batch file not return all the output
Yep, that was the fix. I didn't realize the error output and standard output is virtually identical to the eye or that cfexecute doesn't read error output. Yes, neither did I until I ran into the same problem ;-) Cheers -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need some Distinct help
Hello: Can anyone plz tell me why I cannot get the correct output from this query It gives the following output shown below the query, when there should be no repeats (DISTINCT appears to not be working) cfquery datasource=#datasource# name=list_audit_orgs SELECT audit_org_list.audit_org_id, audit_org_type.audit_org_type_id, audit_org_type.audit_org_type, audit_org_linking.audit_org_id2, audit_org_linking.audit_org_type_id2 FROM audit_org_list inner JOIN audit_org_linking on audit_org_list.audit_org_id=audit_org_linking.audit_org_id2 inner JOIN audit_org_type on audit_org_type.audit_org_type_id=audit_org_linking.audit_org_type_id2 /cfquery cfquery name=unique_info dbtype=query SELECT distinct audit_org_id, audit_org_type_id, audit_org_type, audit_org_type_id2, audit_org_id2 FROM list_audit_orgs /cfquery cfoutput query=unique_info group=audit_org_type_id audit_org_typebrbr /cfoutput Internal Auditors CPA Firms Federal Auditors CPA Firms Federal Auditors ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327501 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 Distinct help
Totally ignoring the data/distinct question for a moment, when using cfoutput group the query data must be sorted correctly, or you will not get the right results. You need to ORDER the query results by the same column you're using in your group. If you are grouping by audit_org_type_id, your query must be ordered by that column as well. cfquery ... SELECT ORDER BY audit_org_type_id /cfquery cfoutput name=... group=audit_org_type_id ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327502 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 Distinct help
AWESOME - simple, easy fix - thanks Leigh ... I had forgotten that requirement Leigh cfsearch...@yahoo.com 10/22/2009 11:55 AM Totally ignoring the data/distinct question for a moment, when using cfoutput group the query data must be sorted correctly, or you will not get the right results. You need to ORDER the query results by the same column you're using in your group. If you are grouping by audit_org_type_id, your query must be ordered by that column as well. cfquery ... SELECT ORDER BY audit_org_type_id /cfquery cfoutput name=... group=audit_org_type_id ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327503 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 Distinct help
Thanks for responding Brian but Leigh's tip made it work Brian McCairn brian.mcca...@medicapp.eu 10/22/2009 12:03 PM do you need those other columns? does cfquery name=unique_info dbtype=query SELECT distinct audit_org_type FROM list_audit_orgs /cfquery work? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327505 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 Distinct help
do you need those other columns? does cfquery name=unique_info dbtype=query SELECT distinct audit_org_type FROM list_audit_orgs /cfquery work? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327504 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ExpandPath() Returns java.lang.NullPointerException When Run As Scheduled Task?
Current I'm in the midst of a puzzler. I have an image processing routine set up to run as a scheduled task. When the .cfm page is initiated from a web browser the page complete just fine. However, when the page is started as part of a scheduled tasks it creates errors in the log file stating there has been java.lang.NullPointerException. Looking at the error log and doing some investigating signs point to an ExpandPath() statement causing the problem (and yes, blah is always more than two characters - again, it'll run just fine through the same data from the URL as it errors on when run as a scheduled task): cfset myDir = ExpandPath('/images/subDir/#left(blah,2)#/#blah#/') / The full exception entry is below. Has anyone seen this before and, more importantly, have an idea on how to fix it (other than hard coding path values to the variable)? Error,jrpp-444,10/20/09,00:21:28,myapp,'' The specific sequence of files included or processed is: D:\mysite\public\sandbox\myfile.cfm, line: 149 java.lang.NullPointerException at coldfusion.runtime.ServletContextWrapper.doGetRealPath(ServletContextWrapper.java:162) at coldfusion.runtime.ServletContextWrapper._doGetRealPath(ServletContextWrapper.java:112) at coldfusion.runtime.ServletContextWrapper.getRealPath(ServletContextWrapper.java:97) at coldfusion.filter.FusionContext.getRealPath(FusionContext.java:800) at coldfusion.util.Utils.expandPath(Utils.java:419) at coldfusion.runtime.CFPage.ExpandPath(CFPage.java:2819) at cffilepull_images2ecfm1549189413._factor5(D:\mysite\public\sandbox\myfile.cfm:149) at cffilepull_images2ecfm1549189413._factor7(D:\mysite\public\sandbox\myfile.cfm:143) at cffilepull_images2ecfm1549189413._factor8(D:\mysite\public\sandbox\myfile.cfm:114) at cffilepull_images2ecfm1549189413.runPage(D:\mysite\public\sandbox\myfile.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) 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.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:284) 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) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ExpandPath() Returns java.lang.NullPointerException When Run As Scheduled Task?
I haven't seen it, but the thought occurs to me that you might try changing the mapping. I'm guessing you're using the default webserver root mapping / -- it's possible that adding a /images mapping might resolve the issue at least temporarily. Or switching between setting the mapping in the CF Admin versus setting it in the Application.cfc. -- s. isaac dealey :: AutLabs Creating meaningful employment for people with Autism http://www.autlabs.com ph: 817.385.0301 http://onTap.riaforge.org/blog ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327507 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
java.lang.IndexOutOfBoundsException on XML Struct?
I'm currently parsing a number of xml files. In attempt to speed up processing I'm running each file in its own parse thread (may be relevant, I'm not sure). Inside of each I have a loop that is causing the error java.lang.IndexOutOfBoundsException. cfif StructKeyExists(stcXML.country,cities) cfloop index=i from=1 to=#ArrayLen(stcXml.country.cities.xmlChildren)# cfset CityData = stcXml.country.cities.xmlChildren[i] / cfsavecontent variable=STUFF'#CityData.url.xmlText#'/cfsavecontent cfset writeToFile(STUFF) / /cfloop /cfif --- The line that the log file says is the problem is: cfset CityData = stcXml.country.cities.xmlChildren[i] / How can that statement with 'i' be throwing a java.lang.IndexOutOfBoundsException when I just set 'i' to increment from 1 to the length of xmlChildren? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
How can that statement with 'i' be throwing a java.lang.IndexOutOfBoundsException when I just set 'i' to increment from 1 to the length of xmlChildren? Since you mentioned threads, are all of the variables properly scoped? Assuming the array has not changed, it sounds like you might be getting the wrong value because the variable is shared by other threads. -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327509 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: java.lang.IndexOutOfBoundsException on XML Struct?
If stcXml.country.cities.xmlChildren is empty, then the first pass at index=1 would be invalid. Can you verify that the the XML has at least 1 cities child? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327510 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT database problem
I have a zipcode table that is driving me nuts... If I open query analyzer and say SELECT * FROM zip WHERE zipcode = 'valid zipcode' I get nothing back but if I say SELECT zipcode from zip I get all the zips back and the valid zipcode from the first query is listed in there. Why cannot I not get anything with a conditional statement in there? Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: java.lang.IndexOutOfBoundsException on XML Struct?
If stcXml.country.cities.xmlChildren is empty, then the first pass at index=1 would be invalid. Can you verify that the the XML has at least 1 cities child? Duh! Good point ;-) -Leigh ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327512 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 database problem
I'd need to see the datatype of the zipcode column as well as the content of the 'valid zipcode' variable before I could answer the question, but my guess would be that there's a discrepancy in datatype: '#validZipCode#' when it should be #validZipCode# or something like that. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327513 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 database problem
What is the field type of the zip code field Douglas Brown mistobr...@gmail.com 10/22/2009 2:12 PM I have a zipcode table that is driving me nuts... If I open query analyzer and say SELECT * FROM zip WHERE zipcode = 'valid zipcode' I get nothing back but if I say SELECT zipcode from zip I get all the zips back and the valid zipcode from the first query is listed in there. Why cannot I not get anything with a conditional statement in there? Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327514 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 database problem
I'd need to see the datatype of the zipcode column as well as the content of the 'valid zipcode' variable before I could answer the question, but my guess would be that there's a discrepancy in datatype: '#validZipCode#' when it should be #validZipCode# or something like that. The datatype is nvarchar(5) the zipcode is just a simple US zipcode '81416' for example. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327515 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 database problem
Is there any reason you're not using an integer field type of some sort? Douglas Brown mistobr...@gmail.com 10/22/2009 2:24 PM I'd need to see the datatype of the zipcode column as well as the content of the 'valid zipcode' variable before I could answer the question, but my guess would be that there's a discrepancy in datatype: '#validZipCode#' when it should be #validZipCode# or something like that. The datatype is nvarchar(5) the zipcode is just a simple US zipcode '81416' for example. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT database problem
Integer fields for zip codes can be problematic in the case of a zip code like 08817 (tends to strip off the leading zero). On Thu, Oct 22, 2009 at 11:35 AM, Timothy Laureska tlaure...@dhmh.state.md.us wrote: Is there any reason you're not using an integer field type of some sort? Douglas Brown mistobr...@gmail.com 10/22/2009 2:24 PM I'd need to see the datatype of the zipcode column as well as the content of the 'valid zipcode' variable before I could answer the question, but my guess would be that there's a discrepancy in datatype: '#validZipCode#' when it should be #validZipCode# or something like that. The datatype is nvarchar(5) the zipcode is just a simple US zipcode '81416' for example. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327517 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 database problem
Ah yes... makes sense Charlie Griefer charlie.grie...@gmail.com 10/22/2009 2:34 PM Integer fields for zip codes can be problematic in the case of a zip code like 08817 (tends to strip off the leading zero). On Thu, Oct 22, 2009 at 11:35 AM, Timothy Laureska tlaure...@dhmh.state.md.us wrote: Is there any reason you're not using an integer field type of some sort? Douglas Brown mistobr...@gmail.com 10/22/2009 2:24 PM I'd need to see the datatype of the zipcode column as well as the content of the 'valid zipcode' variable before I could answer the question, but my guess would be that there's a discrepancy in datatype: '#validZipCode#' when it should be #validZipCode# or something like that. The datatype is nvarchar(5) the zipcode is just a simple US zipcode '81416' for example. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327518 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 database problem
I have a zipcode table that is driving me nuts... If I open query analyzer and say SELECT * FROM zip WHERE zipcode = 'valid zipcode' I get nothing back but if I say SELECT zipcode from zip I get all the zips back and the valid zipcode from the first query is listed in there. Why cannot I not get anything with a conditional statement in there? Thanks NEVERMIND!! I created a new table a loaded it with info and everything works fine. I guess it was corrupt or something. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Issues using CFHTTP
Thanks Barney, This definitely sent me down the right path. Appreciate the input. Thanks, Asaf ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327520 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 database problem
Yeah, an nvarchar(5) with a '81416' in the WHERE clause should work just fine! Glad you've found a working path. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
If stcXml.country.cities.xmlChildren is empty, then the first pass at index=1 would be invalid. Can you verify that the the XML has at least 1 cities child? I do need to verify it, but if stcXml.country.cities.xmlChildren was empty wouldn't the cfloop be equivalent to: cfloop index=i from=1 to=0 In that case the contents of the loop wouldn't execute at all, would they? I also doubt scoping. i is not declared outside the cfthread tag. Even if it was cfthread performs a deep copy of all parent thread variables; meaning they are held in different memory than the other thread 'copies' (or parent) and at that point are independent of each other. Also, all variables declared inside the thread are scoped independently (I could declare soupTaNuts inside a dozen threads and each one would occupy its own memory). ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
Did you add some debugging? What is the value of i and the array length XMLChildren when the error occurs? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
@Matthew, Good call on the from=1 to=0 ... you're right that it wouldn't execute at all ... hm ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
Did you add some debugging? What is the value of i and the array length XMLChildren when the error occurs? So the bizarre thing is a test page, like below, does not process the contents of the loop: Hello - Startbr / cfloop index=i from=1 to=0 Howdy-Do Dah! cfoutput#i#/cfoutputbr / /cfloop End However, changing the previous code example to: cfif StructKeyExists(stcXML.country,cities) cfif ArrayLen(stcXml.country.cities.xmlChildren) gt 0 cfloop index=i from=1 to=#ArrayLen(stcXml.country.cities.xmlChildren)# cfset CityData = stcXml.country.cities.xmlChildren[i] / cfsavecontent variable=STUFF'#CityData.url.xmlText#'/cfsavecontent cfset writeToFile(STUFF) / /cfloop /cfif /cfif --- appears to fix the problem. all I can say is wtf? this is still happening even when I limit the processing to one spawned thread - so there isn't another child thread competing against it; just a parent waiting for the child to finish processing with a cfthread action=join statement. Now that that error is handled I'm getting GC overhead limit exceeded (java.lang.OutOfMemoryError) while parsing the larger file (approx 187MB). I'm reading in the xml one line at a time, suppressing whitespace anywhere I can (so as not to add to the cfthread[#mythread#] output total), etc. Ugh. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
Sounds like it may just be trying to load the entire 187 MB into memory and choking on that? Perhaps overall memory usage is the real issue and the OutOfBounds message is only a false report of a problem related to empty memory spaces. Good luck debugging that! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
However, changing the previous code example to: cfif ArrayLen(stcXml.country.cities.xmlChildren) gt 0 ... appears to fix the problem. all I can say is wtf? Weird. That is like saying zero does not equal 0 anymore. Maybe there is something special about the XMLChildren array? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
Ah, Leigh may be on to it: If the XML is blank or even if just the 'country' element is empty, than 0 is still 0, but 0 can't be determined, since 'cities' wouldn't even exist in the arrayLen(stcXml.country.cities.xmlChildren) test is 'country' is empty. That would be why your new first test (cfif StructKeyExists(stcXML.country, cities) ) is the key ... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327528 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 to display LARGE amounts of Data in a Timely Fashion
Your problem is probably render time, which makes sense if you have a ton of data coming out in a table layout. What you can do is remove as many of the tables as possible, especially for any layout stuff, headers, footers and the like. If you wrap the entire contents of the page in a table, your page has to finish downloading and then figure out how to render, which takes time. You can streamline this process by using CSS to lay your page out. Another thing, and probably the best increase, is if you use a fixed table layout (table-layout:fixed; in CSS). That will render your table with the same dimensions as your first table row, thus forcing the rest of the rows to fall in line. With that set, the browser doesn't have to download the whole table to start rendering it, it renders as it downloads. Another trick that I see around lately is the automatic scroll loading (don't know the official term). The idea is that once someone reaches the bottom of a page of data, more data loads, so you never really reach the bottom until the data has all been loaded. Google Reader was one of the first big sites to do this, but now it's more common. With this trick, you only need to load a couple pagefuls of data at a time. Consider that last one, sure, but DO those first two, for real. nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] On Wed, Oct 21, 2009 at 8:22 PM, Rick Colman rcol...@cox.net wrote: I need to query, retrieve and display a large amount of data; i.e. 4100 rows by 50 columns of numerics, to the browser screen. It is really slow, and after some testing, the bottleneck seems to be on the page that displays the data. The query is OK and connection is ok. But, the user has to wait an unacceptably long time for the results to show. Ideally, I would like to break the returned data into about 10 spreadsheet-style grids, with one grid per tab. TABLES is way too slow. Any ideas on how to render the displayed data quickly would be appreciated. Rick. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT Browser based FTP clients using SFTP
I'm just polling the general intelligence of this group. Can any built in FTP clients that exist in most (if not all) modern browsers communicate with SFTP servers using SSL? I was asked a high level question about a client using a browser to FTP content to a server over SSL. My first reaction was that the browser FTP clients probably don't do SFTP, but then I thought about it more and then thought that maybe they do. My first forary into Google searches yeilded no immediate answer one way or the other and I am hoping to know more before the meeting to discuss this in twenty minutes (2 pm PST). TIA Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
Sounds like it may just be trying to load the entire 187 MB into memory No. My initial approach was to attempt to load the entire file. Obviously, that would consume a lot of memory and cause problems. Instead, I'm using the cfloop file= process to load one line of xml into memory at a time for processing (thankfully each child element of the parent exists on its own unique line). Reading http://forums.adobe.com/thread/43968 makes it seem as if the GCOverheadLimit error is being thrown because the java garbage collector is taking to long to clean up memory; this is consistent with the behavior I have seen. If I load up multiple files to be simultaneously processed (with parallel threads) the smaller files finish fine but the filesize for the large file outputs slows to a crawl the closer jrun.exe gets to the maximum heap size. Finally the GCOverheadLimit error is thrown, the cfthread action=join ops runs, and I see the dumped error. It's as if the garbage collector can't effectively clean up memory allocated to threaded processes; or at least can't release it until all threads are joined together? Belch. I had so much hope for the parallel processing but it just seems to be obscuring and creating more problems than if I just did a straightforward, linear processing of files. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Anyway to disable CF FORM FIELD Validation?
I have forms that have _required and similar field names. I do NOT want to use the build in Form Validation. Is there any way to disable it? I would be happy to disable it completely for the entire server. Is it possible? I poked around in the config files but found nothing. Brook D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyway to disable CF FORM FIELD Validation?
use form instead of cfform? On Thu, Oct 22, 2009 at 2:12 PM, Brook Davies cft...@logiforms.com wrote: I have forms that have _required and similar field names. I do NOT want to use the build in Form Validation. Is there any way to disable it? I would be happy to disable it completely for the entire server. Is it possible? I poked around in the config files but found nothing. Brook D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyway to disable CF FORM FIELD Validation?
Sure. Include a script that removes that attribute from any form field. You can use a custom tag in your application.cfc that inserts this script onrequest(). Pass some code and maybe we can test it out a little. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
But before you can use CFLOOP the file had to be read into memory ... something had to be there for CFLOOP to take action *on* ... Matthew Reinbold wrote: Sounds like it may just be trying to load the entire 187 MB into memory No. My initial approach was to attempt to load the entire file. Obviously, that would consume a lot of memory and cause problems. Instead, I'm using the cfloop file= process to load one line of xml into memory at a time for processing (thankfully each child element of the parent exists on its own unique line). ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
Well, that clinches it. The *exact* same code with the threading pulled out (so now the xml files are processed sequentially, not parallel) and the memory problems disappear (the crude method of watching the memory allocation in windows task manager shows a slight uptick, but no where near to hitting the wall of the java heap size). On a whim I also pulled out the extra check for the xmlChildren size. Guess what? The unexplainable indexing error is gone now too. Of course, processing things will take longer - one file has to wait for the other to finish. But considering I've wasted a day chasing unexplainable ghost problems caused by threading, I'll have to figure out some other processing method to speed things up. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyway to disable CF FORM FIELD Validation?
This works for any input in CF8: script $(document).ready(function(){ $(input).each(function(){ var inptname = $(this).attr(name); $(input[name=+inptname+_CFFORMREQUIRED]).remove(); }); }); /script TEST CASE (TRY IT WITH SCRIPT AND WITHOUT AND WATCH WHAT HAPPENS) cfform name=test cfinput type=text required=yes name=testvar validateat=onserver cfinput type=checkbox required=yes validateat=onserver name=testagain /cfform Drop the script in a custom tag and call it onrequest and you're good to go! There is a hidden field needed to validate the field. Remove that hidden input with some JQuery and no more validation! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
But before you can use CFLOOP the file had to be read into memory ... No, that is not how the cfloop file= row= / tag works. Using that syntax a person processes one line at a time. See this post (under Step 3 main header starting with 1. Reading Lines): http://coldfused.blogspot.com/2007/07/new-file-io-in-coldfusion-8.html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: ajaxCFC/JavaScript/dynamic forms
Hi All, I'm not the best when it comes to JavaScript and I've got a question about forms that are created in a CFC method and then passed back to the client to be displayed in a DIV (meant to look like a pop-up). SCENARIO: - 1) JS function is included when page is rendered and references a form that does not yet exist. 2) User clicks a button which fires an AJAX call to create an HTML string and passes it back to the client to be displayed in a hidden DIV (which is then made visible). The HTML string includes the form tags to define the form that the JS function mentioned above references along with some form prompts. 3) User enters some stuff in the form prompts and then clicks a button to submit. That submit calls the function mentioned in number 1 above. In that call I use jQuery to serialize the form. - Now if I use jQuery (which I'm quite new to as well) to serialize a form that exists at the time the page renders, everything works correctly. If I do it as outlined in the scenario above, my AJAX calls fail. From what I can tell it is because the dynamically created and added form does NOT seem to be seen and thus the serialization of it fails (essentially I think it doesn't see the form and produces a blank string). I'm pretty sure I have figured out what's happening, but I have no idea how to solve it. Any ideas? Thanks a bunch in advance!! Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: ajaxCFC/JavaScript/dynamic forms
Generally when I want to return HTML, I use the JQuery load() function. When I want to return a data set in JSON: array or query object, return a boolean value or a single vfalue I use ColdFusion's native CFAJAXPROXY. I suggest returning the form using load(), which then will fix your issue. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ExpandPath() Returns java.lang.NullPointerException When Run As Scheduled Task?
I'm guessing you're using the default webserver root mapping / -- it's possible that adding a /images mapping might resolve the issue I was relying on the webserver (IIS) default mapping for the '/images' directory. Adding an '/images' logical map in the coldfusion administrator that pointed to the same directory seems to have fixed things when the operation is run as a scheduled task. Thanks! -Matthew Reinbold Creative Principal, Vox Pop Design, http://voxpopdesign.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Flex2gateway not accessible
All, http://[servername]/flex2gateway comes back with error 404. My setup is Coldfusion on JRun integrated with IIS. have tried a bunch of suggestions from the web but nothing seems to be working. Please help Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: ajaxCFC/JavaScript/dynamic forms
Thanks for the quick reply Tony! I should note that I am NOT currently using jQuery with my AJAX calls except for serializing the form. I'm also doing this with openBD where CFAJAXPROXY was a bit off lat time I tested it (but as you said...that's for the simple stuff). Do you have a code snippet on the usage of the load() function? or somewhere to point me so I can RTFM ;-) TIA Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Flex2gateway not accessible
If you wouldn't mind, could you tell us what you've tried so far. I've had luck in the past by running ColdFusion8\bin\connectors\Remove_ALL_connectors.bat and then ColdFusion8\bin\connectors\IIS_connector.bat ~Brad Original Message Subject: Flex2gateway not accessible From: Agha Mehdi aghaime...@gmail.com Date: Thu, October 22, 2009 5:01 pm To: cf-talk cf-talk@houseoffusion.com All, http://[servername]/flex2gateway comes back with error 404. My setup is Coldfusion on JRun integrated with IIS. have tried a bunch of suggestions from the web but nothing seems to be working. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyway to disable CF FORM FIELD Validation?
CF9 allows you to disable it with a This scope variable. On Thu, Oct 22, 2009 at 4:36 PM, Tony Bentley t...@tonybentley.com wrote: This works for any input in CF8: script $(document).ready(function(){ $(input).each(function(){ var inptname = $(this).attr(name); $(input[name=+inptname+_CFFORMREQUIRED]).remove(); }); }); /script TEST CASE (TRY IT WITH SCRIPT AND WITHOUT AND WATCH WHAT HAPPENS) cfform name=test cfinput type=text required=yes name=testvar validateat=onserver cfinput type=checkbox required=yes validateat ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help with lists and query
Sorry for all the posts on here but I only post after digging through the WACK and not finding an answer. I have a custom tag that searches for zip codes within a specified radius and then spits the results out as a list. I want to be able to use that list to search a database of advertisements to only pull the ads that might be in the zip radius. Any thoughts as to what might be easiest? Thanks for the help... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: ajaxCFC/JavaScript/dynamic forms
PS...I have just noticed the ajaxCFC zip file contains the core folder AND the branches folder.and so now I've seen the jQuery branch ;-) I bet the solutions to many of my issues questions reside in there!! ;-) - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: ajaxCFC/JavaScript/dynamic forms
There are plenty of examples online. Check the jQuery docs. I can only advise that when using load, you will need to pass all of your parameters using a URL string, which will limit what you can pass to the posting page. I also suggest passing a timestamp so the browser never caches the results. You can even use a CFC as your page to load. You would do something like this: $(#mydiv).load(/cfc/mycfc.cfc?method=getformid=+firstval+user=+secondval+ts=+gettime(),function(){//run stuff when the div is finished loading}); ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flex2gateway not accessible
- added JRunScripts virtual directory under IIS pointed to C:\JRun4\lib\wsconfig\2. - created a folder (flex2gateway) below the web root. Didn't think it would work. I could not find the connectors .bat files under JRun so not sure how to do that Thanks On Thu, Oct 22, 2009 at 3:08 PM, b...@bradwood.com wrote: If you wouldn't mind, could you tell us what you've tried so far. I've had luck in the past by running ColdFusion8\bin\connectors\Remove_ALL_connectors.bat and then ColdFusion8\bin\connectors\IIS_connector.bat ~Brad Original Message Subject: Flex2gateway not accessible From: Agha Mehdi aghaime...@gmail.com Date: Thu, October 22, 2009 5:01 pm To: cf-talk cf-talk@houseoffusion.com All, http://[servername]/flex2gateway comes back with error 404. My setup is Coldfusion on JRun integrated with IIS. have tried a bunch of suggestions from the web but nothing seems to be working. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyway to disable CF FORM FIELD Validation?
That is very nice! Thanks Ray. So yeah, upgrade to CF9 hahaha. CF9 allows you to disable it with a This scope variable. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: ajaxCFC/JavaScript/dynamic forms
Thanks again Tony! So to make sure I'm barking up the right tree load() is intended to (sorry for lack of a the proper technical term) make a form visible to JS if the form was added to the page after it initially loads (i.e. retrieved the HTML string containing the form from an ajax call to a method in a CFC)? Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: java.lang.IndexOutOfBoundsException on XML Struct?
... On a whim I also pulled out the extra check for the xmlChildren size. Guess what? The unexplainable indexing error is gone now too. If you can consistently reproduce it, I would consider reporting it as a bug. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help with lists and query
Check out http://www.w3schools.com/SQl/sql_in.asp On Thu, Oct 22, 2009 at 5:16 PM, Douglas Brown mistobr...@gmail.com wrote: Sorry for all the posts on here but I only post after digging through the WACK and not finding an answer. I have a custom tag that searches for zip codes within a specified radius and then spits the results out as a list. I want to be able to use that list to search a database of advertisements to only pull the ads that might be in the zip radius. Any thoughts as to what might be easiest? Thanks for the help... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Flex2gateway not accessible
added JRunScripts virtual directory under IIS pointed to C:\JRun4\lib\wsconfig\2. I'm not sure what that would do. Where did you get that one from? created a folder (flex2gateway) below the web root. Didn't think it would work. You certainly don't want to do that. There is no folder called flex2gateway, but if you look in your web.xml there should be a servlet mapping for /flex2gateway/* that maps to the MessageBrokerServlet servlet. I could not find the connectors .bat files under JRun so not sure how to do that Hmm, I don't a multi-server install in front of me right now to look at. You could try using the Web Server Configuration Tool to manually remove and add your web server connectors. I don't know if it will work, but it's worth a try. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Verity mixing up catalogs
I've got a really strange issue happening at random on one of our servers with verity. To paraphrase the situation, we have two catalog defined per site and they are named sitename_site and sitename_jobs. The catalog ending in _site has an alphanumeric key and the catalog ending in _jobs uses a numeric key. What we're seeing is that after a while, queries to the _jobs catalog starts returning data from the _site catalog and throwing data type errors because we're expecting a numeric key and we're getting an alpha-numeric key. The only way we can resolve the problem appears to be to delete and re-create the _jobs catalog but ideally I'd like to get to the bottom of why Verity is getting the catalogs mixed up in the first place. Any ideas or hints of where I should be looking would be much appreciated. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ajaxCFC/JavaScript/dynamic forms
Hi, Bryan... Are you using the .live functionality (jQuery 1.3 and above) or the .livequery method for links, buttons, etc., that are added to the DOM? Rick -Original Message- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Thursday, October 22, 2009 5:45 PM To: cf-talk Subject: SOT: ajaxCFC/JavaScript/dynamic forms Hi All, I'm not the best when it comes to JavaScript and I've got a question about forms that are created in a CFC method and then passed back to the client to be displayed in a DIV (meant to look like a pop-up). SCENARIO: - 1) JS function is included when page is rendered and references a form that does not yet exist. 2) User clicks a button which fires an AJAX call to create an HTML string and passes it back to the client to be displayed in a hidden DIV (which is then made visible). The HTML string includes the form tags to define the form that the JS function mentioned above references along with some form prompts. 3) User enters some stuff in the form prompts and then clicks a button to submit. That submit calls the function mentioned in number 1 above. In that call I use jQuery to serialize the form. - Now if I use jQuery (which I'm quite new to as well) to serialize a form that exists at the time the page renders, everything works correctly. If I do it as outlined in the scenario above, my AJAX calls fail. From what I can tell it is because the dynamically created and added form does NOT seem to be seen and thus the serialization of it fails (essentially I think it doesn't see the form and produces a blank string). I'm pretty sure I have figured out what's happening, but I have no idea how to solve it. Any ideas? Thanks a bunch in advance!! Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SOT: ajaxCFC/JavaScript/dynamic forms
Hi, Bryan... I'm not sure if you saw my reply to your original post, but my question was are you using the .live or .livequery functions for any links, buttons, etc., that are added to the DOM via AJAX? (Load, in your case) Rick -Original Message- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Thursday, October 22, 2009 6:55 PM To: cf-talk Subject: Re: SOT: ajaxCFC/JavaScript/dynamic forms Thanks again Tony! So to make sure I'm barking up the right tree load() is intended to (sorry for lack of a the proper technical term) make a form visible to JS if the form was added to the page after it initially loads (i.e. retrieved the HTML string containing the form from an ajax call to a method in a CFC)? Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flex2gateway not accessible
recreating the connector using wsconfig did it. Thanks a bunch. Still don't know why you have to recreate it but it's one of those things where you don't complain when it starts to work :) Thanks again. On Thu, Oct 22, 2009 at 4:33 PM, b...@bradwood.com wrote: added JRunScripts virtual directory under IIS pointed to C:\JRun4\lib\wsconfig\2. I'm not sure what that would do. Where did you get that one from? created a folder (flex2gateway) below the web root. Didn't think it would work. You certainly don't want to do that. There is no folder called flex2gateway, but if you look in your web.xml there should be a servlet mapping for /flex2gateway/* that maps to the MessageBrokerServlet servlet. I could not find the connectors .bat files under JRun so not sure how to do that Hmm, I don't a multi-server install in front of me right now to look at. You could try using the Web Server Configuration Tool to manually remove and add your web server connectors. I don't know if it will work, but it's worth a try. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327558 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 JSON Grid | ColdExt
People is my query passing by being unread :s -- From: Arsalan Tariq Keen arsalk...@hotmail.com Sent: Thursday, October 22, 2009 2:04 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Problem with JSON Grid | ColdExt Come on guys... I need your help. I am including the code in the email body. This code is from the sample documents of ColdExt. My problem is, I am trying to display a grid inside a Ext.window. The grid has a search box in its toolbar. This grid never shows up at all and gives the following error in FireBug: Ext.ux.grid is undefined http://127.0.0.1:/ext/ext-all.js Line 305 if I remove the searchbox code from my pages, then the grid displays properly inside the Ext.window. Test.cfm - the page that contains script for opening window that will contain the grid Test2.cfm - the page which contains the grid display code. - ** Test.cfm ** - !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleTesting Derby with Railo CF/title link href=cfoutput#application.cssURL#/cfoutput rel=stylesheet type=text/css / cfimport prefix=ext taglib=../coldext /head body ext:onReady ext:script var new_supplier = new Ext.Window({ closable: true, closeAction: 'close', draggable: true, resizable: false, title: 'Add New Supplier', autoLoad: {url: 'test2.cfm', scripts: true, text: 'Loading data ...' }, collapsible: true, maximizable: false, modal: true, width: 614, height: 280, autoScroll: true, iconCls: 'icon-form', deferredRender: true, scripts: true }); new_supplier.show(); /ext:script /ext:onReady /body /html - * Test2.cfm * - cfimport prefix=ext taglib=../coldext cfimport prefix=ux taglib=../coldext/ux !--- all examples will be appended to this div --- div id=grid11-out class=output h2Grid Search user extension/h2 /div ext:onReady ext:jsonStore var=myJSON autoLoad=true remoteSort=true root=query.data totalProperty=totalcount url=http://127.0.0.1:/docs/demos/data/countries.cfm; ext:field name=id / ext:field name=country / ext:field name=capital / ext:field name=continent / ext:param name=limit value=10 / /ext:jsonStore !--- simple example --- ux:gridSearch var=mySearch width=150 / !--- alternative example --- !--- use position=top AND explicitly define a top toolbar in the gridPanel --- !--- ux:gridSearch var=mySearch position=top width=150 / --- ext:gridPanel renderTo=grid11-out title=JSON Grid width=600 height=287 stripeRows=true plugins=mySearch store=myJSON !--- alternative example --- !--- ext:toolbarext:toolbarFill/ext:toolbar --- ext:gridColumn header=ID width=40 sortable=true dataIndex=id / ext:gridColumn id=country header=Country width=150 sortable=true dataIndex=country / ext:gridColumn header=Capital width=245 sortable=true dataIndex=capital / ext:gridColumn header=Continent width=160 sortable=true dataIndex=continent / ext:pagingToolbar displayInfo=true pageSize=10 store=myJSON / /ext:gridPanel /ext:onReady Regards, Arsalan -- From: Arsalan Tariq Keen arsalk...@hotmail.com Sent: Tuesday, October 20, 2009 8:05 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Problem with JSON Grid | ColdExt no ... its not online... actually I am developing this software for my client. Any other possible ways? -- From: Raymond Camden rcam...@gmail.com Sent: Tuesday, October 20, 2009 7:34 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Problem with JSON Grid | ColdExt You've got me now - is this online where we can all look? On Mon, Oct 19, 2009 at 9:59 PM, Arsalan Tariq Keen arsalk...@hotmail.com wrote: Well... I tried the same pages in IE7 and there it is showing two browser errors. 1. 'Ext.ux.grid.Search' is null or not an object 2. Could not complete the operation due to Error 80020101 please help me with this, I am running real
Re: Help with lists and query
Once you have a list, you can do the following directly in the database clause: WHERE zipCode IN ( cfqueryparam cf_sql_type=cf_sql_varchar value=#zipList# list=true / ) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anyway to disable CF FORM FIELD Validation?
I am not using CFFORM, the validation happens regardless. If you submit a form and there is a hidden field named XXX_required, CF shows the default form validation message. Brook -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: October-22-09 2:25 PM To: cf-talk Subject: Re: Anyway to disable CF FORM FIELD Validation? use form instead of cfform? On Thu, Oct 22, 2009 at 2:12 PM, Brook Davies cft...@logiforms.com wrote: I have forms that have _required and similar field names. I do NOT want to use the build in Form Validation. Is there any way to disable it? I would be happy to disable it completely for the entire server. Is it possible? I poked around in the config files but found nothing. Brook D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anyway to disable CF FORM FIELD Validation?
So there is no way to disable this behaviour in CF8? -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: October-22-09 3:19 PM To: cf-talk Subject: Re: Anyway to disable CF FORM FIELD Validation? CF9 allows you to disable it with a This scope variable. On Thu, Oct 22, 2009 at 4:36 PM, Tony Bentley t...@tonybentley.com wrote: This works for any input in CF8: script $(document).ready(function(){ $(input).each(function(){ var inptname = $(this).attr(name); $(input[name=+inptname+_CFFORMREQUIRED]).remove(); }); }); /script TEST CASE (TRY IT WITH SCRIPT AND WITHOUT AND WATCH WHAT HAPPENS) cfform name=test cfinput type=text required=yes name=testvar validateat=onserver cfinput type=checkbox required=yes validateat ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyway to disable CF FORM FIELD Validation?
Can you change the form field name(s)? On Thu, Oct 22, 2009 at 11:37 PM, Brook Davies cft...@logiforms.com wrote: I am not using CFFORM, the validation happens regardless. If you submit a form and there is a hidden field named XXX_required, CF shows the default form validation message. Brook -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: October-22-09 2:25 PM To: cf-talk Subject: Re: Anyway to disable CF FORM FIELD Validation? use form instead of cfform? On Thu, Oct 22, 2009 at 2:12 PM, Brook Davies cft...@logiforms.com wrote: I have forms that have _required and similar field names. I do NOT want to use the build in Form Validation. Is there any way to disable it? I would be happy to disable it completely for the entire server. Is it possible? I poked around in the config files but found nothing. Brook D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyway to disable CF FORM FIELD Validation?
Yes there is . The CFFORM tag has an attibute SCRIPTSRC. Normally it defaults to the location of your CFIDE so it's not necessary to specifiy it in your CFFORM tag. But if you dont want to use the default scripts, you can put your own somewhere and then spell out the CFFORM tag like so: cfform scriptsrc=/forms/myscripts action= . etc etc. then CFFORM will look in that location for the validation scripts and if it doesnt find them it cant use them. YOu can customise a lot of the CFFORM behaviour that way, or as in the case of one of my clients, he's not allowed to use the server scripts, so we copy up the whole of the CFIDE form directory and use the SCRIPTSRC to point to them that way. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Oct 23, 2009 at 2:39 PM, Brook Davies cft...@logiforms.com wrote: So there is no way to disable this behaviour in CF8? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyway to disable CF FORM FIELD Validation?
Gotcha... Sorry, I thought you meant the client side validation. On Thu, Oct 22, 2009 at 8:37 PM, Brook Davies cft...@logiforms.com wrote: I am not using CFFORM, the validation happens regardless. If you submit a form and there is a hidden field named XXX_required, CF shows the default form validation message. Brook -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: October-22-09 2:25 PM To: cf-talk Subject: Re: Anyway to disable CF FORM FIELD Validation? use form instead of cfform? On Thu, Oct 22, 2009 at 2:12 PM, Brook Davies cft...@logiforms.com wrote: I have forms that have _required and similar field names. I do NOT want to use the build in Form Validation. Is there any way to disable it? I would be happy to disable it completely for the entire server. Is it possible? I poked around in the config files but found nothing. Brook D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4