Hi all, Just a query about whether there is a way to
stop events and formatting for the <xforms:repeat> in my application I’m
using the repeat to display data, nothing will change with the data and I don’t
need to monitor the users movement around repeat, nor do I need the yellow bar
for selection. I have used CSS to stop the formatting, but notice that OPS is
going back and forth when I click on the repeat. Is it possible to disable
this? Thanks Ryan Puddephatt Web Developer TFX Group Scotand EH54 7DP (
01506 407 110 7 01506 407 108 -- 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 |
Hi, I have some problems getting date typed data from a oracle DB (version 8 - 10) with ops3.0beta. In my opinion the oracle sql type "date" corresponds with the xs type "datetime". Ops3.0beta throws an error and expects xs:date type. But in this case, hours, minutes and seconds are cutted of. I remember that the mapping from sql type "date" to xs type xs:datetime was no problem. Is there a special reason of this behaviour, cause Oracle does not have a type datetime, only timestamp which is a variable datatype, as far as I know. Regards Sebastian -- 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 |
Administrator
|
In reply to this post by Ryan Puddephatt
Ryan,
There is currently no way to disable this. -Erik Ryan Puddephatt wrote: > Hi all, > > Just a query about whether there is a way to stop events and > formatting for the <xforms:repeat> in my application I’m using the > repeat to display data, nothing will change with the data and I don’t > need to monitor the users movement around repeat, nor do I need the > yellow bar for selection. I have used CSS to stop the formatting, but > notice that OPS is going back and forth when I click on the repeat. Is > it possible to disable this? > > > > Thanks > > > > *Ryan Puddephatt* > > Web Developer > > TFX Group > > 1 Michaelson Square > > Livingston > > West Lothian > > Scotand > > EH54 7DP > > > > * [hidden email] > > ( 01506 407 110 > > 7 01506 407 108 -- 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 |
Administrator
|
In reply to this post by Sebastian Kraus/INPLUS/DE
Hi Sebastian,
What is the exception you are getting? Also, can you send the section of the XPL file where you call the SQL processor? Alex On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote: > > Hi, > > > I have some problems getting date typed data from a oracle DB (version 8 - > 10) with ops3.0beta. > In my opinion the oracle sql type "date" corresponds with the xs type > "datetime". > Ops3.0beta throws an error and expects xs:date type. > But in this case, hours, minutes and seconds are cutted of. > I remember that the mapping from sql type "date" to xs type xs:datetime was > no problem. > > Is there a special reason of this behaviour, cause Oracle does not have a > type datetime, only timestamp which is a variable datatype, as far as I > know. > > Regards > > Sebastian > > > > -- > 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 > > > -- Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/ -- 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
--
Follow Orbeon on Twitter: @orbeon Follow me on Twitter: @avernet |
Hi Alex, I get following exeption: Illegal XML type for SQL type: {http://www.w3.org/2001/XMLSchema}dateTime, DATE the sql Prozessore call looks like this: <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql"> <p:input name="data" href="#data"/> <p:input name="config"> <sql:config> <sql:connection> <sql:datasource>mySource</sql:datasource> <sql:execute> <sql:query> select * from OBJECTS where O_ID = <sql:param type="xs:string" select="test/RequestParams/ID" /> </sql:query> <sql:result-set> <Objects> <sql:row-iterator> <Object> <ID><sql:get-column-value type="xs:decimal" column="O_ID"/></ID> <Name><sql:get-column type="xs:string" column="O_NAME"/></Name> <LastChangeDate><sql:get-column type="xs:dateTime" column="O_LCDATE"/></LastChangeDate> </Object> </sql:row-iterator> </Objects> </Response> </sql:result-set> <sql:no-results> <Response>some response</Response> </sql:no-results> </sql:execute> </sql:connection> </sql:config> </p:input> <p:output name="data" ref="data"/> </p:processor> The line <LastChangeDate><sql:get-column type="xs:dateTime" column="O_LCDATE"/></LastChangeDate> is the important one. If type is set to xs:date, i get data, but without houres, minutes and seconds. Sebastian
Hi Sebastian, What is the exception you are getting? Also, can you send the section of the XPL file where you call the SQL processor? Alex On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote: > > Hi, > > > I have some problems getting date typed data from a oracle DB (version 8 - > 10) with ops3.0beta. > In my opinion the oracle sql type "date" corresponds with the xs type > "datetime". > Ops3.0beta throws an error and expects xs:date type. > But in this case, hours, minutes and seconds are cutted of. > I remember that the mapping from sql type "date" to xs type xs:datetime was > no problem. > > Is there a special reason of this behaviour, cause Oracle does not have a > type datetime, only timestamp which is a variable datatype, as far as I > know. > > Regards > > Sebastian > > > > -- > 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 > > > -- Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/ -- 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 -- 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 |
Hi, ok, sorry, I made some mistakes. DateTime was not a part of ops 2.8. We implemented it within an own SQL-Prozessor. So here is the Problem in a new light. "The oracle datatype "date" supports hours,minutes and seconds. The Xml Schema Type date only supports year,month and day. So the time part is cutted of. The sql processor should be able to provide both xml types, date and datetime, if getting some date data from oracle." Regards Sebastian Kraus
Hi Alex, I get following exeption: Illegal XML type for SQL type: {http://www.w3.org/2001/XMLSchema}dateTime, DATE the sql Prozessore call looks like this: <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql"> <p:input name="data" href="#data"/> <p:input name="config"> <sql:config> <sql:connection> <sql:datasource>mySource</sql:datasource> <sql:execute> <sql:query> select * from OBJECTS where O_ID = <sql:param type="xs:string" select="test/RequestParams/ID" /> </sql:query> <sql:result-set> <Objects> <sql:row-iterator> <Object> <ID><sql:get-column-value type="xs:decimal" column="O_ID"/></ID> <Name><sql:get-column type="xs:string" column="O_NAME"/></Name> <LastChangeDate><sql:get-column type="xs:dateTime" column="O_LCDATE"/></LastChangeDate> </Object> </sql:row-iterator> </Objects> </Response> </sql:result-set> <sql:no-results> <Response>some response</Response> </sql:no-results> </sql:execute> </sql:connection> </sql:config> </p:input> <p:output name="data" ref="data"/> </p:processor> The line <LastChangeDate><sql:get-column type="xs:dateTime" column="O_LCDATE"/></LastChangeDate> is the important one. If type is set to xs:date, i get data, but without houres, minutes and seconds. Sebastian
Hi Sebastian, What is the exception you are getting? Also, can you send the section of the XPL file where you call the SQL processor? Alex On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote: > > Hi, > > > I have some problems getting date typed data from a oracle DB (version 8 - > 10) with ops3.0beta. > In my opinion the oracle sql type "date" corresponds with the xs type > "datetime". > Ops3.0beta throws an error and expects xs:date type. > But in this case, hours, minutes and seconds are cutted of. > I remember that the mapping from sql type "date" to xs type xs:datetime was > no problem. > > Is there a special reason of this behaviour, cause Oracle does not have a > type datetime, only timestamp which is a variable datatype, as far as I > know. > > Regards > > Sebastian > > > > -- > 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 > > > -- Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/ -- 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 -- 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 -- 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 |
Administrator
|
Sebastian,
I entered a bug to track this: http://forge.objectweb.org/tracker/index.php?func=detail&aid=304399&group_id=168&atid=350207 Can you please read the description and confirm that it describes your issue? -Erik Sebastian Kraus/INPLUS/DE wrote: > > Hi, > > ok, sorry, I made some mistakes. DateTime was not a part of ops 2.8. We > implemented it within an own SQL-Prozessor. > So here is the Problem in a new light. > "The oracle datatype "date" supports hours,minutes and seconds. The Xml > Schema Type date only supports year,month and day. So the time part is > cutted of. > The sql processor should be able to provide both xml types, date and > datetime, if getting some date data from oracle." > > Regards > > Sebastian Kraus > > > > *"Sebastian Kraus/INPLUS/DE" <[hidden email]>* > > 14.12.2005 11:38 > Please respond to > [hidden email] > > > > To > [hidden email] > cc > > Subject > Re: [ops-users] sql type date vs. xs type datetime > > > > > > > > > > Hi Alex, > > I get following exeption: > Illegal XML type for SQL type: > {http://www.w3.org/2001/XMLSchema}dateTime, DATE > > the sql Prozessore call looks like this: > > <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql"> > <p:input name="data" href="#data"/> > <p:input name="config"> > <sql:config> > <sql:connection> > <sql:datasource>mySource</sql:datasource> > > <sql:execute> > <sql:query> > select > * > from > OBJECTS > where > O_ID = <sql:param type="xs:string" > select="test/RequestParams/ID" /> > </sql:query> > > <sql:result-set> > <Objects> > <sql:row-iterator> > <Object> > > <ID><sql:get-column-value > type="xs:decimal" column="O_ID"/></ID> > > <Name><sql:get-column > type="xs:string" column="O_NAME"/></Name> > > <LastChangeDate><sql:get-column type="xs:dateTime" > column="O_LCDATE"/></LastChangeDate> > > </Object> > </sql:row-iterator> > > </Objects> > </Response> > </sql:result-set> > <sql:no-results> > <Response>some response</Response> > </sql:no-results> > </sql:execute> > </sql:connection> > </sql:config> > </p:input> > <p:output name="data" ref="data"/> > </p:processor> > > > The line <LastChangeDate><sql:get-column type="xs:dateTime" > column="O_LCDATE"/></LastChangeDate> > > is the important one. If type is set to xs:date, i get data, but without > houres, minutes and seconds. > > Sebastian > > > > *Alessandro Vernet <[hidden email]>* > Sent by: [hidden email] > > 14.12.2005 05:07 > Please respond to > [hidden email] > > > To > [hidden email] > cc > > Subject > Re: [ops-users] sql type date vs. xs type datetime > > > > > > > > > > > Hi Sebastian, > > What is the exception you are getting? Also, can you send the section > of the XPL file where you call the SQL processor? > > Alex > > On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote: > > > > Hi, > > > > > > I have some problems getting date typed data from a oracle DB > (version 8 - > > 10) with ops3.0beta. > > In my opinion the oracle sql type "date" corresponds with the xs type > > "datetime". > > Ops3.0beta throws an error and expects xs:date type. > > But in this case, hours, minutes and seconds are cutted of. > > I remember that the mapping from sql type "date" to xs type > xs:datetime was > > no problem. > > > > Is there a special reason of this behaviour, cause Oracle does not have a > > type datetime, only timestamp which is a variable datatype, as far as I > > know. > > > > Regards > > > > Sebastian > > > > > > > > -- > > 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 > > > > > > > > > -- > Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/ > > > -- > 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 > > -- > 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 > > > ------------------------------------------------------------------------ > > > -- > 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 -- 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 |
Hi Erik, your bug post is a little bit old but I did not see your answer. Now I'm facing this problem again. So here is my confirmation :-) Did something change until now? Regards Sebastian
Sebastian, I entered a bug to track this: http://forge.objectweb.org/tracker/index.php?func=detail&aid=304399&group_id=168&atid=350207 Can you please read the description and confirm that it describes your issue? -Erik Sebastian Kraus/INPLUS/DE wrote: > > Hi, > > ok, sorry, I made some mistakes. DateTime was not a part of ops 2.8. We > implemented it within an own SQL-Prozessor. > So here is the Problem in a new light. > "The oracle datatype "date" supports hours,minutes and seconds. The Xml > Schema Type date only supports year,month and day. So the time part is > cutted of. > The sql processor should be able to provide both xml types, date and > datetime, if getting some date data from oracle." > > Regards > > Sebastian Kraus > > > > *"Sebastian Kraus/INPLUS/DE" <[hidden email]>* > > 14.12.2005 11:38 > Please respond to > [hidden email] > > > > To > [hidden email] > cc > > Subject > Re: [ops-users] sql type date vs. xs type datetime > > > > > > > > > > Hi Alex, > > I get following exeption: > Illegal XML type for SQL type: > {http://www.w3.org/2001/XMLSchema}dateTime, DATE > > the sql Prozessore call looks like this: > > <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql"> > <p:input name="data" href="#data"/> > <p:input name="config"> > <sql:config> > <sql:connection> > <sql:datasource>mySource</sql:datasource> > > <sql:execute> > <sql:query> > select > * > from > OBJECTS > where > O_ID = <sql:param type="xs:string" > select="test/RequestParams/ID" /> > </sql:query> > > <sql:result-set> > <Objects> > <sql:row-iterator> > <Object> > > <ID><sql:get-column-value > type="xs:decimal" column="O_ID"/></ID> > > <Name><sql:get-column > type="xs:string" column="O_NAME"/></Name> > > <LastChangeDate><sql:get-column type="xs:dateTime" > column="O_LCDATE"/></LastChangeDate> > > </Object> > </sql:row-iterator> > > </Objects> > </Response> > </sql:result-set> > <sql:no-results> > <Response>some response</Response> > </sql:no-results> > </sql:execute> > </sql:connection> > </sql:config> > </p:input> > <p:output name="data" ref="data"/> > </p:processor> > > > The line <LastChangeDate><sql:get-column type="xs:dateTime" > column="O_LCDATE"/></LastChangeDate> > > is the important one. If type is set to xs:date, i get data, but without > houres, minutes and seconds. > > Sebastian > > > > *Alessandro Vernet <[hidden email]>* > Sent by: [hidden email] > > 14.12.2005 05:07 > Please respond to > [hidden email] > > > To > [hidden email] > cc > > Subject > Re: [ops-users] sql type date vs. xs type datetime > > > > > > > > > > > Hi Sebastian, > > What is the exception you are getting? Also, can you send the section > of the XPL file where you call the SQL processor? > > Alex > > On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote: > > > > Hi, > > > > > > I have some problems getting date typed data from a oracle DB > (version 8 - > > 10) with ops3.0beta. > > In my opinion the oracle sql type "date" corresponds with the xs type > > "datetime". > > Ops3.0beta throws an error and expects xs:date type. > > But in this case, hours, minutes and seconds are cutted of. > > I remember that the mapping from sql type "date" to xs type > xs:datetime was > > no problem. > > > > Is there a special reason of this behaviour, cause Oracle does not have a > > type datetime, only timestamp which is a variable datatype, as far as I > > know. > > > > Regards > > > > Sebastian > > > > > > > > -- > > 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 > > > > > > > > > -- > Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/ > > > -- > 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 > > -- > 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 > > > ------------------------------------------------------------------------ > > > -- > 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 -- 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 -- 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 |
Administrator
|
Sebastian,
The bug is still open so I don't think it has been fixed. -Erik Sebastian Kraus/INPLUS/DE wrote: > > Hi Erik, > > your bug post is a little bit old but I did not see your answer. Now I'm > facing this problem again. > So here is my confirmation :-) > Did something change until now? > > Regards > > Sebastian > > > *Erik Bruchez <[hidden email]>* > Sent by: Erik Bruchez <[hidden email]> > > 16.12.2005 22:47 > Please respond to > [hidden email] > > > > To > [hidden email] > cc > > Subject > Re: [ops-users] sql type date vs. xs type datetime > > > > > > > > > Sebastian, > > I entered a bug to track this: > > http://forge.objectweb.org/tracker/index.php?func=detail&aid=304399&group_id=168&atid=350207 > > Can you please read the description and confirm that it describes your > issue? > > -Erik > > Sebastian Kraus/INPLUS/DE wrote: > > > > Hi, > > > > ok, sorry, I made some mistakes. DateTime was not a part of ops 2.8. We > > implemented it within an own SQL-Prozessor. > > So here is the Problem in a new light. > > "The oracle datatype "date" supports hours,minutes and seconds. The Xml > > Schema Type date only supports year,month and day. So the time part is > > cutted of. > > The sql processor should be able to provide both xml types, date and > > datetime, if getting some date data from oracle." > > > > Regards > > > > Sebastian Kraus > > > > > > > > *"Sebastian Kraus/INPLUS/DE" <[hidden email]>* > > > > 14.12.2005 11:38 > > Please respond to > > [hidden email] > > > > > > > > To > > [hidden email] > > cc > > > > Subject > > Re: [ops-users] sql type date vs. xs type datetime > > > > > > > > > > > > > > > > > > > > Hi Alex, > > > > I get following exeption: > > Illegal XML type for SQL type: > > {http://www.w3.org/2001/XMLSchema}dateTime, DATE > > > > the sql Prozessore call looks like this: > > > > <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql"> > > <p:input name="data" href="#data"/> > > <p:input name="config"> > > <sql:config> > > <sql:connection> > > <sql:datasource>mySource</sql:datasource> > > > > <sql:execute> > > <sql:query> > > select > > * > > from > > OBJECTS > > where > > O_ID = <sql:param type="xs:string" > > select="test/RequestParams/ID" /> > > </sql:query> > > > > <sql:result-set> > > <Objects> > > <sql:row-iterator> > > <Object> > > > > <ID><sql:get-column-value > > type="xs:decimal" column="O_ID"/></ID> > > > > <Name><sql:get-column > > type="xs:string" column="O_NAME"/></Name> > > > > <LastChangeDate><sql:get-column type="xs:dateTime" > > column="O_LCDATE"/></LastChangeDate> > > > > </Object> > > </sql:row-iterator> > > > > </Objects> > > </Response> > > </sql:result-set> > > <sql:no-results> > > <Response>some response</Response> > > </sql:no-results> > > </sql:execute> > > </sql:connection> > > </sql:config> > > </p:input> > > <p:output name="data" ref="data"/> > > </p:processor> > > > > > > The line <LastChangeDate><sql:get-column type="xs:dateTime" > > column="O_LCDATE"/></LastChangeDate> > > > > is the important one. If type is set to xs:date, i get data, but without > > houres, minutes and seconds. > > > > Sebastian > > > > > > > > *Alessandro Vernet <[hidden email]>* > > Sent by: [hidden email] > > > > 14.12.2005 05:07 > > Please respond to > > [hidden email] > > > > > > To > > [hidden email] > > cc > > > > Subject > > Re: [ops-users] sql type date vs. xs type datetime > > > > > > > > > > > > > > > > > > > > > > Hi Sebastian, > > > > What is the exception you are getting? Also, can you send the section > > of the XPL file where you call the SQL processor? > > > > Alex > > > > On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote: > > > > > > Hi, > > > > > > > > > I have some problems getting date typed data from a oracle DB > > (version 8 - > > > 10) with ops3.0beta. > > > In my opinion the oracle sql type "date" corresponds with the xs type > > > "datetime". > > > Ops3.0beta throws an error and expects xs:date type. > > > But in this case, hours, minutes and seconds are cutted of. > > > I remember that the mapping from sql type "date" to xs type > > xs:datetime was > > > no problem. > > > > > > Is there a special reason of this behaviour, cause Oracle does not > have a > > > type datetime, only timestamp which is a variable datatype, as far > as I > > > know. > > > > > > Regards > > > > > > Sebastian > > > > > > > > > > > > -- > > > 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 > > > > > > > > > > > > > > > -- > > Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/ > > > > > > -- > > 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 > > > > -- > > 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 > > > > > > ------------------------------------------------------------------------ > > > > > > -- > > 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 > > > > -- > 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 > > > ------------------------------------------------------------------------ > > > -- > 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 -- Orbeon - XForms Everywhere: http://www.orbeon.com/blog/ -- 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 |
Ok, so I will try to write a workaround or I even touch the source. I will post the results. Sebastian
Sebastian, The bug is still open so I don't think it has been fixed. -Erik Sebastian Kraus/INPLUS/DE wrote: > > Hi Erik, > > your bug post is a little bit old but I did not see your answer. Now I'm > facing this problem again. > So here is my confirmation :-) > Did something change until now? > > Regards > > Sebastian > > > *Erik Bruchez <[hidden email]>* > Sent by: Erik Bruchez <[hidden email]> > > 16.12.2005 22:47 > Please respond to > [hidden email] > > > > To > [hidden email] > cc > > Subject > Re: [ops-users] sql type date vs. xs type datetime > > > > > > > > > Sebastian, > > I entered a bug to track this: > > http://forge.objectweb.org/tracker/index.php?func=detail&aid=304399&group_id=168&atid=350207 > > Can you please read the description and confirm that it describes your > issue? > > -Erik > > Sebastian Kraus/INPLUS/DE wrote: > > > > Hi, > > > > ok, sorry, I made some mistakes. DateTime was not a part of ops 2.8. We > > implemented it within an own SQL-Prozessor. > > So here is the Problem in a new light. > > "The oracle datatype "date" supports hours,minutes and seconds. The Xml > > Schema Type date only supports year,month and day. So the time part is > > cutted of. > > The sql processor should be able to provide both xml types, date and > > datetime, if getting some date data from oracle." > > > > Regards > > > > Sebastian Kraus > > > > > > > > *"Sebastian Kraus/INPLUS/DE" <[hidden email]>* > > > > 14.12.2005 11:38 > > Please respond to > > [hidden email] > > > > > > > > To > > [hidden email] > > cc > > > > Subject > > Re: [ops-users] sql type date vs. xs type datetime > > > > > > > > > > > > > > > > > > > > Hi Alex, > > > > I get following exeption: > > Illegal XML type for SQL type: > > {http://www.w3.org/2001/XMLSchema}dateTime, DATE > > > > the sql Prozessore call looks like this: > > > > <p:processor name="oxf:sql" xmlns:sql="http://orbeon.org/oxf/xml/sql"> > > <p:input name="data" href="#data"/> > > <p:input name="config"> > > <sql:config> > > <sql:connection> > > <sql:datasource>mySource</sql:datasource> > > > > <sql:execute> > > <sql:query> > > select > > * > > from > > OBJECTS > > where > > O_ID = <sql:param type="xs:string" > > select="test/RequestParams/ID" /> > > </sql:query> > > > > <sql:result-set> > > <Objects> > > <sql:row-iterator> > > <Object> > > > > <ID><sql:get-column-value > > type="xs:decimal" column="O_ID"/></ID> > > > > <Name><sql:get-column > > type="xs:string" column="O_NAME"/></Name> > > > > <LastChangeDate><sql:get-column type="xs:dateTime" > > column="O_LCDATE"/></LastChangeDate> > > > > </Object> > > </sql:row-iterator> > > > > </Objects> > > </Response> > > </sql:result-set> > > <sql:no-results> > > <Response>some response</Response> > > </sql:no-results> > > </sql:execute> > > </sql:connection> > > </sql:config> > > </p:input> > > <p:output name="data" ref="data"/> > > </p:processor> > > > > > > The line <LastChangeDate><sql:get-column type="xs:dateTime" > > column="O_LCDATE"/></LastChangeDate> > > > > is the important one. If type is set to xs:date, i get data, but without > > houres, minutes and seconds. > > > > Sebastian > > > > > > > > *Alessandro Vernet <[hidden email]>* > > Sent by: [hidden email] > > > > 14.12.2005 05:07 > > Please respond to > > [hidden email] > > > > > > To > > [hidden email] > > cc > > > > Subject > > Re: [ops-users] sql type date vs. xs type datetime > > > > > > > > > > > > > > > > > > > > > > Hi Sebastian, > > > > What is the exception you are getting? Also, can you send the section > > of the XPL file where you call the SQL processor? > > > > Alex > > > > On 12/13/05, Sebastian Kraus/INPLUS/DE <[hidden email]> wrote: > > > > > > Hi, > > > > > > > > > I have some problems getting date typed data from a oracle DB > > (version 8 - > > > 10) with ops3.0beta. > > > In my opinion the oracle sql type "date" corresponds with the xs type > > > "datetime". > > > Ops3.0beta throws an error and expects xs:date type. > > > But in this case, hours, minutes and seconds are cutted of. > > > I remember that the mapping from sql type "date" to xs type > > xs:datetime was > > > no problem. > > > > > > Is there a special reason of this behaviour, cause Oracle does not > have a > > > type datetime, only timestamp which is a variable datatype, as far > as I > > > know. > > > > > > Regards > > > > > > Sebastian > > > > > > > > > > > > -- > > > 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 > > > > > > > > > > > > > > > -- > > Blog (XML, Web apps, Open Source): http://www.orbeon.com/blog/ > > > > > > -- > > 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 > > > > -- > > 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 > > > > > > ------------------------------------------------------------------------ > > > > > > -- > > 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 > > > > -- > 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 > > > ------------------------------------------------------------------------ > > > -- > 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 -- Orbeon - XForms Everywhere: http://www.orbeon.com/blog/ -- 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 -- 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 |
Free forum by Nabble | Edit this page |