Flash, XML CF 7
Now that I've scared away 3/4 of the list... I've got an issue. I've got a Flash app (I'm not the developer of the app, but working closely with him) that reads an XML file from the file system, modifies it, and posts to my CF page, which does some work (basically updating the DB) and writes out a new XML file and then goes back to the Flash app. page. My CF page writes out the data with CDATA tags in the appropriate areas. When my XML file has illegal XML characters going into the Flash app, on the post back out I get a 500 NULL error. If I type the illegal characters into the Flash app and write it out, all is well. To be further confusing, I've captured the XML that is being posted on the 500 NULL page, copied into a text file, and had CF read it and try to parse it, and you guessed it, no errors. There are no CDATA tags in the posted XML, but and single quotes are escaped (amp; apos;, etc.). This is what I found in the CFusionMX7\runtime\logs\coldfusion-err.log: 06/29 03:40:17 error java.lang.IllegalArgumentException at coldfusion.filter.FormScope.parseQueryString(FormScope.java:283) at coldfusion.filter.FormScope.parsePostData(FormScope.java:255) at coldfusion.filter.FormScope.fillForm(FormScope.java:206) at coldfusion.filter.FusionContext.SymTab_initForRequest(FusionContext.java:384) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:33) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) This is driving me nuts. I really don't want to hack a PHP or ASP file into my CF app to get this working. Anybody out there have any ideas? Thanks, Michael __ Information from ESET NOD32 Antivirus, version of virus signature database 4194 (20090628) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.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:324038 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flash, XML CF 7
What's in the query string of the POST in the Flash app? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/6/29 Michael Reick mich...@widgethq.com: Now that I've scared away 3/4 of the list... I've got an issue. I've got a Flash app (I'm not the developer of the app, but working closely with him) that reads an XML file from the file system, modifies it, and posts to my CF page, which does some work (basically updating the DB) and writes out a new XML file and then goes back to the Flash app. page. ... 06/29 03:40:17 error java.lang.IllegalArgumentException at coldfusion.filter.FormScope.parseQueryString(FormScope.java:2 ~| 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:324039 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flash, XML CF 7
I've got an issue. I've got a Flash app (I'm not the developer of the app, but working closely with him) that reads an XML file from the file system, modifies it, and posts to my CF page, which does some work (basically updating the DB) and writes out a new XML file and then goes back to the Flash app. page. My CF page writes out the data with CDATA tags in the appropriate areas. When my XML file has illegal XML characters going into the Flash app, on the post back out I get a 500 NULL error. If I type the illegal characters into the Flash app and write it out, all is well. To be further confusing, I've captured the XML that is being posted on the 500 NULL page, copied into a text file, and had CF read it and try to parse it, and you guessed it, no errors. When you save the text file, what encoding do you use? When you submit the form data, what encoding do you use? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more informati ~| 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:324040 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Second bind parameter fails to invoke the Ajax routine
I have a strange one. The documentation says that you can have multiple bind parameters but for some reason the second one I use fails to trigger the routine. When I reverse them the same occurs. I'm 100% sure because the template I call right now does nothing but a cfdump var=#URL# and it shows all the values, but only refreshes on a change to the first bind parameter (regardless of which order I use). Here's my Ajax calling sequence: cfdiv ID=U bindonload=Yes bind=url:PreLotteryGuestCount.cfm?Primary={Primary}guest={guest.chec...@click} / The form this occurs in has a radio button named Primary and a checkbox named Guest. Do I misunderstand the syntax that is allowed? How can I get it to trigger on changes in either field? ~| 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:324041 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Finding tables in MS Access database
I have some code that will take a .MDB file from the client upload it to a directory and create a data source within ColdFusion. My problem is I have to find the first table within that database. I have tried the below query but keep getting a database error. cfquery datasource=myDatasource name=GetTables SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Flags = 0 AND MSysObjects.Type = 1 ORDER BY MSysObjects.Name /cfquery ~| 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:324042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
jquery: Pager, MaXrows
ok.. i am using the jquery pager for pagnation. my problem, is under one way a user can get to the result set i can have over 2400 results. but my pager will only show 100 max at a time. but the page loads slowly due to all the returned rows.. how could i use maxrows to limit the result set, but say grab the next 100 or 500 records? cfquery name=get_it datasource=#request.dsn# Select * From tbl_it cfifbunch of nasty stuff/cfif /cfquery !--- Start Page Numbers --- div id=pager class=pager form img src=/common/jquery/images/first.png class=first/ img src=/common/jquery/images/prev.png class=prev/ input type=text class=pagedisplay/ img src=/common/jquery/images/next.png class=next/ img src=/common/jquery/images/last.png class=last/ select class=pagesize option value=1010/option option selected=selected value=2525/option option value=5050/option option value=100100/option /select /form /div !--- END Page Numbers --- cfif get_it.recordcount gt 0 cfoutputstuff here cfloop query=get_it more stuff /cfloop /cfoutput /cfif ~| 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:324043 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Finding tables in MS Access database
In order to query MSysObjects you must have some permissions set in the security settings of the database. If you have CF 8, you should also be able to use CFdbInfo. Otherwise, there is still CFX_ODBCinfo: http://customtags.internetique.com/ODBCInfo/E/TestODBCInfo.cfm which is not free, but which works on any ODBC datasource under Windows and under CF 8, 7, 6, 5, 4, and may be even lower. ~| 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:324044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Inventory Management System
Guys, Is there any Open source Inventory Management System available in ColdFusion or does any one has any experience with Inventory Management Systems, who could give me guidelines or some links to better understand how to implement a nice workabble Inventory Management System? Regards, Arsalan ~| 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:324045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: alternative to cfwindow
Yes, with Ext it's fairly easy: var calWin = new Ext.Window({ title: 'Calendar', contentEl: 'calendarDiv', // This is a hidden div (class=x-hidden) on the page, containing your calendar width: 200, height: 200, modal: true, border: true }); calWin.show(); Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.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:324046 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inventory Management System
The phrase inventory management has multiple meanings. You could have an inventory of computer equipment, an inventory of software licenses, and inventory of books in a library, an inventory of products for sale at a store, etc. You might want to clarify. Have you checked RiaForge.org? -Mike Chabot On Mon, Jun 29, 2009 at 11:41 AM, Arsalan Tariq Keenarsalk...@hotmail.com wrote: Guys, Is there any Open source Inventory Management System available in ColdFusion or does any one has any experience with Inventory Management Systems, who could give me guidelines or some links to better understand how to implement a nice workabble Inventory Management System? Regards, Arsalan ~| 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:324047 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: alternative to cfwindow
Thanks, Cutter, I need to go a step above that with Ext. What I'd like to do is: launch two windows (one main with attribute show=true and the other small one with attribute show=false) then upon certain event or its trigger, send one form element to the small window (its underlying cf script), then, run a query, change the attribute show to true and display data while main window stays open, so the small window sort is floating over the main one. Easy to do with cf8 but haven't found helpful resources to do the same with EXT. Currently I'm using ColdExt for window management, the starter question is, how to create an Ext js function similar to cf8's ColdFusion.navigate, which would submit the form, and then, I could reference the var for the small window and use the Ext method of show to display it, like varSmallWin.show(); Or alternatively, lauch main window, upon an event trigger launch the small window and send a form element to the small win and have it float over the main window. Much appreciated. Don ~| 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:324048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inventory Management System
yes I did check RiaForge.org but couldn't find anything useful. I basically have to work on an inventory management system, the idea is simple... a Warehouse which is used to kept equipment stock ... then requests are made for shipment either to or from the warehouse does it clear the vagueness? :) -- From: Mike Chabot mcha...@gmail.com Sent: Tuesday, June 30, 2009 12:19 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Inventory Management System The phrase inventory management has multiple meanings. You could have an inventory of computer equipment, an inventory of software licenses, and inventory of books in a library, an inventory of products for sale at a store, etc. You might want to clarify. Have you checked RiaForge.org? -Mike Chabot On Mon, Jun 29, 2009 at 11:41 AM, Arsalan Tariq Keenarsalk...@hotmail.com wrote: Guys, Is there any Open source Inventory Management System available in ColdFusion or does any one has any experience with Inventory Management Systems, who could give me guidelines or some links to better understand how to implement a nice workabble Inventory Management System? Regards, Arsalan ~| 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:324049 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inventory Management System
Arsalan Tariq Keen arsalk...@hotmail.com wrote: yes I did check RiaForge.org but couldn't find anything useful. I basically have to work on an inventory management system, the idea is simple... a Warehouse which is used to kept equipment stock ... then requests are made for shipment either to or from the warehouse I have written a number of inventory-transaction systems over the years. I am not aware of an open source CF solution. It is usually straight forward in that you have a table of inventory records and a table for transactions. After that, you can make it as complicated as you like. You can get into details like status, reporting, etc. A lot of the inventory-transaction control system complexity comes from the actual, physical procedures issues, not the database design. I would suggest you really do a lot of upfront analysis of the processes before you start looking at the design. Also, keep the end users in the team if you can since they sometimes have hidden processes that you will find out about after you have done a lot of initial design. Good luck, Roger ~| 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:324050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inventory Management System
It still isn't clear whether you are talking about an e-commerce store where you ship products to customers or something more like a company stock room. Regardless, I agree with Roger and I'm also unaware of anything in the CF world that you can download that would meet your needs. It is hard to answer your question without knowing what the requirements are. Most inventory management systems I have seen are specific to what is in the inventory, such as a computer equipment inventory system, or a book inventory system. Both MS Excel and MS Access have free inventory management templates. A pen and paper attached to a clipboard is a great inventory management system in some situations. -Mike Chabot On Mon, Jun 29, 2009 at 3:04 PM, Roger Austinraust...@nc.rr.com wrote: Arsalan Tariq Keen arsalk...@hotmail.com wrote: yes I did check RiaForge.org but couldn't find anything useful. I basically have to work on an inventory management system, the idea is simple... a Warehouse which is used to kept equipment stock ... then requests are made for shipment either to or from the warehouse I have written a number of inventory-transaction systems over the years. I am not aware of an open source CF solution. It is usually straight forward in that you have a table of inventory records and a table for transactions. After that, you can make it as complicated as you like. You can get into details like status, reporting, etc. A lot of the inventory-transaction control system complexity comes from the actual, physical procedures issues, not the database design. I would suggest you really do a lot of upfront analysis of the processes before you start looking at the design. Also, keep the end users in the team if you can since they sometimes have hidden processes that you will find out about after you have done a lot of initial design. Good luck, Roger ~| 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:324051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inventory Management System
does it clear the vagueness? Hmmm I hardly imagine an inventory system which is not part of some product management system. In order to make an inventory, you need a list of products. So what you are looking for is rather some store or warehouse management system. If you already have one, but with no inventory system, then you better design your own, you'll never find one compatible with your system. ~| 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:324052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Inspecting a digital certificate (programmatically)
Hi folks, I've got the need to programmatically inspect a digital certificate for certain things (has it been revoked, has it expired, who is the issuer, etc.), but I don't know how to get a handle on the certificate in order to check these things. I've been googling and trying various things for a couple of days now, but I'm not really getting anywhere. The best I've come up with is that I may need to use classes in java.security.cert, but I don't know how to use them. I've looked up the docs on them, but they're not helping too much. Has anyone ever had to do this? How does one go about downloading a digital certificate in order to inspect it? I kinda thought that if I did a cfhttp GET request, that I might get the certificate back to verify amongst the variables returned by cfhttp, but that didn't appear to be the case. I'm really, really stuck and could use any help I can get. :o( Thanks, Chris ~| 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:324053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flash, XML CF 7
I can't seem to post from email or website (CF Error on website), so let's try stripping everything out... To James: The query string as in edit_movie.cfm?doEdit=yes Or the Post information like so: Content-type: application/x-www-form-urlencoded Content-length: 2478 To Dave: The form submit is Content-type: application/x-www-form-urlencoded When I save out the posted xml file, I just save it with a text editor. I have no idea what that encoding is. If either of you want, I'll post the actual XML. Thanks, Michael __ Information from ESET NOD32 Antivirus, version of virus signature database 4197 (20090629) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.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:324054 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inventory Management System
Well people :) it is suppose to be an outsourced warehouse where we keep our products/equipment no e-commerce required :) I guess I should check ms-access/excel templates for ideas :) -- From: Mike Chabot mcha...@gmail.com Sent: Tuesday, June 30, 2009 2:51 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Inventory Management System It still isn't clear whether you are talking about an e-commerce store where you ship products to customers or something more like a company stock room. Regardless, I agree with Roger and I'm also unaware of anything in the CF world that you can download that would meet your needs. It is hard to answer your question without knowing what the requirements are. Most inventory management systems I have seen are specific to what is in the inventory, such as a computer equipment inventory system, or a book inventory system. Both MS Excel and MS Access have free inventory management templates. A pen and paper attached to a clipboard is a great inventory management system in some situations. -Mike Chabot On Mon, Jun 29, 2009 at 3:04 PM, Roger Austinraust...@nc.rr.com wrote: Arsalan Tariq Keen arsalk...@hotmail.com wrote: yes I did check RiaForge.org but couldn't find anything useful. I basically have to work on an inventory management system, the idea is simple... a Warehouse which is used to kept equipment stock ... then requests are made for shipment either to or from the warehouse I have written a number of inventory-transaction systems over the years. I am not aware of an open source CF solution. It is usually straight forward in that you have a table of inventory records and a table for transactions. After that, you can make it as complicated as you like. You can get into details like status, reporting, etc. A lot of the inventory-transaction control system complexity comes from the actual, physical procedures issues, not the database design. I would suggest you really do a lot of upfront analysis of the processes before you start looking at the design. Also, keep the end users in the team if you can since they sometimes have hidden processes that you will find out about after you have done a lot of initial design. Good luck, Roger ~| 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:324055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4