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=lists&body=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=lists&body=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=lists&body=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=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to