|
|
 next
|
  Subject: Date Format error
Author: dean katz
Date: 29 Sep 2005 02:37 PM
Originally Posted: 29 Sep 2005 02:35 PM
|
|
When I run this statement in StylusStudio<br>
<br>
SELECT<br>
XMLELEMENT( NAME "client",<br>
XMLATTRIBUTES(t.record_id, t.system_id, t.odbid, t.date_added, t.date_updated),<br>
XMLELEMENT( NAME "first_name", t.first_name),<br>
XMLELEMENT( NAME "last_name", t.last_name),<br>
XMLELEMENT( NAME "mi_initial", t.mi_initial),<br>
XMLELEMENT( NAME "soc_sec_no", t.soc_sec_no),<br>
XMLELEMENT( NAME "dynamic_content", XMLELEMENT( NAME "svpprofgender", t.svpprofgender),<br>
XMLELEMENT( NAME "svpprofdob",t.svpprofdob), XMLELEMENT( NAME "svpprofrace",t.svpprofrace)))<br>
FROM myServicePoint.DBO.mytblrawclients t<br>
WHERE clientndx = 1500<br>
<br>
I get this result:<br>
<client record_id='RID1500' system_id='SID1500' odbid='346' date_added='2001-08-09 00:00:00.0' date_updated='2001-08-09 00:00:00.0'><first_name>TERROS</first_name><last_name>DILWORTH</last_name><mi_initial></mi_initial><soc_sec_no>319-01-1874</soc_sec_no><dynamic_content><svpprofgender>m</svpprofgender><svpprofdob>1993-11-06 00:00:00.0</svpprofdob><svpprofrace>White/Caucasian</svpprofrace></dynamic_content></client><br>
<br>
I.E. the date_added is missing a 'T' (instead of '2001-08-09T00:00:00.0') in the middle so that it won't get validated against the schema. How can fix this error?
|
|
|
|
top