Forum

July 12th, 2025
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
Find data type of column
11/10/2010
19:14
Avatar
newera
Member
Members
Forum Posts: 4
Member Since:
09/10/2010
sp_UserOfflineSmall Offline

Hi all,

I have stumbled upon a problem. I am giving the opportunity to the user to search items. However I need to know the data type of the field which is being searched upon so that I can make some inferences on this data type. Is there any way to do it? I know that there is a property where you can set the data type for the column which is displayed in grid. However can I get this type when the search is submitted to the server ????

Thanks

12/10/2010
17:10
Avatar
tony
Sofia, Bulgaria
Moderator
Members

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

Hello,

Little difficult, but not impossible:

Some advises.

You should definne a sorttype property in colModel for the searched (or all) fields.

One possible solution is to use the serializeGridData event.

In this event you can check if the serch is lunched _serach = true.

Depending on the search type (multiple/single) you can get the needed data and see which field(s) is (are) in search and then get its type from colModel and post it to the server.

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.

12/10/2010
17:14
Avatar
newera
Member
Members
Forum Posts: 4
Member Since:
09/10/2010
sp_UserOfflineSmall Offline

I solved it using server side code. Basically I am using LINQ and finding the data type using .NET. But thanks anyway.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 994

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