This one time, at band camp, Phillip Tricoli said:
PT>
PT>
PT>How would we map the following xml file listed below into a database
PT>table with the following table layout.
PT>
PT>
PT>
PT>Table Name = Category
PT>
PT>Column = Description (where value is Tow or Spill)
PT>
PT>Column = Type (where value is car, Heavy Duty, flatbed or Gasoline,
PT>diesel, Oil)
PT>
PT>Column = Details (details value)
PT>
PT>
PT>
PT> How do we do this with out creating a mapping for each element (that
PT>is get the value Tow or heavy_duty) into the column type?
PT>
PT>We do not want to do a transform if possible and we don't want to have
PT>separate tables for each class of Category.
PT>
PT>So basically we want the element to be a value in are table like one
PT>normally does for attributes
Phillip,
You could map to a table whose field types are all of type varchar. Then
the values in the all columns of the table would be Strings. The downside
to this is that your app will need to parse each String to determine what
it is rather than relying upon the database to do what it's good at -
querying based on contents of the column(s).
Bruce
--
perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
