Re: NSTimeStamp

hi,
check the date u enterning in GEB_DATUM,or thr
bindings to the textfield.

regds



--- coyote4442002 <[email protected]> wrote:

> Hello,
> 
> I have a problem with NSTimestamp. I build a
> Textfield with a specific
> Dateformat (like "%d.%m.%y"). When I fill it with a
> correct date I get
> an error like this:
> 
> com.webobjects.eoaccess.EOGeneralAdaptorException:
> EvaluateExpression
> failed:
>
<com.webobjects.jdbcadaptor.OpenBasePlugIn$OpenBaseExpression:
> "INSERT INTO PATIENT(PATIENT_ID, NACHNAME, VORNAME,
> INWORK,
> MODIFY_DATE, CREATE_DATE, GEB_DATUM, STRING_ID,
> GEB_ORT, GEB_NAME)
> VALUES (?, ?, ?, NULL, NULL, ?, ?, NULL, ?, ?)"
> withBindings:
> 1:101(patientId), 2:"Mustermann"(nachname),
> 3:"Peter"(vorname),
> 4:2005-06-08 09:51:13(createDate), 5:1957-01-15
> 00:03:00(gebDatum),
> 6:"Osnabrück"(gebOrt), 7:""(gebName)>:
>     Next exception:SQL State:42000 -- error code: 0
> -- msg: SQL ERROR
> - [position 200, near 'E' in '1.38732822E+9, NULL,
> 'Osn'] insert
> error: comma expected but not found in data.
> SQL: INSERT INTO PATIENT(PATIENT_ID, NACHNAME,
> VORNAME, INWORK,
> MODIFY_DATE, CREATE_DATE, GEB_DATUM, STRING_ID,
> GEB_ORT, GEB_NAME)
> VALUES (101, 'Mustermann', 'Peter', NULL, NULL,
> 139909873.198,
> -1.38732822E+9, NULL, 'Osnabrück', '')
> 
> Can anyone help me? I'm using Webobjects 5.2.3 on
> Windows 2000.
> 
> Thanks, Carsten
> 
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/webobjects-newbies/

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/