jQuery Grid Plugin - jqGrid - Topic: Cannot Add http://www.trirand.com/blog/?page_id=393/help/cannot-add Simple:Press Version 5.7.5.3 tony on Cannot Add http://www.trirand.com/blog/?page_id=393/help/cannot-add#p31356 Help http://www.trirand.com/blog/?page_id=393/help/cannot-add#p31356 Hello,

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

 

Kind Regards

]]> Sun, 09 Nov 2014 13:50:10 +0200 kevinc on Cannot Add http://www.trirand.com/blog/?page_id=393/help/cannot-add#p31343 Help http://www.trirand.com/blog/?page_id=393/help/cannot-add#p31343 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.

]]> Thu, 06 Nov 2014 17:51:53 +0200 kevinc on Cannot Add http://www.trirand.com/blog/?page_id=393/help/cannot-add#p31338 Help http://www.trirand.com/blog/?page_id=393/help/cannot-add#p31338 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?

]]> Wed, 05 Nov 2014 21:27:42 +0200