Bruno Desthuilliers <[EMAIL PROTECTED]>
wrote in news:[EMAIL PROTECTED]:
> dcleaner a écrit :
>> hi there...i'm a begginer level user and i've stumbbled upon a
>> problem a bit beyond my knowledge. i hope that somebody will be able
>> to help me with my problem...
>>
>> the problem is: i'm transforming an Access database to XML
>
> Strange idea IMHO, but anyway...
>
>> with some
>> adjustements. basicaly i have one main table in which i have my main
>> data and keys to other tables containing other relevant data.
>> after exporting my main table to xml i have in some tags only keys to
>> other tables. and now i want to change those keys to meaningful data.
>> for instance: after exporting, i have a line like this:
>> 1, and i want to change it to be just an opening tag for
>> something else; .the data which must be
>> written in attr1 and attr2 depends upon the number (in this case
>> number 1) inside the tag (tagZ).
>
> And where's your problem exactly ?-)
>
> More seriously: you don't explain how you export your database to XML,
> so it won't be easy to help.
>
> What I'd personnaly do would be to use the db-api (or whatever
> appropriate for accessing a .mdb) and a templating system (like genshi
> or mako or...) to build the xml file. In which case there's no problem
> accessing the related tables (that's what SQL is for, isn't it ?).
>
> Now if you hope to get some serious help, you probably want to give
> more details...
>
the tool i used to transform from mdb to xml was the microsoft's access itself
(2007
version). i only exported one table for now which is my main table, from the
others i
want to extract data so that i could put in inside the newly formed xml. hmm...
in
short i want to have everything in one xml file...
about sql database... i'm using xml because i want it to be able to run offline.
--
http://mail.python.org/mailman/listinfo/python-list
