Assuming will is required, the following 358 results were found.
-
on) published => obviously by whether they're published or not... no idea why u would checked_out => sort by checked out (will either display or not on the front page so again not any use to sort by this) checked_out_time => just cos this value exists,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
-------------------------------------------------------------------------------- -- _jcomments_settings -- ignored as this will load factory settings -- -------------------------------------------------------------------------------- /* INSERT INTO...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
I'd like to use various techniques, and the first part of this article (Stage 1) is the only part you need to modify as this will improve your Joomla search results by giving priority to articles where the search term is in the article title. In the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Warning Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla Administration Panel (to check for and remove expired menu items) A good database administrator...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Allowing the scope to access the user profile also sends through a JSON Web Token (JWT) under the variable "id_token". This will be included in the response from the Google Authentication process and if you store the credentials in a file, then the JWT...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and specify column datatypes. You don't get that with Excel but you can still control the data range. How?...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
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 setting the "Available Values" as...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
DATEPART(year, ExecutionLogStorage.TimeStart), Catalog.Name Chart-wise: create a line chart [Sum(Counter)] will be the data field, [ReportName] will be the series field and [DayOfYearRun] will be category field: So is this doing what I wanted? Well NO....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
server needs to have the "unattended execution account" configured. Some sources are specific saying that the account will need to be able to logon to the external server holding the files. MSDN Quote: When the report is previewed in Report Designer,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
site as this article focuses on getting an Oracle stored procedure to work with SSRS. Main Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's names and date-of-birth based on the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
key with the action name (eg. "Print Directory Contents To File" - replace spaces with underscores if you are unsure this will work) Add a key to this one called "command" Under the "command" key, there should be a new string value called "(Default)"....
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Well how to deactivate an account and set up a new one in Windows Live Mail. If you used IMAP all along then the new account will have all your mail. The error Unable to send or receive messages for the Hotmail (someone) account. Subject 'your Microsoft...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Looks pretty good, doesn't it? The advantages of this is that you can send this data to your developers and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
PHP function: "json_encode". How? So here's what I tried and ended up with: If your XML is UTF-8 This is the basic code and will work to fetch some XML and return it in JSON formatting as long as the XML is encoded in UTF-8. // set headers for JSON file...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Pancakeshttps://www.joellipman.com/component/content/article/pancakes.html?catid=96&Itemid=165
well in the centre of the flour and break the eggs into it. Then begin whisking the eggs - any sort of whisk or even a fork will do - incorporating any bits of flour from around the edge of the bowl as you do so. Next gradually add small quantities of...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
here. Basic Example Here's a complete PHP script of a basic example of getting the agencies belonging to a company (note you will need to change the keys and relevant IDs to match your own solution): // specify provider ID $my_provider_id = 1234;...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
XY coordinates. Export the report to Excel and all the fields in the section appear in the same column. Extra blank columns will not appear. Cause 2: Objects in the same column have different widths To ensure all the objects in the same column have the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
and double-quotes. You can change this but remember to put two double-quotes if you are searching on it, eg: FIND(""",B1) // will NOT work! FIND("""",B1) // will work FIND("″",B1) // will work You could merge all the statements into one but for...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB