below is my mysql(MariaDB) server stored procedure code # call `pkrss_get_rssitem_vo`(2, 0, 0, 0, 1, 0, 0, 0); # flag = 1: select items # flag =-1: select items count # flag = 2: select items with image mode # flag =-2: select items with image mode count # flag = 3: get top 1 item with each table # flag = 4: get top n item with each table CREATE PROCEDURE `pkrss_get_rssitem_vo`(IN `lid` INT, IN `cid` INT, IN `tid` INT, IN `offset` INT, IN `limit` INT, IN `idOrderBy` INT, IN `timeOrderBy` INT, IN `flag` INT) BEGIN DECLARE s VARCHAR(512); DECLARE s2 VARCHAR(512); DECLARE t VARCHAR(128); DECLARE selImgMode INT DEFAULT 0; DECLARE selCountMode INT DEFAULT 0; IF flag = -1 THEN SET selCountMode = 1; END IF; IF flag = -2 THEN SET selCountMode = 1; SET selImgMode = 1; END IF; IF flag = 2 THEN SET selImgMode = 1; END IF; SET s = ''; IF selCountMode = 1 THEN SET s = CONCAT(s,'S...
01 I need lean english from now on by self-learnt. what are depression(沮丧) days! some many things need I fixed. liked:friends married,production to be bad,goal is losing,society is blackness,pressure come from many ways,money to earn…. pkrss need me to implement,girlfriend need me to find,caused need me to worked hardly, knowledge need me to learnt,living need me to live. ok,you are right,I am a stubborn(顽固) old man.who are 28ages, and hardly communicate to another one.who are be imagined(想像) by adhere to self-view(坚持自我观点),who are prevent another continue to work in many timers. Always silence, not to many saying.. because i think that is wasting. Good , I will work hardly. 02 cy is leaving from fz,go to xm,why 10 silverlight 5 is not good, xaml is not good edit in blend 5,blend has some bug, not good run in many computers. I want to found some hyperlink control in web, liked in : http://gallery.expression.microsoft.com 20 when I research silver...
1.test examples/discover.php 1.1 error when i test http://localhost/t/php-openid/examples/discover.php and used bellow for "Enter an OpenID URL to begin discovery": http://localhost/t/php-openid/examples/server/server.php ,get this error: Got no response code when fetching https: //localhost:80/t/php-openid/examples/server/server.php/idpXrds CURL error (35): error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol fixed: then i changed above URL to: https://localhost/t/php-openid/examples/server/server.php 1.2 error then get bellow error message: Got no response code when fetching https: //localhost/t/php-openid/examples/server/server.php CURL error (60): SSL certificate problem, verify that the CA cert is OK. Details: error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed fixed: add one line in php-openid\Auth\Yadis\ParanoidHTTPFetcher.php line:130 curl_setopt($c, CURLOPT_SSL_VERIFYPEER, false );
Comments