I have four parameters "vStartDate date", "vEndDate date", "vCountry TEXT", "vColumns TEXT". And last two is check box. If I select all, it will output below error:
DB error (1406): Data too long for column 'inQuery' at row 1
SQL: call sp_MyDBR_Stat_AddStart('sp_DBR_Registrants','dba',2,'call sp_DBR_Registrants(\'2015-03-02\',\'2015-03-05\',\'\'AE\',\'AF\',\'AR\',\'AT\',\'AU\',\'AZ\',\'BD\',\'BE\',\'BG\',\'BM\',\'BR\',\'BT\',\'BY\',\'CA\',\'CH\',\'CN\',\'CU\',\'CY\',\'DE\',\'DZ\',\'EG\',\'FI\',\'FR\',\'GB\',\'GI\',\'GR\',\'HK\',\'HU\',\'ID\',\'IE\',\'IL\',\'IN\',\'IR\',\'IS\',\'IT\',\'JP\',\'KH\',\'KP\',\'KR\',\'KZ\',\'LB\',\'LK\',\'MM\',\'MX\',\'MY\',\'NG\',\'NL\',\'NO\',\'NP\',\'PH\',\'PK\',\'PL\',\'PT\',\'QA\',\'RO\',\'RU\',\'SA\',\'SC\',\'SE\',\'SG\',\'SI\',\'SK\',\'TH\',\'TJ\',\'TO\',\'TR\',\'TV\',\'TW\',\'TZ\',\'UA\',\'UG\',\'UM\',\'US\',\'VN\'\',\'\'#\',\'FirstName\',\'LastName\',\'Email\',\'Registration Date\',\'Approved Date\',\'Score\',\'Logins Last week\',\'LastLogin Date\',\'Telephone\',\'University\',\'Major\',\'Country\'\');','10.24.57.13','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.154 Safari/537.36');[code]
If I reduce selecting some field in "vCountry" or "vColumns", it works well. I think it should be length limit for report procedure. Do you have any suggestion? Thanks a lot.
