Assuming select is required, the following 242 results were found.
-
original_url varchar(255); declare url_counter int; set original_url = new.url_alias; set url_counter = 1; while exists (select true from my_table_name where url_alias = new.url_alias) do set new.url_alias = concat(original_url, '_', url_counter); set...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Weblinks links now goes to link via Joomla component. - Date Uploaded: Fri, 25th Nov 2011 1.5.4.2 - Fixed Bug: Category selects from user prefix (was gh165 prefix) - Date Uploaded: Fri, 4th Nov 2011 1.5.4.1 - Enhancement: Version 1.5.4 ported to Joomla...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
notes on a third page. How? Printing to PDF or saving as a PDF lets me preview the page breaks based on the paper size I select. I have a bit of HTML knowledge as well... ahem... well in this particular case CSS... so maybe this will help others: The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
tags of the page: For Joomla v1.5.x Administrators: Login to the backend admin panel Go to Extensions > Template Manager Select the template and click on 'Edit' Click on 'Edit HTML' Look for the beginning tag Insert the code above just after the tag...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
one for windows 7 here. I'm actually only saving you a click as you can just right-click on the google chrome icon and select "New Incognito Window". This is just how to set it by default (useful if you do online banking, shopping, etc). Right-click on...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
to something like: https://lh3.googleusercontent.com/=w320 Methods of getting the File ID #1 Right-click on the file and select "Get Shareable Link". If link sharing is already on, it will display a link such as: https://drive.google.com/open?id=, where...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
size, user who uploaded, timestamp and the path. Remember that the paths are determined using the MD5 Hash of the filename: select img_name, img_size, img_user_text, img_timestamp, CONCAT(SUBSTR(MD5(img_name), 1, 1), '/', SUBSTR(MD5(img_name), 1, 2)) AS...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
Dates and Times used in parameter fields to UK format (dd/MM/yyyy). You can override this in the report by: Go to Design Select the View tab Check that the "Properties" pane is displayed/ticked Change Language under Report Properties > Localization to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
is collapsed (as opposed to expanded). The user can specify the date as it's a report parameter. What we want The user will select a date. We want the report to open with the specified day expanded and the remaining days that week to be collapsed...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the border to be grey and save the project but when I come back to the setting, it's still black. I found that you have to select a color or expression first, then define which border (top, right, bottom, left) the settings apply to... Mad. 1. Type your...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the same as the first...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
time, we could have tried changing the "connection string" parameter to "shared datasource" parameter where the user can select which "shared data source" to use). You might be able to get this working with a shared data source but in our case the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
on why borders may be misbehaving in SSRS. This note corrects the situation at Design time. This is where you are trying to select a cell to have an outline border but then cells around it without a border. You may find that BIDS or Report Builder...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
based on the status) to output: Green (for Success), Red (for Fail), Orange (for Unknown). Right-click on the rectangle and select Insert > Image Edit the Image Properties to specify the image to use. The image can be an expression as well (I embed...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
ones for those that know how but for those who can't remember, then it can take a while. How? Open the solution file Select any file in the Solution Explorer Go to File » Source Control » Go Online The "Go Online" is the option I was missing in this case.
- Type: Article
- Author: Joel Lipman
- Category: Team Foundation Server
- Language: *
-
post the way I do it: Open up windows explorer Go to Tools -> Folder Options Click on the File Types tab Scroll down and select (NONE) Folder as file type Click on Advanced Click on New... For the Action type what ever you want the context menu to...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1 WHERE column1='this_article' Add 1 to counter_field_value UPDATE table1 SET...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID, columnFullName, CASE WHEN columnFirstName LIKE @ThisSearch THEN 20 WHEN columnFullName LIKE @ThisSearch THEN 10...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
This is what I use to convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-", trim(substr($this_date,...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB