Search - Joel Lipman .Com

41. Connect to Joomla database in standalone script: / Joomla /; ... prefix (may be empty) // Database prefix (if empty then remove prefixing double underscore) $db_prefix = (trim($db_prefix)=="") ? "":$db_prefix; $db_connect = mysqli_connect($db_host,$db_user,$db_pass); ...; Created on 17 August 2012
42. DataJumble - Shuffling characters in a data value: / Transact-SQL /; ... DECLARE @DateMatch int; DECLARE @TimeMatch int; DECLARE @ColumnTypeIsDate int; -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); ...; Created on 01 August 2012
43. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... student_accounts WHERE student_accounts.studentUsername = trim(:p_myinparameter); SELECT NVL(student_details.studentFirstname, 'John') "FORENAMES", ...; Created on 24 January 2012
44. Basic Oracle Function Structure: / Oracle PL/SQL /; ... (ad_username IN varchar2) RETURN number IS student_no number; cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN ...; Created on 15 January 2012
45. Getting the mysql where in delimited string to work: / MySQL /; What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", ...; Created on 02 January 2012
46. SSRS AlphaNumeric Parameter Validation: / SQL Server Reporting Services /; ... (LENGTH(TRIM(TRANSLATE(:ParameterToCheck, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', ' ')))) AS NotAlphaNumeric FROM ... -- Transact-SQL -- 0 if is alphanumeric, 1 or ...; Created on 07 November 2011
47. Migrate Joomla Users to WordPress: / Wordpress /; ... user_activation_key, user_status, display_name ) SELECT a.id 'ID', a.username 'user_login', REPLACE(TRIM(LOWER(a.username)), ' ', '_') AS 'user_nicename', a.email AS 'user_email', ' ' AS 'user_url', a.registerDate ...; Created on 03 October 2011
48. Fun with DllCall in AutoHotkey: / AutoHotkey /; ... Int,1, AStr ) : DllCall( "lstrcpy", Str,Var, UInt,nPtr ), nPtr := nPtr+StrLen( Var )+1, List .= "`n" Var, A_Index=1 ? Omit := StrLen( Var )+2 : StringTrimLeft, List, List, %Omit% DllCall( "ImageHlp\UnMapAndLoad", ...; Created on 27 September 2011
49. List MediaWiki Articles: / MediaWiki /; ... GROUP_CONCAT(TRIM(REPLACE(ccg.GroupName_Friendly, '_', ' '))) FROM custombu_category_restrictions ccr INNER JOIN custombu_category_groups ccg ON ccg.BUKBGroupID=ccr.GroupAllowedID WHERE REPLACE(ccr.CategoryName, ...; Created on 22 September 2011
50. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... values" to =IIF(LTrim(Parameters!StudentADAccount.Value)="", Parameters!StudentReference.Value, First(Fields!S_STUDENTREFERENCE.Value, "StudentDetails")) should work: Apparently not because ...; Created on 19 July 2011