javax.servlet.ServletException: ORA-00933: SQL command not properly ended

I can't see your form.
Without that, the most likely explanation is that you've got two form fields
with the same name. This adds a comma and causes all kinds of syntax
errors. If you've used DW's built-in behaviors, there is a hidden field
containing the record ID. Sometimes, that hidden field gets duplicated if
you edit the behavior after it's applied; sometimes it does not.

If you don't want to try to find the duplicated field, removing and
re-applying the behavior usually fixes it.


"gfoulks" <webforumsuser@macromedia.com> wrote in message
news:ep5au9$2p0$1@forums.macromedia.com...
> Lionstone,
> Thanks for the message... I don't understand what you are saying?
>
> I have just one form field collecting the input. The page loads without
> error
> but when I try to update the database with the collected input this is
> when I
> get the ORA error.
>

There aren't a lot of JSP or Oracle users here.
Your problem is not specific to DW, but to Oracle. There's something it
doesn't like about your query. All messages prior to this one have fallen
out of the thread, though, so I have nothing to go on besides your error
message. Could be anything from a missing semicolon to a blank parameter to
just downright wrongness. ;)


"gfoulks" <webforumsuser@macromedia.com> wrote in message
news:eoinlj$jqh$1@forums.macromedia.com...
> So this must not be a common problem? Anyone have any thoughts or ideas?