Assuming order is required, the following 133 results were found.
-
connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, database, etc.). For obvious reasons, these cannot be hardcoded....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
http://qa1.mysite.com. When working with a FTP client this also helps as all you are usually changing is a folder name in order to quickly point to LIVE or TEST. Confirm with each person aware of this setup and involved in the development, that they...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
has been made to reset your %s account password. To reset your password, you will need to submit this verification code in order to verify that the request was legitimate.\n\nThe verification code is %s\n\nClick on the URL below to enter the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
asset that has a parent_id of zero. Login to your database using phpMyAdmin, open the table with the suffix "_assets" and order the data (clicking on the heading of the column) by their parent_id. If you see more than one record with a value of 0, then...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
`created_by_alias`, `modified`, `modified_by`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`, `featured`, `language`, `xreference`) SELECT a.`id`, ( SELECT x.`id`...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
SELECT m.`user_id`, m.`group_id`, u.`username`, u.`email` FROM `#_user_usergroup_map` m JOIN `#_users` u ON u.id = m.user_id ORDER BY `group_id` DESC; UPDATE `#_user_usergroup_map` SET `group_id`=2 WHERE `user_id`111 AND `user_id`222 AND `user_id`333;...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
you that location services is enabled but it is attached to a reminder that needs to constantly monitor your whereabouts in order to "remind you". The reminder here was to charge the phone but it was the reminder which would drain a full charge in less...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
OR StudentName=@StudentADAccount). And according to other web articles on this matter, I have to change the order of my parameters (I will be checking "Student Username" first as "Student Reference" must be calculated and not blank/null): So I tried...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
if datasource is correct): Before you close this box, click on "Parameters" in the right and specify your parameters in the order that they are accepted by your stored procedure (eg. MyStoredProcedure(param1,param2,param3) -> param1=@param1,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
numbers you might ask? Well every character is built of a collection of digits that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
= ExecutionLog.ReportID WHERE ExecutionLog.TimeStart BETWEEN @DateFrom AND @DateTo AND Type = 2 ) AS RE GROUP BY Name ORDER BY COUNT(Name) DESC , Name
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
SELECT TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = @p_Column ORDER BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME; -- Create temporary table to hold results CREATE TABLE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT from_index, number_of_rows ROW_NUMBER() OVER(ORDER BY column_name ASC) AS Rownum Source(s): MSDN Microsoft Library (DATEPART (Transact-SQL)) MSDN Microsoft Library (DATENAME (Transact-SQL)) MySQL...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
'SonyEricsson') THEN 'Smartphone' ELSE 'Other' END VisitorBrowser FROM custombu_stats_visits a GROUP BY a.VisitorIP ORDER BY a.DateTimeStamp DESC) t1 GROUP BY CONCAT(MONTH(t1.Date), ' ', YEAR(t1.Date)) Caused by SQL statement returning first column date...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling. Why? We want to scramble sensitive...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
SUM(myCount) AS myCount FROM #ListDistinctValuesAndCounts GROUP BY myValue COLLATE ' + @p_UseCollation + ', myColumn ORDER BY myColumn, myValue '; EXEC(@SqlToExecute); END
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Looping -- From resultset of $i ,assigning it to variable $j using let clause, -- Getting top two employees by using where & order by clause. SELECT Event_XML.query('for $i in /STAFF/student let $j:= $i where ($j/@ID)
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID INNER JOIN Teams t ON t.TeamID=s.TeamID GROUP BY s.LogID ORDER BY s.TeamID, u.Username, s.DateTimeCreated, Resource Note there is no WHERE clause because we're going to use EXCEL filters as the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB