Looks to me like you should replace
x.DateReceived = x.DateReceived & REReplaceNoCase(x.xml,
"^.*<Time>(.*?)</Time>.*$","\1");
with
x.DateReceived = x.DateReceived & " " & REReplaceNoCase(x.xml,
"^.*<Time>(.*?)</Time>.*$","\1");
Notice the addition of the " " separator.
Jon
>>> [EMAIL PROTECTED] 03/10/04 04:52PM >>>
Hi guys,
I have 3 lines of code which I really don't know what they do (I only
have them because they interface with a mobile provider, they
translate
the XML to CF):
x.DateReceived = REReplaceNoCase(x.xml,
"^.*<Date>(.*?)</Date>.*$","\1");if(x.DateReceived eq
xml_in){x.DateReceived = "";};
x.DateReceived = DateFormat(x.DateReceived, "yyyy-mm-dd");
x.DateReceived = x.DateReceived & REReplaceNoCase(x.xml,
"^.*<Time>(.*?)</Time>.*$","\1");if(x.DateReceived eq
xml_in){x.Datereceived = "";};
But I do know that when I insert x.DateReceived into my database it
comes out as 2004-03-0911:24:15 which confuses my database. Obviously
there should be some sort of separator between the date and the time
but
I don't know how to fix those lines of code.
Can anyone help as it's over my head?
Cheers,
Stuart
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- RE: CF & XML?? Jon Gunnip
- RE: CF & XML?? Saturday. S. Kidd
- RE:CF & XML?? Suyer, Ed