Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What framework should I Use ?
Message
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01079797
Message ID:
01081027
Views:
19
>>
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform