A few issues on Torque's (little-known?,little-used?) XML data dump/load.
1. Who would freak if I suggested changing the dump output format from:
<tablename col1="..." col2="..." ... colN="..."/>
to
<tablename >
<col1>...</col1>
<col2>...</col2>
...
<colN>...</colN>
</tablename>
The main reason here is that for any non-trivial database, you're
gonna need to escape XML-ish characters in the column values. It's nice
to have either entity-escapes (&<entity>;) _and_ CDATA in the outputted
XML. With the current scheme, since you can't use CDATA escapes in
attribute values, all you're able to use is entity-escapes.
I will do this work but before I do it and submit patch, I need to
see if tomatoes get thrown at me :)
2. Conversely, does anyone know if SQL database have "standard" escape
quotes on INSERT statements? for example:
embeded quotes:
insert into foo values('Hello World my name is \"Buddy\"')
thanks,
russ
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
