Next and Previous on grouped output
Hi I have query which joins together four tables, in my output i use group to display the correct information to the screen. The query returns around 42 records of which 13 are being displayed to the screen, code below; (i'll tidy up .* when i get it working) My question is how to do next and previous, my normal method falls short, because of the grouping as it uses the record count of the query to know where it is. I have had a look around for some examples, with no luck so far. If any one can pint me in the right direction - thank you. cfquery name=get_global_products datasource=#application.dsn# SELECT wp_products.*, gp_product_templates.*, wa_websites.*, wp_images.* FROM ((gp_product_templates INNER JOIN wp_products ON gp_product_templates.gp_id = wp_products.wp_product_template_id) INNER JOIN wa_websites ON wp_products.wp_product_web_id = wa_websites.wa_websiteID) LEFT JOIN wp_images ON wp_products.wp_products_id = wp_images.wp_gp_product_id WHERE wp_product_web_id = cfqueryparam cfsqltype=cf_sql_integer value=#get_websites.wa_websiteID# /cfquery cfoutput query=get_global_products group=gp_name/cfoutput ~| 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:323067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Scheduled Tasks
Yesterday, we noticed that the CF server v8.0.1 (apparently) was just forgetting to run some (not all) of our scheduled tasks. They were not throwing exceptions, there was nothing useful in the logs, and I could run them just fine and error-free by clicking the Run Scheduled Task icon next to each. Here's what I did (and all that I did): 1. delete and re-insert forgotten tasks 2. apply http://bit.ly/6vehC 3. reboot server ...and now they're (apparently) working fine. Questions: 1. Have you ever seen this? 2. If so, any idea what caused it? 3. If so, what fix(es) worked for you? 4. After applying fix(es), did the problem recur? 5. If so, any idea why? -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss ~| 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:323068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Next and Previous on grouped output
Have you looked at this? http://paginationcfc.riaforge.org/ On Tue, Jun 2, 2009 at 7:53 AM, Jason Congerton ja...@jasoncongerton.co.ukwrote: Hi I have query which joins together four tables, in my output i use group to display the correct information to the screen. The query returns around 42 records of which 13 are being displayed to the screen, code below; (i'll tidy up .* when i get it working) My question is how to do next and previous, my normal method falls short, because of the grouping as it uses the record count of the query to know where it is. I have had a look around for some examples, with no luck so far. If any one can pint me in the right direction - thank you. cfquery name=get_global_products datasource=#application.dsn# SELECT wp_products.*, gp_product_templates.*, wa_websites.*, wp_images.* FROM ((gp_product_templates INNER JOIN wp_products ON gp_product_templates.gp_id = wp_products.wp_product_template_id) INNER JOIN wa_websites ON wp_products.wp_product_web_id = wa_websites.wa_websiteID) LEFT JOIN wp_images ON wp_products.wp_products_id = wp_images.wp_gp_product_id WHERE wp_product_web_id = cfqueryparam cfsqltype=cf_sql_integer value=#get_websites.wa_websiteID# /cfquery cfoutput query=get_global_products group=gp_name/cfoutput ~| 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:323069 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
Acknowledged. My (admittedly conservative) approach is to prove that the app _doesn't_ need locking rather than the reverse. Don't get me wrong, I'm all in favour of eliminating both the extra coding burden as well as the overhead. That said, the docs seem to lean towards locking when in doubt... that and the fact I've had the whole locking religion hammered home relentlessly over the years. It may take me a while to get with the new program. ;-) The docs were originally written in a time when failure to lock religiously often caused the server to crash. In my experience, locking is usually not needed with CF 6+. Going back to the questions I originally asked you about whether you care about race conditions - those are the questions you need to answer to implement locking optimally. 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 ~| 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:323070 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: jQuery Guru guidance needed....
You could also create an array variable outside of your tabs setup. Then add to that. Since it's external from the tabs code, every piece of JS would be able to recognize it. script var arrProdID = []; // tabs code here /script -Original Message- From: Will Tomlinson [mailto:w...@wtomlinson.com] Sent: Monday, June 01, 2009 9:44 PM To: cf-talk Subject: jQuery Guru guidance needed I'm using jQuery Tabs to rebuild my ancient product admin. Trying to slicken it up a bit. As a product is added, I need the tab .cfm's, and the parent to pass around the prod ID variable to each other. The tabs I'm using: http://docs.jquery.com/UI/API/1.7/Tabs I have a parent page that contains the tabs (disabling 2nd-5th tab until a product is added: tabs.cfm script $(document).ready(function() { $(#productAdmin).tabs({ disabled: [1, 2, 3, 4] }); }); /script div id=productAdmin ul lia href=product_add.cfmspanProduct Info/span/a/li lia href=productBuilder-Categories.cfmspanCategories/span/a/li lia href=productBuilder-Skus.cfmspanSKUS/span/a/li lia href=productBuilder-SuggestedProducts.cfmspanSuggested Products/span/a/li lia href=productBuilder-prodImage.cfmspanImages/span/a/li /ul If someone is using the product info tab, and they add a product, how could I let the parent, tabs.cfm know, and enable the other tabs at that point. Thanks, Will ~| 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:323071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scheduled Tasks
Yesterday, we noticed that the CF server v8.0.1 (apparently) was just forgetting to run some (not all) of our scheduled tasks. They were not throwing exceptions, there was nothing useful in the logs, and I could run them just fine and error-free by clicking the Run Scheduled Task icon next to each. Here's what I did (and all that I did): 1. delete and re-insert forgotten tasks 2. apply http://bit.ly/6vehC 3. reboot server ...and now they're (apparently) working fine. Questions: 1. Have you ever seen this? 2. If so, any idea what caused it? 3. If so, what fix(es) worked for you? 4. After applying fix(es), did the problem recur? 5. If so, any idea why? I would recommend not using link shorteners in email when describing problems, because it makes it more difficult to answer the question. 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 i ~| 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:323072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
captcha
Anyone have recommendations for CAPTCHA? I know about CFImage's captcha, but what other programming can be used to figure out if the submission was done by a human? I thought about timing the form page load and time to submission. If it took a user less than 5 seconds to fill out the form then assume they are not human. ~| 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:323073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: captcha
Awesome form protection http://cfformprotect.riaforge.org/ http://cfformprotect.riaforge.org/Rob On Tue, Jun 2, 2009 at 9:46 AM, Chad Gray cg...@careyweb.com wrote: Anyone have recommendations for CAPTCHA? I know about CFImage's captcha, but what other programming can be used to figure out if the submission was done by a human? I thought about timing the form page load and time to submission. If it took a user less than 5 seconds to fill out the form then assume they are not human. ~| 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:323074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Scheduled Tasks
Sorry. That was, Cumulative Hot Fix 2 for ColdFusion 8.0.1 - http://kb2.adobe.com/cps/403/kb403781.html On Tue, Jun 2, 2009 at 8:33 AM, Dave Watts dwa...@figleaf.com wrote: Yesterday, we noticed that the CF server v8.0.1 (apparently) was just forgetting to run some (not all) of our scheduled tasks. They were not throwing exceptions, there was nothing useful in the logs, and I could run them just fine and error-free by clicking the Run Scheduled Task icon next to each. Here's what I did (and all that I did): 1. delete and re-insert forgotten tasks 2. apply http://bit.ly/6vehC 3. reboot server ...and now they're (apparently) working fine. Questions: 1. Have you ever seen this? 2. If so, any idea what caused it? 3. If so, what fix(es) worked for you? 4. After applying fix(es), did the problem recur? 5. If so, any idea why? I would recommend not using link shorteners in email when describing problems, because it makes it more difficult to answer the question. 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 i ~| 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:323075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: captcha
Rob Parkhill wrote: Awesome form protection http://cfformprotect.riaforge.org/ I second that. I've been using CFFormProtect for a while now with good results. ~| 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:323076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: captcha
Looks nice. I'll try it to. :) -- Ryan On Tue, Jun 2, 2009 at 8:51 AM, Scott Weikert li...@alphageek.com wrote: Rob Parkhill wrote: Awesome form protection http://cfformprotect.riaforge.org/ I second that. I've been using CFFormProtect for a while now with good results. ~| 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:323077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: captcha
Anyone have recommendations for CAPTCHA? Yes: don't use captcha. Users hate them. what other programming can be used to figure out if the submission was done by a human? -Add some hidden check value by javascript on submit. I don't thing many bots execute correctly Javascript. - Add some Javascript Confirm on submit. I thought about timing the form page load and time to submission. If it took a user less than 5 seconds to fill out the form then assume they are not human. Not a good idea, some bots are able to wait between their requests; it is much easier than execute Javascript. ~| 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:323078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: AddSOAPRequestHeader
Thanks to inspiration from Ray Camden, the solution: cfset doc = XmlNew() cfset doc.ApiUserAuthHeader = XmlElemNew(ApiUserAuthHeader, namespace, ApiUserAuthHeader) cfset doc.ApiUserAuthHeader.UserName = XmlElemNew(ApiUserAuthHeader, UserName) cfset doc.ApiUserAuthHeader.UserName.XmlText = x cfset doc.ApiUserAuthHeader.UserAccessKey = XmlElemNew(ApiUserAuthHeader, UserAccessKey) cfset doc.ApiUserAuthHeader.UserAccessKey.XmlText = x cfset doc.ApiUserAuthHeader.Password = XmlElemNew(ApiUserAuthHeader, Password) cfset doc.ApiUserAuthHeader.Password.XmlText = x cfset AddSOAPRequestHeader(MyWebservice, namespace, ApiUserAuthHeader, doc) On Mon, Jun 1, 2009 at 9:10 AM, John M Bliss bliss.j...@gmail.com wrote: I'm trying to consume a webservice that expects: soap:Header ApiUserAuthHeader xmlns=namespace UserNamex/UserName Passwordx/Password UserAccessKey/UserAccessKey /ApiUserAuthHeader /soap:Header ...so I wrote: cfset ApiUserAuthHeader = StructNew() cfset ApiUserAuthHeader.UserAccessKey = x cfset ApiUserAuthHeader.Password = x cfset ApiUserAuthHeader.UserName = x cfset AddSOAPRequestHeader(MyWebservice, namespace, ApiUserAuthHeader, ApiUserAuthHeader) ...but this generates: soapenv:Header ns1:ApiUserAuthHeader xmlns:ns1=namespace item xmlns:ns2=http://xml.apache.org/xml-soap; key xsi:type=xsd:stringPASSWORD/key value xsi:type=xsd:stringx/value /item item key xsi:type=xsd:stringUSERNAME/key value xsi:type=xsd:stringx/value /item item key xsi:type=xsd:stringUSERACCESSKEY/key value xsi:type=xsd:stringx/value /item /ns1:ApiUserAuthHeader /soapenv:Header How do I emulate the header that the webservice is expecting? -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss ~| 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:323079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Consuming .net web service with Coldfusion 7
I got Could not generate stub objects for web service invocation. error. Here is my code: !--- ready test.txt file into a binary variable --- cffile action=readBinary file=#FileName# variable=objBinaryData !--- convert the binary variable to Base64 --- cfset b64file = #toBase64(objBinaryData)# !--- invoke .net web service --- cfinvoke webservice = http:///fileservice.asmx?wsdl; method = UploadFileBasic returnVariable = recordNumber cfinvokeargument name=incomingArray value=#b64file# / cfinvokeargument name=FileName value=#form.FILENAME# / /cfinvoke Any idea? 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:323080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File to large errors when posting to CF8
It appears I had a stray 'ulimit' added to the top of the start up script. No idea why it was there :-) -- Helping to seamlessly generate interdependent technologies as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office 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.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:323081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Next and Previous on grouped output
Hi Thanks for you response, i downloaded and set up pagination.cfc, however this still uses the main query to get the total record count, when using with grouped ouput the wrong page amounts are retuned. However, i must say easy to use and setup! Jason Have you looked at this? http://paginationcfc.riaforge.org/ On Tue, Jun 2, 2009 at 7:53 AM, Jason Congerton ja...@jasoncongerton.co.ukwrote: ~| 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:323082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: captcha
I have also had decent luck with the hidden form field. In your form, put an input type=text in a div that is display: none, so the field isn't technically hidden, but a human won't see it, and then call the field something like name=lastName, something that a bot will always fill out. (Example works in a form that does not also have a 'real' form field called lastName, of course.) Then on submission, server-side, CFIF len(form.lastName) then bail out and don't process the results at all. CFFORMPROTECT is much more robust, of course, covering several different bot / hack angles, but I often use the non-displayed form field as a quick, lightweight filter. ~| 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:323083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Twitter stopped accepting updates
About a month ago, I implemented this code: CFHTTP url=http://twitter.com/statuses/update.xml; method=POST username=useridhere password=passwordhere charset=UTF-8 CFHTTPPARAM type=FORMFIELD name=user value=useridhere CFHTTPPARAM type=FORMFIELD name=password value=passwordhere CFHTTPPARAM type=FORMFIELD name=status value=#form.ttext# /CFHTTP CFOUTPUT#cfhttp.StatusCode#/CFOUTPUT and it was posting updates to my Twitter account just perfectly. I'd get a 200 OK as the response code. And, I'm still getting that code, but about two weeks ago, the posts actually stopped appearing on Twitter. No errors, no notifications in my account, nothing. Ideas? ~| 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:323084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Twitter stopped accepting updates
On Tue, Jun 2, 2009 at 11:21 AM, Curt Schryver c...@schryver.org wrote: About a month ago, I implemented this code: CFHTTP url=http://twitter.com/statuses/update.xml; method=POST username=useridhere password=passwordhere charset=UTF-8 CFHTTPPARAM type=FORMFIELD name=user value=useridhere CFHTTPPARAM type=FORMFIELD name=password value=passwordhere CFHTTPPARAM type=FORMFIELD name=status value=#form.ttext# /CFHTTP CFOUTPUT#cfhttp.StatusCode#/CFOUTPUT and it was posting updates to my Twitter account just perfectly. I'd get a 200 OK as the response code. And, I'm still getting that code, but about two weeks ago, the posts actually stopped appearing on Twitter. No errors, no notifications in my account, nothing. Ideas? Are you posting the same message to multiple twitter accounts? That would be one issue to check into. They consider it spam at that point. ~| 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:323085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFDocumentitem strangeness
For the benefit of future searchers, this problem is remedied (for CF8) by applying the CFDocument hot fix available at: http://kb2.adobe.com/cps/402/kb402584.html -Original Message- From: Billy Cox [mailto:bi...@oldworldspices.com] Sent: Monday, June 01, 2009 4:58 PM To: cf-talk Subject: CFDocumentitem strangeness I am using cfdocument to output mutliple cfdocumentsections and everything works fine...except for the cfdocumentitem header within each section. All of the other code in the section handles the loop iteration correctly, but the cfdocumentitem outputs only data for the last record in the result set. So, if I have records 100, 101, 102, and 103, the cfocumentitem will show 103 for each section. How can I get this to cooperate? All of the examples I have found are very simple things like ouputting page numbers. Thanks in advance, Billy Cox Old World Spices bi...@oldworldspices.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:323086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Twitter stopped accepting updates
No, just one account. Differing text, too. I just logged into Twitter and was able to post manually but a test from my web page still doesn't appear. Do they restrict certain accounts on how they can update? ~| 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:323087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IIS permissions on CF files
If I turn off read permission for an IIS directory (virtual or normal), I can't access that in the browser (as expected), and nor can I access any directories or files within it... well, except for CFM and CFC files. :/ It appears that IIS ignores the fact that there is no read permission for the file, and serves it as normal. Does anyone know why this is the case, and how to fix it? (Other than switching from IIS to a decent web server, which unfortunately isn't an option.) 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:323088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: IIS permissions on CF files
Does anyone know why this is the case, and how to fix it? IIS doesn't access the files directly. It hands the request off to the ColdFusion server and it reads the files and returns the content. You would need to disable anonymous access to the file/folder in IIS to ensure the user is authenticated before hitting those pages. -Justin ~| 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:323089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IIS permissions on CF files
Well, the user wont be authenticated, because the point is to block this directory completely on this site (it will be accessed via an entirely different domain/port). But I think the login prompt that displays with anonymous access disabled is a good enough block, (even though a straight 403 would be better). 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:323090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Error register asp.net web service in CF 7 admin
We have an ASMX webservice using Visual Studio 2005 and a web application project in Visual Studio 2008 that successfully consumes the web service. But when I register the web service under CF MX 7 admin, I got the following error: Could not generate stub objects for web service invocation. Name: http:///xxx.asmx?wsdl. WSDL: http:///xxx.asmx?wsdl. org.xml.sax.SAXException: Fatal Error: URI=null Line=11: The element type META must be terminated by the matching end-tag . It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can't be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. Any idea? 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:323091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFformprotect
Not sure if the developer of CFFormProtect monitors this list, I could not find an email. Maybe someone else can answer my question. Can CFFormProtect use the mail server setup in CFAdmin instead of having to specify mail server settings in the cffp.ini.cfm? I tried leaving emailServer blank in the cffp.ini.cfm file and email is not delivered. 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:323092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error register asp.net web service in CF 7 admin
We have an ASMX webservice using Visual Studio 2005 and a web application project in Visual Studio 2008 that successfully consumes the web service. But when I register the web service under CF MX 7 admin, I got the following error: Could not generate stub objects for web service invocation. Name: http:///xxx.asmx?wsdl. WSDL: http:///xxx.asmx?wsdl. org.xml.sax.SAXException: Fatal Error: URI=null Line=11: The element type META must be terminated by the matching end-tag . It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can't be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. What do you get when you use a web browser from the server console to retrieve and examine the requested WSDL document for correctness? Note that you have to do this test from the server console, not your own computer. 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! ~| 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:323093 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Creating MS Word Documents
Hello all! We have a project where we need to create MS Word documents on the fly via Coldfusion - has anyone had any experience with this. We need to adhere to strict output rules for this project and wondering if just creating HTML content will be enough. Has anyone used any tool for this before? Any suggestions would be most helpful. Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com Coldfusion Shopping Cart Software ~| 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:323094 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating MS Word Documents
Hey, Paul, long time no talk. A guy I work with just demo'd the Apache POI project recently. He was doing it for Excel 2007 formatting but it handles pretty much all Office programs. I think there is a limited version of this built into CF8 (not sure if you are using that) but depending on what functionality you need, you might need the newest full version. Check it out here: http://poi.apache.org/ Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Paul Giesenhagen [mailto:p...@quilldesign.com] Sent: Tuesday, June 02, 2009 4:20 PM To: cf-talk Subject: Creating MS Word Documents Hello all! We have a project where we need to create MS Word documents on the fly via Coldfusion - has anyone had any experience with this. We need to adhere to strict output rules for this project and wondering if just creating HTML content will be enough. Has anyone used any tool for this before? Any suggestions would be most helpful. Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com Coldfusion Shopping Cart Software ~| 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:323095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: replace width/height values in youtube script
hi, just wondering if anyone had some ideas on how to do the above function? ~| 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:323096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating MS Word Documents
I just got done doing something like this. What I did was take a RTF document which uses a markup like HTML except for word processors and opened the document in a text editor and inserted the variables wrapped with cfoutputs where I wanted them to show up. Then I saved it as a text file and stuck it into a cfsavecontent tags as an include cfsavecontent variable=asdcfinclude template=MyDoc.txt/cfsavecontent Then I forced the download using cfheader and cfcontent. HTH G! On Tue, Jun 2, 2009 at 5:20 PM, Paul Giesenhagen p...@quilldesign.comwrote: Hello all! We have a project where we need to create MS Word documents on the fly via Coldfusion - has anyone had any experience with this. We need to adhere to strict output rules for this project and wondering if just creating HTML content will be enough. Has anyone used any tool for this before? Any suggestions would be most helpful. Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com Coldfusion Shopping Cart Software ~| 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:323097 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating MS Word Documents
That sounds like a pretty straightforward way of doing it. We'll dig into it tomorrow. Thanks Gerald. Paul Giesenhagen QuillDesign http://www.quilldesign.com Coldfusion Shopping Cart Software -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Tuesday, June 02, 2009 8:01 PM To: cf-talk Subject: Re: Creating MS Word Documents I just got done doing something like this. What I did was take a RTF document which uses a markup like HTML except for word processors and opened the document in a text editor and inserted the variables wrapped with cfoutputs where I wanted them to show up. Then I saved it as a text file and stuck it into a cfsavecontent tags as an include cfsavecontent variable=asdcfinclude template=MyDoc.txt/cfsavecontent Then I forced the download using cfheader and cfcontent. HTH G! ~| 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:323098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IIS permissions on CF files
put an Application.cfc in that directory and add code in onRequestStart method in it to check for cgi.server_name or cgi.http_host ( or for getPageContext().getRequest().getServerName() ) and abort the request (and maybe return a 403 header) if the domain the request is coming from is not allowed. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 02/06/2009 23:58, Peter Boughton wrote: Well, the user wont be authenticated, because the point is to block this directory completely on this site (it will be accessed via an entirely different domain/port). But I think the login prompt that displays with anonymous access disabled is a good enough block, (even though a straight 403 would be better). 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:323099 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error register asp.net web service in CF 7 admin
Dave, Thanks for the quick reply. I logged on to the coldfusion server and was able the see the WSDL on the web browser. The project I'm working on involves coldfusion mx7, .net web services, and HP Trim. The web service I want to register sits on Trim server. When I tried to register a web service created by our .net developer, I actually got this error: Error creating web service. Please ensure that you have entered a correct Web Service name or URL. I got the Could not generate stub objects for web service invocation.as I posted before when I directly invoke the web service without pre register it in CF Admin. And also I found a registered web service in CF Admin: http://trim/trimws/trim.asmx?wsdl. My colleague told me this is production Trim web service, no client program in our company uses it. I'm not sure why it was registered in CF Admin if no client program uses it, but when I refresh/update it, I got the same error as I run the cf code to invoke web service without pre register it in CF Admin. I appreciate your help! Hong -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, June 02, 2009 5:09 PM To: cf-talk Subject: Re: Error register asp.net web service in CF 7 admin We have an ASMX webservice using Visual Studio 2005 and a web application project in Visual Studio 2008 that successfully consumes the web service. But when I register the web service under CF MX 7 admin, I got the following error: Could not generate stub objects for web service invocation. Name: http:///xxx.asmx?wsdl. WSDL: http:///xxx.asmx?wsdl. org.xml.sax.SAXException: Fatal Error: URI=null Line=11: The element type META must be terminated by the matching end-tag . It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can't be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. What do you get when you use a web browser from the server console to retrieve and examine the requested WSDL document for correctness? Note that you have to do this test from the server console, not your own computer. 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! ~| 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:323100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery Guru guidance needed....
go here: http://jqueryui.com/demos/tabs/ click on Methods tab. read about the 'URL' method. presumably, your product_add.cfm page adds a product using ajax post? if so, the callback function should receive the id of newly added product and then call the url() method on the other tabs (and maybe load() method as well - can't remember now if just setting a new url reloads the tab or not...) Where do you put the callback funtion? In the product_add.cfm page? Or the parent tabs.cfm page? I'm a little mixed up. Thanks for the help, Will ~| 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:323101 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: replace width/height values in youtube script
ok, i have made an attempt at converting a php function. unfortunately it does not quite work. i think i am close ?? cffunction name=resize_markup access=public returntype=string output=false cfargument name=markup type=string required=yes cfargument name=width type=numeric required=false cfargument name=height type=numeric required=false cfset var patterns = arrayNew(1) cfset var replacements = arrayNew(1) cfif isDefined(arguments.width) cfscript pattern = 'width=([0-9]+)'; arrayAppend(patterns, pattern); pattern = 'width:([0-9]+)'; arrayAppend(patterns, pattern); replacement = 'width=' arguments.width ''; arrayAppend(replacements, replacement); replacement = 'width:' arguments.width; arrayAppend(replacements, replacement); /cfscript /cfif cfif isDefined(arguments.height) cfscript pattern = 'height=([0-9]+)'; arrayAppend(patterns, pattern); pattern = 'height:([0-9]+)'; arrayAppend(patterns, pattern); replacement = 'height=' arguments.height ''; arrayAppend(replacements, replacement); replacement = 'height:' arguments.height; arrayAppend(replacements, replacement); /cfscript /cfif cfloop from=1 to=#arrayLen(patterns)# index=idx cfset new_string = REReplaceNoCase(arguments.markup, patterns[idx], replacements[idx], All) /cfloop cfreturn new_string / /cffunction ~| 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:323102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: jQuery Guru guidance needed....
a safe bet would be to define all your js in the main page (tabs.cfm). but particulars depend on your code... how are you submitting your add product form? are you using jquery (i.e. $.ajax or $.post) or are you using cf8 built-in ajax features (cfajaxproxy or ColdFusion.Ajax.submitForm())? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 03/06/2009 09:14, Will Tomlinson wrote: go here: http://jqueryui.com/demos/tabs/ click on Methods tab. read about the 'URL' method. presumably, your product_add.cfm page adds a product using ajax post? if so, the callback function should receive the id of newly added product and then call the url() method on the other tabs (and maybe load() method as well - can't remember now if just setting a new url reloads the tab or not...) Where do you put the callback funtion? In the product_add.cfm page? Or the parent tabs.cfm page? I'm a little mixed up. Thanks for the help, Will ~| 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:323103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: replace width/height values in youtube script
ah i found the prob. put this at top of function: cfset var new_string = arguments.markup and the rereplace becomes: cfset new_string = REReplaceNoCase(new_string, '#patterns[idx]#', '#replacements[idx]#', 'All') ~| 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:323104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: jQuery Guru guidance needed....
a safe bet would be to define all your js in the main page (tabs.cfm). but particulars depend on your code... how are you submitting your add product form? are you using jquery (i.e. $.ajax or $.post) or are you using cf8 built-in ajax features (cfajaxproxy or ColdFusion.Ajax.submitForm())? Here's what I have so far. It still isn't quite working properly. tabs.cfm: script $(document).ready(function() { $(#productAdmin).tabs(); }); /script product_add.cfm: script type=text/javascript src=/admin/js/jquery.form.js/script cfoutput script type=text/javascript var id = #variables.lastprodID# $(document).ready(function() { //cfoutputalert(#variables.lastprodID# yo yo!);/cfoutput $('##addprod').ajaxForm(function() { $(##productAdmin).tabs('url', 1, 'productBuilder-Categories.cfm?id=' + id); //$(##productAdmin).tabs('load', 2); }); }); /script cfform name=addprod id=addprod action=processProd.cfm. inputs here... processProd.cfm has all the form processing code. How do I get the lastProdId back into the tab pages for use there? Man, I have no idea what I'm doin. Thanks, Will ~| 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:323105 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error register asp.net web service in CF 7 admin
I got the Could not generate stub objects for web service invocation.as I posted before when I directly invoke the web service without pre register it in CF Admin. Based on your original error: Could not generate stub objects for web service invocation. Name: http:///xxx.asmx?wsdl. WSDL: http:///xxx.asmx?wsdl. org.xml.sax.SAXException: Fatal Error: URI=null Line=11: The element type META must be terminated by the matching end-tag it looks like there's a problem with the file that CF's bringing back. Can you post a copy here? 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! ~| 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:323106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: jQuery Guru guidance needed....
Man, I have no idea what I'm doin. hehe, i often feel that way, too :) i do not know what your processProd.cfm exactly does and what it returns, but it MUST return the new product ID. in its simplest form, make sure that your processProd.cfm does not return anything but the new product id (no validation errors, nothing). stick all your code inside cfsilent block and cfoutput the new product id after it. your form processing javascript will then look something like this: var options = { url: 'processProd.cfm', dataType: 'json', success: function(res) { var id = eval(res); $(#productAdmin).tabs('url', 1, 'productBuilder-Categories.cfm?id=' + id); } }; $('#addprod').submit(function() { $(this).ajaxSubmit(options); return false; }); Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 03/06/2009 10:26, Will Tomlinson wrote: a safe bet would be to define all your js in the main page (tabs.cfm). but particulars depend on your code... how are you submitting your add product form? are you using jquery (i.e. $.ajax or $.post) or are you using cf8 built-in ajax features (cfajaxproxy or ColdFusion.Ajax.submitForm())? Here's what I have so far. It still isn't quite working properly. tabs.cfm: script $(document).ready(function() { $(#productAdmin).tabs(); }); /script product_add.cfm: script type=text/javascript src=/admin/js/jquery.form.js/script cfoutput script type=text/javascript var id = #variables.lastprodID# $(document).ready(function() { //cfoutputalert(#variables.lastprodID# yo yo!);/cfoutput $('##addprod').ajaxForm(function() { $(##productAdmin).tabs('url', 1, 'productBuilder-Categories.cfm?id=' + id); //$(##productAdmin).tabs('load', 2); }); }); /script cfform name=addprod id=addprod action=processProd.cfm. inputs here... processProd.cfm has all the form processing code. How do I get the lastProdId back into the tab pages for use there? Man, I have no idea what I'm doin. Thanks, Will ~| 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:323107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4