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_Related Related Topics sp_TopicIcon
Renaming the _search parameter
21/06/2010
19:04
Avatar
mark_caulfield
New Member
Members
Forum Posts: 2
Member Since:
21/06/2010
sp_UserOfflineSmall Offline

Hi,

Oracle doesn't like the _search parameter, it si a reserver symbol and cannot be used for parameter names.

This means I cant use jqgrids search and paging features.

Is there a way to either rename  _search to p_search or remove the _search parameter completly?

Many thanks

Mark Caulfield

http://www.blucel.co.uk

25/06/2010
10:52
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

Hello,

Our PHP component wich work with Oracle does not have a problem with this.

Instead this is possible and you can configure all the posted values to the server.

For this purpose you will need to use prmNames parameter

http://www.trirand.com/jqgridw.....ki:options

prmNames : {search:"myOracleSearch"}

Regards

Tony

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.

30/06/2010
18:25
Avatar
mark_caulfield
New Member
Members
Forum Posts: 2
Member Since:
21/06/2010
sp_UserOfflineSmall Offline

Thanks Tony, just what i needed.

I'm writing javascript directly against the Oracle server ORADB service (like REST web services), so I am in effect bypassing the middle man (PHP) and querying directly against the Oracle database tables and procedures.

In this case my src is an oracle package that  cant accept _parameters, so this gets round it nicely.

many thanks

Mark

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
24 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