RE: Re: CFHttp and Wddx posting for results only???
Thanks Sharon, How do i parse the page returned back(ie #cfhttp.filecontent#) to get only the results of the query. I would like to know, how can one Parse the info from a page without the forms fields and such. Appretiate it. Thanks Joe --- Original Message --- Sharon DiOrio [EMAIL PROTECTED] Wrote on Fri, 28 Apr 2000 10:50:04 -0400 -- You can use cfhttp and WDDX to query other sites, provided the other site is cooperating. Otherwise you're stuck with querying the site and parsing out all of the extraneous page information. A tedious process at best. Sharon At 09:30 AM 4/25/2000 -0700, [EMAIL PROTECTED] wrote: Hello all, I am Wondering whether is possible to use Cfhttp and Wddx to query other sites for information and return back just the results rather than site2's entire page. How do i know whether site2 allows use of Method="Post" of Cfhttp, How can i achive this?? Thank inadvance. Appretiate it Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHttp and Wddx posting for results only???
Sharon: How do you design sites that are XML/Wddx Friendly? Do you have someplace I can go to read about this? Andy -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Re: CFHttp and Wddx posting for results only???
Well, I can't give code because it's entirely dependent on the page that is returned. But I'd point you in the direction of regular expressions to do the job. It isn't for the faint of heart. There's a chapter on regular expressions in the Advanced CFWACK book and O'Reilly has an entire book dedicated to them. Sharon At 08:31 AM 4/28/2000 -0700, [EMAIL PROTECTED] wrote: Thanks Sharon, How do i parse the page returned back(ie #cfhttp.filecontent#) to get only the results of the query. I would like to know, how can one Parse the info from a page without the forms fields and such. Appretiate it. Thanks Joe --- Original Message --- Sharon DiOrio [EMAIL PROTECTED] Wrote on Fri, 28 Apr 2000 10:50:04 -0400 -- You can use cfhttp and WDDX to query other sites, provided the other site is cooperating. Otherwise you're stuck with querying the site and parsing out all of the extraneous page information. A tedious process at best. Sharon At 09:30 AM 4/25/2000 -0700, [EMAIL PROTECTED] wrote: Hello all, I am Wondering whether is possible to use Cfhttp and Wddx to query other sites for information and return back just the results rather than site2's entire page. How do i know whether site2 allows use of Method="Post" of Cfhttp, How can i achive this?? Thank inadvance. Appretiate it Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHttp and Wddx posting for results only???
www.wddx.org is the best place to start to understand what WDDX is and how it works. Then, start playing with it. cfquery name="myQuery" datasource="#APPLICATION.dsn#" maxRows="10" SELECT * FROM TableName /cfquery cfwddx action="CFML2WDDX" input="#myQuery#" output="myWDDX" cfoutput#HTMLCodeFormat(myWDDX)#/cfoutput Examine the output and you'll see what WDDX looks like. Now imagine a page that had nothing more than a query that produced a WDDX packet (no HTML, no extra whitespace, nothing.) Another server could use cfhttp to grab that page and using the same cfwddx tag turn it back into a query. If the WDDX page accepted form/url variables, you could even customize the query that populates the WDDX packet. But it's definitely a cooperative effort. Hope that helps. Sharon At 11:43 AM 4/28/2000 -0400, [EMAIL PROTECTED] wrote: Sharon: How do you design sites that are XML/Wddx Friendly? Do you have someplace I can go to read about this? Andy -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHttp and Wddx posting for results only???
Andy Three ways immediately come to mind (designed to be accessed by a program via something like CFHTTP): 1) A data-drop site (page)... one that returns a WDDX packet when the page as accessed. For example A Manufacturer creates a page which returns a WDDX packet containing a database query or a recordset of changes to its products database. Distributers can access the page with a program which uses the WDDX packet to update its own copy of the database. 2) A intelligent data-exchange site (page)... one that allows the visitor to make requests and receive WDDX packets containing the results of the requests. For example, a publisher allows other sites to republish articles. The republisher is provided with a program which can browse and mark articles to be retrieved from the publisher, When through, the republisher sends a request to retrieve the articles. The intelligent data-exchange page builds a custom WDDX packet containing only the requested articles (including content and markup). The republisher uses this WDDX packet to populate his database and/or web pages 3) An interactive site (page)... where WDDX packets are the medium of exchange, primarily because they easily handle complex data structures and special character content which would be prohibitive to handle by other means. The interactive database stub I described earlier in this thread, is an example of this... essentially a program on one site accessing a database on another. Any, or all of these WDDX-Friendly sites (pages) can require whatever security that the provider deems necessary - including, but not limited to: controlled access (cookie, login, IP address, etc.) time-limited window of availability unpublished site (page) address data encryption SSL transmission These are exactly the types of applications that WDDX was designed to address. An additional advantage, is that WDDX allows all of these interacting programs to be written in different languages (Perl, ASP, Java, JavaScript, C++, CF). WDDX is kind of the ultimate medium for data exchange: a XML packet contains A WXXX packet... ... this WDDX packet can contain arrays, structures, recordsets... and, yes, it can contain an XML packets which can contain HTH Dick At 11:43 AM -0400 4/28/2000, [EMAIL PROTECTED] wrote: Sharon: How do you design sites that are XML/Wddx Friendly? Do you have someplace I can go to read about this? Andy -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHttp and Wddx posting for results only???
Well said! That's exactly how to learn to do it! Dick At 2:05 PM -0400 4/28/2000, Sharon DiOrio wrote: www.wddx.org is the best place to start to understand what WDDX is and how it works. Then, start playing with it. cfquery name="myQuery" datasource="#APPLICATION.dsn#" maxRows="10" SELECT * FROM TableName /cfquery cfwddx action="CFML2WDDX" input="#myQuery#" output="myWDDX" cfoutput#HTMLCodeFormat(myWDDX)#/cfoutput Examine the output and you'll see what WDDX looks like. Now imagine a page that had nothing more than a query that produced a WDDX packet (no HTML, no extra whitespace, nothing.) Another server could use cfhttp to grab that page and using the same cfwddx tag turn it back into a query. If the WDDX page accepted form/url variables, you could even customize the query that populates the WDDX packet. But it's definitely a cooperative effort. Hope that helps. Sharon At 11:43 AM 4/28/2000 -0400, [EMAIL PROTECTED] wrote: Sharon: How do you design sites that are XML/Wddx Friendly? Do you have someplace I can go to read about this? Andy -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Re: CFHttp and Wddx posting for results only???
Joe If you don't have access to the other site to install a stub, then you will get whatever the other serves to the browser as if you visited the page and sublitted a form. The returned results can be parsed (usually with regexps). You usually must do a little detective work to determine how to pares... do some page requests display the source The Connection Failure problem may be a CF bug (especially CF 4.5) If you post your CFHTTP code, I'll try it on CF 4.0 Dick At 6:06 AM -0700 4/27/2000, [EMAIL PROTECTED] wrote: Thanks Dick, Can i accomplish this without having complete access to the other site. Lets say i wanted to check for a SpecificBusiness at NetWorkSolutions.com, Is it possible to get only the results back using the Method="Post". i tried this and i am getting a connection faliure error. Appretiate your help Thanks Joe --- Original Message --- Dick Applebaum [EMAIL PROTECTED] Wrote on Wed, 26 Apr 2000 21:08:53 -0700 -- Joe If you have access to the other site, you can install a stub program, then communicate with this stub via CFHTTP, passing WDDX packet(s) as form fields. So, for example Site A serializes a WDDX packet of an SQL query statements (to be issued on Site B) Site A passes this query to Site B via CFHTTP (invokes the stub) Sitw B deserializes the WDDX packet and issues the SQL Query against a dsn on site B. Site B Serializes the results of the SQL Query (record set) into a WDDX packet Site B returns this WDDX packet as the output of the CFHTTP request (from site A) Site A receives the WDDX packet in CFHTTP,FileContent Site A Deserializes the packet into a SWL query result (record set) Site A presents the Query to the user... I have done exactly this to move a large database (many related tables), piecemeal, form one web/SQL server to another web/SQL server. for example populate a (duplicate) table on Site A with a Query (Record set) from Site B It works amazingly well. HTH Dick At 10:26 PM -0400 4/27/2000, Joseph Eugene wrote: - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 25, 2000 12:30 PM Subject: CFHttp and Wddx posting for results only??? Hello all, I am Wondering whether is possible to use Cfhttp and Wddx to query other sites for information and return back just the results rather than site2's entire page. How do i know whether site2 allows use of Method="Post" of Cfhttp, How can i achive this?? Thank inadvance. Appretiate it Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHttp and Wddx posting for results only???
Thanks Dick, This is my sample code. CFHTTP URL="http://search.yahoo.com/bin/search?" Method="Post" CFhttpParam name="P" type="URL" value="Usa" /CFHTTP CFOUTPUT #cfhttp.filecontent#BR BR H3BThe mime-type:/B/H3BR #cfhttp.mimetype#BR H3BThe Status Code:/B/H3BR #cfhttp.statuscode#BR H3BThe Raw Header:/B/H3BR #cfhttp.header#BR /CFOUTPUT I can get this to work with Method="Get" and pass the parameter via Url. I downloaded the CFHTTP bug release for CF4.5 and its still saying Connection Failure, is there something wrong in the code? How can i return/Parse the results only from the returned(#cfhttp.filecontent#), if i can do this, thats pretty slick. Thanks a lot for your help. Appretiate it. Thanks Joe --- --- Original Message --- Dick Applebaum [EMAIL PROTECTED] Wrote on Thu, 27 Apr 2000 07:08:36 -0700 -- Joe If you don't have access to the other site to install a stub, then you will get whatever the other serves to the browser as if you visited the page and sublitted a form. The returned results can be parsed (usually with regexps). You usually must do a little detective work to determine how to pares... do some page requests display the source The Connection Failure problem may be a CF bug (especially CF 4.5) If you post your CFHTTP code, I'll try it on CF 4.0 Dick At 6:06 AM -0700 4/27/2000, [EMAIL PROTECTED] wrote: Thanks Dick, Can i accomplish this without having complete access to the other site. Lets say i wanted to check for a SpecificBusiness at NetWorkSolutions.com, Is it possible to get only the results back using the Method="Post". i tried this and i am getting a connection faliure error. Appretiate your help Thanks Joe --- Original Message --- Dick Applebaum [EMAIL PROTECTED] Wrote on Wed, 26 Apr 2000 21:08:53 -0700 -- Joe If you have access to the other site, you can install a stub program, then communicate with this stub via CFHTTP, passing WDDX packet(s) as form fields. So, for example Site A serializes a WDDX packet of an SQL query statements (to be issued on Site B) Site A passes this query to Site B via CFHTTP (invokes the stub) Sitw B deserializes the WDDX packet and issues the SQL Query against a dsn on site B. Site B Serializes the results of the SQL Query (record set) into a WDDX packet Site B returns this WDDX packet as the output of the CFHTTP request (from site A) Site A receives the WDDX packet in CFHTTP,FileContent Site A Deserializes the packet into a SWL query result (record set) Site A presents the Query to the user... I have done exactly this to move a large database (many related tables), piecemeal, form one web/SQL server to another web/SQL server. for example populate a (duplicate) table on Site A with a Query (Record set) from Site B It works amazingly well. HTH Dick At 10:26 PM -0400 4/27/2000, Joseph Eugene wrote: - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 25, 2000 12:30 PM Subject: CFHttp and Wddx posting for results only??? Hello all, I am Wondering whether is possible to use Cfhttp and Wddx to query other sites for information and return back just the results rather than site2's entire page. How do i know whether site2 allows use of Method="Post" of Cfhttp, How can i achive this?? Thank inadvance. Appretiate it Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com
Re: CFHttp and Wddx posting for results only???
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 25, 2000 12:30 PM Subject: CFHttp and Wddx posting for results only??? Hello all, I am Wondering whether is possible to use Cfhttp and Wddx to query other sites for information and return back just the results rather than site2's entire page. How do i know whether site2 allows use of Method="Post" of Cfhttp, How can i achive this?? Thank inadvance. Appretiate it Joe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.