Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What framework should I Use ?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
01079797
Message ID:
01081027
Vues:
18
>>
>>You don't need anyhing special - you can connect with OLEDB - you can connect with XML messaging. You can connect with ASP and ADO. It's no big deal.
>>
>>You don't need anything. VFP and your skills will do the job!
>
>Do have some sample code you could share? Old programmer's like me are new to ADO/ASP...

For some ADO - you can check out download #9840 (ADO Query Analyzer). I try not to use it - I just connect to ASP pages - send them an XML - and let them do it!
Here is a VFP GUI procedure making a request to an ASP:
lcURL=[http://www.mydomain.com/relay1.asp]
oHTTP=NewOBJECT("MSXML2.XMLHTTP")
oHTTP.open([POST],lcURL,.f.)
oHttp.setRequestHeader("Content-Type", "text/xml")
oHttp.send(lcSendXMLBody) && an XML string
Here is the ASP that receives it:
dim oXML<pre>
set oXML = Server.CreateObject("Msxml2.DOMDocument")
oXML.async = false
oXML.resolveExternals = false
oXML.load(Request)
cBody=""
dim oItems
set oItems=oXML.selectSingleNode("row") 
cName=oItems.selectSingleNode("name").text
cMailTo=oItems.selectSingleNode("mailto").text
cBlindTo="<" & oItems.selectSingleNode("blindto").text & ">"
cSubject=oItems.selectSingleNode("subject").text
cBody = cBody & oItems.selectSingleNode("status").text
cNameMail=cName &" <" & cMailTo & ">"
' .. the mailer routine uses these vars later in the SP
I have even done the same thing with VFP MTDLL and foxISAPI. The "claim" is that XML messaging is the "glue" of the internet. It cannot be overstated how important it is to get a good understanding of DOM (xml node collections) and messaging. With those objects all desktop programming languages can be web-enabled. The playing field has leveled.

I would say ADO is not as important as XML - ADO ASP templates are available through google (let the ASP shop write it - but it's not hat hard. XML - and XML beyond the vfp XML/cursor services - is very important - learning to navigate nodes and working with X-Path cannot be over stated.
Imagination is more important than knowledge
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform