loganathann Posted February 21, 2012 Share Posted February 21, 2012 While using a single select query list control a page is throwing some javascript error.I think javascript is unable to handle an amount of records higher than 20000.Am I right? If yes is there a way to handle this issue?Is there any way to put some search page or auto complete procedure? Kindly help me ASAP .... I need it ...very urgent... Link to comment Share on other sites More sharing options...
norcenmarco Posted February 21, 2012 Share Posted February 21, 2012 Which error?? You mean that you have 20000 value in the single select query??How could you think that someone help you, if you didn't explain the problem? Link to comment Share on other sites More sharing options...
loganathann Posted February 21, 2012 Author Share Posted February 21, 2012 Hi norcenmarco,query for single select input control: SELECT item.ADITMNAME,item.ID FROM RT_DATA_ITEM AS item,RT_DATA_DEPARTMENT AS department WHERE item.ADITMNAME IS NOT NULL AND department.ID=item.ADITMDEPT AND department.DEPARTMENTNAME="Main Pharmacy" ORDER BY item.ADITMNAMEit returns more than 30000 records...it takes more time(3 - 4 minutes) for getting the report.. Link to comment Share on other sites More sharing options...
norcenmarco Posted February 21, 2012 Share Posted February 21, 2012 I never had this problem!!You have really loto of data! I don't have a solution now... but what you think maybe adding another single select query and add the main pharmacy maybe divided by city?Could it work for your purpose? Cheers,Marco Link to comment Share on other sites More sharing options...
loganathann Posted February 21, 2012 Author Share Posted February 21, 2012 Thanks for ur reply...but not possible to divide by any other filters...have u know the max limit of data in select list?...if not possible i can divide these data by item category... Link to comment Share on other sites More sharing options...
norcenmarco Posted February 21, 2012 Share Posted February 21, 2012 I'm sorry but i didn't find a solution.... But if i find something i will post here! By the way, post the javascript error!Cheers,MarcoPost Edited by norcenmarco at 02/21/2012 12:02 Link to comment Share on other sites More sharing options...
loganathann Posted February 21, 2012 Author Share Posted February 21, 2012 Warning: Unresponsive scriptA script on this page may be busy, or it may have stopped responding.You can stop the script now, or you can continue to see if the script will complete.Script: http://192.168.1.60:8080/jasperserver-pro/dwr/util.js:589 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now