On Dec 21, 2004, at 10:23 PM, Simon Carter wrote:

>
>> I was actually concerned about mixing free form text (like
>> sql statement) with having a tag (like <Row>) on the same
>> level. Wouldn't the following be more appropriate or standard:
>>
>> <Table>
>> <sql>SELECT * FROM ...etc.</sql>
>> <Row>
>> ...etc.
>> </Row>
>> </Table>
>
> Its not free text it's the text for the <table> node which is valid, I
> can
> see where your coming from though :-)

It is legal xml, but it is the dread mixed content which virtually
eliminates the possibility of meaningful validation. Any of the
possibilities of putting the sql in an element will save you endless
headaches down the road.

david jencks

>
> When I wrote it, it was for a specific internal purpose, I will look at
> changing it though, but probably to something like:
>
> <table>
> <source type="sql">
> SELECT ....
> </source>
> <rows>
> <row>
> ...
> </row>
> <row>
> ...
> </row>
> </rows>
> </table>
>
> Rgds
>
> Si Carter
> TECT Software Ltd
> http://www.tectsoft.net/
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>