RE: Need help with CFHTTP
I would get rid of the NAME and delimeter attributes and try simply getting the file first. Does that work? Can you get the raw contents of the file (without putting it into a query). Also, is the Cfhttp actually pointed at a filename? Or does it point to a cfm page that delivers up the file? If the latter, it could be that you need a POST request with Cfhttpparams. -mk -Original Message- From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 2:57 PM To: CF-Talk Subject: Need help with CFHTTP Hello, Last week I asked about a CFFILE issue and was advised to use CFHTTP to read files from a remote server. Now I am trying to make this work but with no success yet. Unfortunatelly, this is on an intranet and I am not able to give you the link, but I will try to explain what is happenening. received_plans_test.cfm (similar to http://webapps1.hud.gov/pih/pha/plans/received/received_plans.cfm) sends a form to received_plans_test.cfm (similar to http://webapps1.hud.gov/pih/pha/plans/received/view_received.cfm) The form sends whatever field office, plan type, fiscal year and beginning quarter is selected from a set of drop-down menus. Depending on the fiscalyear selected in page1.cfm, page2.cfm is supposed to read a text file and expose its content sorted one way or another. Here is the error message I am getting: Error Diagnostic Information CFHTTP The error occurred while processing an element with a general identifier of (CFHTTP), occupying document position (449:11) to (450:111) in the template file /home1/web-docs-80/pih/pha/received/view_received_test.cfm. Date/Time: Mon Sep 23 15:52:49 2002 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95; YComp 5.0.0.0) Remote Address: 10.200.36.101 HTTP Referrer: http://www2.hud.gov/pih/pha/received/received_plans_test.cfm Here is the piece of code between lines 449 and 450: cfhttp method=get name=PHAPlansQuery URL=http://www.hud.gov/offices/pih/pha/received/#fiscalyear#/#fieldoffice#- #fiscalyear#.txt delimiter=; /cfhttp What is wrong? Thanks in advance for your help, Mitko __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need help with CFHTTP
well first off the only two valid characters for the delimiter are a tab or comma and you are using a semi-colon. Here is the excerpt from CF Help: GET file into a query -- To download a file in a ColdFusion page so that a query can be built using the file, the file must be either comma-separated or tab-delimited. Although risky, text qualification may be omitted. The file will be parsed and an appropriate query built from it. Columns may be specified in the attribute list so that the client can override the columns specified in the file. There is error checking within the tag that prevents a user from either entering an invalid column name or using an invalid column name that was specified in the original file. If such an illegal filename is encountered, the illegal characters are stripped. Such action could produce duplicate column names, so duplicate columns are renamed and inserted into the query header. The query has all of the functionality of a standard CFQUERY object. +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis Let's Roll - Todd Beamer, Flight 93 -Original Message- From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 12:57 PM To: CF-Talk Subject: Need help with CFHTTP Hello, Last week I asked about a CFFILE issue and was advised to use CFHTTP to read files from a remote server. Now I am trying to make this work but with no success yet. Unfortunatelly, this is on an intranet and I am not able to give you the link, but I will try to explain what is happenening. received_plans_test.cfm (similar to http://webapps1.hud.gov/pih/pha/plans/received/received_plans.cfm) sends a form to received_plans_test.cfm (similar to http://webapps1.hud.gov/pih/pha/plans/received/view_received.cfm) The form sends whatever field office, plan type, fiscal year and beginning quarter is selected from a set of drop-down menus. Depending on the fiscalyear selected in page1.cfm, page2.cfm is supposed to read a text file and expose its content sorted one way or another. Here is the error message I am getting: Error Diagnostic Information CFHTTP The error occurred while processing an element with a general identifier of (CFHTTP), occupying document position (449:11) to (450:111) in the template file /home1/web-docs-80/pih/pha/received/view_received_test.cfm. Date/Time: Mon Sep 23 15:52:49 2002 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95; YComp 5.0.0.0) Remote Address: 10.200.36.101 HTTP Referrer: http://www2.hud.gov/pih/pha/received/received_plans_test.cfm Here is the piece of code between lines 449 and 450: cfhttp method=get name=PHAPlansQuery URL=http://www.hud.gov/offices/pih/pha/received/#fiscalyear#/#fieldoffice#- #fiscalyear#.txt delimiter=; /cfhttp What is wrong? Thanks in advance for your help, Mitko __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need help with CFHTTP
In fact, by adding the textqualifier attribute I am now able to see the content of the text file: cfhttp method=get name=PHAPlansQuery URL=http://www.hud.gov/offices/pih/pha/received/#fiscalyear#/#fieldoffice#-#fiscalyear#.txt; delimiter=; textqualifier= And yes, it is pointing to a real text file which in fact contains HTML tables already. Long story why and how -- it comes from a VB application someone built long time ago. I am not supposed to take this text file and sort its content. I might get back with more questions :-) Thanks, Mitko -- Original Message -- From: Mark A. Kruger - CFG [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 23 Sep 2002 15:09:34 -0500 I would get rid of the NAME and delimeter attributes and try simply getting the file first. Does that work? Can you get the raw contents of the file (without putting it into a query). Also, is the Cfhttp actually pointed at a filename? Or does it point to a cfm page that delivers up the file? If the latter, it could be that you need a POST request with Cfhttpparams. -mk -Original Message- From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 2:57 PM To: CF-Talk Subject: Need help with CFHTTP Hello, Last week I asked about a CFFILE issue and was advised to use CFHTTP to read files from a remote server. Now I am trying to make this work but with no success yet. Unfortunatelly, this is on an intranet and I am not able to give you the link, but I will try to explain what is happenening. received_plans_test.cfm (similar to http://webapps1.hud.gov/pih/pha/plans/received/received_plans.cfm) sends a form to received_plans_test.cfm (similar to http://webapps1.hud.gov/pih/pha/plans/received/view_received.cfm) The form sends whatever field office, plan type, fiscal year and beginning quarter is selected from a set of drop-down menus. Depending on the fiscalyear selected in page1.cfm, page2.cfm is supposed to read a text file and expose its content sorted one way or another. Here is the error message I am getting: Error Diagnostic Information CFHTTP The error occurred while processing an element with a general identifier of (CFHTTP), occupying document position (449:11) to (450:111) in the template file /home1/web-docs-80/pih/pha/received/view_received_test.cfm. Date/Time: Mon Sep 23 15:52:49 2002 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95; YComp 5.0.0.0) Remote Address: 10.200.36.101 HTTP Referrer: http://www2.hud.gov/pih/pha/received/received_plans_test.cfm Here is the piece of code between lines 449 and 450: cfhttp method=get name=PHAPlansQuery URL=http://www.hud.gov/offices/pih/pha/received/#fiscalyear#/#fieldoffice#- #fiscalyear#.txt delimiter=; /cfhttp What is wrong? Thanks in advance for your help, Mitko __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need help with CFHTTP
If the text file contains HTML, then it is not an appropriate choice for the use of the NAME and delimiter. Name/delimeter/texqualifiers are used to convert a correctly formatted tab or comma separated file into a query. To convert an HTML table into a query you are going to have to use regex. -mk -Original Message- From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 3:27 PM To: CF-Talk Subject: RE: Need help with CFHTTP In fact, by adding the textqualifier attribute I am now able to see the content of the text file: cfhttp method=get name=PHAPlansQuery URL=http://www.hud.gov/offices/pih/pha/received/#fiscalyear#/#fieldoffice#- #fiscalyear#.txt delimiter=; textqualifier= And yes, it is pointing to a real text file which in fact contains HTML tables already. Long story why and how -- it comes from a VB application someone built long time ago. I am not supposed to take this text file and sort its content. I might get back with more questions :-) Thanks, Mitko -- Original Message -- From: Mark A. Kruger - CFG [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Mon, 23 Sep 2002 15:09:34 -0500 I would get rid of the NAME and delimeter attributes and try simply getting the file first. Does that work? Can you get the raw contents of the file (without putting it into a query). Also, is the Cfhttp actually pointed at a filename? Or does it point to a cfm page that delivers up the file? If the latter, it could be that you need a POST request with Cfhttpparams. -mk -Original Message- From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 2:57 PM To: CF-Talk Subject: Need help with CFHTTP Hello, Last week I asked about a CFFILE issue and was advised to use CFHTTP to read files from a remote server. Now I am trying to make this work but with no success yet. Unfortunatelly, this is on an intranet and I am not able to give you the link, but I will try to explain what is happenening. received_plans_test.cfm (similar to http://webapps1.hud.gov/pih/pha/plans/received/received_plans.cfm) sends a form to received_plans_test.cfm (similar to http://webapps1.hud.gov/pih/pha/plans/received/view_received.cfm) The form sends whatever field office, plan type, fiscal year and beginning quarter is selected from a set of drop-down menus. Depending on the fiscalyear selected in page1.cfm, page2.cfm is supposed to read a text file and expose its content sorted one way or another. Here is the error message I am getting: Error Diagnostic Information CFHTTP The error occurred while processing an element with a general identifier of (CFHTTP), occupying document position (449:11) to (450:111) in the template file /home1/web-docs-80/pih/pha/received/view_received_test.cfm. Date/Time: Mon Sep 23 15:52:49 2002 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95; YComp 5.0.0.0) Remote Address: 10.200.36.101 HTTP Referrer: http://www2.hud.gov/pih/pha/received/received_plans_test.cfm Here is the piece of code between lines 449 and 450: cfhttp method=get name=PHAPlansQuery URL=http://www.hud.gov/offices/pih/pha/received/#fiscalyear#/#fieldoffice# - #fiscalyear#.txt delimiter=; /cfhttp What is wrong? Thanks in advance for your help, Mitko __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need Help for cfhttp
Look at cfx_http in the taggallery... Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 2:50 PM To: CF-Talk Subject: Need Help for cfhttp Hi, I have a cfm page that needs access to https site to get files back to my server, here is my problem and question. In order for me to get the file, I will need to login to https site first then click one submit form to get the file. I am able to use cfhttp to send username and password and Logon successful. BTW on the https site is use Servelt to verify username and password,the servelt is running on JRUN. But, in order for me to get the file, I will need to send another cfhttp to access the 2nd page, but it tells me that I am not logged on when I try to access the 2nd page. here is my questions: 1. when I use cfhttp to access to either http or https, is that a new instance to the server that I am try to access to it? 2. Actually, JRUN Server is the server that I am try to use cfhttp to get access to it, is there a way for me to use 2 cfhttp and it will knows that is one instance instead of 2 instances. Is there a way to catch the jrunsessionid and the value so I can attached that jrunsessionid and value on my 2nd cfhttp? Thank you for any suggestion YC I'm currently using CF Webstore, and also found that the site is currently down. Notwithstanding, the product appears to be well written and in its 4th iteration, fairly mature. Documentation is just fair - I'm struggling with some issues with customization (I wish we had access to a map of the files so we could see the interaction between files). I too use CrystalTech in Arizona for most of my hosting. Their support is top notch - I can get a live network support person in the server room any hour of the day, even 3 and 4 AM EDT, and they solve problems nearly immediately. They are also very responsive on email support as well. I will caution you, the CF Webstore (to use images) requires that the CFX_ImgInfo tag be put on the server (CrystalTech will charge you $10 per month to do it). Does someone with CF Webstore experience know how to use a CFModule call for this tag so that I can avoid having to place the custom tag in CF Admin? Thanks, Mark Leder -Original Message- From: Hawkins, Tim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 4:34 PM To: CF-Talk Subject: CF Shopping Cart Solution? Does anyone have experience with CF EZ CART or other CF based Shopping Cart software? Im a Mid-Level Developer who is looking for a shopping cart solution. Crystaltech www.crystaltech.com is a great ISP which has Cold Fusion in their most basic monthly plans but their standard Cart is Miva Merchant, which isn't currently very stable on 2000. Thanks in Advance. Tim Hawkins Web Developer Spectrum Astro Inc. www.spectrumastro.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists