Re: ASP, Delphi and XML help

Hi Mike,

Thanks for the tip. I've never created an ActiveX with Delphi yet but I'll
give it a try.

Thanks again.

Andy

"Mike Shkolnik" <mshkolnik2002@xxxxxxx> wrote in message
news:4640d3f7@xxxxxxxxxxxxxxxxxxxxxxxxx
Andy,

you need create the ActiveX control in Delphi where you'll connect to your
database, convert the resultset to xml (using SMExport). In your ASP
you'll
call the method of your ActiveX and return the xml as response for
ASP-page

The same for data load - you'll send your xml-string as parameter for
ActiveX's method (caled from ASP page) which will import your xml to
database

--
With best regards, Mike Shkolnik
Scalabium Software
http://www.scalabium.com
mshkolnik@xxxxxxxxxxxxx

"Andy" <andy@xxxxxxxxx> wrote in message
news:463fb2aa@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Mike,

Thanks for the good response. I have both SMExport and SMImport. Do you
have
any tips on how to pass the XML to and from an ASP page? I would like to
actually query the database using ASP and return the results in XML for
my
Delphi application and also to be able to send an XML from my Delphi
application back to ASP. I think I can handle the Delphi side, just not
sure
how to do it in ASP. Any resource or tip on this is greatly appreciated.

Thanks again Mike.

Andy
"Mike Shkolnik" <mshkolnik2002@xxxxxxx> wrote in message
news:463f6f5d@xxxxxxxxxxxxxxxxxxxxxxxxx
Andy,

you may create the xml from dataset using our SMExport suite:
http://www.scalabium.com/sme

To parse the xml in Delphi and load to dataset you may using our
SMImport
suite
http://www.scalabium.com/smi

Both suites works in server-side environments

Also you may check the sample project in DEMOS\XMLExchange directory
(included in SMExport archive)
--
With best regards, Mike Shkolnik
Scalabium Software
http://www.scalabium.com
mshkolnik@xxxxxxxxxxxxx

"Andrew Diabo" <andy@xxxxxxxxx> wrote in message
news:463e59b9@xxxxxxxxxxxxxxxxxxxxxxxxx
I am tring to query a database in ASP and obtain the results in XML
using
something like TacHTTP or similar component. How do I output to XML in
ASP
and parse it in Delphi from the TacHTTP component? If anyone has done
something like this, I would appreciate any help or resource on how to
do
this.

Thanking you in advance.

Andy










.

Relevant Pages

  • Database application using XML
    ... I am doing very basic transfer of data and the workhorse is actually in the ASP itself. ... How do I configure SQL Server, ASP and Delphi to work in XML? ... Delphi runs 'SearchRecords.asp' using the TacHTTP/TWebPost component by a defined URL ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: ASP, Delphi and XML help
    ... I have both SMExport and SMImport. ... any tips on how to pass the XML to and from an ASP page? ... Delphi application and also to be able to send an XML from my Delphi ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: XSD to Pascal Objects?
    ... only for Delphi users, and Delphi users of XML at that, we're talking about ... A recordset field can be another, ... Then, when you save the top-level recordset as an XML file, it saves ... got my read/write hierarchical data structure. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Those requirements just get weirder :-)
    ... >> programming ability between individuals, something of the order of 10:1 ... and Ian is right in anothe respect - what does four years ... except Delphi, but all the rest I can make work to a more than acceptable level. ... Now I'm writing stuff in C# against a MySQL database with XML, ...
    (uk.consultants)
  • Re: XML stylesheet editor
    ... look for XML). ... > dataset in Word using stylesheet .dot). ... Is there a native Delphi VCL component or Axtivex ...
    (borland.public.delphi.thirdpartytools.general)