select name, REPLACE(format, ' – ', '/') as format, CAST(price AS UNSIGNED INTEGER) as price, CONCAT('http://www.example.com/',url_key) as url, id, delivery, sku from Database1 where delivery <> 'finished' INTO OUTFILE 'test.txt' FIELDS TERMINATED BY '\t'; this query returns empty result while select name, REPLACE(format, ' – ', '/') as format, CAST(price AS UNSIGNED INTEGER) as price, CONCAT('http://www.example.com/',url_key) as url, id, delivery, sku from Database1 where delivery <> 'finished'; returns with results, I am a new to databases and developement so need help.

Member Avatar
+0 forum 0

Hi, is there a way how to (in transact sql) catch output from stored procedure which returns set (2 and more) of tables and move through it ??? thanks!

Member Avatar
+0 forum 0

Hi, i hava a dropdownlist in asp.net mvc page. On selecting particular select item from dropdownlist i have made an ajax post request to the controller method that returns me the result. Everything is working fine. i also get the required result. But the problem is how shall i extract required things from json result. Here is my ajax request: [code=javascript] <script <script type="text/javascript"> function getContent() { var Sid = document.getElementById("hdnSectionId").value; var Lid = document.getElementById("DdLanguageTrans").options[document.getElementById("DdLanguageTrans").selectedIndex].value; var sectionOrder = document.getElementById("hdnSectionOrder").value; $.ajax({ type: "POST", url: "/AjaxRequest/ControllerMethod", data: "Sid=" + Sid + "&Lid=" + Lid + "&sectionOrder=" + sectionOrder, success: function(result) { alert(result); …

Member Avatar
+0 forum 0

I get the following message when executing a stored procedure. [COLOR="Red"]The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.[/COLOR] However , i cannot change the fact that the SP uses a cursor. Basically what happens is that the SP executes into a declared table, and then for each row it executes a new stored procedure bringing the number of result sets to about 20 000.... Any advice on where i can change this setting ? Regards,

Member Avatar
+0 forum 0

The End.