Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Cannot Add
05/11/2014
21:27
Avatar
kevinc
Member
Members
Forum Posts: 7
Member Since:
03/02/2012
sp_UserOfflineSmall 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
Avatar
kevinc
Member
Members
Forum Posts: 7
Member Since:
03/02/2012
sp_UserOfflineSmall 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
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall 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.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 496

Currently Online:
20 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information