SQL SQL Server – Find Stored Procedures User Can Access benjf.com.blog@benjf.com, 2011-10-25 http://msdn.microsoft.com/en-us/library/ms190310.aspx Returns a report that has information about user permissions for an object, or statement… Continue Reading
HTML Checkboxes benjf.com.blog@benjf.com, 2011-05-16 Occasionally, you discover something that you have been doing wrong for a long time. Sometimes… Continue Reading
PHP and jQuery – Reduce Long String to Preview Length and Reveal Full Text OnClick benjf.com.blog@benjf.com, 2011-05-142023-06-15 Goal: Reduce long string to specified length for end-user preview. Reveal entire string when clicked. … Continue Reading
JSON Returning NULL When Special Characters Exist in Result Set benjf.com.blog@benjf.com, 2011-04-25 Nearly 24 hours of my life lost and I just figured this out. Maybe I… Continue Reading
Finding Duplicate Records In Database benjf.com.blog@benjf.com, 2010-07-08 If there is more than 1 column with that value it will show up like:… Continue Reading
C# Database Connections and Queries benjf.com.blog@benjf.com, 2010-07-06 Create connection string:SqlConnection conn = new SqlConnection(“Data Source=DATASOURCE\\\\SQLEXPRESS;Initial Catalog=DATABASE_NAME;Integrated Security=True”); try { conn.Open(); SqlCommand sql… Continue Reading
Droid ConnectBot – Unix SSH on the go! benjf.com.blog@benjf.com, 2010-06-24 Connect Bot I probably don’t need to sell any develpers on the advantages of being… Continue Reading
PHP Ternary Operator – The "IF-Else" Shortcut benjf.com.blog@benjf.com, 2010-06-22 A ternary operator is a quick shortcut to bypass the multi-line if-else statement. It is… Continue Reading
PHP explode and trim the results? benjf.com.blog@benjf.com, 2010-06-22 php.net – where I posted this Overview This is something that I used to use… Continue Reading
JavaScript stripslashes benjf.com.blog@benjf.com, 2010-06-19 Sometimes you have to add slashes to javascript text. PHP has it built in, javascript… Continue Reading