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 > > <ot>Strange idea IMHO, but anyway...</ot> > >> 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: >> <tagZ>1</tagZ>, and i want to change it to be just an opening tag for >> something else; <tagQ attr1="xx" attr2="yy">.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
