if sql support xs:time in schema: http://orbeon.org/oxf/xml/sql

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

if sql support xs:time in schema: http://orbeon.org/oxf/xml/sql

Zhou, Kevin
hi  guys
 
who could tell me if up to date the xs:time could be supported within http://orbeon.org/oxf/xml/sql
 
because my column is type of time in the mysql database ,my codes in my xpl file as followed:
 
...
<sql:result-set xmlns:sql="http://orbeon.org/oxf/xml/sql">
<sql:row-iterator>
      <contact>
 <id>
     <sql:get-column type="xs:int" column="id"/>
 </id>
 <time>
     <sql:get-column type="xs:time" column="time"/>
 </time>
 <date>
     <sql:get-column type="xs:date" column="date"/>
 </date>
 <title>
     <sql:get-column type="xs:string" column="p_title"/>
 </title>
 <first-name>
     <sql:get-column type="xs:string" column="p_firstname"/>
 </first-name>
 <last-name>
     <sql:get-column type="xs:string" column="p_surname"/>
 </last-name>
 <company>
     <sql:get-column type="xs:string" column="p_company"/>
 </company>
 <position>
     <sql:get-column type="xs:string" column="p_position"/>
 </position>
 <address-1>
     <sql:get-column type="xs:string" column="c_address1"/>
 </address-1>
 <address-2>
     <sql:get-column type="xs:string" column="c_address2"/>
 </address-2>
 
</contact>
</sql:row-iterator>
</sql:result-set>
...
 
 
 
 
Once i run to here ,it always pop the exception that the bad type below.

Error attribute "type" has a bad value(schema: http://orbeon.org/oxf/xml/sql)


Who can help me to cross that ,thanks ahead.
 
cheers
 
 
kevin
 
 


This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding.



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws