JustLikeIcarus
-
Posts
430 -
Joined
-
Last visited
JustLikeIcarus's Achievements
Newbie (1/5)
1
Reputation
-
Strategy for keeping development in synch with test?
JustLikeIcarus replied to davidannis's topic in MySQL Help
You could use something like MySQL workbench which allows you to generate db diffs and manage migrations. http://dev.mysql.com/downloads/workbench/ -
Here us a js fiddle with an up all night off the top of my head method http://jsfiddle.net/MtBSe/1/ Hope it helps Html: <body> <ul class="blogroll"> <li><a href="#">Title 1</a></li> <li><a href="#">Title 2</a></li> <li><a href="#">Title 3</a></li> <li><a href="#">Title 4</a></li> <li><a href="#">Title 5</a></li> <li><a href="#">Title 6</a></li> <li><a href="#">Title 7</a></li> <li><a href="#">Title 8</a></li> <li><a href="#">Title 9</a></li> <li><a href="#">Title 10</a></li> <li><a href="#">Title 11</a></li> <li><a href="#">Title 12</a></li> <li><a href="#">Title 13</a></li> <li><a href="#">Title 14</a></li> <li><a href="#">Title 15</a></li> <li><a href="#">Title 16</a></li> </ul> <a href="#" class="pager" data-page="1"> Next </a> </body> jQuery: $(function (){ var pageSize = 4; var count = 0; currentPage = $('.pager').data('page'); $(".blogroll li").each(function(i){ count = i % 4 == 0 ? count + 1 : count; $(this).addClass("listGroup" + count); }).not(".listGroup" + currentPage).hide(); $('.pager').on("click", function(e){ currentPage = currentPage < count ? currentPage + 1 : 1; $(this).data("page", currentPage); $(".blogroll").find("li").hide().end().find(".listGroup" + currentPage).show(); }); });
-
When you build the link if you encode "&" as "&" this should no longer be an issue. A lot of people always encode the ampersand to prevent issues such as this. So the link would resemble <a href="http://somesite.com/page.php?var=1<id=1211" />...</a>
-
start by changing #nav ul li:hover ul{ /*diplay when hovered*/ display: block; } to #nav ul li:hover > ul{ /*diplay when hovered*/ display: block; } test that it should put you in the right direction. Here is a fiddle with the change http://jsfiddle.net/6TGaf/13/
-
Azure Sql - Freetds - Specific Database
JustLikeIcarus replied to GavMJM's topic in Microsoft SQL - MSSQL
Per the following from MSDN try changing your username to username@database. See if that gets you anywhere -
Chrome and Safari are both webkit browsers so they will both prove true for your media query and use the included style.
-
Change Td Bgcolor On Jquery Ajax Callback With Checkbox
JustLikeIcarus replied to Wilf's topic in Javascript Help
Maybe something like this would help <script type="text/javascript"> jQuery(function($){ $('input[name=alm]').click(function(){ var parentTD = $(this).parents('td'); var id=$(this).attr('id'); var alm=$(this).val(); $.ajax({ type:'GET', url:'inc/villas_allotment_ajax_update.php', data:'id='+id+'&alm='+alm, success: function(html) { if(html=="1"){//change td bg to green if succeed parentTD.css("background-color", "#66cc00"); }else{ parentTD.css("background-color", "#ff8080"); } } }); }); }); </script> -
Google Maps Help (Long And Lat Not Working)
JustLikeIcarus replied to Tenaciousmug's topic in Javascript Help
I dont belive those coordinates exist on the planet... Could be the issue you are seeing. -
If you give the clickable rows a class for example <tr class="clickable"><tr> then you could do something like $("#MyTable tr.clickable").click(function(){ $(this).nextUntil(".clickable").toggle(); } This would select all the sibling rows until it hit the next with the class of clickable.
-
Try something like this. select `website`, sum(case when YEAR(FROM_UNIXTIME(`date_assigned`)) = YEAR(CURDATE()) then 1 else 0 end) AS c_year, count(*) as c_all from `assignments` group by `website` order by `website` asc
-
Per the documentation it would be wrapAll instead of wrap. $('footer h5, footer ul').wrapAll('<div></div>');
-
help with htaccess and multipie vars
JustLikeIcarus replied to Alechko's topic in Apache HTTP Server
Well the following rule would split the url by '/' and set the vars vendor/category/product RewriteRule ^(.+)/(.+)/(.+)$ script.php?vendor=$1&category=$2&product=$3 -
help with htaccess and multipie vars
JustLikeIcarus replied to Alechko's topic in Apache HTTP Server
If you have 3 different scripts I would think you would want 3 different rules for example: RewriteRule ^vendor/(.+)$ vendor.php?name=$1 RewriteRule ^category/([0-9]+)$ cat.php?id=$1 RewriteRule ^product/([0-9]+)$ product.php?id=$1 Otherwise you may be better off passing the url to a php script to parse out using its regex engine. RewriteRule ^(.+)$ parse.php?url=$1 -
Should be able to do something along the lines of SELECT id, CASE WHEN col1 = 'true' OR col2 = 'true' OR col3 = 'true' THEN 'true' ELSE 'false' END as newcol1, CASE WHEN col4 = 'true' OR col5 = 'true' OR col6 = 'true' THEN 'true' ELSE 'false' END as newcol2 FROM table;
-
This should point you in the right direction if I understand you correctly. SELECT id, CASE WHEN col2 = 'true' OR col2 = 'true' OR col3 = 'true' THEN 'true' ELSE 'false' END FROM table;
