Re: Getting article aid (giving or not givingpubid) via the title

Thanx mike.
To be more specific:

> 1) regarding SQLXML
>
> If I understand correctly, is that yet another way to communicate using
> XML, next to SOAP and XML-RPC ? XML-RPC support is somewhat
> functional (cfr. blogger API for instance), SOAP support is rudimentary
> but perhaps it might make sense adding SQLXML support as well
> someday ?

I've developed an interface, based on HTTP calls allowed by MS-SQL+IIS5 xml
templating system (SQLXML). I use it to interface an already existing ERP
system (with storedprocs, storedfunctions and other funny capabilities). The
XML returned is parsed by a Sablotron XSLT parser
(--enable-xslt --with-xslt-sablot in compiling PHP). Parsing is done
producing a string consisting in simple PHP code (in Xaraya, a populated
$items array), that is on-the-fly eval(uated), then returned to the xaraya
USER call.
so the sequence is
module user call->module API call->XML http call->XSLT
transformation->evaluation->module user return->...

SQLXML calls, transformations, debugging ETC are done with a simple class.
Further, I've added to this class a simple cache system (which can be
implemented in the filesystem or with xarSession variables) in order to
reduce remote calls.
It's very intersting, because Web and SQL server are completely decoupled.
The WEB server can be VLAN connected with SQL server, or behind the
firewall.
In my systems, Web server +php code (Xaraya) are under LINUX, SQL server
under W2000.
SQLXML is very interesting and simple to use. It transforms SQL results
(from queries of every type stored in a template) in valid XML, and is
executed/returned via a normal HTTP call with parameters.
In the future a more standard SOAP interface will be interesting, but I
don't know it very well.
The complete system runs very well, and it's very stable.

> 2) about retrieving an article by title
>
> I'm not sure why you could have the title available but not the aid.
> After all, even with syndication, you can retrieve the aid from the
> URL if necessary.

This is the point. XML results came from another data source, completely
decoupled.
If I have to interface, for example, a product name
("PIPPO PC SERVER")
with an article, how to connect the name ("PIPPO PC SERVER") with an AID?
My hope:
1) with the title (+pubid)
Your response:
2) with a search

Another problem is about a simple help module that I want to develop.
In a Xaraya user function call I always have the follwing variables:
Module
Function
(other vars)
If I want to build a generic article Hook capable of retrieving an article
(Topic Help) for every Xaraya function, I have to join articles using these
variables. No AID. ;-)

In every case, thanks for your reply.
If you are interested in SQLXML, Sablotron etc, here I am: feel free to
contact me, even at my personal email
[email protected]

> Anyway, there's no separate API function to retrieve an article aid
> by title at the moment (no need for it), but you could use the generic
> search function if you want. Or if you really need that functionality
> for [whatever], you can always add another API function in there :-)
>
> Mike.
>
The last is probably the best.
Bye
Federico