Re: Better random record generator
Thank you Dean for seeing my issue, and supplying a possible resolution. I agree access is not the best system out there, But I have applications with over 500,000 records in a single table that have been working with cold fusion of many years also. I agree I should migrate but that is not in my scope for this project right now. I will try that solution today and let you know. Thank You, Keith ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314392 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion, Verity and Files with extended characters in the filename
Hi, We're currently having an issue on Linux with Verity. We're using CF8 on Debian, ubuntu for dev, where a client has PDFs that need indexing but contain extended characters in the filename, in particular the registered symbol. On Linux this is not being indexed by the Verity engine, on Windows (Where we are migrating away from) these files are correctly indexed. Using CFDirectory and Java's listFiles() I can confirm that CF and Java both see the files correctly, a FileExists() also returns true, however when CFIndexing the paths I get the following: Error E3-0422 (VDK ): Could not find file /home/jedi/Dev/htdocs/jedi/verity/mypdf.pdf ( -- Including the extended char, CF-Talk won't accept the Base64 post) In the Messages section of the Status dump (the symbol is shown correctly) but in the bad keys section of the Status dump the character does not come out correctly. Has anyone come across this before and know of a fix/work around? Thanks in advance Jedi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314393 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: url rewrite question
Well, it turns out that ISAPI_Rewrite cannot do what I'm trying to do, because it would CHANGE the url. So we'll either go the subdomain route (easy) or the virtual directory route (a little more troublesome just because we'd have a site with thousands of virtual directories, and I'm not sure how well that would scale) Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314394 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problem with check box data binding in IE
I am new to data binding and have set up a page that refines a list of search terms based on a set of check boxes and radio buttons. The boxes and buttons are bound to a CFM that returns the results at the bottom of the page. This works fine in Firefox, but there is a problem in IE. After checking a check box in IE, I have to click on the page or check another box for the code to run, displaying my results. I've tested this on IE 6 and 7 and get the same result. The page is available for viewing from our development server at: http://rutile.igs.indiana.edu/geology/geologicNames/list2.cfm You may download a zip file containing the code using the following link: https://www.slashtmp.iu.edu/public/download.php?FILE=neaton/94fHJFyN Any idea how I can fix this? Thanks, Nathan Eaton Indiana Geological Survey Indiana University ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion, Verity and Files with extended characters in the filename
While it won't fix the problem, as a last ditch effort you can consider using my pdfUtils CFC from RIAForge. It has a function to read the text out of a PDF. You could read that in and then index the text. It is what my Seeker project (CF/Lucene integration) uses to read and index PDF files. On Mon, Oct 27, 2008 at 7:50 AM, JediHomer [EMAIL PROTECTED] wrote: Hi, We're currently having an issue on Linux with Verity. We're using CF8 on Debian, ubuntu for dev, where a client has PDFs that need indexing but contain extended characters in the filename, in particular the registered symbol. On Linux this is not being indexed by the Verity engine, on Windows (Where we are migrating away from) these files are correctly indexed. Using CFDirectory and Java's listFiles() I can confirm that CF and Java both see the files correctly, a FileExists() also returns true, however when CFIndexing the paths I get the following: Error E3-0422 (VDK ): Could not find file /home/jedi/Dev/htdocs/jedi/verity/mypdf.pdf ( -- Including the extended char, CF-Talk won't accept the Base64 post) In the Messages section of the Status dump (the symbol is shown correctly) but in the bad keys section of the Status dump the character does not come out correctly. Has anyone come across this before and know of a fix/work around? Thanks in advance Jedi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314396 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Apache/CF8 problems
It looks like you are binding your vhosts to 127.0.0.1. Are you sure thats the IP you get when you are browsing to this dev site? For example if you ping localhost on a vista box I think by default it resolves to an IPv6 address. I don't think that will match the virtualhost 127.0.0.1 entry. Try using virtualhost * instead. You should probably change NameVirtualHost to use * also. -Ryan Will Tomlinson wrote: I'm helping a friend setup his Vista machine to run Apache/CF8, like my XP Pro machine. The problem we're having is, whenever he hits one of his domains we setup in his windows hosts file, it directs you to the default apache website. It works! But we have virtualhost directives in the httpd.config file to direct to C:\webRoot\somesite Here's the hosts file: 127.0.0.1 localhost 127.0.0.1 local.ApacheTestSite 127.0.0.1 local.ApacheTestSite2 Here's the bottom of his config file: NameVirtualHost 127.0.0.1 VirtualHost 127.0.0.1 DocumentRoot C:\webRoot\testSite2 ServerName local.ApacheTestSite2 /VirtualHost VirtualHost 127.0.0.1 DocumentRoot C:\webRoot\InfoSite ServerName local.infotest /VirtualHost What's strange is, this all works on my XP Pro machine. I can't figure out why you hit one of those domains in the URL, and it will not take you to the right website in the webroot. Any ideas? Thanks! Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFML Language Development
I am hosting a Birds of a Feather session at MAX on the future development and evolution of CFML. I am looking for suggestions on topics to cover and speakers you'd like to hear from. http://www.vertabase. com/blog/your-ideas-for-the-future-of-cfml-adobe-max-bof-session With OpenBD, Railo and the continued evolution of Adobe's CF, these are exciting and important times for the CFML community. Even if you won't be at MAX, I'll be posting about the session on my blog so please do contribute. Here's something that pops out of my head upon reading your post. Years ago where's ColdFusion Express (free)... naturally functionally not in par with commercial version... But I thought if one (independent developers / cf shops etc.) uses such a free platform and negotiate a price for additional tag/features (say, like today's CFPDF, CFIMAGE etc.) with CF company like Adobe, then, it really creates win-win situation for all. Adobe can sell heavy-duty CF package to the big spenders as it does now while it does not alietnate the 'little guys' (an integral part of the CF development community) and provides considerable value to them. This approach/model would seem to generate more revenue for CF company/companies but no I haven't run some detailed number crunch... Thanks. Chunshen Li (Don) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFML Language Development
Here's something that pops out of my head upon reading your post. Years ago where's ColdFusion Express (free)... naturally functionally not in par with commercial version... But I thought if one (independent developers / cf shops etc.) uses such a free platform and negotiate a price for additional tag/features (say, like today's CFPDF, CFIMAGE etc.) with CF company like Adobe, then, it really creates win-win situation for all. Adobe can sell heavy-duty CF package to the big spenders as it does now while it does not alietnate the 'little guys' (an integral part of the CF development community) and provides considerable value to them. This approach/model would seem to generate more revenue for CF company/companies but no I haven't run some detailed number crunch... Given the recent roadmap that Adobe published for CF in their marketing kit, I suspect they may be planning to separate some of the features in a few years when version 11 or so is released. I.e. you would buy CF but then you wouldn't be paying for PDF generation unless you're using it, because the PDF features would be in a supplemental product... and it would make similar or alternative products from other vendors more feasible. At this point it's all guesswork though because they're not really allowed to say more about their plans, just that they're planning to provide a pluggable architecture in that version. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314399 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Issue with XML
I am working on a project that needs to parse through and xml file and add new xml elements to specific child tags. I have been able to accomplish adding the elements in the positions that I need them, but when I re write them to a file the xml attributes show up as uppercase. Here is my example. Unfortunately, the application that reads the xml relies on the values to be be mixed case so I just can't lcase the output when writing the file. Any help is greatly appreciated. *This is the xml that is currently in the file* component articlenumber= description=Fan id=15 imagefile= name=Fan popuptext= type=CMC-TC FAN uniqueid=module(riwatchit_communication_module_urb1889)/snmp( 10.38.0.225)/PU(1)/CU(fan) location path=1/2/ technicalreference path=12/13/ variablereference eventfilterlevel=0 owner=true showfilterlevel=0 variableid=7/ variablereference eventfilterlevel=0 owner=true showfilterlevel=6 variableid=8/ variablereference eventfilterlevel=0 owner=true showfilterlevel=0 variableid=9/ variablereference eventfilterlevel=0 owner=true showfilterlevel=6 variableid=10/ variablereference eventfilterlevel=0 owner=true showfilterlevel=1 variableid=11/ variablereference eventfilterlevel=0 owner=true showfilterlevel=3 variableid=12/ variablereference eventfilterlevel=0 owner=true showfilterlevel=3 variableid=13/ variablereference eventfilterlevel=0 owner=true showfilterlevel=3 variableid=14/ right name=read role=default/ right name=settings role=default/ property editable=false name=Host type=IP-Address10.38.0.225 /property /component *This is the xml that I create and add* component ARTICLENUMBER=7320.240 DESCRIPTION=Rittal PDU ID=16 IMAGEFILE= NAME=Rittal PDU POPUPTEXT= TYPE=Rittal PDU UNIQUEID=module(riwatchit_communication_module_urb1889)/snmp( 99.99.99.99)/PU(1)/CU(fan)/varId(1.3.6.1.4.1.2606.100.1.2.5.1.10.1.2)location PATH=1/2/technicalreference PATH=3/14/right NAME=read ROLE=default/right NAME=settings ROLE=default/property EDITABLE=false NAME=Host TYPE=IP-Address99.99.99.99/propertyproperty EDITABLE=false NAME=Port TYPE=Integer5/propertyvariablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=15/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=16/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=17/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=18/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=19/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=20/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=21/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=22/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=23/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=24//component/project ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314400 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Issue with XML
Got the code that does the rewriting of the attributes? When writing structures, myStruct.someKey will result in SOMEKEY when you view it. The way around it is to do myStruct[someKey]. Adrian Building a database of ColdFusion errrors at http://cferror.org/ -Original Message- From: Marc Edwards Sent: 27 October 2008 17:08 To: cf-talk Subject: Issue with XML I am working on a project that needs to parse through and xml file and add new xml elements to specific child tags. I have been able to accomplish adding the elements in the positions that I need them, but when I re write them to a file the xml attributes show up as uppercase. Here is my example. Unfortunately, the application that reads the xml relies on the values to be be mixed case so I just can't lcase the output when writing the file. Any help is greatly appreciated. *This is the xml that is currently in the file* component articlenumber= description=Fan id=15 imagefile= name=Fan popuptext= type=CMC-TC FAN uniqueid=module(riwatchit_communication_module_urb1889)/snmp( 10.38.0.225)/PU(1)/CU(fan) location path=1/2/ technicalreference path=12/13/ variablereference eventfilterlevel=0 owner=true showfilterlevel=0 variableid=7/ variablereference eventfilterlevel=0 owner=true showfilterlevel=6 variableid=8/ variablereference eventfilterlevel=0 owner=true showfilterlevel=0 variableid=9/ variablereference eventfilterlevel=0 owner=true showfilterlevel=6 variableid=10/ variablereference eventfilterlevel=0 owner=true showfilterlevel=1 variableid=11/ variablereference eventfilterlevel=0 owner=true showfilterlevel=3 variableid=12/ variablereference eventfilterlevel=0 owner=true showfilterlevel=3 variableid=13/ variablereference eventfilterlevel=0 owner=true showfilterlevel=3 variableid=14/ right name=read role=default/ right name=settings role=default/ property editable=false name=Host type=IP-Address10.38.0.225 /property /component *This is the xml that I create and add* component ARTICLENUMBER=7320.240 DESCRIPTION=Rittal PDU ID=16 IMAGEFILE= NAME=Rittal PDU POPUPTEXT= TYPE=Rittal PDU UNIQUEID=module(riwatchit_communication_module_urb1889)/snmp( 99.99.99.99)/PU(1)/CU(fan)/varId(1.3.6.1.4.1.2606.100.1.2.5.1.10.1.2)loca tion PATH=1/2/technicalreference PATH=3/14/right NAME=read ROLE=default/right NAME=settings ROLE=default/property EDITABLE=false NAME=Host TYPE=IP-Address99.99.99.99/propertyproperty EDITABLE=false NAME=Port TYPE=Integer5/propertyvariablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=15/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=16/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=17/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=18/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=19/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=20/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=21/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=22/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=23/variablereference EVENTFILTERLEVEL=0 OWNER=true SHOWFILTERLEVEL=0 VARIABLEID=24//component/project ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314401 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Issue with XML
Adrian Lynch wrote: Got the code that does the rewriting of the attributes? When writing structures, myStruct.someKey will result in SOMEKEY when you view it. The way around it is to do myStruct[someKey]. And if you are using the CF XML functions, a quick survey showed that many have a 'caseSensitive' switch to maintain the case of the xml nodes. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314402 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Convert variable to UTF-16LE?
Hey guys, I have a little pet project which has become a real pain in the neck. Basically, I want to be able to change active directory passwords from CF. The basic steps to do this are: 1) Load the appropriate certificate into the keystore 2) Allow the CF server to communicate with the AD DC using LDAPS. 3) Use cfldap with modify to set the attribute unicodePwd to the new password in UTF16-LE format. As per this document: http://msdn.microsoft.com/en-us/library/cc200469.aspx Now, after much frustration and messing around, 1 and 2 are done and working. However, I can't for the life of me figure out how to get CF to pass the password through the LDAPS connection as UTF-16LE, and with double quotes around it. Does anyone have any clue what to do? I've tried the following (from a CF doc) to test, with no success: cfset charData = passwordhere !-- Create a Base64 representation of this string. cfset data64 = toBase64(#charData#) p The following string is the Base64 representation of the string.br cfoutput#data64#/cfoutput/p ! Create a binary representation of Base64 data. --- cfset dataBinary = toBinary(data64) ! Create the string representation of the binary data. - cfset dataString = ToString(dataBinary,UTF-16) pThe following is the string representation of the binary data.br cfoutput#dataString#/cfoutput/p Does anyone have any idea how to go about this? I'm baffled. There are other ways I can do this, but after going this far and only having this in my way, I'd really like to get it figured out. Thanks in advance for the help. Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314403 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Convert variable to UTF-16LE?
Have you been able to duplicate the example output on the link below? Mike -Original Message- From: dan m [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2008 1:32 PM To: cf-talk Subject: Convert variable to UTF-16LE? Hey guys, I have a little pet project which has become a real pain in the neck. Basically, I want to be able to change active directory passwords from CF. The basic steps to do this are: 1) Load the appropriate certificate into the keystore 2) Allow the CF server to communicate with the AD DC using LDAPS. 3) Use cfldap with modify to set the attribute unicodePwd to the new password in UTF16-LE format. As per this document: http://msdn.microsoft.com/en-us/library/cc200469.aspx ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314404 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Convert variable to UTF-16LE?
No, but frankly I'm not sure how I would know. When I output the converted string I get a bunch of odd characters in my browser, I'm assuming because the encoding is different... Have you been able to duplicate the example output on the link below? Mike Hey guys, I have a little pet project which has become a real pain in the neck. Basically, I want to be able to change active directory passwords from CF. The basic steps to do this are: 1) Load the appropriate certificate into the keystore 2) Allow the CF server to communicate with the AD DC using LDAPS. 3) Use cfldap with modify to set the attribute unicodePwd to the new password in UTF16-LE format. As per this document: http://msdn.microsoft.com/en-us/library/cc200469.aspx ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Best way to create an .xls file from a page
Hi all, I have a page that creates an invoice. I need to be able to make an Excel spreadsheet out of it. It does have different sized tables in it. What is the best way to do this? I have saved the page as a .xls and it was perfect. Just need to do this automatically now. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Best way to create an .xls file from a page
You can change your content type so that the browser thinks it is downloading an Excel file. Google: cfcontent Excel cfheader -Original Message- From: Brian Yager [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2008 2:15 PM To: cf-talk Subject: Best way to create an .xls file from a page Hi all, I have a page that creates an invoice. I need to be able to make an Excel spreadsheet out of it. It does have different sized tables in it. What is the best way to do this? I have saved the page as a .xls and it was perfect. Just need to do this automatically now. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best way to create an .xls file from a page
If you use the content type trick to open HTML inside of Excel then you get content type warnings whenever you open the file. Creating native Excel files is harder to do, but I think the results are more professional, and you can make use of features like filter columns and calculation columns. If you haven't already done so, you should search the archives of this list since this topic has been discussed many times. Another thing to consider is creating a PDF version instead since PDF files are often easier to create. PDF is a more common file format for invoices from what I have seen. -Mike Chabot On Mon, Oct 27, 2008 at 3:46 PM, Dawson, Michael [EMAIL PROTECTED] wrote: You can change your content type so that the browser thinks it is downloading an Excel file. Google: cfcontent Excel cfheader -Original Message- From: Brian Yager [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2008 2:15 PM To: cf-talk Subject: Best way to create an .xls file from a page Hi all, I have a page that creates an invoice. I need to be able to make an Excel spreadsheet out of it. It does have different sized tables in it. What is the best way to do this? I have saved the page as a .xls and it was perfect. Just need to do this automatically now. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best way to create an .xls file from a page
I wouldn't say it is the *best* way but this will maintain table layouts: http://mgt.pastebin.com/f27bd1c5a Another way to do it is what Mike Chabot suggested. Yet another way: Create a spreadsheet and fill the places where you want your data to go with CF vars #.yourQury.yourVar# and then save as XML or HTML (I forget) and use the above method to populated it and force it to the browser. HTH ~G~ On Mon, Oct 27, 2008 at 3:14 PM, Brian Yager [EMAIL PROTECTED]wrote: Hi all, I have a page that creates an invoice. I need to be able to make an Excel spreadsheet out of it. It does have different sized tables in it. What is the best way to do this? I have saved the page as a .xls and it was perfect. Just need to do this automatically now. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfthread and queue management
Howdy, I'm trying to wrap my head around the best way to use cfthread to manage a task queue. I have a remote service that I call via cfhttp that does a processing task. It is a commercial service and our license is based on the number of simultaneous requests we can make against the service. So lets say that I have 5 ports available to me, i.e., I can have 5 active requests at any given time. Additional requests will be refused by the remote service. On my side, I have a queue of requests that I need to get through. What I'm trying to design is a simple setup where it launches the 5 allowed http requests using cfthread (each task is independent of the others) and when one of the threads completes, it goes and grabs the next item that needs to be sent to this remote service that way we are utilizing all 5 ports to full effect. I understand how to launch an individual thread. What I'm having difficulty wrapping my head around is how to have it go fetch the next item in the queue and launch a thread again until the queue has been processed. It kind of seems like what I want to be doing is having a top level variable that keeps track of what the next item in the queue is, then down at the thread level, have my threads in some sort of a while statement that keeps going until the queue is done, then have the completion of a thread return a value that launches that thread again with the current value of the top level variable and then changes the top level variable to the next item in the queue. Any thoughts about the situation and ideas of how best to code it? Thanks in advance, Judah ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314410 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfthread and queue management
I have a remote service that I call via cfhttp that does a processing task. It is a commercial service and our license is based on the number of simultaneous requests we can make against the service. So lets say that I have 5 ports available to me, i.e., I can have 5 active requests at any given time. Additional requests will be refused by the remote service. On my side, I have a queue of requests that I need to get through. What I'm trying to design is a simple setup where it launches the 5 allowed http requests using cfthread (each task is independent of the others) and when one of the threads completes, it goes and grabs the next item that needs to be sent to this remote service that way we are utilizing all 5 ports to full effect. I understand how to launch an individual thread. What I'm having difficulty wrapping my head around is how to have it go fetch the next item in the queue and launch a thread again until the queue has been processed. It kind of seems like what I want to be doing is having a top level variable that keeps track of what the next item in the queue is, then down at the thread level, have my threads in some sort of a while statement that keeps going until the queue is done, then have the completion of a thread return a value that launches that thread again with the current value of the top level variable and then changes the top level variable to the next item in the queue. I would recommend that you use one thread to monitor the others. This thread could wake every 500ms, for example, then check the progress of the other threads, terminate unresponsive threads, and assign new tasks. There's an example of this in the Adobe Advanced ColdFusion 8 Development course, actually. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314411 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfthread and queue management
On Mon, Oct 27, 2008 at 3:20 PM, Dave Watts [EMAIL PROTECTED] wrote: I would recommend that you use one thread to monitor the others. This thread could wake every 500ms, for example, then check the progress of the other threads, terminate unresponsive threads, and assign new tasks. There's an example of this in the Adobe Advanced ColdFusion 8 Development course, actually. I was pondering this method and that may be what I go with but it seems like I ought to be able to trigger a new event based on the completion of a thread, along the lines of a callback function in JS. The sleep, wake, check, sleep paradigm is functional but it seems a bit inelegant. The child function ought to be able to say to the parent Hey, I'm done now! and have the parent launch another thread. But I can't quite wrap my head around how to make that happen. Thanks for the response though, its an excellent suggestion. Judah ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314412 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfthread and queue management
So, you can only have it trying 5 threads at a time... How about in the CF Admin, set your maximum simultaneous threads to 5. It will queue all other requests until each one completes. Enterprise defaults to 10 I believe... =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314413 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFML Language Development
Here's something that pops out of my head upon reading your post. Given the recent roadmap that Adobe published for CF in their marketing kit, I suspect they may be planning to separate some of the features in a few years when version 11 or so is released. I.e. you would buy CF but then you wouldn't be paying for PDF generation unless you're using it, because the PDF features would be in a supplemental product... and it would make similar or alternative products from other vendors more feasible. At this point it's all guesswork though because they're not really allowed to say more about their plans, just that they're planning to provide a pluggable architecture in that version. s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog Thanks for sharing what is sharable. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314414 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Passing data to another web application on another server
Hi there I need to check whether the following is possible and I have to find out ASAP. I have to find out if I can pass data to another application on a differet server, Basically I have been told so far that the only way that I can pass information is by a HTTP post. Previously I have done something similar by posting a form to a URL. This time I have a string which contains the information. How can I post a string so it can be used by the application which is o the other server. Thanks in advance. Toby ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314415 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfthread and queue management
The problem with that is that I may want to use cfthread elsewhere on the server (like in cleanup/maintenance tasks) and in this particular application I want exactly 5 threads active at all times to maximize the usage of this external resource. Still, a sneaky idea that I had pondered as well. Judah On Mon, Oct 27, 2008 at 4:12 PM, Alan Rother [EMAIL PROTECTED] wrote: So, you can only have it trying 5 threads at a time... How about in the CF Admin, set your maximum simultaneous threads to 5. It will queue all other requests until each one completes. Enterprise defaults to 10 I believe... =] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314416 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Passing data to another web application on another server
CFHTTP Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Toby King wrote: Hi there I need to check whether the following is possible and I have to find out ASAP. I have to find out if I can pass data to another application on a differet server, Basically I have been told so far that the only way that I can pass information is by a HTTP post. Previously I have done something similar by posting a form to a URL. This time I have a string which contains the information. How can I post a string so it can be used by the application which is o the other server. Thanks in advance. Toby ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfthread and queue management
Yeah... I kind of figured that was the deal, but I had to point it out. In that case Dave is right (as he almost always is...) keeping a single monitoring thread active to watch the others makes the most sense. One thing to watch our for in fully asynchronous threads is that error catching is much tricker. Many of the usual techniques don't work. I had to build a complex system that during development failed all the time, yet never logged a single error in the CF log files. The only solution I could come up with during dev was to wrap every segment of code in a cftry that used a webservice to report errors back to me through lighthouse. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Passing data to another web application on another server
And, if the string is long or has 'special' characters in it, be sure to set the cfhttp method to POST, and send the string as a formfield: cfhttp method=POST ... cfhttpparam type=FORMFIELD name=theVariableName value=theBigString /cfhttp Gets around any URL length limitations. CFHTTP Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Toby King wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314419 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Passing data to another web application on another server
Use WDDX. This is exactly what WDDX is meant to do. Most server languages can serialize and de-serialize WDDX packets including Coldfusion, PHP, ASP, and Javascript. WDDX was created by Allaire. http://en.wikipedia.org/wiki/WDDX http://www.openwddx.org/ Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Oct 27, 2008, at 6:23 PM, Toby King wrote: Hi there I need to check whether the following is possible and I have to find out ASAP. I have to find out if I can pass data to another application on a differet server, Basically I have been told so far that the only way that I can pass information is by a HTTP post. Previously I have done something similar by posting a form to a URL. This time I have a string which contains the information. How can I post a string so it can be used by the application which is o the other server. Thanks in advance. Toby ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfthread and queue management
You really need 5 threads that loop, while there is something to be
executed, and a Queue of CFCs that have a common execute() commands.
something like:
cfthread name=thread1
while(NOT queue.isEmpty())
{
action = queue.pop();
action.execute();
}
/cfthread
While there is probably some error checking, and logging etc, that is
the basic gist of building a queue processing system.
Mark
On Tue, Oct 28, 2008 at 10:39 AM, Alan Rother [EMAIL PROTECTED] wrote:
Yeah... I kind of figured that was the deal, but I had to point it out.
In that case Dave is right (as he almost always is...) keeping a single
monitoring thread active to watch the others makes the most sense.
One thing to watch our for in fully asynchronous threads is that error
catching is much tricker. Many of the usual techniques don't work. I had to
build a complex system that during development failed all the time, yet
never logged a single error in the CF log files. The only solution I could
come up with during dev was to wrap every segment of code in a cftry that
used a webservice to report errors back to me through lighthouse.
=]
--
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314421
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFML Language Development
Not the first time this has come up: http://cfrant.blogspot.com/2008/04/why-adobe-should-love-open-bluedragon.html Gert, of Railo, also mentions a similar view in episode 10 of cfConversations (please forgive the crappy quality): http://www.cfconversations.com/index.cfm/2008/7/28/CFConversations-10-Interview-6--Gert-Franz-of-Railo--072808 And lets be honest here it is already a plugable architecture, just do a CFdump on most (probably any) tag class and you will see they all extend off JSP tag. The only engine that does not do this currently is OpenBD but as my blog post above speaks to, OpenBD has a plugable architecture as well, just does not base it strictly off JSP. Adam Haskell On Mon, Oct 27, 2008 at 7:21 PM, Don L [EMAIL PROTECTED] wrote: Here's something that pops out of my head upon reading your post. Given the recent roadmap that Adobe published for CF in their marketing kit, I suspect they may be planning to separate some of the features in a few years when version 11 or so is released. I.e. you would buy CF but then you wouldn't be paying for PDF generation unless you're using it, because the PDF features would be in a supplemental product... and it would make similar or alternative products from other vendors more feasible. At this point it's all guesswork though because they're not really allowed to say more about their plans, just that they're planning to provide a pluggable architecture in that version. s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog Thanks for sharing what is sharable. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
