Re: ISO date format on SOAP interface

Subject: Re: ISO date format on SOAP interface

From: Gordon Maynard <email@hidden>

Date: Fri, 13 Oct 2006 13:57:03 +0100

Delivered-to: email@hidden

Feel free!

The 'isot' is what comes back from the soap call to a Web Service developed using WebObjects which is wrapped around a MySQL database. The field in the database is defined as a datetime and the entity in the Enterprise Objects model as a NSCalendatDate. Applescript _was_ able to handle the value in this form using the coercion:

set datestamp to datestamp as date

after which it behaved like a normal AS date.

My problem was how to generate a date which I could write back to the web service to set the date field in the database. I tried the earlier suggestion of using:

(current date) as class «isot»

and while this worked within the script I still got an error back from WebObjects. The solution/workaround I have used makes use of EOModeler's ability to change value classes internally so this entity is now defined as type NSString to the outside world but as a timestamp on the database side. In my script I now send the date formatted into a text string in the format yyyy-mm-dd and the interface is working fine.

It's always nice to find a solution but that's a couple of hours of my life gone which I won't get back...

Regards,

Gordon.

Gordon Maynard

m: 07 970 638 415

e: email@hidden

AIM: maynardaim

Jabber: email@hidden

On 13 Oct 2006, at 13:36, Mark J. Reed wrote:

If I may inject a dumb question here:

On 10/12/06, Gordon Maynard <email@hidden> wrote:

I'm using Applescript to extract data from a Web Service developed using
WebObjects. The format of the response is as follows:

{gid:{primarykeys:{1}, entityname:"folderList"},
websafefoldername:"folderName", datestamp:«data
isot323030362D30382D31315432333A30303A30305A»,
foldername:"Folder Name", folderid:1}

What app is it that defines class "isot"? From the above, it looks
like AppleScript doesn't have any idea what that is; if it did, it
would presumably show the data as a string ("2006-08-11T23:00:00Z")
instead of as raw hex codes. I'm guessing that doing whatever you're
doing in a tell block to the appropriate app would help...
--
Mark J. Reed <email@hidden>

_______________________________________________ Do not post admin requests to the list. They will be ignored. AppleScript-Users mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/applescript-users/email@hidden This email sent to email@hidden

Follow-Ups:

Re: ISO date format on SOAP interface
- From: "Mark J. Reed" <email@hidden>

References:
	>ISO date format on SOAP interface (From: Gordon Maynard <email@hidden>)
	>Re: ISO date format on SOAP interface (From: "Mark J. Reed" <email@hidden>)