CGDevTools Forum

Welcome to the Official CGDevTools Support Community Forums.

Errormessage Request URL Too Long

Questions & Answers about IWCGJQuery Suite.

by JRehorst » 29 Apr 2015 08:32

Situation:
We are using a Grid with about 4000 records. Provider of the data is the component TIWCGJQGridDataSetProvider.
Every single record has a traffic light image. This traffic light image is loaded via the returned cell value (see sourcecode below).
The grid has a rowlist with the strings 50/100/200/500 with a standard of 50.
When switching to a rowlist greater than 50 and then jump through the different pages it happens that you receive
a http error 414 (The request URL is too long).
Setting of the image in the grid is Formatter = gfcImage and load all images at once. If we switch to load images per row then it works
but displaying the images in the grid takes a lot of time for 500 entries. with load complete all images apear at once but it results
very often in the described error message.

Sourcecode:
procedure Tfr_TrackAndTrace.TIWCGJQGridOptionsColModel0GetImage(Sender: TObject;
ACol: TIWCGJQGridCol; const ARowId, ACellValue: string;
var APicture: TPicture; var AImgUrl, ATitle, AAltTitle: string);
begin
if ACellValue = '1' then
AImgUrl := 'imgcache/AmpelRot.bmp'
else if ACellValue = '2' then
AImgUrl := 'imgcache/AmpelGelb.bmp'
else if ACellValue = '3' then
AImgUrl := 'imgcache/AmpelGruen.bmp'
else
AImgUrl := 'imgcache/AmpelAus.bmp';
end;
JRehorst
 
Posts: 3
Joined: 27 Mar 2015 16:09

by Jorge Sousa » 29 Apr 2015 11:50

Hello

About the first part of your question, the number of records, i can only think about this:

http://www.cgdevtools.com/cgforum/viewtopic.php?f=40&t=1461&p=7175&hilit=grid+ISAPI#p7175

About the 2nd part, the images, if you don't need the server, ie, you don't need to search in a database, we can post another solution.
Best Regards
CGDevTools Develop / Support Team
Home Page: http://www.cgdevtools.com
Jorge Sousa
 
Posts: 4261
Joined: 17 May 2012 09:58

by Jorge Sousa » 29 Apr 2015 11:50

Hello

About the first part of your question, the number of records, i can only think about this:

http://www.cgdevtools.com/cgforum/viewtopic.php?f=40&t=1461&p=7175&hilit=grid+ISAPI#p7175

About the 2nd part, the images, if you don't need the server, ie, you don't need to search in a database for instance, or properties in the server, we can post another solution, using formatter gcfFunction.
Best Regards
CGDevTools Develop / Support Team
Home Page: http://www.cgdevtools.com
Jorge Sousa
 
Posts: 4261
Joined: 17 May 2012 09:58


Return to Q & A

Who is online

Users browsing this forum: No registered users and 2 guests

Contact Us.