jQuery Grid Plugin - jqGridForum

Topic RSS

Cannot Add

05/11/2014
21:27

kevinc

Member

Members

Forum Posts: 7

Member Since:
03/02/2012

Offline

I am testing out jqGrid, and have everything working except for Add a new record. The issue seems to be with one of my fields that is a date.

I get an error in the add dialog which says "error Status: 'error'. Error code: 404"

but the URL certainly does exist on the web server...in fact, in the logs I can see that the post actually did send, and the web server got the parms. It is missing the "oper" parm though, which should be "add" and it's also missing the id parm.

What would cause it to post without these?

If I leave the date field blank then click submit, it posts oper=add and an empty id as it should...but then I get no date!

???

I am having formatting issues too, and can't seem to get the jQuery-UI Date Picker format to match up with the datefmt option. Maybe if I can get the default working above I will psot back to get further help with formatting options...

Any ideas?

06/11/2014
17:51

kevinc

Member

Members

Forum Posts: 7

Member Since:
03/02/2012

Offline

Just answering my own issue here...

On the back-end I'm using Oracle web server and PL/SQL. When the post is sent to the server, the name/value pairs are received as an oracle array (owa_util.vc_arr). They are then looped through to get the names and values, and then saved to the DB. When the date field is encountered, it's format must match that of what the database date field is expecting...in my case, the post is sending "2014-11-01", but the database errors on converting this to a date without the proper format mask...in the end, it was as simple as having a to_date with a mask that matches...and some error checking.

09/11/2014
13:50

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Thanks for the feedback and let us know. I'm sure this will help other.

Kind Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
54 Guest(s)

Currently Browsing this Page:
1 Guest(s)