Assuming where is required, the following 228 results were found.
-
users. This sounds really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql = "SELECT * FROM Content WHERE content_body LIKE '%$search_term_esc%'"; Great! Few problems though, multiple terms are not supported; quotation marks and...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
PUT, DELETE'); // open connection $ch = curl_init(); // set the cURL options curl_setopt($ch, CURLOPT_URL, $api_url); // where to send the variables to curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml')); // specify content type of...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a long sentence; let me try this: When I save a record in...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Taking a break from website migrations. Thought I'd share some thoughts I was reminiscing of: "We cast a shadow on something wherever we stand, and it is no good moving from place to place to save things; because the shadow always follows. Choose a...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- Language: *
-
commas between double-quotes var column_values = row_content.split(/,(?=(?:(?:[^"]*"){2})*[^"]*$)/); // prevents JS error where results unmatched column_values = column_values || []; // ignore row if first item is blank (allows for blank excel lines)...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
an easy to remember word for this set of options, eg. "portrait". Now click outside of the option box at the end (in between where it says +1 more) Type the word "value" and press Now type the string of words/phrases that you want to store against this...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
was asked "... how do you find out where the positions are, like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after your website URL:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
but in the database. Open the database to the Joomla 1.5.x website Browse the table "jos_components" (or "#__components" where "#_" is the site table prefix. default is "jos"). Open the row where name="User Manager" Set the value under params for...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
my_table GROUP BY my_field; Additional: Not sure why method 3 is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
, rb.[DateFinish] , rb.[ContactUsername] , rb.[ContactName] , rb.[Room] , rb.[BookingNotes] FROM roombookings rb WHERE rb.[GivenDate] BETWEEN @GivenDate AND @ToDate AND rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows This returns...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Directory. I know the AD domain and username, show me the person! http:///Person.aspx?accountname=MYDOMAIN\myusername (where "" can be domain\username or just username. Master of the Universe!...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
data_type TEXT across all databases: SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS value FROM information_schema.COLUMNS WHERE DATA_TYPE='text' ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all columns that had the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
I have another system which starts on Monday and ends on the following Sunday. The solution below is for the opposite, where the week starts on the previous Saturday and ends on the last working day of the week. The Solution Where "givenDate" is the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
be a real quick one for a dropdown search field which has to find relevant terms to autofill/autocomplete a search form: -- where @ThisSearch is a posted (and sanitized) variable SET @ThisSearch:="Brains"; SELECT columnID, columnFullName, CASE WHEN...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
with URL friendly characters. How? -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that are non-alphanumeric but ignore underscores SELECT * FROM...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
are unnecessary on the O11 Dynamic Mini and air flow isn't perfectly balanced. I'd opt for the O11 Air Mini (newer one) where fans can be mounted to the front and it supports an ATX Power supply. I bought 9 Coolmoon fans (3 x 3-packs) but left the 2...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
Couldn't find this anywhere on the net and kinda needed it so am making a note of how to do it here. The issue is that I wanted to make my autohotkey program change the image that the mouse hovers over (within it's own GUI). No third-party component or...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
either version 3 of the License, or (at your option) any later version. You are to maintain copyright information where credit is due. The scripts and programs are distributed in the hope that they will be useful, but WITHOUT ANY WARRANTY; without even...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Support during this month is included in the initial development. Service Transition will happen over the course of 1 month where the client's team should be made available to receive manuals and training on how to manage their website. A support...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
send the file to your temporary directory instead of using the root c drive. If you do not have c:\windows folder than find where "cmd.exe" exists and chage the path in the above instructions accordingly. The use of some environment variables (eg....
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *