Re: sending a form through CF and catching the results
> > There is no sensible reason for requiring CSV conversion to go via HTTP - > since the vast majority of the time this isn't necessary/desired - having > a dedicated cfcsv tag and/or CsvParse function would have made sense. Yup, I totally agree with that. Guess I misread the emphasis in your previous comment. -- Josh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336621 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
Josh, you're missing the point entirely. Converting from CSV->Query makes sense and wasn't being questioned. Using the cfhttp tag to do the conversion is what's crazy. There is no sensible reason for requiring CSV conversion to go via HTTP - since the vast majority of the time this isn't necessary/desired - having a dedicated cfcsv tag and/or CsvParse function would have made sense. As I said, we'd need to ask the relevant developers why the decision to tangle the CSV functionality with cfhttp was made. (Rick, I used "Adobe" as shorthand; not to exclude Macromedia or Allaire.) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336610 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: sending a form through CF and catching the results
> Actually, it's probably something only someone from the Allaire days > could tell us. My guess would be that since they had the cfquery functions already, it's easier to just turn the CSV into a query and use that existing functionality, than to write a bunch of similar functions specifically for CSV's. -- Josh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
On Wed, Aug 25, 2010 at 12:07 PM, Peter Boughton wrote: > > (The columns attribute is part of cfhttp's csv parsing ability. Why cfhttp > does CSV parsing instead of having dedicated CSV functions is something only > Adobe can tell us.) Actually, it's probably something only someone from the Allaire days could tell us. rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
Hey William, I did try that. It didn't help, but thank you. > try changing the value in your script from "SPHL-School of Public > Health" to "20" ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336590 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: sending a form through CF and catching the results
The page you are trying to hit with cfhttp is expecting a numeric value for 'di_20156'. try changing the value in your script from "SPHL-School of Public Health" to "20" William -- William E. Seiter On Aug 26, 2010, daniel kessler wrote: >Seems like the error isn't really giving much help. > > >Can you get full debugging from that error on jobs.cfm? >Can we see the code on and around line 346 of jobs.cfm? How would I get the full error? The code on and around 346 is the block of code that I posted last. https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp"; columns="di_0_20156" name="blah" port="443" > Line 346 is the: though as pointed out earlier, the value should be "20" ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336583 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
Though I still have hope, I'm starting to think that this is a wasted effort, because I think it's working off a timed session and that Timestamp is constantly changing. I suspect that's the reason for the 302 error. I can ask them to provide a query just for me, but the chance of it being done is really remote. It's a different unit in the University with their own deadlines and responsibilities. Thank you for your thoughts. > It returns a 302 instead of search results - probably because there's > still some missing fields or it doesn't like the windowTimestamp or > whatever. > > > But all of this seems to be a waste of effort - is there a reason you > can't just ask the guys who created this to do one specifically for > your department? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336571 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
>Seems like the error isn't really giving much help. > > >Can you get full debugging from that error on jobs.cfm? >Can we see the code on and around line 346 of jobs.cfm? How would I get the full error? The code on and around 346 is the block of code that I posted last. https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp"; columns="di_0_20156" name="blah" port="443" > Line 346 is the: though as pointed out earlier, the value should be "20" ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
Oh and name is incorrect attribute too. Should be result to change the default 'cfhttp' variable name. There's a lot of hidden fields you probably need to pass in - here's some code that will get you a step closer. (Note how the cfhttp tag only has URL and METHOD attributes - nothing else is needed for standard behaviour like this.) https://jobs.umd.edu/applicants/Central";> The URL I'm using there is taken from the form's action attribute. It returns a 302 instead of search results - probably because there's still some missing fields or it doesn't like the windowTimestamp or whatever. But all of this seems to be a waste of effort - is there a reason you can't just ask the guys who created this to do one specifically for your department? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
Seems like the error isn't really giving much help. Can you get full debugging from that error on jobs.cfm? Can we see the code on and around line 346 of jobs.cfm? - Jason "feed me moar web2 loafmeat" From: "daniel kessler" Sent: Wednesday, August 25, 2010 11:48 AM To: "cf-talk" Subject: Re: sending a form through CF and catching the results Howdy Jason, I'm having significant trouble making this work. I'm going through, trying to simplify it as I go. Here's the current state of the code: https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp " columns="di_0_20156" name="blah" port="443"> I'm receiving an error with no description. http://sph.umd.edu/test/error_display.jpg Also, what if I don't know the columns to be returned and just want whatever it gives me? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
Don't specify the columns attribute, it is not needed, and obviously doesn't work. (The columns attribute is part of cfhttp's csv parsing ability. Why cfhttp does CSV parsing instead of having dedicated CSV functions is something only Adobe can tell us.) Use the cfhttpparam tags to send through formfields. If you don't know what form fields there are, load the first page with cfhttp (where the form is), run the results through a HTML parser (you can use XmlParse if it's valid XHTML) and extract a list of fields to send with the second cfhttp request. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
Howdy Jason, I'm having significant trouble making this work. I'm going through, trying to simplify it as I go. Here's the current state of the code: https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp"; columns="di_0_20156" name="blah" port="443"> I'm receiving an error with no description. http://sph.umd.edu/test/error_display.jpg Also, what if I don't know the columns to be returned and just want whatever it gives me? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336510 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re: sending a form through CF and catching the results
Yes, CFHTTP is your buddy here. Just enter the actual column names that are coming back in your search query in the 'columns' attribute, and try this: https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp " port="443" name="mySearchQuery" columns="whatever,columns,are,coming,back,from,search"> - Jason "feed me moar web2 loafmeat" From: "daniel kessler" Sent: Wednesday, August 25, 2010 9:35 AM To: "cf-talk" Subject: sending a form through CF and catching the results I want to send a form through CF, without the user entering anything, to the this page: https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp I would like it to display particular results, so I would have to also send it a field with a value in it. I wish to do this through code only without the user participating. Then, I would like to catch the results, parse that out and display it on another page. Is this possible? Is it somehow done through cfhttp? That look promising, but I didn't know how to send over field information too. I want the college/division field to only search for the information "SPHL - School of Public Health" to get our job listings. Thank you for any assistance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
sending a form through CF and catching the results
I want to send a form through CF, without the user entering anything, to the this page: https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp I would like it to display particular results, so I would have to also send it a field with a value in it. I wish to do this through code only without the user participating. Then, I would like to catch the results, parse that out and display it on another page. Is this possible? Is it somehow done through cfhttp? That look promising, but I didn't know how to send over field information too. I want the college/division field to only search for the information "SPHL - School of Public Health" to get our job listings. Thank you for any assistance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm