-----Original Message-----
From: Jon Gunnip [mailto:[EMAIL PROTECTED]
Sent: 10 March 2004 23:58
To: CF-Talk
Subject: Re: CF & XML??
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]
