Database - Should I define a max length for stored url? -

-

i'm building small webapplication should store urls input of form. urls can have attributes, parameters etc. https:/www.stackoverflow.com/search?q=this+could+be+a+very+long+string. 'experts' make use out of missing validator, checks length of string. otherwise limitation may let occur error if url long.

i'm using sqlite3, solution should work database-independent.


Comments

Post a Comment

Popular posts from this blog

sql - Postgresql error: "failed to find conversion function from unknown to text" -

-
i have following postgresql query: ( select '201405mase04' testid, count(*) totq, count(distinct case when se1 = '' null else se1 end) totse, case when count(*)=0 7 else count(distinct rc) end totrc eivtestitems ti, eivtests t ti.test_id = t.test_id , t.test_type_id = 1 , t.test_id= '201405mase04' , ti.omit <> 1 ), b ( select '201405mase04' testid, count(*) totq eivtestitems ti, eivtests t ti.test_id = t.test_id , t.test_type_id = 1 , t.test_id= '201405mase04' , ti.omit = 1 ), c ( select '201405mase04' testid, count(*) totq eivtestitems ti, eivtests t ti.test_id = t.test_id , t.test_type_id = 1 , t.test_id= '201405mase04' , ti....
Read more

javascript - Why in IE loading image not show at center bottom of page? -

-
this question has answer here: how “position:fixed” css work in ie 7+ transitional doctype? 2 answers why in ie loading image not show @ center bottom of page ? this function load content on load page , load content on scroll bottom. first, load page index.php see loading image @ center bottom of page. but test on ie 7,8 loading not show @ center bottom of page , how can ? index.php <script src="http://code.jquery.com/jquery-1.7.2.js"></script> <script> // on submit form call function code // $("#f1").submit(send_requests()); </script> <body> <form method="post" id="f1"> <input type="hidden" name="something"/> </form> <div id="loading" style="padding: 0px; margin: 0px; position: fixed; bottom: 135px; right: 50%;...
Read more

Phantomjs login, redirect and render page after pageLoad finishes -

-
i have website login form. if user not logged , tries access internal page redirected default page. instance if try access http://siteurl.phantomprint.aspx redirected http://siteurl/default.aspx?returnurl=phantomprint.aspx. , after login automatic redirect take place page. after redirect want render page phantomjs , save pdf. problem rendering takes place before page load finished , can render page if use timeouts. in case, if page loading takes longer normal resulted pdf not proper one. below can find java script code: var page = require('webpage').create(); var index = 0, page.onconsolemessage = function (msg) { console.log(msg); }; var steps = [ function () { //load login page page.open("http://siteurl.phantomprint.aspx", function () { //enter credentials page.evaluate(function () { console.log("filling inputs"); var usernameinput = document.getelementbyid("txtusername...
Read more